GET https://land.n46.net/en/for-sale/residential/mun-chisinau/chisinau/view-map

Response
200 OK
IP
216.73.216.57
Profiled on
Token
34a53c

Query Metrics

24 Database Queries
19 Different statements
12.91 ms Query time
0 Invalid entities
69 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
9.14 ms
(70.77%) 		1 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.label AS label_2, a0_.property_sub_type_id AS property_sub_type_id_3, a0_.language_id AS language_id_4 FROM ax_property_sub_type_translation a0_ WHERE a0_.language_id = ? AND a0_.property_sub_type_id IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  1
  1
  1
  1
  3
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(5.98%) 		1 
SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, a0_.type AS 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_.country AS country_11, a0_.administrative_area_level_one AS administrative_area_level_one_12, a0_.administrative_area_level_one_slug AS administrative_area_level_one_slug_13, a0_.administrative_area_level_two AS administrative_area_level_two_14, a0_.locality_long_name AS locality_long_name_15, a0_.locality_long_name_slug AS locality_long_name_slug_16, a0_.sublocality AS sublocality_17, a0_.route AS route_18, a0_.street_number AS street_number_19, a0_.formatted_address AS formatted_address_20, a0_.lat AS lat_21, a0_.lng AS lng_22, a0_.place_id AS place_id_23, a0_.price AS price_24, a0_.price_per_square_meter AS price_per_square_meter_25, a0_.monthly_expenses AS monthly_expenses_26, a0_.orientation AS orientation_27, a0_.levels AS levels_28, a0_.bedrooms AS bedrooms_29, a0_.bathrooms AS bathrooms_30, a0_.wc AS wc_31, a0_.kitchens AS kitchens_32, a0_.livingrooms AS livingrooms_33, a0_.balconies AS balconies_34, a0_.heating_type AS heating_type_35, a0_.heating_medium AS heating_medium_36, a0_.ac AS ac_37, a0_.energy_class AS energy_class_38, a0_.new_development AS new_development_39, a0_.renovated AS renovated_40, a0_.requires_renovation AS requires_renovation_41, a0_.unfinished AS unfinished_42, a0_.under_construction AS under_construction_43, a0_.air_conditioning AS air_conditioning_44, a0_.heating_under_floor AS heating_under_floor_45, a0_.fireplace AS fireplace_46, a0_.alarm AS alarm_47, a0_.secure_door AS secure_door_48, a0_.storage_space AS storage_space_49, a0_.garden AS garden_50, a0_.garage AS garage_51, a0_.parking_space AS parking_space_52, a0_.solar_water_heater AS solar_water_heater_53, a0_.swimming_pool AS swimming_pool_54, a0_.floor AS floor_55, a0_.is_top_floor AS is_top_floor_56, a0_.elevator AS elevator_57, a0_.penthouse AS penthouse_58, a0_.zone AS zone_59, a0_.construction_year AS construction_year_60, a0_.furnished AS furnished_61, a0_.pets_allowed AS pets_allowed_62, a0_.land_classification AS land_classification_63, a0_.is_corner AS is_corner_64, a0_.youtube_video_id AS youtube_video_id_65, a0_.instagram_reel_id AS instagram_reel_id_66, a0_.client_status AS client_status_67, a0_.server_status AS server_status_68, a0_.views AS views_69, a0_.is_promoted AS is_promoted_70, a0_.available_date AS available_date_71, a0_.expiration_date AS expiration_date_72, a0_.created_at AS created_at_73, a0_.updated_at AS updated_at_74, a0_.user_id AS user_id_75, a0_.locality_id AS locality_id_76, a0_.property_sub_type_id AS property_sub_type_id_77, a0_.property_listing_type_id AS property_listing_type_id_78, a0_.residential_complex_id AS residential_complex_id_79 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_.price ASC
Parameters: 
[
  "0100"
  1
  "active"
  "ok"
  1
  48
  51
  47
  64
  15
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(5.05%) 		6 
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: 
[
  48
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(4.38%) 		1 
SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, a0_.type AS 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_.country AS country_11, a0_.administrative_area_level_one AS administrative_area_level_one_12, a0_.administrative_area_level_one_slug AS administrative_area_level_one_slug_13, a0_.administrative_area_level_two AS administrative_area_level_two_14, a0_.locality_long_name AS locality_long_name_15, a0_.locality_long_name_slug AS locality_long_name_slug_16, a0_.sublocality AS sublocality_17, a0_.route AS route_18, a0_.street_number AS street_number_19, a0_.formatted_address AS formatted_address_20, a0_.lat AS lat_21, a0_.lng AS lng_22, a0_.place_id AS place_id_23, a0_.price AS price_24, a0_.price_per_square_meter AS price_per_square_meter_25, a0_.monthly_expenses AS monthly_expenses_26, a0_.orientation AS orientation_27, a0_.levels AS levels_28, a0_.bedrooms AS bedrooms_29, a0_.bathrooms AS bathrooms_30, a0_.wc AS wc_31, a0_.kitchens AS kitchens_32, a0_.livingrooms AS livingrooms_33, a0_.balconies AS balconies_34, a0_.heating_type AS heating_type_35, a0_.heating_medium AS heating_medium_36, a0_.ac AS ac_37, a0_.energy_class AS energy_class_38, a0_.new_development AS new_development_39, a0_.renovated AS renovated_40, a0_.requires_renovation AS requires_renovation_41, a0_.unfinished AS unfinished_42, a0_.under_construction AS under_construction_43, a0_.air_conditioning AS air_conditioning_44, a0_.heating_under_floor AS heating_under_floor_45, a0_.fireplace AS fireplace_46, a0_.alarm AS alarm_47, a0_.secure_door AS secure_door_48, a0_.storage_space AS storage_space_49, a0_.garden AS garden_50, a0_.garage AS garage_51, a0_.parking_space AS parking_space_52, a0_.solar_water_heater AS solar_water_heater_53, a0_.swimming_pool AS swimming_pool_54, a0_.floor AS floor_55, a0_.is_top_floor AS is_top_floor_56, a0_.elevator AS elevator_57, a0_.penthouse AS penthouse_58, a0_.zone AS zone_59, a0_.construction_year AS construction_year_60, a0_.furnished AS furnished_61, a0_.pets_allowed AS pets_allowed_62, a0_.land_classification AS land_classification_63, a0_.is_corner AS is_corner_64, a0_.youtube_video_id AS youtube_video_id_65, a0_.instagram_reel_id AS instagram_reel_id_66, a0_.client_status AS client_status_67, a0_.server_status AS server_status_68, a0_.views AS views_69, a0_.is_promoted AS is_promoted_70, a0_.available_date AS available_date_71, a0_.expiration_date AS expiration_date_72, a0_.created_at AS created_at_73, a0_.updated_at AS updated_at_74, a0_.user_id AS user_id_75, a0_.locality_id AS locality_id_76, a0_.property_sub_type_id AS property_sub_type_id_77, a0_.property_listing_type_id AS property_listing_type_id_78, a0_.residential_complex_id AS residential_complex_id_79 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_.price ASC
Parameters: 
[
  "0100"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(2.28%) 		1 
SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_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_.price ASC LIMIT 10
Parameters: 
[
  "0100"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(1.80%) 		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: 
[
  "0100"
  1
  "active"
  "ok"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(1.71%) 		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: 
[
  "for-sale"
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.91%) 		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.11 ms
(0.88%) 		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: 
[
  "residential"
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.79%) 		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: 
[
  "chisinau"
  "mun-chisinau"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.73%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM ax_property_listing_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.63%) 		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.08 ms
(0.63%) 		1 
SELECT ST_AsGeoJSON(p.multipolygon) AS geojson FROM ax_property p WHERE p.id = :id
Parameters: 
[
  "id" => 15
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.62%) 		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.08 ms
(0.62%) 		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.07 ms
(0.57%) 		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: 
[
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.56%) 		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.07 ms
(0.56%) 		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.07 ms
(0.56%) 		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

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\PropertyImage 44
App\Entity\Property 6
App\Entity\PropertyType 4
App\Entity\User 4
App\Entity\PropertyListingType 2
App\Entity\PropertySubType 2
App\Entity\PropertySubTypeTranslation 2
App\Entity\PropertyListingTypeTranslation 1
App\Entity\Language 1
App\Entity\PropertyTypeTranslation 1
App\Entity\District 1
App\Entity\Locality 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\PropertySubType No errors.
App\Entity\District No errors.
App\Entity\Locality No errors.
App\Entity\Property No errors.
App\Entity\User No errors.
App\Entity\ResidentialComplex No errors.
App\Entity\PropertySubTypeTranslation No errors.
App\Entity\PropertyDescription No errors.
App\Entity\PropertyImage No errors.
App\Entity\UserSavedProperty No errors.