GET https://testing-eg.am-root.com/en/compounds/?page=5

Query Metrics

167 Database Queries
6 Different statements
402.13 ms Query time
7 Invalid entities
595 Managed entities

Queries

Group similar statements

# Time Info
1 2.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.slug IS NULL LIMIT 1
Parameters:
[]
2 2.57 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"
]
3 9.95 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_.is_availability_email_sent AS is_availability_email_sent_50, l0_.market_property_type AS market_property_type_51, l0_.creation_source AS creation_source_52, l0_.click_through_rate AS click_through_rate_53, l0_.label AS label_54, l0_.is_top_picks AS is_top_picks_55, l0_.contact_rate AS contact_rate_56, l0_.synced AS synced_57, l0_.reference_id AS reference_id_58, l0_.is_pending_featuring AS is_pending_featuring_59, l0_.pending_featuring_type AS pending_featuring_type_60, l0_.rate_status AS rate_status_61, l0_.is_rate_reviewed AS is_rate_reviewed_62, l0_.is_call_request AS is_call_request_63, l0_.is_shown_in_homepage AS is_shown_in_homepage_64, l0_.is_commercial AS is_commercial_65, l0_.is_resale AS is_resale_66, l0_.is_rent AS is_rent_67, l0_.is_primary AS is_primary_68, l0_.is_mortgage_approved AS is_mortgage_approved_69, l0_.meta_title AS meta_title_70, l0_.meta_description AS meta_description_71, l0_.is_mortgage AS is_mortgage_72, l0_.eligible_for_mortgage AS eligible_for_mortgage_73, l0_.property_registration_status AS property_registration_status_74, l0_.advertiser_number AS advertiser_number_75, l0_.authorization_number AS authorization_number_76, l0_.freezed_at AS freezed_at_77, l0_.eligible_for_bumpup AS eligible_for_bumpup_78, l0_.waiting_time AS waiting_time_79, l0_.reference_number AS reference_number_80, l0_.is_hold AS is_hold_81, l0_.is_ai_content AS is_ai_content_82, l0_.ai_review AS ai_review_83, l0_.parent_id AS parent_id_84, l0_.relist_id AS relist_id_85, l0_.section_id AS section_id_86, l0_.property_type_id AS property_type_id_87, l0_.location_id AS location_id_88, l0_.compound_location_id AS compound_location_id_89, l0_.user_id AS user_id_90, l0_.compound_field_id AS compound_field_id_91, l0_.brochure_id AS brochure_id_92 FROM listings l0_ WHERE (l0_.parent_id IS NULL AND l0_.category = ? AND l0_.status = ?) AND (l0_.deleted_at IS NULL)
Parameters:
[
  3
  2
]
4 2.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:
[
  1
]
5 2.24 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  3
]
6 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:
[
  4
]
7 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:
[
  14
]
8 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:
[
  17
]
9 2.27 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  23
]
10 2.20 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  33
]
11 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
]
12 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:
[
  44
]
13 2.74 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  66
]
14 2.22 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
]
15 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:
[
  71
]
16 2.29 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  80
]
17 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:
[
  81
]
18 2.30 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  84
]
19 2.27 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  91
]
20 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:
[
  93
]
21 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:
[
  108
]
22 2.47 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  111
]
23 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:
[
  114
]
24 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:
[
  117
]
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:
[
  121
]
26 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:
[
  124
]
27 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:
[
  125
]
28 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:
[
  127
]
29 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  131
]
30 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:
[
  140
]
31 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:
[
  141
]
32 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:
[
  148
]
33 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  155
]
34 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:
[
  156
]
35 2.08 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  158
]
36 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:
[
  163
]
37 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:
[
  168
]
38 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:
[
  170
]
39 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
]
40 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:
[
  179
]
41 2.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  180
]
42 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:
[
  181
]
43 2.32 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  187
]
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:
[
  188
]
45 6.70 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  196
]
46 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  198
]
47 2.07 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  210
]
48 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:
[
  212
]
49 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:
[
  215
]
50 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:
[
  216
]
51 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:
[
  219
]
52 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:
[
  221
]
53 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:
[
  229
]
54 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:
[
  236
]
55 2.25 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  239
]
56 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:
[
  246
]
57 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:
[
  247
]
58 2.12 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  252
]
59 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:
[
  253
]
60 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  259
]
61 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:
[
  261
]
62 2.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  264
]
63 2.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  265
]
64 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:
[
  272
]
65 2.02 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  279
]
66 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:
[
  286
]
67 2.20 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  288
]
68 2.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  294
]
69 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:
[
  296
]
70 2.24 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  297
]
71 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:
[
  298
]
72 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:
[
  312
]
73 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:
[
  314
]
74 2.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  321
]
75 2.52 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  323
]
76 2.27 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  334
]
77 3.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  337
]
78 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
]
79 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:
[
  340
]
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:
[
  350
]
81 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:
[
  352
]
82 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:
[
  356
]
83 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:
[
  360
]
84 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:
[
  363
]
85 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:
[
  370
]
86 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:
[
  374
]
87 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:
[
  377
]
88 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:
[
  384
]
89 1.93 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  388
]
90 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:
[
  390
]
91 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:
[
  401
]
92 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:
[
  404
]
93 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:
[
  407
]
94 1.95 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  413
]
95 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:
[
  415
]
96 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:
[
  416
]
97 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:
[
  424
]
98 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:
[
  427
]
99 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:
[
  428
]
100 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:
[
  429
]
101 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:
[
  430
]
102 2.09 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  431
]
103 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:
[
  435
]
104 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:
[
  437
]
105 2.22 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
]
106 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:
[
  445
]
107 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:
[
  446
]
108 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:
[
  454
]
109 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:
[
  455
]
110 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:
[
  460
]
111 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
]
112 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:
[
  464
]
113 4.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:
[
  471
]
114 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:
[
  472
]
115 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:
[
  479
]
116 2.00 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0.listing_id = ?
Parameters:
[
  480
]
117 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:
[
  484
]
118 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:
[
  486
]
119 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:
[
  489
]
120 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:
[
  495
]
121 5.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:
[
  496
]
122 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:
[
  498
]
123 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:
[
  642
]
124 3.63 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
125 3.32 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
126 3.23 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  7
]
127 2.70 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  7
]
128 3.09 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  11
]
129 2.53 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  11
]
130 3.48 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  52
]
131 2.50 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  52
]
132 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  9
]
133 2.35 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  9
]
134 3.03 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  4
]
135 2.34 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  4
]
136 3.06 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  2
]
137 2.42 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2
]
138 3.11 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  21
]
139 2.40 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  21
]
140 3.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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  10
]
141 2.37 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  10
]
142 3.12 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  13
]
143 2.44 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  13
]
144 3.13 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  5
]
145 2.46 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  5
]
146 3.06 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  6
]
147 2.62 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  6
]
148 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  3
]
149 2.31 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3
]
150 3.12 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  12
]
151 2.41 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  12
]
152 3.04 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  14
]
153 2.53 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  14
]
154 3.04 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  20
]
155 2.52 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  20
]
156 2.84 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  17
]
157 3.54 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  17
]
158 3.04 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  15
]
159 2.22 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  15
]
160 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  8
]
161 2.38 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  8
]
162 2.92 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  16
]
163 2.39 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  16
]
164 2.98 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  19
]
165 2.45 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  19
]
166 3.05 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.listing_availability_last_checked AS listing_availability_last_checked_43, t0.recent_search_last_send AS recent_search_last_send_44, t0.boost_level AS boost_level_45, t0.boost AS boost_46, t0.is_phone_verified AS is_phone_verified_47, t0.auth_identifier AS auth_identifier_48, t0.auth_access_token AS auth_access_token_49, t0.auth_refresh_token AS auth_refresh_token_50, t0.auth_updated_at AS auth_updated_at_51, t0.parent_id AS parent_id_52, t0.logo AS logo_53, t0.personal_photo AS personal_photo_54, t0.subscription_id AS subscription_id_55, t0.company_id AS company_id_56, t0.staff_id AS staff_id_57, t0.team_id AS team_id_58, t0.developerField_id AS developerField_id_59, t0.phone_id AS phone_id_60 FROM users t0 WHERE t0.id = ?
Parameters:
[
  18
]
167 2.44 ms
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  18
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation 362
Aqarmap\Bundle\ListingBundle\Entity\Listing 120
Aqarmap\Bundle\ListingBundle\Entity\CompoundField 24
Aqarmap\Bundle\UserBundle\Entity\User 23
Aqarmap\Bundle\CRMBundle\Entity\Company 20
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation 11
Aqarmap\Bundle\ListingBundle\Entity\PropertyType 10
Aqarmap\Bundle\ListingBundle\Entity\File 9
Aqarmap\Bundle\ListingBundle\Entity\Location 8
Aqarmap\Bundle\ListingBundle\Entity\Photo 3
Aqarmap\Bundle\ListingBundle\Entity\Phone 2
Aqarmap\Bundle\ListingBundle\Entity\CustomField 1
Aqarmap\Bundle\ListingBundle\Entity\Section 1
App\Entity\Subscriptions\UserSubscription 1

Entities Mapping

Class Mapping errors
Aqarmap\Bundle\ListingBundle\Entity\Location
  • The mappings Aqarmap\Bundle\ListingBundle\Entity\Location#childrenSortedById and Aqarmap\Bundle\ListingBundle\Entity\Location#parent are inconsistent with each other.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule No errors.
Aqarmap\Bundle\ListingBundle\Entity\Listing
  • The field Aqarmap\Bundle\ListingBundle\Entity\Listing#compoundAveragePrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#parentCompound does not contain the required 'inversedBy="compoundAveragePrices"' attribute.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice No errors.
Aqarmap\Bundle\UserBundle\Entity\User
  • The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#geoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserGeoLocation#user does not contain the required 'inversedBy="geoLocations"' attribute.
  • The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\ListingAttribute No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhone No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingLead No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingFeature No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNotification No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rejection No errors.
Aqarmap\Bundle\ListingBundle\Entity\Interaction No errors.
App\Entity\Label No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite 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\File No errors.
Aqarmap\Bundle\ListingBundle\Entity\Photo No errors.
App\Entity\Subscriptions\UserSubscription 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\ListingBundle\Entity\Phone No errors.
Aqarmap\Bundle\PaymentBundle\Entity\Payment
  • The association Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction refers to the inverse side field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#paymentTransactions which does not exist.
App\Entity\User\UserCard No errors.
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction
  • The field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#recurringTransactionStates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransactionState#recurringTransaction does not contain the required 'inversedBy="recurringTransactionStates"' attribute.
  • The mappings Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#payment and Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction are inconsistent with each other.
App\Entity\User\UserGeoLocation No errors.
Aqarmap\Bundle\UserBundle\Entity\Group No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker No errors.
Aqarmap\Bundle\CreditBundle\Entity\Credit
  • The association Aqarmap\Bundle\CreditBundle\Entity\Credit#userPackages refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\UserPackages#credits which does not exist.
Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis No errors.
Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis No errors.
Aqarmap\Bundle\UserBundle\Entity\TeamHistory No errors.
App\Entity\Lead\Lead No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDevice No errors.
Aqarmap\Bundle\NotifierBundle\Entity\Notifier No errors.
Aqarmap\Bundle\UserBundle\Entity\UserServices No errors.
App\Entity\UserLabel No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequestUnlock No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest 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\UserBundle\Entity\UserPackages
  • The field 'Aqarmap\Bundle\UserBundle\Entity\UserPackages#creditPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Aqarmap\Bundle\ListingBundle\Entity\UserPhone No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike No errors.
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService No errors.
Aqarmap\Bundle\CRMBundle\Entity\StaffHistory No errors.
App\Entity\LeadsBank\UserSegment No errors.