Redirect 301 redirect from GET @neighborhood_main_page (26c684)

GET https://testing-eg.am-root.com/en/neighborhood/cairo/faisal/

Query Metrics

297 Database Queries
20 Different statements
656.20 ms Query time
2 Invalid entities
809 Managed entities

Queries

Group similar statements

# Time Info
1 4.40 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.synonyms AS synonyms_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:
[
  "cairo/faisal"
]
2 2.21 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  44
]
3 1.94 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 1.97 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.08 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:
[
  44
]
6 2.09 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:
[
  44
]
7 14.64 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_.synonyms AS synonyms_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 < 15513 AND l0_._left > 14990 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  1
]
8 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:
[
  284
]
9 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  25088
]
10 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  25079
]
11 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17260
]
12 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17265
]
13 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17270
]
14 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17271
]
15 3.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:
[
  17272
]
16 1.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:
[
  25089
]
17 3.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:
[
  27820
]
18 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17273
]
19 2.15 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17274
]
20 1.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17275
]
21 3.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:
[
  17276
]
22 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17278
]
23 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17279
]
24 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:
[
  17280
]
25 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17281
]
26 1.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17282
]
27 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17283
]
28 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:
[
  17284
]
29 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:
[
  17286
]
30 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17288
]
31 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17289
]
32 1.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:
[
  17290
]
33 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17291
]
34 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17293
]
35 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17295
]
36 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17296
]
37 1.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:
[
  17299
]
38 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17300
]
39 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17302
]
40 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17303
]
41 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17304
]
42 1.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:
[
  17306
]
43 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17307
]
44 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17309
]
45 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17311
]
46 1.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:
[
  17315
]
47 1.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:
[
  17316
]
48 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17326
]
49 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:
[
  17330
]
50 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17332
]
51 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17340
]
52 2.12 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17343
]
53 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:
[
  27542
]
54 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  27847
]
55 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28365
]
56 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28442
]
57 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28645
]
58 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28758
]
59 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28985
]
60 1.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:
[
  285
]
61 1.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:
[
  27769
]
62 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  27951
]
63 1.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28625
]
64 1.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:
[
  28833
]
65 1.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:
[
  286
]
66 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17253
]
67 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17254
]
68 1.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:
[
  17255
]
69 1.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:
[
  17256
]
70 1.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:
[
  17257
]
71 1.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:
[
  17258
]
72 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17259
]
73 1.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:
[
  17261
]
74 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17262
]
75 1.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:
[
  17263
]
76 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:
[
  17264
]
77 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17266
]
78 1.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:
[
  17267
]
79 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17268
]
80 1.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:
[
  17269
]
81 1.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:
[
  17277
]
82 1.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:
[
  17285
]
83 1.81 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17287
]
84 1.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:
[
  287
]
85 1.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:
[
  17381
]
86 1.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:
[
  17382
]
87 1.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:
[
  17383
]
88 1.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:
[
  17397
]
89 1.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:
[
  17398
]
90 1.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:
[
  17401
]
91 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17403
]
92 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17405
]
93 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17406
]
94 2.10 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17407
]
95 1.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:
[
  17408
]
96 2.10 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17411
]
97 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17412
]
98 1.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:
[
  17415
]
99 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17416
]
100 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17419
]
101 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17420
]
102 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17422
]
103 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17423
]
104 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17424
]
105 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17428
]
106 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17429
]
107 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17430
]
108 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17434
]
109 1.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:
[
  17442
]
110 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17444
]
111 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:
[
  17445
]
112 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:
[
  17449
]
113 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:
[
  17458
]
114 2.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17461
]
115 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17476
]
116 2.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17492
]
117 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17502
]
118 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17508
]
119 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17509
]
120 1.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:
[
  17510
]
121 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17513
]
122 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17516
]
123 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17517
]
124 1.81 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  288
]
125 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  25663
]
126 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:
[
  25737
]
127 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28219
]
128 1.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:
[
  289
]
129 1.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:
[
  291
]
130 1.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:
[
  292
]
131 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17292
]
132 1.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:
[
  17294
]
133 1.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:
[
  17297
]
134 1.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:
[
  17298
]
135 1.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:
[
  17301
]
136 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17305
]
137 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:
[
  17308
]
138 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17310
]
139 1.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:
[
  17312
]
140 1.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:
[
  17313
]
141 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:
[
  17314
]
142 1.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:
[
  17317
]
143 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17318
]
144 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17319
]
145 1.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:
[
  17320
]
146 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:
[
  17321
]
147 1.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:
[
  17322
]
148 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:
[
  17323
]
149 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17324
]
150 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17325
]
151 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17327
]
152 1.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:
[
  17328
]
153 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17329
]
154 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17331
]
155 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17333
]
156 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:
[
  17334
]
157 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17335
]
158 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17336
]
159 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:
[
  17337
]
160 2.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17338
]
161 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17339
]
162 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17341
]
163 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:
[
  17342
]
164 1.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:
[
  17344
]
165 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:
[
  17345
]
166 2.12 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17346
]
167 1.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17347
]
168 1.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:
[
  17348
]
169 1.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:
[
  17349
]
170 1.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:
[
  17350
]
171 1.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:
[
  17351
]
172 1.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:
[
  17352
]
173 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17353
]
174 1.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17354
]
175 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17355
]
176 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17356
]
177 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17357
]
178 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17358
]
179 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17359
]
180 4.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:
[
  17360
]
181 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17361
]
182 1.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:
[
  17362
]
183 1.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:
[
  17363
]
184 2.10 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17364
]
185 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:
[
  17365
]
186 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17366
]
187 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17367
]
188 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17368
]
189 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:
[
  17369
]
190 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17370
]
191 2.03 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17371
]
192 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17372
]
193 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17373
]
194 2.16 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17374
]
195 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:
[
  17375
]
196 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:
[
  17376
]
197 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17377
]
198 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17378
]
199 2.16 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17379
]
200 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17380
]
201 2.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17384
]
202 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:
[
  17385
]
203 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17386
]
204 2.21 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17387
]
205 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17388
]
206 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17389
]
207 2.12 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17390
]
208 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17391
]
209 2.15 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17392
]
210 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17393
]
211 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17394
]
212 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17395
]
213 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:
[
  17396
]
214 1.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:
[
  17399
]
215 1.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:
[
  17400
]
216 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:
[
  17402
]
217 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17404
]
218 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17409
]
219 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:
[
  17410
]
220 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17418
]
221 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17421
]
222 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.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17425
]
223 2.12 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17426
]
224 2.15 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17427
]
225 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17433
]
226 2.13 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17437
]
227 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17438
]
228 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17446
]
229 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17452
]
230 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17455
]
231 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:
[
  17460
]
232 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17467
]
233 1.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:
[
  17474
]
234 1.81 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  17475
]
235 1.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:
[
  28070
]
236 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28226
]
237 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28227
]
238 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28363
]
239 1.81 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28572
]
240 1.92 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28587
]
241 2.06 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28856
]
242 2.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  29035
]
243 1.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:
[
  29117
]
244 1.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:
[
  29195
]
245 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  294
]
246 2.04 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  295
]
247 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  296
]
248 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  297
]
249 1.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:
[
  298
]
250 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:
[
  25500
]
251 1.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:
[
  28004
]
252 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28245
]
253 2.01 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28641
]
254 1.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28725
]
255 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  299
]
256 1.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:
[
  300
]
257 1.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:
[
  1232
]
258 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  27039
]
259 1.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:
[
  27561
]
260 1.98 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28016
]
261 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28189
]
262 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:
[
  28206
]
263 1.97 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28237
]
264 2.05 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28240
]
265 2.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
  28350
]
266 1.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:
[
  28413
]
267 1.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:
[
  28465
]
268 1.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:
[
  29197
]
269 1.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.searchable = ?
Parameters:
[
  1
]
270 1.80 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:
[]
271 2.38 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
  44
]
272 1.74 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
]
273 2.43 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_.synonyms AS synonyms_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
  44
]
274 1.86 ms
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
Parameters:
[]
275 2.12 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
]
276 2.15 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:
[
  44
]
277 2.11 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-04-10 06:34:54"
]
278 8.86 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_.synonyms AS synonyms_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 <= 14990 AND l0_._right >= 15513 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  1
]
279 1.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:
[
  1
]
280 24.65 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.synonyms AS synonyms_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
  44
]
281 2.08 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:
[
  11
]
282 8.55 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_.synonyms AS synonyms_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 <= 14990 AND l0_._right >= 15513 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters:
[
  1
]
283 2.74 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
]
284 2.08 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
]
285 1.85 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
]
286 1.97 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
]
287 1.93 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
]
288 1.93 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
]
289 1.87 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
]
290 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
  14
]
291 1.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:
[
  13
]
292 1.85 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
]
293 1.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:
[
  38
]
294 1.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
]
295 2.98 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
  44
  1
  "title"
  5
]
296 2.54 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
]
297 2.25 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
  44
  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 487
Aqarmap\Bundle\ListingBundle\Entity\Location 264
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation 21
Aqarmap\Bundle\ListingBundle\Entity\LocationRating 12
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 12
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation 8
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\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.