Query Metrics
378
Database Queries
20
Different statements
809.94 ms
Query time
3
Invalid entities
896
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
672.75 ms (83.06%) |
341 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
1
]
|
|
33.35 ms (4.12%) |
2 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.level AS level_16, l0_._left AS _left_17, l0_._right AS _right_18, l0_.root AS root_19, l0_.show_primary_only AS show_primary_only_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.synonyms AS synonyms_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.type AS type_26, l0_.eligible_for_mortgage AS eligible_for_mortgage_27, l0_.is_compound_location AS is_compound_location_28, l0_.parent_id AS parent_id_29, l0_.location_compound_id AS location_compound_id_30, l0_.rating_id AS rating_id_31, l0_.listing_id AS listing_id_32 FROM locations l0_ WHERE l0_._right < 14989 AND l0_._left > 14310 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
1
]
|
|
23.06 ms (2.85%) |
2 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.level AS level_16, l0_._left AS _left_17, l0_._right AS _right_18, l0_.root AS root_19, l0_.show_primary_only AS show_primary_only_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.synonyms AS synonyms_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.type AS type_26, l0_.eligible_for_mortgage AS eligible_for_mortgage_27, l0_.is_compound_location AS is_compound_location_28, l0_.parent_id AS parent_id_29, l0_.location_compound_id AS location_compound_id_30, l0_.rating_id AS rating_id_31, l0_.listing_id AS listing_id_32 FROM locations l0_ WHERE l0_._left <= 14310 AND l0_._right >= 14989 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
1
]
|
|
20.44 ms (2.52%) |
11 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
1
]
|
|
9.57 ms (1.18%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95, l0_.new_valuation_id AS new_valuation_id_96 FROM listings l0_ WHERE (l0_.status = ? AND l0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4
Parameters:
[ 2 41 7019 7011 7085 7086 24038 24039 24260 25612 26277 26762 27475 1280 1229 7119 28611 24852 24853 26976 26977 26978 24854 24855 24856 26308 24857 26979 27530 24858 26305 27732 28150 28341 28893 29128 242 28540 28550 28921 28931 29063 243 244 1268 251 1281 7199 7200 1357 1359 1381 1382 1383 1269 24184 24486 25064 25065 25066 25068 25069 25070 25072 25197 27016 27062 1277 27301 27464 27533 27632 28058 28079 28117 28125 28126 28128 28426 28435 28619 28809 28826 28904 28976 28981 28982 29010 29038 29040 29098 29248 245 246 26899 26900 26901 26902 26903 26907 26908 26909 26910 26911 26919 26920 26921 26922 26923 26932 26933 26934 26935 26936 26959 26960 26961 247 26962 26963 26969 26970 26971 26972 26973 26996 26997 26998 26999 27000 27018 27019 27020 27021 27022 27028 27029 27030 27031 27032 27044 27045 27046 27047 27048 27065 27066 27067 27068 27069 27092 27093 27094 27095 27096 27110 27111 27112 27113 27114 27139 27140 27141 27142 27143 27147 27148 27149 28190 248 27150 27151 27159 27160 27161 27162 27163 27173 27174 27175 27176 27177 27184 27185 27186 27187 27188 27199 27200 27201 27202 27203 27210 27211 27212 27213 27214 27227 27228 27229 27230 27231 27236 27237 249 250 27238 27239 27240 27257 27258 27259 27260 27261 27263 27264 27265 27266 27267 27274 27275 27276 27277 27278 27284 27285 27286 27287 27288 27290 27291 27292 27293 27294 27296 27297 27298 27299 27300 27303 27304 27305 27306 27307 27312 27313 27314 27315 27316 27329 27330 27331 27332 27333 27341 27342 27343 27344 27345 27346 27347 27348 27349 27350 27373 27374 27375 27376 27377 27385 27386 27387 27388 27389 27397 27398 27399 27400 27401 27408 27409 27410 27411 27412 27417 27418 27419 27420 27421 27445 27446 27447 27461 27462 27463 27470 27471 27918 28303 252 769 770 771 772 253 254 1278 255 25007 25008 25009 25010 25011 25012 25013 25018 25019 25020 25021 25022 25023 25024 25025 25026 25027 25028 25029 25030 25031 25032 25033 25034 25035 25036 25037 25038 25039 23790 27241 29077 29078 ] |
|
7.50 ms (0.93%) |
4 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
888
]
|
|
4.86 ms (0.60%) |
2 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.searchable AS searchable_14, p0_.deleted_at AS deleted_at_15, p0_.custom_order AS custom_order_16, p0_.amenities AS amenities_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC
Parameters:
[
false
]
|
|
4.61 ms (0.57%) |
2 |
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p1_.content AS content_2, p0_.level AS level_3, s2_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s2_ ON (s2_.property_type_id = p0_.id) INNER JOIN property_types_translations p1_ ON p0_.id = p1_.property_type_id WHERE (s2_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s2_.location_id IN (?) AND s2_.section_id = ? AND p1_.field = ? AND s2_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s2_.search_result_count DESC
Parameters:
[ 1 8 7 16 11 5 14 13 47 38 10 41 1 "title" 5 ] |
|
4.29 ms (0.53%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95, l0_.new_valuation_id AS new_valuation_id_96 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL)
Parameters:
[ "263" "58" "20" "376" "213" ] |
|
3.84 ms (0.47%) |
2 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters:
[
1
]
|
|
3.67 ms (0.45%) |
1 |
SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ INNER JOIN comments c1_ ON d0_.id = c1_.discussion_id AND (c1_.deleted_at IS NULL) WHERE (d0_.status = ? AND d0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d0_.comments_counter > 0) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.comments_counter DESC, d0_.created_at DESC
Parameters:
[ 2 41 7019 7011 7085 7086 24038 24039 24260 25612 26277 26762 27475 1280 1229 7119 28611 24852 24853 26976 26977 26978 24854 24855 24856 26308 24857 26979 27530 24858 26305 27732 28150 28341 28893 29128 242 28540 28550 28921 28931 29063 243 244 1268 251 1281 7199 7200 1357 1359 1381 1382 1383 1269 24184 24486 25064 25065 25066 25068 25069 25070 25072 25197 27016 27062 1277 27301 27464 27533 27632 28058 28079 28117 28125 28126 28128 28426 28435 28619 28809 28826 28904 28976 28981 28982 29010 29038 29040 29098 29248 245 246 26899 26900 26901 26902 26903 26907 26908 26909 26910 26911 26919 26920 26921 26922 26923 26932 26933 26934 26935 26936 26959 26960 26961 247 26962 26963 26969 26970 26971 26972 26973 26996 26997 26998 26999 27000 27018 27019 27020 27021 27022 27028 27029 27030 27031 27032 27044 27045 27046 27047 27048 27065 27066 27067 27068 27069 27092 27093 27094 27095 27096 27110 27111 27112 27113 27114 27139 27140 27141 27142 27143 27147 27148 27149 28190 248 27150 27151 27159 27160 27161 27162 27163 27173 27174 27175 27176 27177 27184 27185 27186 27187 27188 27199 27200 27201 27202 27203 27210 27211 27212 27213 27214 27227 27228 27229 27230 27231 27236 27237 249 250 27238 27239 27240 27257 27258 27259 27260 27261 27263 27264 27265 27266 27267 27274 27275 27276 27277 27278 27284 27285 27286 27287 27288 27290 27291 27292 27293 27294 27296 27297 27298 27299 27300 27303 27304 27305 27306 27307 27312 27313 27314 27315 27316 27329 27330 27331 27332 27333 27341 27342 27343 27344 27345 27346 27347 27348 27349 27350 27373 27374 27375 27376 27377 27385 27386 27387 27388 27389 27397 27398 27399 27400 27401 27408 27409 27410 27411 27412 27417 27418 27419 27420 27421 27445 27446 27447 27461 27462 27463 27470 27471 27918 28303 252 769 770 771 772 253 254 1278 255 25007 25008 25009 25010 25011 25012 25013 25018 25019 25020 25021 25022 25023 25024 25025 25026 25027 25028 25029 25030 25031 25032 25033 25034 25035 25036 25037 25038 25039 23790 27241 29077 29078 ] |
|
3.52 ms (0.43%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.level AS level_16, l0_._left AS _left_17, l0_._right AS _right_18, l0_.root AS root_19, l0_.show_primary_only AS show_primary_only_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.synonyms AS synonyms_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.type AS type_26, l0_.eligible_for_mortgage AS eligible_for_mortgage_27, l0_.is_compound_location AS is_compound_location_28, l0_.parent_id AS parent_id_29, l0_.location_compound_id AS location_compound_id_30, l0_.rating_id AS rating_id_31, l0_.listing_id AS listing_id_32 FROM locations l0_ WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1
Parameters:
[ false true ] |
|
3.37 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.level AS level_17, t0._left AS _left_18, t0._right AS _right_19, t0.root AS root_20, t0.show_primary_only AS show_primary_only_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.synonyms AS synonyms_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id = ?
Parameters:
[
"41"
]
|
|
2.81 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.searchable AS searchable_15, t0.deleted_at AS deleted_at_16, t0.custom_order AS custom_order_17, t0.amenities AS amenities_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
1
]
|
|
2.34 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM listing_score_settings t0
Parameters:
[] |
|
2.21 ms (0.27%) |
1 |
SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[
83
]
|
|
2.08 ms (0.26%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ?
Parameters:
[ 1 "2026-06-08 21:22:05" ] |
|
1.91 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.category_id AS category_id_5 FROM discussions_categories_translations t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
|
1.89 ms (0.23%) |
1 |
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
Parameters:
[] |
|
1.87 ms (0.23%) |
1 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ?
Parameters:
[
"web.enable.facebooklogin"
]
|
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 |
|---|---|
| Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation | 380 |
| Aqarmap\Bundle\ListingBundle\Entity\Location | 341 |
| Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting | 75 |
| Aqarmap\Bundle\ListingBundle\Entity\LocationRating | 21 |
| Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation | 21 |
| Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation | 20 |
| Aqarmap\Bundle\ListingBundle\Entity\PropertyType | 13 |
| Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation | 8 |
| Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound | 6 |
| Aqarmap\Bundle\ListingBundle\Entity\Listing | 5 |
| Aqarmap\Bundle\ListingBundle\Entity\Section | 2 |
| Aqarmap\Bundle\UserBundle\Entity\User | 2 |
| Aqarmap\Bundle\DiscussionBundle\Entity\Category | 1 |
| Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation | 1 |