GET https://testing-eg.am-root.com/en/neighborhood/ain-elsokhna/resorts/

Response
200 OK
IP
10.244.220.183
Profiled on
Token
f8cfcc

Query Metrics

179 Database Queries
20 Different statements
416.73 ms Query time
2 Invalid entities
449 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.82 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: 
[
  "ain-elsokhna/resorts"
]
View formatted query    View runnable query    Explain query
2 3.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: 
[
  2113
]
View formatted query    View runnable query    Explain query
3 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.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.18 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.22 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: 
[
  2113
]
View formatted query    View runnable query    Explain query
6 2.36 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: 
[
  2113
]
View formatted query    View runnable query    Explain query
7 9.36 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 < 289 AND l0_._left > 2 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
8 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: 
[
  7633
]
View formatted query    View runnable query    Explain query
9 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: 
[
  3844
]
View formatted query    View runnable query    Explain query
10 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: 
[
  6936
]
View formatted query    View runnable query    Explain query
11 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: 
[
  4633
]
View formatted query    View runnable query    Explain query
12 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: 
[
  3874
]
View formatted query    View runnable query    Explain query
13 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: 
[
  3875
]
View formatted query    View runnable query    Explain query
14 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: 
[
  3876
]
View formatted query    View runnable query    Explain query
15 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: 
[
  3877
]
View formatted query    View runnable query    Explain query
16 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: 
[
  3878
]
View formatted query    View runnable query    Explain query
17 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: 
[
  3879
]
View formatted query    View runnable query    Explain query
18 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: 
[
  3880
]
View formatted query    View runnable query    Explain query
19 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: 
[
  3881
]
View formatted query    View runnable query    Explain query
20 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: 
[
  3882
]
View formatted query    View runnable query    Explain query
21 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: 
[
  3883
]
View formatted query    View runnable query    Explain query
22 6.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: 
[
  3884
]
View formatted query    View runnable query    Explain query
23 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: 
[
  3885
]
View formatted query    View runnable query    Explain query
24 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: 
[
  3886
]
View formatted query    View runnable query    Explain query
25 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: 
[
  3887
]
View formatted query    View runnable query    Explain query
26 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: 
[
  3888
]
View formatted query    View runnable query    Explain query
27 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: 
[
  3889
]
View formatted query    View runnable query    Explain query
28 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: 
[
  3890
]
View formatted query    View runnable query    Explain query
29 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: 
[
  3891
]
View formatted query    View runnable query    Explain query
30 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: 
[
  3892
]
View formatted query    View runnable query    Explain query
31 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: 
[
  3893
]
View formatted query    View runnable query    Explain query
32 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: 
[
  3894
]
View formatted query    View runnable query    Explain query
33 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: 
[
  3895
]
View formatted query    View runnable query    Explain query
34 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: 
[
  3896
]
View formatted query    View runnable query    Explain query
35 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: 
[
  3897
]
View formatted query    View runnable query    Explain query
36 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: 
[
  3898
]
View formatted query    View runnable query    Explain query
37 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: 
[
  3899
]
View formatted query    View runnable query    Explain query
38 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: 
[
  3900
]
View formatted query    View runnable query    Explain query
39 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: 
[
  3901
]
View formatted query    View runnable query    Explain query
40 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: 
[
  3902
]
View formatted query    View runnable query    Explain query
41 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: 
[
  3903
]
View formatted query    View runnable query    Explain query
42 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: 
[
  3904
]
View formatted query    View runnable query    Explain query
43 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: 
[
  3905
]
View formatted query    View runnable query    Explain query
44 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: 
[
  3906
]
View formatted query    View runnable query    Explain query
45 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: 
[
  3907
]
View formatted query    View runnable query    Explain query
46 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: 
[
  3908
]
View formatted query    View runnable query    Explain query
47 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: 
[
  3909
]
View formatted query    View runnable query    Explain query
48 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: 
[
  3910
]
View formatted query    View runnable query    Explain query
49 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: 
[
  3911
]
View formatted query    View runnable query    Explain query
50 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: 
[
  3912
]
View formatted query    View runnable query    Explain query
51 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: 
[
  3913
]
View formatted query    View runnable query    Explain query
52 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: 
[
  3914
]
View formatted query    View runnable query    Explain query
53 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: 
[
  3915
]
View formatted query    View runnable query    Explain query
54 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: 
[
  3916
]
View formatted query    View runnable query    Explain query
55 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: 
[
  3917
]
View formatted query    View runnable query    Explain query
56 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: 
[
  3918
]
View formatted query    View runnable query    Explain query
57 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: 
[
  3919
]
View formatted query    View runnable query    Explain query
58 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: 
[
  3920
]
View formatted query    View runnable query    Explain query
59 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: 
[
  3921
]
View formatted query    View runnable query    Explain query
60 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: 
[
  3922
]
View formatted query    View runnable query    Explain query
61 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: 
[
  3923
]
View formatted query    View runnable query    Explain query
62 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: 
[
  7251
]
View formatted query    View runnable query    Explain query
63 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: 
[
  3924
]
View formatted query    View runnable query    Explain query
64 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: 
[
  3925
]
View formatted query    View runnable query    Explain query
65 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: 
[
  3926
]
View formatted query    View runnable query    Explain query
66 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: 
[
  3927
]
View formatted query    View runnable query    Explain query
67 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: 
[
  3928
]
View formatted query    View runnable query    Explain query
68 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: 
[
  3929
]
View formatted query    View runnable query    Explain query
69 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: 
[
  3930
]
View formatted query    View runnable query    Explain query
70 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: 
[
  3931
]
View formatted query    View runnable query    Explain query
71 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: 
[
  3932
]
View formatted query    View runnable query    Explain query
72 1.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: 
[
  3933
]
View formatted query    View runnable query    Explain query
73 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: 
[
  3934
]
View formatted query    View runnable query    Explain query
74 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: 
[
  3935
]
View formatted query    View runnable query    Explain query
75 1.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: 
[
  3936
]
View formatted query    View runnable query    Explain query
76 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: 
[
  3937
]
View formatted query    View runnable query    Explain query
77 1.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: 
[
  3938
]
View formatted query    View runnable query    Explain query
78 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: 
[
  3939
]
View formatted query    View runnable query    Explain query
79 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: 
[
  3940
]
View formatted query    View runnable query    Explain query
80 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: 
[
  3941
]
View formatted query    View runnable query    Explain query
81 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: 
[
  3942
]
View formatted query    View runnable query    Explain query
82 1.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: 
[
  3943
]
View formatted query    View runnable query    Explain query
83 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: 
[
  3944
]
View formatted query    View runnable query    Explain query
84 1.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: 
[
  3945
]
View formatted query    View runnable query    Explain query
85 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: 
[
  3946
]
View formatted query    View runnable query    Explain query
86 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: 
[
  3947
]
View formatted query    View runnable query    Explain query
87 1.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: 
[
  3948
]
View formatted query    View runnable query    Explain query
88 1.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: 
[
  3949
]
View formatted query    View runnable query    Explain query
89 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: 
[
  3950
]
View formatted query    View runnable query    Explain query
90 1.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: 
[
  3951
]
View formatted query    View runnable query    Explain query
91 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: 
[
  3952
]
View formatted query    View runnable query    Explain query
92 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: 
[
  3953
]
View formatted query    View runnable query    Explain query
93 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: 
[
  3954
]
View formatted query    View runnable query    Explain query
94 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: 
[
  3955
]
View formatted query    View runnable query    Explain query
95 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: 
[
  3956
]
View formatted query    View runnable query    Explain query
96 6.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: 
[
  3957
]
View formatted query    View runnable query    Explain query
97 3.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: 
[
  3958
]
View formatted query    View runnable query    Explain query
98 1.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: 
[
  3959
]
View formatted query    View runnable query    Explain query
99 1.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: 
[
  3960
]
View formatted query    View runnable query    Explain query
100 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: 
[
  3961
]
View formatted query    View runnable query    Explain query
101 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: 
[
  3962
]
View formatted query    View runnable query    Explain query
102 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: 
[
  3963
]
View formatted query    View runnable query    Explain query
103 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: 
[
  3965
]
View formatted query    View runnable query    Explain query
104 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: 
[
  3966
]
View formatted query    View runnable query    Explain query
105 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: 
[
  3967
]
View formatted query    View runnable query    Explain query
106 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: 
[
  3968
]
View formatted query    View runnable query    Explain query
107 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: 
[
  3970
]
View formatted query    View runnable query    Explain query
108 4.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: 
[
  3971
]
View formatted query    View runnable query    Explain query
109 1.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: 
[
  3972
]
View formatted query    View runnable query    Explain query
110 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: 
[
  3973
]
View formatted query    View runnable query    Explain query
111 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: 
[
  3974
]
View formatted query    View runnable query    Explain query
112 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: 
[
  3975
]
View formatted query    View runnable query    Explain query
113 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: 
[
  3976
]
View formatted query    View runnable query    Explain query
114 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: 
[
  3977
]
View formatted query    View runnable query    Explain query
115 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: 
[
  7065
]
View formatted query    View runnable query    Explain query
116 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: 
[
  7135
]
View formatted query    View runnable query    Explain query
117 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: 
[
  7136
]
View formatted query    View runnable query    Explain query
118 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: 
[
  7137
]
View formatted query    View runnable query    Explain query
119 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: 
[
  7138
]
View formatted query    View runnable query    Explain query
120 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: 
[
  7325
]
View formatted query    View runnable query    Explain query
121 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: 
[
  7497
]
View formatted query    View runnable query    Explain query
122 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: 
[
  7624
]
View formatted query    View runnable query    Explain query
123 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: 
[
  7625
]
View formatted query    View runnable query    Explain query
124 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: 
[
  7688
]
View formatted query    View runnable query    Explain query
125 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: 
[
  7711
]
View formatted query    View runnable query    Explain query
126 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: 
[
  23850
]
View formatted query    View runnable query    Explain query
127 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: 
[
  23888
]
View formatted query    View runnable query    Explain query
128 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: 
[
  23924
]
View formatted query    View runnable query    Explain query
129 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: 
[
  23925
]
View formatted query    View runnable query    Explain query
130 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: 
[
  23951
]
View formatted query    View runnable query    Explain query
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: 
[
  23956
]
View formatted query    View runnable query    Explain query
132 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: 
[
  23967
]
View formatted query    View runnable query    Explain query
133 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: 
[
  24028
]
View formatted query    View runnable query    Explain query
134 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: 
[
  24294
]
View formatted query    View runnable query    Explain query
135 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: 
[
  24528
]
View formatted query    View runnable query    Explain query
136 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: 
[
  24538
]
View formatted query    View runnable query    Explain query
137 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: 
[
  25015
]
View formatted query    View runnable query    Explain query
138 1.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: 
[
  25178
]
View formatted query    View runnable query    Explain query
139 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: 
[
  25204
]
View formatted query    View runnable query    Explain query
140 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: 
[
  25602
]
View formatted query    View runnable query    Explain query
141 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: 
[
  26623
]
View formatted query    View runnable query    Explain query
142 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: 
[
  26625
]
View formatted query    View runnable query    Explain query
143 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: 
[
  26626
]
View formatted query    View runnable query    Explain query
144 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: 
[
  26743
]
View formatted query    View runnable query    Explain query
145 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: 
[
  27180
]
View formatted query    View runnable query    Explain query
146 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: 
[
  27517
]
View formatted query    View runnable query    Explain query
147 1.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: 
[
  28392
]
View formatted query    View runnable query    Explain query
148 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: 
[
  28499
]
View formatted query    View runnable query    Explain query
149 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: 
[
  29106
]
View formatted query    View runnable query    Explain query
150 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: 
[
  29178
]
View formatted query    View runnable query    Explain query
151 1.84 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
152 1.76 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
153 2.62 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
  2113
]
View formatted query    View runnable query    Explain query
154 1.87 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
155 2.73 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
  2113
]
View formatted query    View runnable query    Explain query
156 1.90 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
157 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.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
158 2.85 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: 
[
  2113
]
View formatted query    View runnable query    Explain query
159 2.68 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-30 11:20:21"
]
View formatted query    View runnable query    Explain query
160 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 <= 2 AND l0_._right >= 289 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
161 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: 
[
  5
]
View formatted query    View runnable query    Explain query
162 31.88 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
  2113
]
View formatted query    View runnable query    Explain query
163 2.30 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: 
[
  1383
]
View formatted query    View runnable query    Explain query
164 2.99 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 <= 2 AND l0_._right >= 289 AND l0_.root = ? ORDER BY l0_._left ASC
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
165 2.68 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
166 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: 
[
  1
]
View formatted query    View runnable query    Explain query
167 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.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
168 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.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
169 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.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
170 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.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
171 2.25 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
172 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.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
173 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.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
174 1.72 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters: 
[
  47
]
View formatted query    View runnable query    Explain query
175 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.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
176 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.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
177 3.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
  2113
  1
  "title"
  5
]
View formatted query    View runnable query    Explain query
178 3.08 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
179 2.49 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
  2113
  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 250
Aqarmap\Bundle\ListingBundle\Entity\Location 146
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation 21
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 12
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation 8
Aqarmap\Bundle\ListingBundle\Entity\LocationRating 7
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.