https://testing-eg.am-root.com/ar/neighborhood/

301 Redirect from
@neighborhood_all_locations (98fad7)
Method
GET
HTTP Status
200
IP
192.168.5.202
Profiled on
Token
6e6e7e

Query Metrics

139 Database Queries
7 Different statements
303.52 ms Query time
6 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.80 ms 
SELECT COUNT(l0_.id) AS sclr_0 FROM leads l0_ WHERE l0_.user_ip = ? AND l0_.created_at >= ?
Parameters: 
[
  "192.168.5.202"
  "2024-09-28 21:04:26"
]
View formatted query    View runnable query    Explain query
2 6.59 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_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.keyword AS keyword_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.eligible_for_mortgage AS eligible_for_mortgage_26, l0_.is_compound_location AS is_compound_location_27, l0_.parent_id AS parent_id_28, l0_.location_compound_id AS location_compound_id_29, l0_.rating_id AS rating_id_30, l0_.listing_id AS listing_id_31 FROM locations l0_ WHERE l0_.neighborhood_filter = ? AND l0_.disabled = ? AND l0_.level = ?
Parameters: 
[
  true
  false
  0
]
View formatted query    View runnable query    Explain query
3 2.98 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
  "2024-09-28 21:19:26"
]
View formatted query    View runnable query    Explain query
4 2.55 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: 
[
  31
]
View formatted query    View runnable query    Explain query
5 1.73 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: 
[
  43
]
View formatted query    View runnable query    Explain query
6 1.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: 
[
  46
]
View formatted query    View runnable query    Explain query
7 1.71 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: 
[
  52
]
View formatted query    View runnable query    Explain query
8 1.67 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: 
[
  56
]
View formatted query    View runnable query    Explain query
9 1.86 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: 
[
  64
]
View formatted query    View runnable query    Explain query
10 2.01 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: 
[
  33
]
View formatted query    View runnable query    Explain query
11 1.74 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: 
[
  66
]
View formatted query    View runnable query    Explain query
12 1.71 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: 
[
  68
]
View formatted query    View runnable query    Explain query
13 1.95 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: 
[
  70
]
View formatted query    View runnable query    Explain query
14 1.90 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: 
[
  72
]
View formatted query    View runnable query    Explain query
15 1.83 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: 
[
  82
]
View formatted query    View runnable query    Explain query
16 1.96 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: 
[
  102
]
View formatted query    View runnable query    Explain query
17 1.96 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: 
[
  104
]
View formatted query    View runnable query    Explain query
18 1.96 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: 
[
  110
]
View formatted query    View runnable query    Explain query
19 1.81 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: 
[
  116
]
View formatted query    View runnable query    Explain query
20 1.86 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: 
[
  120
]
View formatted query    View runnable query    Explain query
21 1.88 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: 
[
  122
]
View formatted query    View runnable query    Explain query
22 1.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: 
[
  124
]
View formatted query    View runnable query    Explain query
23 1.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: 
[
  130
]
View formatted query    View runnable query    Explain query
24 1.77 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: 
[
  134
]
View formatted query    View runnable query    Explain query
25 1.75 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: 
[
  136
]
View formatted query    View runnable query    Explain query
26 1.93 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: 
[
  140
]
View formatted query    View runnable query    Explain query
27 1.96 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: 
[
  146
]
View formatted query    View runnable query    Explain query
28 1.76 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: 
[
  148
]
View formatted query    View runnable query    Explain query
29 1.70 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: 
[
  160
]
View formatted query    View runnable query    Explain query
30 1.83 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: 
[
  162
]
View formatted query    View runnable query    Explain query
31 1.83 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: 
[
  164
]
View formatted query    View runnable query    Explain query
32 1.93 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: 
[
  166
]
View formatted query    View runnable query    Explain query
33 1.86 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: 
[
  168
]
View formatted query    View runnable query    Explain query
34 1.82 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: 
[
  170
]
View formatted query    View runnable query    Explain query
35 1.90 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: 
[
  178
]
View formatted query    View runnable query    Explain query
36 1.95 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: 
[
  180
]
View formatted query    View runnable query    Explain query
37 1.91 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: 
[
  186
]
View formatted query    View runnable query    Explain query
38 1.98 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: 
[
  188
]
View formatted query    View runnable query    Explain query
39 1.95 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: 
[
  198
]
View formatted query    View runnable query    Explain query
40 2.00 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: 
[
  202
]
View formatted query    View runnable query    Explain query
41 1.97 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: 
[
  206
]
View formatted query    View runnable query    Explain query
42 2.05 ms 
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = ?
Parameters: 
[
  208
]
View formatted query    View runnable query    Explain query
43 1.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: 
[
  212
]
View formatted query    View runnable query    Explain query
44 1.91 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: 
[
  214
]
View formatted query    View runnable query    Explain query
45 1.87 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: 
[
  216
]
View formatted query    View runnable query    Explain query
46 1.80 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: 
[
  218
]
View formatted query    View runnable query    Explain query
47 1.91 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: 
[
  222
]
View formatted query    View runnable query    Explain query
48 1.83 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: 
[
  224
]
View formatted query    View runnable query    Explain query
49 1.90 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: 
[
  228
]
View formatted query    View runnable query    Explain query
50 1.71 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: 
[
  238
]
View formatted query    View runnable query    Explain query
51 1.76 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: 
[
  242
]
View formatted query    View runnable query    Explain query
52 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: 
[
  252
]
View formatted query    View runnable query    Explain query
53 2.05 ms 
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = ?
Parameters: 
[
  258
]
View formatted query    View runnable query    Explain query
54 1.89 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: 
[
  260
]
View formatted query    View runnable query    Explain query
55 1.71 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: 
[
  266
]
View formatted query    View runnable query    Explain query
56 1.88 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: 
[
  270
]
View formatted query    View runnable query    Explain query
57 1.65 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: 
[
  272
]
View formatted query    View runnable query    Explain query
58 1.86 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: 
[
  274
]
View formatted query    View runnable query    Explain query
59 1.80 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: 
[
  276
]
View formatted query    View runnable query    Explain query
60 1.87 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: 
[
  280
]
View formatted query    View runnable query    Explain query
61 1.84 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: 
[
  282
]
View formatted query    View runnable query    Explain query
62 1.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: 
[
  286
]
View formatted query    View runnable query    Explain query
63 1.95 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: 
[
  292
]
View formatted query    View runnable query    Explain query
64 1.93 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: 
[
  294
]
View formatted query    View runnable query    Explain query
65 1.96 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: 
[
  298
]
View formatted query    View runnable query    Explain query
66 1.95 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: 
[
  300
]
View formatted query    View runnable query    Explain query
67 1.92 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: 
[
  302
]
View formatted query    View runnable query    Explain query
68 1.87 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: 
[
  308
]
View formatted query    View runnable query    Explain query
69 1.95 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: 
[
  312
]
View formatted query    View runnable query    Explain query
70 1.98 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: 
[
  316
]
View formatted query    View runnable query    Explain query
71 2.02 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: 
[
  320
]
View formatted query    View runnable query    Explain query
72 1.96 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: 
[
  322
]
View formatted query    View runnable query    Explain query
73 1.97 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: 
[
  326
]
View formatted query    View runnable query    Explain query
74 1.82 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: 
[
  330
]
View formatted query    View runnable query    Explain query
75 12.02 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: 
[
  340
]
View formatted query    View runnable query    Explain query
76 20.84 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: 
[
  342
]
View formatted query    View runnable query    Explain query
77 1.64 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: 
[
  344
]
View formatted query    View runnable query    Explain query
78 1.74 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: 
[
  346
]
View formatted query    View runnable query    Explain query
79 1.65 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: 
[
  348
]
View formatted query    View runnable query    Explain query
80 1.69 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: 
[
  352
]
View formatted query    View runnable query    Explain query
81 1.59 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: 
[
  354
]
View formatted query    View runnable query    Explain query
82 1.58 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: 
[
  356
]
View formatted query    View runnable query    Explain query
83 1.78 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: 
[
  358
]
View formatted query    View runnable query    Explain query
84 1.72 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: 
[
  360
]
View formatted query    View runnable query    Explain query
85 1.88 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: 
[
  364
]
View formatted query    View runnable query    Explain query
86 1.75 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: 
[
  370
]
View formatted query    View runnable query    Explain query
87 1.77 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: 
[
  376
]
View formatted query    View runnable query    Explain query
88 1.58 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: 
[
  378
]
View formatted query    View runnable query    Explain query
89 1.75 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: 
[
  388
]
View formatted query    View runnable query    Explain query
90 1.61 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: 
[
  394
]
View formatted query    View runnable query    Explain query
91 1.80 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: 
[
  396
]
View formatted query    View runnable query    Explain query
92 1.96 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: 
[
  400
]
View formatted query    View runnable query    Explain query
93 1.70 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: 
[
  406
]
View formatted query    View runnable query    Explain query
94 1.57 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: 
[
  408
]
View formatted query    View runnable query    Explain query
95 1.68 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: 
[
  410
]
View formatted query    View runnable query    Explain query
96 1.50 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: 
[
  412
]
View formatted query    View runnable query    Explain query
97 1.76 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: 
[
  416
]
View formatted query    View runnable query    Explain query
98 1.60 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: 
[
  424
]
View formatted query    View runnable query    Explain query
99 2.37 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: 
[
  428
]
View formatted query    View runnable query    Explain query
100 1.54 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: 
[
  432
]
View formatted query    View runnable query    Explain query
101 1.60 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: 
[
  434
]
View formatted query    View runnable query    Explain query
102 1.53 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: 
[
  436
]
View formatted query    View runnable query    Explain query
103 1.68 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: 
[
  438
]
View formatted query    View runnable query    Explain query
104 1.86 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: 
[
  442
]
View formatted query    View runnable query    Explain query
105 1.79 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: 
[
  444
]
View formatted query    View runnable query    Explain query
106 1.71 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: 
[
  446
]
View formatted query    View runnable query    Explain query
107 1.65 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: 
[
  448
]
View formatted query    View runnable query    Explain query
108 1.70 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: 
[
  450
]
View formatted query    View runnable query    Explain query
109 1.68 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: 
[
  456
]
View formatted query    View runnable query    Explain query
110 1.69 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: 
[
  458
]
View formatted query    View runnable query    Explain query
111 2.95 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: 
[
  462
]
View formatted query    View runnable query    Explain query
112 1.89 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: 
[
  464
]
View formatted query    View runnable query    Explain query
113 1.71 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: 
[
  466
]
View formatted query    View runnable query    Explain query
114 1.80 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: 
[
  468
]
View formatted query    View runnable query    Explain query
115 1.67 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: 
[
  472
]
View formatted query    View runnable query    Explain query
116 1.75 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: 
[
  474
]
View formatted query    View runnable query    Explain query
117 1.72 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: 
[
  478
]
View formatted query    View runnable query    Explain query
118 1.76 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: 
[
  486
]
View formatted query    View runnable query    Explain query
119 1.83 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: 
[
  488
]
View formatted query    View runnable query    Explain query
120 1.76 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: 
[
  490
]
View formatted query    View runnable query    Explain query
121 1.81 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: 
[
  492
]
View formatted query    View runnable query    Explain query
122 1.99 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: 
[
  496
]
View formatted query    View runnable query    Explain query
123 1.96 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: 
[
  498
]
View formatted query    View runnable query    Explain query
124 1.86 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: 
[
  500
]
View formatted query    View runnable query    Explain query
125 1.83 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: 
[
  502
]
View formatted query    View runnable query    Explain query
126 1.80 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: 
[
  504
]
View formatted query    View runnable query    Explain query
127 1.80 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: 
[
  508
]
View formatted query    View runnable query    Explain query
128 1.67 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: 
[
  516
]
View formatted query    View runnable query    Explain query
129 1.83 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: 
[
  520
]
View formatted query    View runnable query    Explain query
130 1.66 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: 
[
  522
]
View formatted query    View runnable query    Explain query
131 1.88 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: 
[
  530
]
View formatted query    View runnable query    Explain query
132 1.73 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: 
[
  536
]
View formatted query    View runnable query    Explain query
133 1.73 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: 
[
  538
]
View formatted query    View runnable query    Explain query
134 1.77 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: 
[
  1
]
View formatted query    View runnable query    Explain query
135 1.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: 
[
  545
]
View formatted query    View runnable query    Explain query
136 2.99 ms 
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.private AS private_3, p0_.level AS level_4, p0_._left AS _left_5, p0_._right AS _right_6, p0_.root AS root_7, p0_.compound_related AS compound_related_8, p0_.reference_id AS reference_id_9, p0_.exchangeable AS exchangeable_10, p0_.is_evaluable AS is_evaluable_11, p0_.synced AS synced_12, p0_.searchable AS searchable_13, p0_.deleted_at AS deleted_at_14, p0_.custom_order AS custom_order_15, p0_.parent_id AS parent_id_16 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
137 8.56 ms 
SELECT l0_.id AS id_0, COALESCE(l1_.content, l0_.title) AS sclr_1, l0_.slug AS slug_2 FROM locations l0_ LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id AND (l1_.locale = ? AND l1_.field = ? AND l1_.location_id = l0_.id) WHERE l0_.disabled = ? AND l0_.parent_id IS NULL ORDER BY l0_.listings_counter DESC
Parameters: 
[
  "ar"
  "title"
  false
]
View formatted query    View runnable query    Explain query
138 2.35 ms 
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.private AS private_3, p0_.level AS level_4, p0_._left AS _left_5, p0_._right AS _right_6, p0_.root AS root_7, p0_.compound_related AS compound_related_8, p0_.reference_id AS reference_id_9, p0_.exchangeable AS exchangeable_10, p0_.is_evaluable AS is_evaluable_11, p0_.synced AS synced_12, p0_.searchable AS searchable_13, p0_.deleted_at AS deleted_at_14, p0_.custom_order AS custom_order_15, p0_.parent_id AS parent_id_16 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
139 6.42 ms 
SELECT l0_.id AS id_0, COALESCE(l1_.content, l0_.title) AS sclr_1, l0_.slug AS slug_2 FROM locations l0_ LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id AND (l1_.locale = ? AND l1_.field = ? AND l1_.location_id = l0_.id) WHERE l0_.disabled = ? AND l0_.parent_id IS NULL ORDER BY l0_.listings_counter DESC
Parameters: 
[
  "ar"
  "title"
  false
]
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.

Entities Mapping

Class Mapping 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.
App\Entity\Lead\Lead No 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\ListingBundle\Entity\Phone No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserPhone No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhone No errors.
Aqarmap\Bundle\UserBundle\Entity\UserServices No errors.
Aqarmap\Bundle\UserBundle\Entity\User
  • The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType
  • The field Aqarmap\Bundle\ListingBundle\Entity\PropertyType#compoundAveragePrice is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#propertyType does not contain the required 'inversedBy="compoundAveragePrice"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule No errors.
Aqarmap\Bundle\UserBundle\Entity\UserPackages No errors.
Aqarmap\Bundle\CreditBundle\Entity\Credit
  • The association Aqarmap\Bundle\CreditBundle\Entity\Credit#userPackages refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\UserPackages#credits which does not exist.
Aqarmap\Bundle\PaymentBundle\Entity\Payment
  • The association Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction refers to the inverse side field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#paymentTransactions which does not exist.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopSellerLead No errors.
Aqarmap\Bundle\MessageBundle\Entity\Message No errors.
Aqarmap\Bundle\MessageBundle\Entity\Conversation No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto No errors.
Aqarmap\Bundle\ListingBundle\Entity\Interaction No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite No errors.
Aqarmap\Bundle\ListingBundle\Entity\CallRequestLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\PhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\MessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\FreeListing No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserPhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserMessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\TargetUserLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\SimilarListingsLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserDomainPhoneLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\UserDomainMessageLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\WhatsAppLead No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting No errors.
Aqarmap\Bundle\ListingBundle\Entity\Lead No errors.
Aqarmap\Bundle\MessageBundle\Entity\Recipient No errors.
Aqarmap\Bundle\ListingBundle\Entity\CallRequest No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingFeature No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations No errors.
Aqarmap\Bundle\UserBundle\Entity\Group No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rejection No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand No errors.
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics No errors.
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest 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\NotifierBundle\Entity\Notifier No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion No errors.
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ListingInsight 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\CompoundAveragePrice No errors.