GET https://land.n46.net/ro/de-vanzare/rezidential/mun-chisinau/codru?orderBy=createdAt&sortOrder=DESC

Response
200 OK
IP
216.73.217.98
Profiled on
Token
57f303

Query Metrics

20 Database Queries
20 Different statements
3.56 ms Query time
0 Invalid entities
35 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.36 ms
(10.18%) 		1 
SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, a0_.cadastral_type AS cadastral_type_2, a0_.address AS address_3, a0_.use_for AS use_for_4, a0_.land_area AS land_area_5, a0_.area AS area_6, a0_.ownership AS ownership_7, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_8, ST_AsText(a0_.multipolygon) AS multipolygon_9, ST_AsText(a0_.centroid) AS centroid_10, a0_.geohash AS geohash_11, a0_.country AS country_12, a0_.administrative_area_level_one AS administrative_area_level_one_13, a0_.administrative_area_level_one_slug AS administrative_area_level_one_slug_14, a0_.administrative_area_level_two AS administrative_area_level_two_15, a0_.locality_long_name AS locality_long_name_16, a0_.locality_long_name_slug AS locality_long_name_slug_17, a0_.sublocality AS sublocality_18, a0_.route AS route_19, a0_.street_number AS street_number_20, a0_.formatted_address AS formatted_address_21, a0_.lat AS lat_22, a0_.lng AS lng_23, a0_.place_id AS place_id_24, a0_.price AS price_25, a0_.price_per_square_meter AS price_per_square_meter_26, a0_.monthly_expenses AS monthly_expenses_27, a0_.orientation AS orientation_28, a0_.levels AS levels_29, a0_.bedrooms AS bedrooms_30, a0_.bathrooms AS bathrooms_31, a0_.wc AS wc_32, a0_.kitchens AS kitchens_33, a0_.livingrooms AS livingrooms_34, a0_.balconies AS balconies_35, a0_.heating_type AS heating_type_36, a0_.heating_medium AS heating_medium_37, a0_.ac AS ac_38, a0_.energy_class AS energy_class_39, a0_.new_development AS new_development_40, a0_.renovated AS renovated_41, a0_.requires_renovation AS requires_renovation_42, a0_.unfinished AS unfinished_43, a0_.under_construction AS under_construction_44, a0_.air_conditioning AS air_conditioning_45, a0_.heating_under_floor AS heating_under_floor_46, a0_.fireplace AS fireplace_47, a0_.alarm AS alarm_48, a0_.secure_door AS secure_door_49, a0_.storage_space AS storage_space_50, a0_.garden AS garden_51, a0_.garage AS garage_52, a0_.parking_space AS parking_space_53, a0_.solar_water_heater AS solar_water_heater_54, a0_.swimming_pool AS swimming_pool_55, a0_.floor AS floor_56, a0_.is_top_floor AS is_top_floor_57, a0_.elevator AS elevator_58, a0_.penthouse AS penthouse_59, a0_.zone AS zone_60, a0_.construction_year AS construction_year_61, a0_.furnished AS furnished_62, a0_.pets_allowed AS pets_allowed_63, a0_.land_classification AS land_classification_64, a0_.is_corner AS is_corner_65, a0_.youtube_video_id AS youtube_video_id_66, a0_.instagram_reel_id AS instagram_reel_id_67, a0_.client_status AS client_status_68, a0_.server_status AS server_status_69, a0_.views AS views_70, a0_.is_promoted AS is_promoted_71, a0_.available_date AS available_date_72, a0_.expiration_date AS expiration_date_73, a0_.created_at AS created_at_74, a0_.updated_at AS updated_at_75, a0_.user_id AS user_id_76, a0_.locality_id AS locality_id_77, a0_.property_sub_type_id AS property_sub_type_id_78, a0_.property_listing_type_id AS property_listing_type_id_79, a0_.residential_complex_id AS residential_complex_id_80 FROM ax_property a0_ INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id AND (a0_.property_sub_type_id = a1_.id) INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id AND (a1_.property_type_id = a2_.id) WHERE a0_.locality_id = ? AND a0_.property_sub_type_id = a1_.id AND a1_.property_type_id = ? AND a0_.client_status = ? AND a0_.server_status = ? AND a0_.property_listing_type_id = ? AND a0_.id IN (?) ORDER BY a0_.created_at DESC
Parameters: 
[
  "0131"
  1
  "active"
  "ok"
  1
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(9.50%) 		1 
SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, a0_.cadastral_type AS cadastral_type_2, a0_.address AS address_3, a0_.use_for AS use_for_4, a0_.land_area AS land_area_5, a0_.area AS area_6, a0_.ownership AS ownership_7, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_8, ST_AsText(a0_.multipolygon) AS multipolygon_9, ST_AsText(a0_.centroid) AS centroid_10, a0_.geohash AS geohash_11, a0_.country AS country_12, a0_.administrative_area_level_one AS administrative_area_level_one_13, a0_.administrative_area_level_one_slug AS administrative_area_level_one_slug_14, a0_.administrative_area_level_two AS administrative_area_level_two_15, a0_.locality_long_name AS locality_long_name_16, a0_.locality_long_name_slug AS locality_long_name_slug_17, a0_.sublocality AS sublocality_18, a0_.route AS route_19, a0_.street_number AS street_number_20, a0_.formatted_address AS formatted_address_21, a0_.lat AS lat_22, a0_.lng AS lng_23, a0_.place_id AS place_id_24, a0_.price AS price_25, a0_.price_per_square_meter AS price_per_square_meter_26, a0_.monthly_expenses AS monthly_expenses_27, a0_.orientation AS orientation_28, a0_.levels AS levels_29, a0_.bedrooms AS bedrooms_30, a0_.bathrooms AS bathrooms_31, a0_.wc AS wc_32, a0_.kitchens AS kitchens_33, a0_.livingrooms AS livingrooms_34, a0_.balconies AS balconies_35, a0_.heating_type AS heating_type_36, a0_.heating_medium AS heating_medium_37, a0_.ac AS ac_38, a0_.energy_class AS energy_class_39, a0_.new_development AS new_development_40, a0_.renovated AS renovated_41, a0_.requires_renovation AS requires_renovation_42, a0_.unfinished AS unfinished_43, a0_.under_construction AS under_construction_44, a0_.air_conditioning AS air_conditioning_45, a0_.heating_under_floor AS heating_under_floor_46, a0_.fireplace AS fireplace_47, a0_.alarm AS alarm_48, a0_.secure_door AS secure_door_49, a0_.storage_space AS storage_space_50, a0_.garden AS garden_51, a0_.garage AS garage_52, a0_.parking_space AS parking_space_53, a0_.solar_water_heater AS solar_water_heater_54, a0_.swimming_pool AS swimming_pool_55, a0_.floor AS floor_56, a0_.is_top_floor AS is_top_floor_57, a0_.elevator AS elevator_58, a0_.penthouse AS penthouse_59, a0_.zone AS zone_60, a0_.construction_year AS construction_year_61, a0_.furnished AS furnished_62, a0_.pets_allowed AS pets_allowed_63, a0_.land_classification AS land_classification_64, a0_.is_corner AS is_corner_65, a0_.youtube_video_id AS youtube_video_id_66, a0_.instagram_reel_id AS instagram_reel_id_67, a0_.client_status AS client_status_68, a0_.server_status AS server_status_69, a0_.views AS views_70, a0_.is_promoted AS is_promoted_71, a0_.available_date AS available_date_72, a0_.expiration_date AS expiration_date_73, a0_.created_at AS created_at_74, a0_.updated_at AS updated_at_75, a0_.user_id AS user_id_76, a0_.locality_id AS locality_id_77, a0_.property_sub_type_id AS property_sub_type_id_78, a0_.property_listing_type_id AS property_listing_type_id_79, a0_.residential_complex_id AS residential_complex_id_80 FROM ax_property a0_ INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id AND (a0_.property_sub_type_id = a1_.id) INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id AND (a1_.property_type_id = a2_.id) WHERE a0_.locality_id = ? AND a0_.property_sub_type_id = a1_.id AND a1_.property_type_id = ? AND a0_.client_status = ? AND a0_.server_status = ? AND a0_.property_listing_type_id = ? ORDER BY a0_.created_at DESC
Parameters: 
[
  "0131"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(7.22%) 		1 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.label AS label_2, a0_.property_listing_type_id AS property_listing_type_id_3, a0_.language_id AS language_id_4 FROM ax_property_listing_type_translation a0_ INNER JOIN ax_language a1_ ON a0_.language_id = a1_.id WHERE a0_.slug = ? AND a1_.locale = ?
Parameters: 
[
  "de-vanzare"
  "ro"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(7.20%) 		1 
SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM ax_property a0_ INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id AND (a0_.property_sub_type_id = a1_.id) INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id AND (a1_.property_type_id = a2_.id) WHERE a0_.locality_id = ? AND a0_.property_sub_type_id = a1_.id AND a1_.property_type_id = ? AND a0_.client_status = ? AND a0_.server_status = ? AND a0_.property_listing_type_id = ? ORDER BY a0_.created_at DESC LIMIT 10
Parameters: 
[
  "0131"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(5.82%) 		1 
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_property a0_ INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id AND (a0_.property_sub_type_id = a1_.id) INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id AND (a1_.property_type_id = a2_.id) WHERE a0_.locality_id = ? AND a0_.property_sub_type_id = a1_.id AND a1_.property_type_id = ? AND a0_.client_status = ? AND a0_.server_status = ? AND a0_.property_listing_type_id = ?
Parameters: 
[
  "0131"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(5.06%) 		1 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.district_id AS district_id_4 FROM ax_locality t0 WHERE t0.district_id = ? ORDER BY t0.id ASC
Parameters: 
[
  "01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.92%) 		1 
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5, t0.language_id AS language_id_6 FROM ax_property_description t0 WHERE t0.property_id = ? ORDER BY t0.created_at ASC
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.92%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.sex AS sex_7, t0.contact_hours AS contact_hours_8, t0.status AS status_9, t0.is_suspended AS is_suspended_10, t0.roles AS roles_11, t0.balance AS balance_12, t0.has_picture AS has_picture_13, t0.is_public_name AS is_public_name_14, t0.is_subscribed AS is_subscribed_15, ST_AsText(t0.location) AS location_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.language_id AS language_id_19, t0.company_id AS company_id_20, t21.id AS id_22, t21.phone_number AS phone_number_23, t21.status AS status_24, t21.code AS code_25, t21.ip_address AS ip_address_26, t21.created_at AS created_at_27, t21.updated_at AS updated_at_28, t21.user_id AS user_id_29 FROM ax_user t0 LEFT JOIN ax_user_phone t21 ON t21.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.75%) 		1 
SELECT t0.id AS id_1, t0.lat AS lat_2, t0.lng AS lng_3, t0.formatted_address AS formatted_address_4, t0.created_at AS created_at_5, t0.property_id AS property_id_6 FROM ax_property_image t0 WHERE t0.property_id = ? ORDER BY t0.created_at ASC
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.74%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(4.55%) 		1 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.label AS label_2, a0_.property_type_id AS property_type_id_3, a0_.language_id AS language_id_4 FROM ax_property_type_translation a0_ INNER JOIN ax_language a1_ ON a0_.language_id = a1_.id WHERE a0_.slug = ? AND a1_.locale = ?
Parameters: 
[
  "rezidential"
  "ro"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(4.16%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.property_type_id AS property_type_id_3 FROM ax_property_sub_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(3.74%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM ax_property_listing_type a0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(3.66%) 		1 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM ax_district t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "mun-chisinau"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(3.65%) 		1 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.district_id AS district_id_3 FROM ax_locality a0_ INNER JOIN ax_district a1_ ON a0_.district_id = a1_.id WHERE a0_.slug = ? AND a1_.slug = ?
Parameters: 
[
  "codru"
  "mun-chisinau"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(3.34%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM ax_property_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(3.26%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.property_type_id AS property_type_id_2 FROM ax_property_sub_type a0_ WHERE a0_.property_type_id = ? ORDER BY a0_.id ASC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(3.20%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1 FROM ax_property_type a0_ ORDER BY a0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(3.14%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(2.98%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.locale = ? LIMIT 1
Parameters: 
[
  "ro"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Locality 15
App\Entity\PropertyType 4
App\Entity\PropertyListingType 2
App\Entity\Language 2
App\Entity\PropertyDescription 2
App\Entity\PropertyListingTypeTranslation 1
App\Entity\PropertyTypeTranslation 1
App\Entity\District 1
App\Entity\Property 1
App\Entity\User 1
App\Entity\PropertySubType 1
App\Entity\ResidentialComplex 1
App\Entity\PropertyImage 1
App\Entity\Company 1
App\Entity\UserPhone 1

Entities Mapping

Class Mapping errors
App\Entity\PropertyListingTypeTranslation No errors.
App\Entity\Language No errors.
App\Entity\PropertyListingType No errors.
App\Entity\PropertyTypeTranslation No errors.
App\Entity\PropertyType No errors.
App\Entity\District No errors.
App\Entity\Locality No errors.
App\Entity\PropertySubType No errors.
App\Entity\Property No errors.
App\Entity\User No errors.
App\Entity\ResidentialComplex No errors.
App\Entity\PropertyDescription No errors.
App\Entity\PropertyImage No errors.
App\Entity\UserSavedProperty No errors.
App\Entity\PropertySubTypeTranslation No errors.
App\Entity\Company No errors.
App\Entity\UserPhone No errors.
App\Entity\CompanyDescription No errors.