Redirect 301 redirect from GET @search (d95b1c)

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

Response
200 OK
IP
10.244.220.183
Profiled on
Token
f74f0c

Query Metrics

168 Database Queries
20 Different statements
501.06 ms Query time
3 Invalid entities
325 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.54 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.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.slug = ? LIMIT 1
Parameters: 
[
  "alexandria/smouha"
]
View formatted query    View runnable query    Explain query
2 2.79 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: 
[
  35
]
View formatted query    View runnable query    Explain query
3 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.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
4 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.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
5 2.54 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: 
[
  35
]
View formatted query    View runnable query    Explain query
6 2.62 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: 
[
  35
]
View formatted query    View runnable query    Explain query
7 7.96 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_.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 < 441 AND l0_._left > 178 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8 3.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: 
[
  25058
]
View formatted query    View runnable query    Explain query
9 2.83 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: 
[
  25138
]
View formatted query    View runnable query    Explain query
10 2.93 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: 
[
  24339
]
View formatted query    View runnable query    Explain query
11 7.27 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: 
[
  18218
]
View formatted query    View runnable query    Explain query
12 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: 
[
  18224
]
View formatted query    View runnable query    Explain query
13 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: 
[
  18234
]
View formatted query    View runnable query    Explain query
14 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: 
[
  18240
]
View formatted query    View runnable query    Explain query
15 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: 
[
  18242
]
View formatted query    View runnable query    Explain query
16 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: 
[
  18249
]
View formatted query    View runnable query    Explain query
17 2.73 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: 
[
  18251
]
View formatted query    View runnable query    Explain query
18 2.27 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: 
[
  18258
]
View formatted query    View runnable query    Explain query
19 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: 
[
  18263
]
View formatted query    View runnable query    Explain query
20 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: 
[
  18264
]
View formatted query    View runnable query    Explain query
21 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: 
[
  18269
]
View formatted query    View runnable query    Explain query
22 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: 
[
  18275
]
View formatted query    View runnable query    Explain query
23 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: 
[
  18276
]
View formatted query    View runnable query    Explain query
24 6.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: 
[
  18277
]
View formatted query    View runnable query    Explain query
25 2.94 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: 
[
  18279
]
View formatted query    View runnable query    Explain query
26 2.89 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: 
[
  18282
]
View formatted query    View runnable query    Explain query
27 2.94 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: 
[
  18285
]
View formatted query    View runnable query    Explain query
28 3.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: 
[
  18286
]
View formatted query    View runnable query    Explain query
29 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18288
]
View formatted query    View runnable query    Explain query
30 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: 
[
  18289
]
View formatted query    View runnable query    Explain query
31 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: 
[
  18290
]
View formatted query    View runnable query    Explain query
32 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: 
[
  18292
]
View formatted query    View runnable query    Explain query
33 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: 
[
  18293
]
View formatted query    View runnable query    Explain query
34 2.99 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: 
[
  18296
]
View formatted query    View runnable query    Explain query
35 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: 
[
  18299
]
View formatted query    View runnable query    Explain query
36 2.73 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: 
[
  18300
]
View formatted query    View runnable query    Explain query
37 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: 
[
  18301
]
View formatted query    View runnable query    Explain query
38 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: 
[
  18302
]
View formatted query    View runnable query    Explain query
39 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: 
[
  18303
]
View formatted query    View runnable query    Explain query
40 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18304
]
View formatted query    View runnable query    Explain query
41 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: 
[
  18310
]
View formatted query    View runnable query    Explain query
42 2.87 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: 
[
  18314
]
View formatted query    View runnable query    Explain query
43 2.75 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: 
[
  18315
]
View formatted query    View runnable query    Explain query
44 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: 
[
  18316
]
View formatted query    View runnable query    Explain query
45 5.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: 
[
  18317
]
View formatted query    View runnable query    Explain query
46 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: 
[
  18318
]
View formatted query    View runnable query    Explain query
47 2.84 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: 
[
  18319
]
View formatted query    View runnable query    Explain query
48 2.94 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: 
[
  18320
]
View formatted query    View runnable query    Explain query
49 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: 
[
  18321
]
View formatted query    View runnable query    Explain query
50 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: 
[
  18323
]
View formatted query    View runnable query    Explain query
51 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18324
]
View formatted query    View runnable query    Explain query
52 2.74 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: 
[
  18325
]
View formatted query    View runnable query    Explain query
53 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: 
[
  18326
]
View formatted query    View runnable query    Explain query
54 2.73 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: 
[
  18327
]
View formatted query    View runnable query    Explain query
55 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: 
[
  18328
]
View formatted query    View runnable query    Explain query
56 2.79 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: 
[
  18329
]
View formatted query    View runnable query    Explain query
57 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: 
[
  18330
]
View formatted query    View runnable query    Explain query
58 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18331
]
View formatted query    View runnable query    Explain query
59 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18332
]
View formatted query    View runnable query    Explain query
60 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: 
[
  18333
]
View formatted query    View runnable query    Explain query
61 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: 
[
  18335
]
View formatted query    View runnable query    Explain query
62 2.68 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: 
[
  18336
]
View formatted query    View runnable query    Explain query
63 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: 
[
  18338
]
View formatted query    View runnable query    Explain query
64 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18339
]
View formatted query    View runnable query    Explain query
65 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: 
[
  18340
]
View formatted query    View runnable query    Explain query
66 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: 
[
  18341
]
View formatted query    View runnable query    Explain query
67 2.62 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: 
[
  18343
]
View formatted query    View runnable query    Explain query
68 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: 
[
  18345
]
View formatted query    View runnable query    Explain query
69 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: 
[
  18346
]
View formatted query    View runnable query    Explain query
70 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: 
[
  18347
]
View formatted query    View runnable query    Explain query
71 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: 
[
  18349
]
View formatted query    View runnable query    Explain query
72 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  18350
]
View formatted query    View runnable query    Explain query
73 2.26 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: 
[
  18356
]
View formatted query    View runnable query    Explain query
74 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: 
[
  18357
]
View formatted query    View runnable query    Explain query
75 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: 
[
  18358
]
View formatted query    View runnable query    Explain query
76 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: 
[
  18359
]
View formatted query    View runnable query    Explain query
77 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: 
[
  18361
]
View formatted query    View runnable query    Explain query
78 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: 
[
  18363
]
View formatted query    View runnable query    Explain query
79 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: 
[
  18364
]
View formatted query    View runnable query    Explain query
80 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: 
[
  18365
]
View formatted query    View runnable query    Explain query
81 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: 
[
  18438
]
View formatted query    View runnable query    Explain query
82 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: 
[
  18439
]
View formatted query    View runnable query    Explain query
83 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: 
[
  18440
]
View formatted query    View runnable query    Explain query
84 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: 
[
  18441
]
View formatted query    View runnable query    Explain query
85 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: 
[
  18442
]
View formatted query    View runnable query    Explain query
86 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: 
[
  18443
]
View formatted query    View runnable query    Explain query
87 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: 
[
  18444
]
View formatted query    View runnable query    Explain query
88 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: 
[
  18445
]
View formatted query    View runnable query    Explain query
89 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: 
[
  18446
]
View formatted query    View runnable query    Explain query
90 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: 
[
  18447
]
View formatted query    View runnable query    Explain query
91 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: 
[
  18448
]
View formatted query    View runnable query    Explain query
92 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: 
[
  18449
]
View formatted query    View runnable query    Explain query
93 6.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: 
[
  18450
]
View formatted query    View runnable query    Explain query
94 2.87 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: 
[
  18451
]
View formatted query    View runnable query    Explain query
95 2.93 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: 
[
  24117
]
View formatted query    View runnable query    Explain query
96 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: 
[
  25141
]
View formatted query    View runnable query    Explain query
97 2.74 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: 
[
  25274
]
View formatted query    View runnable query    Explain query
98 2.82 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: 
[
  25338
]
View formatted query    View runnable query    Explain query
99 2.85 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: 
[
  26663
]
View formatted query    View runnable query    Explain query
100 2.82 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: 
[
  26722
]
View formatted query    View runnable query    Explain query
101 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  26646
]
View formatted query    View runnable query    Explain query
102 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: 
[
  26585
]
View formatted query    View runnable query    Explain query
103 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: 
[
  26373
]
View formatted query    View runnable query    Explain query
104 2.86 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: 
[
  26347
]
View formatted query    View runnable query    Explain query
105 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: 
[
  26311
]
View formatted query    View runnable query    Explain query
106 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: 
[
  25410
]
View formatted query    View runnable query    Explain query
107 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: 
[
  25331
]
View formatted query    View runnable query    Explain query
108 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: 
[
  25220
]
View formatted query    View runnable query    Explain query
109 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: 
[
  25182
]
View formatted query    View runnable query    Explain query
110 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: 
[
  24625
]
View formatted query    View runnable query    Explain query
111 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: 
[
  24443
]
View formatted query    View runnable query    Explain query
112 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: 
[
  24442
]
View formatted query    View runnable query    Explain query
113 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: 
[
  24441
]
View formatted query    View runnable query    Explain query
114 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: 
[
  24438
]
View formatted query    View runnable query    Explain query
115 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: 
[
  24437
]
View formatted query    View runnable query    Explain query
116 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: 
[
  24435
]
View formatted query    View runnable query    Explain query
117 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: 
[
  24173
]
View formatted query    View runnable query    Explain query
118 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: 
[
  24433
]
View formatted query    View runnable query    Explain query
119 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: 
[
  26699
]
View formatted query    View runnable query    Explain query
120 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: 
[
  26700
]
View formatted query    View runnable query    Explain query
121 2.79 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: 
[
  26701
]
View formatted query    View runnable query    Explain query
122 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: 
[
  24434
]
View formatted query    View runnable query    Explain query
123 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: 
[
  25483
]
View formatted query    View runnable query    Explain query
124 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: 
[
  25770
]
View formatted query    View runnable query    Explain query
125 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: 
[
  24436
]
View formatted query    View runnable query    Explain query
126 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters: 
[
  26912
]
View formatted query    View runnable query    Explain query
127 2.75 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: 
[
  26943
]
View formatted query    View runnable query    Explain query
128 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: 
[
  26980
]
View formatted query    View runnable query    Explain query
129 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: 
[
  26991
]
View formatted query    View runnable query    Explain query
130 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: 
[
  26994
]
View formatted query    View runnable query    Explain query
131 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: 
[
  27010
]
View formatted query    View runnable query    Explain query
132 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: 
[
  27334
]
View formatted query    View runnable query    Explain query
133 2.62 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: 
[
  27754
]
View formatted query    View runnable query    Explain query
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: 
[
  28106
]
View formatted query    View runnable query    Explain query
135 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: 
[
  28319
]
View formatted query    View runnable query    Explain query
136 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: 
[
  28806
]
View formatted query    View runnable query    Explain query
137 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: 
[
  26745
]
View formatted query    View runnable query    Explain query
138 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: 
[
  27760
]
View formatted query    View runnable query    Explain query
139 2.52 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.reference_id AS reference_id_9, t0.meta_search_description AS meta_search_description_10 FROM sections t0 WHERE t0.searchable = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
140 2.88 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: 
[]
View formatted query    View runnable query    Explain query
141 2.82 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: 
[]
View formatted query    View runnable query    Explain query
142 3.59 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
  35
]
View formatted query    View runnable query    Explain query
143 2.43 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.reference_id AS reference_id_9, t0.meta_search_description AS meta_search_description_10 FROM sections t0 WHERE t0.main = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
144 12.31 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_.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_ 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
  35
]
View formatted query    View runnable query    Explain query
145 2.57 ms 
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
146 2.75 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
]
View formatted query    View runnable query    Explain query
147 3.35 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: 
[
  35
]
View formatted query    View runnable query    Explain query
148 2.72 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-06-17 22:06:26"
]
View formatted query    View runnable query    Explain query
149 3.69 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_.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 <= 178 AND l0_._right >= 441 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
150 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: 
[
  2
]
View formatted query    View runnable query    Explain query
151 27.71 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.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.disabled = ? AND t0.parent_id = ?) ORDER BY t0._left ASC
Parameters: 
[
  0
  35
]
View formatted query    View runnable query    Explain query
152 3.12 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: 
[
  6782
]
View formatted query    View runnable query    Explain query
153 3.24 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_.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 <= 178 AND l0_._right >= 441 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
154 3.27 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_.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
]
View formatted query    View runnable query    Explain query
155 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
156 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: 
[
  8
]
View formatted query    View runnable query    Explain query
157 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: 
[
  7
]
View formatted query    View runnable query    Explain query
158 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: 
[
  16
]
View formatted query    View runnable query    Explain query
159 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
160 2.11 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
]
View formatted query    View runnable query    Explain query
161 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
162 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
163 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  47
]
View formatted query    View runnable query    Explain query
164 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: 
[
  38
]
View formatted query    View runnable query    Explain query
165 2.81 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
]
View formatted query    View runnable query    Explain query
166 3.26 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
  35
  1
  "title"
  5
]
View formatted query    View runnable query    Explain query
167 4.47 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_.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
]
View formatted query    View runnable query    Explain query
168 2.69 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
  35
  2
  "title"
  5
]
View formatted query    View runnable query    Explain query

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 139
Aqarmap\Bundle\ListingBundle\Entity\Location 134
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation 21
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 12
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation 8
Aqarmap\Bundle\ListingBundle\Entity\LocationRating 6
Aqarmap\Bundle\ListingBundle\Entity\Section 2
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.
App\Entity\Location\LocationTier 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\Comment No errors.
Aqarmap\Bundle\UserBundle\Entity\User
  • The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#geoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserGeoLocation#user does not contain the required 'inversedBy="geoLocations"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
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.