Query Metrics
276
Database Queries
44
Different statements
605.88 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.72 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:
[] |
2 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
1
]
|
3 | 2.52 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"90th-street"
]
|
4 | 2.31 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
3
]
|
5 | 2.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"finish-type"
]
|
6 | 13.39 ms |
SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.description) AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, COALESCE(t3_.content, l0_.address) AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, COALESCE(t4_.content, l0_.meta_title) AS meta_title_69, COALESCE(t5_.content, l0_.meta_description) AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ LEFT JOIN listings_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.listing_id = l0_.id LEFT JOIN listings_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'description' AND t2_.listing_id = l0_.id LEFT JOIN listings_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'address' AND t3_.listing_id = l0_.id LEFT JOIN listings_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'metaTitle' AND t4_.listing_id = l0_.id LEFT JOIN listings_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'metaDescription' AND t5_.listing_id = l0_.id WHERE (l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL)
Parameters:
[ 3 2 ] |
7 | 2.55 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
1
]
|
8 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
3
]
|
9 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
4
]
|
10 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
14
]
|
11 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
17
]
|
12 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
23
]
|
13 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
33
]
|
14 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
34
]
|
15 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
36
]
|
16 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
37
]
|
17 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
41
]
|
18 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
44
]
|
19 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
53
]
|
20 | 2.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
66
]
|
21 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
69
]
|
22 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
71
]
|
23 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
75
]
|
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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
78
]
|
25 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
80
]
|
26 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
81
]
|
27 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
84
]
|
28 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
91
]
|
29 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
93
]
|
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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
108
]
|
31 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
111
]
|
32 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
114
]
|
33 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
117
]
|
34 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
121
]
|
35 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
124
]
|
36 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
125
]
|
37 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
127
]
|
38 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
131
]
|
39 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
140
]
|
40 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
141
]
|
41 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
148
]
|
42 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
155
]
|
43 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
156
]
|
44 | 2.03 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
158
]
|
45 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
163
]
|
46 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
168
]
|
47 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
170
]
|
48 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
176
]
|
49 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
179
]
|
50 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
180
]
|
51 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
181
]
|
52 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
187
]
|
53 | 1.82 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
188
]
|
54 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
196
]
|
55 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
198
]
|
56 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
210
]
|
57 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
212
]
|
58 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
215
]
|
59 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
216
]
|
60 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
219
]
|
61 | 1.76 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
221
]
|
62 | 1.73 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
229
]
|
63 | 1.76 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
236
]
|
64 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
239
]
|
65 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
246
]
|
66 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
247
]
|
67 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
252
]
|
68 | 1.99 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
253
]
|
69 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
259
]
|
70 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
261
]
|
71 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
264
]
|
72 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
265
]
|
73 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
272
]
|
74 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
279
]
|
75 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
286
]
|
76 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
288
]
|
77 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
294
]
|
78 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
296
]
|
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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
297
]
|
80 | 2.06 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
298
]
|
81 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
312
]
|
82 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
314
]
|
83 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
321
]
|
84 | 3.17 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
323
]
|
85 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
334
]
|
86 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
337
]
|
87 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
339
]
|
88 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
340
]
|
89 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
350
]
|
90 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
352
]
|
91 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
356
]
|
92 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
360
]
|
93 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
363
]
|
94 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
370
]
|
95 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
374
]
|
96 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
377
]
|
97 | 1.74 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
384
]
|
98 | 1.73 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
388
]
|
99 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
390
]
|
100 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
401
]
|
101 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
404
]
|
102 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
407
]
|
103 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
413
]
|
104 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
415
]
|
105 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
416
]
|
106 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
424
]
|
107 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
427
]
|
108 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
428
]
|
109 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
429
]
|
110 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
430
]
|
111 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
431
]
|
112 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
435
]
|
113 | 2.06 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
437
]
|
114 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
442
]
|
115 | 4.52 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
445
]
|
116 | 3.15 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
446
]
|
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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
454
]
|
118 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
455
]
|
119 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
460
]
|
120 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
462
]
|
121 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
464
]
|
122 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
471
]
|
123 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
472
]
|
124 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
479
]
|
125 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
480
]
|
126 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
484
]
|
127 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
486
]
|
128 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
489
]
|
129 | 1.73 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
495
]
|
130 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
496
]
|
131 | 1.63 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
498
]
|
132 | 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.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
642
]
|
133 | 2.89 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
1
]
|
134 | 2.69 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
135 | 2.76 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
7
]
|
136 | 2.04 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
7
]
|
137 | 2.50 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
11
]
|
138 | 2.27 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
11
]
|
139 | 2.72 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
52
]
|
140 | 2.15 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
52
]
|
141 | 2.72 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
9
]
|
142 | 2.14 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
9
]
|
143 | 2.87 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
4
]
|
144 | 2.06 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
4
]
|
145 | 2.64 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
2
]
|
146 | 2.27 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
147 | 14.74 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
21
]
|
148 | 1.99 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
21
]
|
149 | 2.65 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
10
]
|
150 | 2.15 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
10
]
|
151 | 2.61 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
13
]
|
152 | 2.13 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13
]
|
153 | 2.64 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
5
]
|
154 | 2.16 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
5
]
|
155 | 2.65 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
6
]
|
156 | 2.02 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
6
]
|
157 | 2.50 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
3
]
|
158 | 2.08 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
3
]
|
159 | 2.68 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
12
]
|
160 | 2.32 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12
]
|
161 | 2.42 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
14
]
|
162 | 2.01 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
14
]
|
163 | 2.47 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
20
]
|
164 | 2.21 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
20
]
|
165 | 2.53 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
17
]
|
166 | 2.21 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
17
]
|
167 | 2.67 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
15
]
|
168 | 2.24 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
15
]
|
169 | 2.51 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
8
]
|
170 | 2.36 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
8
]
|
171 | 2.90 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
16
]
|
172 | 2.17 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
16
]
|
173 | 2.53 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
19
]
|
174 | 2.20 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
19
]
|
175 | 2.71 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54, t0.phone_id AS phone_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
18
]
|
176 | 2.23 ms |
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
18
]
|
177 | 2.23 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.coordinates AS coordinates_2, c0_.slug AS slug_3, c0_._left AS _left_4, c0_.level AS level_5, c0_._right AS _right_6, c0_.root AS root_7, c0_.activity AS activity_8, c0_.is_compound_location AS is_compound_location_9, c0_.type AS type_10, c0_.parent_id AS parent_id_11, c0_.listing_id AS listing_id_12, c0_.location_id AS location_id_13 FROM compound_locations c0_ WHERE c0_._right < 4 AND c0_._left > 3 AND c0_.root = ? AND c0_.activity = ? ORDER BY c0_._left ASC
Parameters:
[ 1 1 ] |
178 | 4.45 ms |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.id IN (?)) AND (l0_.deleted_at IS NULL)
Parameters:
[ [ "4" "23" ] ] |
179 | 2.58 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.eligible_for_mortgage AS eligible_for_mortgage_27, t0.is_compound_location AS is_compound_location_28, t0.parent_id AS parent_id_29, t0.location_compound_id AS location_compound_id_30, t0.rating_id AS rating_id_31, t0.listing_id AS listing_id_32 FROM locations t0 WHERE t0.id IN (?)
Parameters:
[ [ "1" "2" "3" "4" "5" ] ] |
180 | 4.49 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.paragraph AS paragraph_2, c0_.place AS place_3, c0_.is_published AS is_published_4, c0_.photo AS photo_5 FROM custom_paragraphs c0_ INNER JOIN paragraphs_sections p2_ ON c0_.id = p2_.paragraph_id INNER JOIN sections s1_ ON s1_.id = p2_.section_id INNER JOIN paragraphs_compound_locations p4_ ON c0_.id = p4_.paragraph_id INNER JOIN compound_locations c3_ ON c3_.id = p4_.compound_location_id WHERE s1_.id = ? AND c0_.place = ? AND (SELECT COUNT(*) FROM paragraphs_locations p5_ WHERE p5_.paragraph_id = c0_.id) = 0 AND c3_.id IN (?) AND c0_.is_published = ?
Parameters:
[ 3 2 3 true ] |
181 | 3.56 ms |
SELECT (l0_.compound_status) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ WHERE (l0_.compound_status IN (?) AND l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.compound_status
Parameters:
[ [ 10 11 12 ] 3 2 ] |
182 | 2.90 ms |
SELECT (l0_.price_level) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ WHERE (l0_.price_level IN (?) AND l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.price_level
Parameters:
[ [ 0 1 2 ] 3 2 ] |
183 | 2.86 ms |
SELECT (l0_.payment_method) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ WHERE (l0_.payment_method IN (?) AND l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.payment_method
Parameters:
[ [ 1 2 3 ] 3 2 ] |
184 | 2.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
185 | 2.11 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
2
]
|
186 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
3
]
|
187 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
4
]
|
188 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
5
]
|
189 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
6
]
|
190 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
7
]
|
191 | 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
]
|
192 | 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:
[
9
]
|
193 | 1.85 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
10
]
|
194 | 1.71 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
11
]
|
195 | 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.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = ?
Parameters:
[
12
]
|
196 | 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:
[
13
]
|
197 | 3.91 ms |
SELECT (l0_.property_type_id) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ INNER JOIN property_types p1_ ON l0_.property_type_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.id = l0_.property_type_id) WHERE (p1_.id IN (?) AND l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.property_type_id
Parameters:
[ [ 1 2 3 4 5 6 7 8 9 10 11 12 13 ] 3 2 ] |
198 | 2.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.activity = ?
Parameters:
[
1
]
|
199 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
1
]
|
200 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
2
]
|
201 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
5
]
|
202 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
6
]
|
203 | 2.05 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
7
]
|
204 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
8
]
|
205 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
9
]
|
206 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
10
]
|
207 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
11
]
|
208 | 1.82 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
12
]
|
209 | 1.92 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.id = ?
Parameters:
[
4
]
|
210 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
4
]
|
211 | 3.61 ms |
SELECT (l0_.compound_location_id) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ INNER JOIN compound_locations c1_ ON l0_.compound_location_id = c1_.id AND (c1_.id = l0_.compound_location_id) WHERE (c1_.id IN (?) AND l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL) GROUP BY l0_.compound_location_id
Parameters:
[ [ 1 2 3 5 6 7 8 9 10 11 12 ] 3 2 ] |
212 | 2.04 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.coordinates AS coordinates_2, c0_.slug AS slug_3, c0_._left AS _left_4, c0_.level AS level_5, c0_._right AS _right_6, c0_.root AS root_7, c0_.activity AS activity_8, c0_.is_compound_location AS is_compound_location_9, c0_.type AS type_10, c0_.parent_id AS parent_id_11, c0_.listing_id AS listing_id_12, c0_.location_id AS location_id_13 FROM compound_locations c0_ WHERE c0_.parent_id IS NULL AND c0_.activity = ?
Parameters:
[
1
]
|
213 | 2.09 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
1
]
|
214 | 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 compound_locations_translations t0 WHERE t0.location_id = ?
Parameters:
[
13
]
|
215 | 1.92 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
2
]
|
216 | 1.88 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
3
]
|
217 | 1.94 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
4
]
|
218 | 1.99 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
5
]
|
219 | 2.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
7
]
|
220 | 1.89 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
6
]
|
221 | 2.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
8
]
|
222 | 1.81 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
9
]
|
223 | 1.98 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
13
]
|
224 | 1.85 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
10
]
|
225 | 1.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
11
]
|
226 | 1.90 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = ? ORDER BY t0._left ASC
Parameters:
[
12
]
|
227 | 1.97 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters:
[
1
]
|
228 | 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.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters:
[
2
]
|
229 | 9.70 ms |
SELECT l0_.user_id AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ WHERE l0_.status = ? AND l0_.user_id IN (?) GROUP BY l0_.user_id
Parameters:
[ 2 [ 1 ] ] |
230 | 2.03 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-11-17 03:41:02" ] |
231 | 1.78 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ?
Parameters:
[
"web.compound.advisor"
]
|
232 | 2.09 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
233 | 2.11 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
234 | 1.99 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
235 | 1.95 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
236 | 1.71 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 2
Parameters:
[
1
]
|
237 | 1.82 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.original_phone_number AS original_phone_number_3, t0.country_code AS country_code_4, t0.ip AS ip_5, t0.country AS country_6, t0.created_at AS created_at_7 FROM phones t0 WHERE t0.id = ?
Parameters:
[
820
]
|
238 | 1.58 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ?
Parameters:
[
"web.whatsapp.chat.exclude"
]
|
239 | 1.76 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
240 | 1.76 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
241 | 1.53 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.original_phone_number AS original_phone_number_3, t0.country_code AS country_code_4, t0.ip AS ip_5, t0.country AS country_6, t0.created_at AS created_at_7 FROM phones t0 WHERE t0.id = ?
Parameters:
[
628
]
|
242 | 1.66 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
243 | 1.69 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = ?
Parameters:
[
4
]
|
244 | 1.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
1
]
|
245 | 1.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
2
]
|
246 | 1.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
3
]
|
247 | 1.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
5
]
|
248 | 1.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.hash AS hash_4 FROM photos t0 WHERE t0.id = ?
Parameters:
[
398
]
|
249 | 1.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
Parameters:
[
1
]
|
250 | 1.91 ms |
SELECT t0.id AS id_1, t0.average_price_per_meter AS average_price_per_meter_2, t0.parent_compound_id AS parent_compound_id_3, t0.property_type_id AS property_type_id_4 FROM compound_average_prices t0 WHERE t0.parent_compound_id = ? ORDER BY t0.average_price_per_meter DESC
Parameters:
[
4
]
|
251 | 1.76 ms |
SELECT t0.id AS id_1, t0.developer_name AS developer_name_2, t0.establishing_year AS establishing_year_3, t0.number_of_projects_inhabited AS number_of_projects_inhabited_4, t0.number_of_projects_delivered AS number_of_projects_delivered_5, t0.number_of_projects_under_construction AS number_of_projects_under_construction_6, t0.min_price AS min_price_7, t0.min_area AS min_area_8, t0.max_price AS max_price_9, t0.updated_at AS updated_at_10, t0.parent_compound_id AS parent_compound_id_11 FROM compound_fields t0 WHERE t0.id = ?
Parameters:
[
7
]
|
252 | 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.compound_field_id AS compound_field_id_5 FROM compound_fields_translations t0 WHERE t0.compound_field_id = ?
Parameters:
[
7
]
|
253 | 1.83 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
4
]
|
254 | 1.60 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ?
Parameters:
[
4
]
|
255 | 1.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.hash AS hash_4 FROM photos t0 WHERE t0.id = ?
Parameters:
[
224
]
|
256 | 1.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = ?
Parameters:
[
3
]
|
257 | 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.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = ?
Parameters:
[
3
]
|
258 | 2.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.eligible_for_mortgage AS eligible_for_mortgage_27, t0.is_compound_location AS is_compound_location_28, t0.parent_id AS parent_id_29, t0.location_compound_id AS location_compound_id_30, t0.rating_id AS rating_id_31, t0.listing_id AS listing_id_32 FROM locations t0 WHERE t0.id = ?
Parameters:
[
38
]
|
259 | 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:
[
38
]
|
260 | 1.78 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
261 | 1.61 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
262 | 1.94 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
263 | 1.96 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.main_number DESC, t0.id DESC
Parameters:
[
1
]
|
264 | 2.09 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 2
Parameters:
[
1
]
|
265 | 1.95 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
266 | 2.06 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
267 | 2.09 ms |
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.main_number AS main_number_3, t0.verification_code AS verification_code_4, t0.verified_at AS verified_at_5, t0.has_whatsApp AS has_whatsApp_6, t0.added_at AS added_at_7, t0.user_id AS user_id_8, t0.phone_id AS phone_id_9 FROM users_phones t0 WHERE (t0.has_whatsApp = ? AND t0.user_id = ?) ORDER BY t0.id DESC
Parameters:
[ 1 1 ] |
268 | 1.88 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = ?
Parameters:
[
23
]
|
269 | 1.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = ?
Parameters:
[
8
]
|
270 | 1.91 ms |
SELECT t0.id AS id_1, t0.average_price_per_meter AS average_price_per_meter_2, t0.parent_compound_id AS parent_compound_id_3, t0.property_type_id AS property_type_id_4 FROM compound_average_prices t0 WHERE t0.parent_compound_id = ? ORDER BY t0.average_price_per_meter DESC
Parameters:
[
23
]
|
271 | 1.92 ms |
SELECT t0.id AS id_1, t0.developer_name AS developer_name_2, t0.establishing_year AS establishing_year_3, t0.number_of_projects_inhabited AS number_of_projects_inhabited_4, t0.number_of_projects_delivered AS number_of_projects_delivered_5, t0.number_of_projects_under_construction AS number_of_projects_under_construction_6, t0.min_price AS min_price_7, t0.min_area AS min_area_8, t0.max_price AS max_price_9, t0.updated_at AS updated_at_10, t0.parent_compound_id AS parent_compound_id_11 FROM compound_fields t0 WHERE t0.id = ?
Parameters:
[
8
]
|
272 | 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.compound_field_id AS compound_field_id_5 FROM compound_fields_translations t0 WHERE t0.compound_field_id = ?
Parameters:
[
8
]
|
273 | 1.99 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
Parameters:
[
23
]
|
274 | 1.74 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ?
Parameters:
[
23
]
|
275 | 2.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.eligible_for_mortgage AS eligible_for_mortgage_27, t0.is_compound_location AS is_compound_location_28, t0.parent_id AS parent_id_29, t0.location_compound_id AS location_compound_id_30, t0.rating_id AS rating_id_31, t0.listing_id AS listing_id_32 FROM locations t0 WHERE t0.id = ?
Parameters:
[
42
]
|
276 | 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:
[
42
]
|
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 |
|
App\Entity\Lead\Lead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Location |
|
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 |
|
Aqarmap\Bundle\ListingBundle\Entity\PropertyType | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Rule | No errors. |
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle | No errors. |
Aqarmap\Bundle\CreditBundle\Entity\Credit |
|
Aqarmap\Bundle\ListingBundle\Entity\ListingLead | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TopSellerLead | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize | No errors. |
Aqarmap\Bundle\NotifierBundle\Entity\Notifier | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CustomField | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserInterest | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserPackages | No errors. |
Aqarmap\Bundle\PaymentBundle\Entity\Payment |
|
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\MainBundle\Entity\CustomParagraph | 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\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\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\CompoundLocationTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingAttribute | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingNotification | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingRate | No errors. |
Aqarmap\Bundle\ValueEngineBundle\Entity\ValueEngineListingsLocations | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingNote | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\ListingsRatesNote | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundField | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\Photo | No errors. |
Aqarmap\Bundle\CRMBundle\Entity\Company | No errors. |
Aqarmap\Bundle\CRMBundle\Entity\Staff | No errors. |
Aqarmap\Bundle\UserBundle\Entity\Team | No errors. |
Aqarmap\Bundle\UserBundle\Entity\DeveloperField | No errors. |
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction |
|
Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller | No errors. |
Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker | No errors. |
Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis | No errors. |
Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis | No errors. |
Aqarmap\Bundle\UserBundle\Entity\TeamHistory | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserDevice | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion | No errors. |
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequestUnlock | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserCheckin | No errors. |
Aqarmap\Bundle\UserBundle\Entity\UserDomain | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\Comment | No errors. |
Aqarmap\Bundle\UserBundle\Entity\PersonalInfo | No errors. |
Aqarmap\Bundle\CustomerProfilingBundle\Entity\CustomerProfilingQuestionQueue | No errors. |
Aqarmap\Bundle\MessageBundle\Entity\ConversationRecipient | No errors. |
Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike | No errors. |
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService | No errors. |
Aqarmap\Bundle\CRMBundle\Entity\StaffHistory | No errors. |
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationRating | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\CompoundFieldTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto | No errors. |
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm | No errors. |
Aqarmap\Bundle\ValueEngineBundle\Entity\ListingInsight | No errors. |