Redirect 302 redirect from GET @show_property_by_id (83869f)

GET https://land.n46.net/ro/de-vanzare/rezidential/mun-chisinau/chisinau/65

Response
200 OK
Browse referrer URL
IP
216.73.216.57
Profiled on
Token
c232dd

Query Metrics

16 Database Queries
15 Different statements
2.40 ms Query time
0 Invalid entities
23 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.33 ms
(13.79%) 		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_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = a2_.id AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 3
Parameters: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(11.66%) 		1 
SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, t0.type AS type_3, t0.address AS address_4, t0.use_for AS use_for_5, t0.land_area AS land_area_6, t0.area AS area_7, t0.ownership AS ownership_8, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_9, ST_AsText(t0.multipolygon) AS multipolygon_10, ST_AsText(t0.centroid) AS centroid_11, t0.country AS country_12, t0.administrative_area_level_one AS administrative_area_level_one_13, t0.administrative_area_level_one_slug AS administrative_area_level_one_slug_14, t0.administrative_area_level_two AS administrative_area_level_two_15, t0.locality_long_name AS locality_long_name_16, t0.locality_long_name_slug AS locality_long_name_slug_17, t0.sublocality AS sublocality_18, t0.route AS route_19, t0.street_number AS street_number_20, t0.formatted_address AS formatted_address_21, t0.lat AS lat_22, t0.lng AS lng_23, t0.place_id AS place_id_24, t0.price AS price_25, t0.price_per_square_meter AS price_per_square_meter_26, t0.monthly_expenses AS monthly_expenses_27, t0.orientation AS orientation_28, t0.levels AS levels_29, t0.bedrooms AS bedrooms_30, t0.bathrooms AS bathrooms_31, t0.wc AS wc_32, t0.kitchens AS kitchens_33, t0.livingrooms AS livingrooms_34, t0.balconies AS balconies_35, t0.heating_type AS heating_type_36, t0.heating_medium AS heating_medium_37, t0.ac AS ac_38, t0.energy_class AS energy_class_39, t0.new_development AS new_development_40, t0.renovated AS renovated_41, t0.requires_renovation AS requires_renovation_42, t0.unfinished AS unfinished_43, t0.under_construction AS under_construction_44, t0.air_conditioning AS air_conditioning_45, t0.heating_under_floor AS heating_under_floor_46, t0.fireplace AS fireplace_47, t0.alarm AS alarm_48, t0.secure_door AS secure_door_49, t0.storage_space AS storage_space_50, t0.garden AS garden_51, t0.garage AS garage_52, t0.parking_space AS parking_space_53, t0.solar_water_heater AS solar_water_heater_54, t0.swimming_pool AS swimming_pool_55, t0.floor AS floor_56, t0.is_top_floor AS is_top_floor_57, t0.elevator AS elevator_58, t0.penthouse AS penthouse_59, t0.zone AS zone_60, t0.construction_year AS construction_year_61, t0.furnished AS furnished_62, t0.pets_allowed AS pets_allowed_63, t0.land_classification AS land_classification_64, t0.is_corner AS is_corner_65, t0.youtube_video_id AS youtube_video_id_66, t0.instagram_reel_id AS instagram_reel_id_67, t0.client_status AS client_status_68, t0.server_status AS server_status_69, t0.views AS views_70, t0.is_promoted AS is_promoted_71, t0.available_date AS available_date_72, t0.expiration_date AS expiration_date_73, t0.created_at AS created_at_74, t0.updated_at AS updated_at_75, t0.user_id AS user_id_76, t0.locality_id AS locality_id_77, t0.property_sub_type_id AS property_sub_type_id_78, t0.property_listing_type_id AS property_listing_type_id_79, t0.residential_complex_id AS residential_complex_id_80 FROM ax_property t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "65"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(11.16%) 		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.22 ms
(9.07%) 		1 
SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, t0.type AS type_3, t0.address AS address_4, t0.use_for AS use_for_5, t0.land_area AS land_area_6, t0.area AS area_7, t0.ownership AS ownership_8, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_9, ST_AsText(t0.multipolygon) AS multipolygon_10, ST_AsText(t0.centroid) AS centroid_11, t0.country AS country_12, t0.administrative_area_level_one AS administrative_area_level_one_13, t0.administrative_area_level_one_slug AS administrative_area_level_one_slug_14, t0.administrative_area_level_two AS administrative_area_level_two_15, t0.locality_long_name AS locality_long_name_16, t0.locality_long_name_slug AS locality_long_name_slug_17, t0.sublocality AS sublocality_18, t0.route AS route_19, t0.street_number AS street_number_20, t0.formatted_address AS formatted_address_21, t0.lat AS lat_22, t0.lng AS lng_23, t0.place_id AS place_id_24, t0.price AS price_25, t0.price_per_square_meter AS price_per_square_meter_26, t0.monthly_expenses AS monthly_expenses_27, t0.orientation AS orientation_28, t0.levels AS levels_29, t0.bedrooms AS bedrooms_30, t0.bathrooms AS bathrooms_31, t0.wc AS wc_32, t0.kitchens AS kitchens_33, t0.livingrooms AS livingrooms_34, t0.balconies AS balconies_35, t0.heating_type AS heating_type_36, t0.heating_medium AS heating_medium_37, t0.ac AS ac_38, t0.energy_class AS energy_class_39, t0.new_development AS new_development_40, t0.renovated AS renovated_41, t0.requires_renovation AS requires_renovation_42, t0.unfinished AS unfinished_43, t0.under_construction AS under_construction_44, t0.air_conditioning AS air_conditioning_45, t0.heating_under_floor AS heating_under_floor_46, t0.fireplace AS fireplace_47, t0.alarm AS alarm_48, t0.secure_door AS secure_door_49, t0.storage_space AS storage_space_50, t0.garden AS garden_51, t0.garage AS garage_52, t0.parking_space AS parking_space_53, t0.solar_water_heater AS solar_water_heater_54, t0.swimming_pool AS swimming_pool_55, t0.floor AS floor_56, t0.is_top_floor AS is_top_floor_57, t0.elevator AS elevator_58, t0.penthouse AS penthouse_59, t0.zone AS zone_60, t0.construction_year AS construction_year_61, t0.furnished AS furnished_62, t0.pets_allowed AS pets_allowed_63, t0.land_classification AS land_classification_64, t0.is_corner AS is_corner_65, t0.youtube_video_id AS youtube_video_id_66, t0.instagram_reel_id AS instagram_reel_id_67, t0.client_status AS client_status_68, t0.server_status AS server_status_69, t0.views AS views_70, t0.is_promoted AS is_promoted_71, t0.available_date AS available_date_72, t0.expiration_date AS expiration_date_73, t0.created_at AS created_at_74, t0.updated_at AS updated_at_75, t0.user_id AS user_id_76, t0.locality_id AS locality_id_77, t0.property_sub_type_id AS property_sub_type_id_78, t0.property_listing_type_id AS property_listing_type_id_79, t0.residential_complex_id AS residential_complex_id_80 FROM ax_property t0 WHERE t0.id = ? AND t0.locality_id = ? AND t0.property_listing_type_id = ? LIMIT 1
Parameters: 
[
  65
  "0100"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(7.96%) 		2 
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(6.24%) 		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.13 ms
(5.62%) 		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, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t0.company_id AS company_id_19, t20.id AS id_21, t20.phone_number AS phone_number_22, t20.status AS status_23, t20.code AS code_24, t20.ip_address AS ip_address_25, t20.created_at AS created_at_26, t20.updated_at AS updated_at_27, t20.user_id AS user_id_28 FROM ax_user t0 LEFT JOIN ax_user_phone t20 ON t20.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(5.58%) 		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: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(5.33%) 		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.13 ms
(5.29%) 		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: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(4.21%) 		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
(3.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.09 ms
(3.54%) 		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.09 ms
(3.54%) 		1 
SELECT t0.id AS id_1, t0.favourite AS favourite_2, t0.notes AS notes_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.property_id AS property_id_7 FROM ax_user_saved_property t0 WHERE t0.user_id IS NULL AND t0.property_id = ? LIMIT 1
Parameters: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(3.38%) 		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

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\Property 4
App\Entity\Locality 3
App\Entity\PropertySubType 3
App\Entity\Language 2
App\Entity\User 2
App\Entity\PropertyDescription 2
App\Entity\PropertyListingTypeTranslation 1
App\Entity\PropertyListingType 1
App\Entity\PropertyTypeTranslation 1
App\Entity\PropertyType 1
App\Entity\District 1
App\Entity\PropertyImage 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\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.
App\Entity\Company No errors.
App\Entity\UserPhone No errors.