Redirect 301 redirect from GET @neighborhood_main_page (269942)

GET https://testing-eg.am-root.com/en/neighborhood/alexandria/bakoos/

Query Metrics

170 Database Queries
20 Different statements
469.44 ms Query time
2 Invalid entities
322 Managed entities

Queries

Group similar statements

# Time Info
1 3.53 ms
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.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "alexandria/bakoos"
]
2 2.96 ms
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:
[
  76
]
3 2.72 ms
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
]
4 2.66 ms
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:
[
  2
]
5 2.45 ms
SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE t0.location_id = ?
Parameters:
[
  76
]
6 2.41 ms
SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE t0.location_id = ?
Parameters:
[
  76
]
7 9.35 ms
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_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 3291 AND l0_._left > 3022 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  2
]
8 2.47 ms
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:
[
  22278
]
9 2.33 ms
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:
[
  22285
]
10 2.54 ms
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:
[
  22286
]
11 2.37 ms
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:
[
  22289
]
12 2.30 ms
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:
[
  22291
]
13 2.43 ms
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:
[
  22297
]
14 2.52 ms
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:
[
  22301
]
15 2.36 ms
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:
[
  22303
]
16 2.51 ms
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:
[
  22307
]
17 2.45 ms
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:
[
  22309
]
18 2.63 ms
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:
[
  22312
]
19 2.53 ms
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:
[
  22313
]
20 2.65 ms
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:
[
  22326
]
21 2.77 ms
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:
[
  22328
]
22 2.88 ms
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:
[
  22329
]
23 2.71 ms
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:
[
  22336
]
24 2.54 ms
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:
[
  22344
]
25 2.38 ms
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:
[
  22346
]
26 2.60 ms
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:
[
  22353
]
27 2.66 ms
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:
[
  22357
]
28 2.60 ms
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:
[
  22362
]
29 2.58 ms
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:
[
  22387
]
30 2.43 ms
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:
[
  22392
]
31 2.58 ms
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:
[
  22401
]
32 2.55 ms
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:
[
  22407
]
33 2.56 ms
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:
[
  22424
]
34 2.55 ms
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:
[
  22432
]
35 2.49 ms
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:
[
  22446
]
36 2.52 ms
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:
[
  22448
]
37 2.51 ms
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:
[
  22449
]
38 2.57 ms
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:
[
  22452
]
39 2.57 ms
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:
[
  22453
]
40 2.40 ms
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:
[
  22456
]
41 2.47 ms
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:
[
  22462
]
42 2.52 ms
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:
[
  22463
]
43 2.37 ms
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:
[
  22464
]
44 2.51 ms
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:
[
  22467
]
45 2.47 ms
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:
[
  22468
]
46 2.59 ms
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:
[
  22469
]
47 2.59 ms
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:
[
  22471
]
48 2.32 ms
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:
[
  22475
]
49 2.40 ms
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:
[
  22477
]
50 2.51 ms
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:
[
  22478
]
51 2.23 ms
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:
[
  22480
]
52 2.30 ms
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:
[
  22482
]
53 2.64 ms
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:
[
  22483
]
54 2.55 ms
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:
[
  22485
]
55 2.22 ms
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:
[
  22488
]
56 2.33 ms
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:
[
  22489
]
57 2.23 ms
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:
[
  22490
]
58 2.51 ms
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:
[
  22491
]
59 2.46 ms
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:
[
  22493
]
60 2.38 ms
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:
[
  22497
]
61 2.37 ms
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:
[
  22499
]
62 2.36 ms
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:
[
  22502
]
63 2.42 ms
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:
[
  22503
]
64 2.41 ms
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:
[
  22506
]
65 2.34 ms
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:
[
  22510
]
66 2.46 ms
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:
[
  22514
]
67 2.40 ms
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:
[
  22517
]
68 2.54 ms
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:
[
  22518
]
69 2.80 ms
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:
[
  22522
]
70 2.40 ms
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:
[
  22523
]
71 2.50 ms
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:
[
  22524
]
72 2.51 ms
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:
[
  22525
]
73 2.25 ms
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:
[
  22526
]
74 2.31 ms
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:
[
  22527
]
75 2.42 ms
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:
[
  22530
]
76 2.67 ms
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:
[
  22531
]
77 2.49 ms
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:
[
  22536
]
78 2.44 ms
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:
[
  22538
]
79 2.32 ms
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:
[
  22540
]
80 2.80 ms
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:
[
  22545
]
81 2.47 ms
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:
[
  22552
]
82 2.47 ms
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:
[
  22553
]
83 2.29 ms
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:
[
  22554
]
84 2.38 ms
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:
[
  22555
]
85 2.29 ms
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:
[
  22556
]
86 2.50 ms
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:
[
  22557
]
87 2.52 ms
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:
[
  22558
]
88 2.37 ms
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:
[
  22559
]
89 2.47 ms
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:
[
  22560
]
90 2.36 ms
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:
[
  22566
]
91 2.28 ms
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:
[
  22571
]
92 2.48 ms
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:
[
  22572
]
93 2.30 ms
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:
[
  22579
]
94 2.45 ms
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:
[
  22582
]
95 2.59 ms
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:
[
  22585
]
96 2.63 ms
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:
[
  22588
]
97 2.65 ms
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:
[
  22589
]
98 2.64 ms
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:
[
  22590
]
99 2.70 ms
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:
[
  22595
]
100 2.58 ms
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:
[
  22596
]
101 2.64 ms
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:
[
  22598
]
102 2.69 ms
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:
[
  22599
]
103 2.59 ms
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:
[
  22602
]
104 2.52 ms
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:
[
  22603
]
105 2.57 ms
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:
[
  22611
]
106 2.39 ms
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:
[
  22615
]
107 2.49 ms
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:
[
  22616
]
108 2.41 ms
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:
[
  22617
]
109 2.37 ms
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:
[
  22618
]
110 3.33 ms
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:
[
  22621
]
111 2.43 ms
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:
[
  22624
]
112 2.36 ms
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:
[
  22625
]
113 2.36 ms
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:
[
  22629
]
114 2.23 ms
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:
[
  22632
]
115 2.20 ms
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:
[
  22634
]
116 2.14 ms
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:
[
  22641
]
117 2.41 ms
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:
[
  22643
]
118 2.48 ms
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:
[
  22648
]
119 2.18 ms
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:
[
  22649
]
120 2.49 ms
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:
[
  22651
]
121 2.45 ms
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:
[
  22652
]
122 2.29 ms
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:
[
  22653
]
123 2.24 ms
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:
[
  22654
]
124 2.24 ms
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:
[
  22655
]
125 2.29 ms
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:
[
  22657
]
126 2.35 ms
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:
[
  22658
]
127 2.31 ms
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:
[
  22660
]
128 2.35 ms
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:
[
  22661
]
129 2.31 ms
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:
[
  22662
]
130 2.22 ms
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:
[
  22664
]
131 2.02 ms
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:
[
  22667
]
132 2.56 ms
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:
[
  22668
]
133 2.24 ms
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:
[
  22678
]
134 2.35 ms
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:
[
  22682
]
135 2.39 ms
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:
[
  22686
]
136 2.57 ms
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:
[
  22688
]
137 2.71 ms
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:
[
  22693
]
138 2.37 ms
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:
[
  22706
]
139 2.57 ms
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:
[
  24116
]
140 2.52 ms
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:
[
  24396
]
141 2.63 ms
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:
[
  28646
]
142 2.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.searchable = ?
Parameters:
[
  1
]
143 2.34 ms
SELECT l0_.id AS id_0, l0_.growth AS growth_1, l0_.avg_price AS avg_price_2, l0_.demand_heat AS demand_heat_3, l0_.ppm_min AS ppm_min_4, l0_.ppm_max AS ppm_max_5, l0_.updated_at AS updated_at_6, l0_.section_id AS section_id_7, l0_.property_type_id AS property_type_id_8, l0_.location_id AS location_id_9 FROM locations_statistics l0_ ORDER BY l0_.updated_at DESC LIMIT 1
Parameters:
[]
144 3.64 ms
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 LIMIT 3
Parameters:
[
  2
  76
]
145 2.85 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.main = ? LIMIT 1
Parameters:
[
  1
]
146 3.91 ms
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_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ INNER JOIN locations_nearestby l2_ ON l0_.id = l2_.nearest_location_id INNER JOIN locations l1_ ON l1_.id = l2_.location_id WHERE l0_.neighborhood_filter = ? AND l1_.id = ? LIMIT 3
Parameters:
[
  true
  76
]
147 2.77 ms
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
Parameters:
[]
148 2.76 ms
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
]
149 3.05 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = ?
Parameters:
[
  76
]
150 3.05 ms
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-02-08 02:56:44"
]
151 5.00 ms
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_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 3022 AND l0_._right >= 3291 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  2
]
152 2.42 ms
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:
[
  2
]
153 30.14 ms
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.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE (t0.disabled = ? AND t0.parent_id = ?) ORDER BY t0._left ASC
Parameters:
[
  0
  76
]
154 3.00 ms
SELECT t0.id AS id_1, t0.overall AS overall_2, t0.neighborhood AS neighborhood_3, t0.education AS education_4, t0.location_rate AS location_rate_5, t0.transportation AS transportation_6, t0.population AS population_7, t0.Life_style AS Life_style_8, t0.health_care AS health_care_9, t0.location_id AS location_id_10 FROM locations_rating t0 WHERE t0.id = ?
Parameters:
[
  6805
]
155 4.57 ms
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_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 3022 AND l0_._right >= 3291 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  2
]
156 3.33 ms
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_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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
]
157 2.53 ms
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
]
158 2.56 ms
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:
[
  8
]
159 2.40 ms
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:
[
  7
]
160 2.49 ms
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:
[
  16
]
161 2.72 ms
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:
[
  11
]
162 2.78 ms
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:
[
  5
]
163 2.25 ms
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:
[
  14
]
164 2.61 ms
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:
[
  13
]
165 2.41 ms
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:
[
  47
]
166 2.53 ms
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:
[
  38
]
167 2.63 ms
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:
[
  10
]
168 3.42 ms
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
  76
  1
  "title"
  5
]
169 3.42 ms
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_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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
]
170 3.05 ms
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
  76
  2
  "title"
  5
]

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 138
Aqarmap\Bundle\ListingBundle\Entity\Location 137
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation 21
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 12
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation 8
Aqarmap\Bundle\ListingBundle\Entity\Section 2
Aqarmap\Bundle\ListingBundle\Entity\LocationRating 1
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics 1
Aqarmap\Bundle\DiscussionBundle\Entity\Category 1
Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation 1

Entities Mapping

Class Mapping errors
Aqarmap\Bundle\ListingBundle\Entity\Location
  • The mappings Aqarmap\Bundle\ListingBundle\Entity\Location#childrenSortedById and Aqarmap\Bundle\ListingBundle\Entity\Location#parent are inconsistent with each other.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule No errors.
Aqarmap\Bundle\ListingBundle\Entity\Listing
  • The field Aqarmap\Bundle\ListingBundle\Entity\Listing#compoundAveragePrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#parentCompound does not contain the required 'inversedBy="compoundAveragePrices"' attribute.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationRating No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation No errors.
Aqarmap\Bundle\CRMBundle\Entity\Company No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand No errors.
Aqarmap\Bundle\NotifierBundle\Entity\Notifier No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest No errors.
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm No errors.
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Category No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\StatisticsHistory No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\Photo No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice No errors.