Symfony Profiler

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

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 = 1 ORDER BY t0.id DESC;

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

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 = 1 AND t0.user_id = 7) ORDER BY t0.id DESC;

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 = ?

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 = 40;

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

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 = 153 ORDER BY t0.position ASC;

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

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 = 1 ORDER BY t0.main_number DESC, t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.category AS category_4,
  t0.pending_photos_status AS pending_photos_status_5,
  t0.pending_payment_status AS pending_payment_status_6,
  t0.relist_status AS relist_status_7,
  t0.seller_role AS seller_role_8,
  t0.area AS area_9,
  t0.price AS price_10,
  t0.address AS address_11,
  t0.center_lat AS center_lat_12,
  t0.center_lng AS center_lng_13,
  t0.status AS status_14,
  t0.property_view AS property_view_15,
  t0.payment_method AS payment_method_16,
  t0.featured AS featured_17,
  t0.views AS views_18,
  t0.phone_counter AS phone_counter_19,
  t0.messages_counter AS messages_counter_20,
  t0.leads_counter AS leads_counter_21,
  t0.sent_notifiers AS sent_notifiers_22,
  t0.relist_counter AS relist_counter_23,
  t0.ip AS ip_24,
  t0.video_url AS video_url_25,
  t0.slug AS slug_26,
  t0.custom_slug AS custom_slug_27,
  t0.score AS score_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.pending_status_created_at AS pending_status_created_at_31,
  t0.published_at AS published_at_32,
  t0.expires_at AS expires_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.rejected_at AS rejected_at_35,
  t0.campaign AS campaign_36,
  t0.final_price AS final_price_37,
  t0.source_of_sale AS source_of_sale_38,
  t0.delete_reason AS delete_reason_39,
  t0.delete_reason_details AS delete_reason_details_40,
  t0.source AS source_41,
  t0.impressions AS impressions_42,
  t0.impressions_monthly_count AS impressions_monthly_count_43,
  t0.impressions_weekly_count AS impressions_weekly_count_44,
  t0.impression_updated_at AS impression_updated_at_45,
  t0.price_level AS price_level_46,
  t0.compound_status AS compound_status_47,
  t0.price_per_meter AS price_per_meter_48,
  t0.is_bumped AS is_bumped_49,
  t0.is_send_email AS is_send_email_50,
  t0.market_property_type AS market_property_type_51,
  t0.creation_source AS creation_source_52,
  t0.click_through_rate AS click_through_rate_53,
  t0.label AS label_54,
  t0.is_top_picks AS is_top_picks_55,
  t0.contact_rate AS contact_rate_56,
  t0.synced AS synced_57,
  t0.reference_id AS reference_id_58,
  t0.is_pending_featuring AS is_pending_featuring_59,
  t0.pending_featuring_type AS pending_featuring_type_60,
  t0.rate_status AS rate_status_61,
  t0.is_rate_reviewed AS is_rate_reviewed_62,
  t0.is_call_request AS is_call_request_63,
  t0.is_shown_in_homepage AS is_shown_in_homepage_64,
  t0.is_commercial AS is_commercial_65,
  t0.is_resale AS is_resale_66,
  t0.is_rent AS is_rent_67,
  t0.is_primary AS is_primary_68,
  t0.is_mortgage_approved AS is_mortgage_approved_69,
  t0.meta_title AS meta_title_70,
  t0.meta_description AS meta_description_71,
  t0.is_mortgage AS is_mortgage_72,
  t0.eligible_for_mortgage AS eligible_for_mortgage_73,
  t0.property_registration_status AS property_registration_status_74,
  t0.advertiser_number AS advertiser_number_75,
  t0.authorization_number AS authorization_number_76,
  t0.freezed_at AS freezed_at_77,
  t0.eligible_for_bumpup AS eligible_for_bumpup_78,
  t0.waiting_time AS waiting_time_79,
  t0.reference_number AS reference_number_80,
  t0.parent_id AS parent_id_81,
  t0.relist_id AS relist_id_82,
  t0.section_id AS section_id_83,
  t0.property_type_id AS property_type_id_84,
  t0.location_id AS location_id_85,
  t0.compound_location_id AS compound_location_id_86,
  t0.user_id AS user_id_87,
  t0.compound_field_id AS compound_field_id_88
FROM
  listings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pending_photos_status AS pending_photos_status_5, t0.pending_payment_status AS pending_payment_status_6, t0.relist_status AS relist_status_7, t0.seller_role AS seller_role_8, t0.area AS area_9, t0.price AS price_10, t0.address AS address_11, t0.center_lat AS center_lat_12, t0.center_lng AS center_lng_13, t0.status AS status_14, t0.property_view AS property_view_15, t0.payment_method AS payment_method_16, t0.featured AS featured_17, t0.views AS views_18, t0.phone_counter AS phone_counter_19, t0.messages_counter AS messages_counter_20, t0.leads_counter AS leads_counter_21, t0.sent_notifiers AS sent_notifiers_22, t0.relist_counter AS relist_counter_23, t0.ip AS ip_24, t0.video_url AS video_url_25, t0.slug AS slug_26, t0.custom_slug AS custom_slug_27, t0.score AS score_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.pending_status_created_at AS pending_status_created_at_31, t0.published_at AS published_at_32, t0.expires_at AS expires_at_33, t0.deleted_at AS deleted_at_34, t0.rejected_at AS rejected_at_35, t0.campaign AS campaign_36, t0.final_price AS final_price_37, t0.source_of_sale AS source_of_sale_38, t0.delete_reason AS delete_reason_39, t0.delete_reason_details AS delete_reason_details_40, t0.source AS source_41, t0.impressions AS impressions_42, t0.impressions_monthly_count AS impressions_monthly_count_43, t0.impressions_weekly_count AS impressions_weekly_count_44, t0.impression_updated_at AS impression_updated_at_45, t0.price_level AS price_level_46, t0.compound_status AS compound_status_47, t0.price_per_meter AS price_per_meter_48, t0.is_bumped AS is_bumped_49, t0.is_send_email AS is_send_email_50, t0.market_property_type AS market_property_type_51, t0.creation_source AS creation_source_52, t0.click_through_rate AS click_through_rate_53, t0.label AS label_54, t0.is_top_picks AS is_top_picks_55, t0.contact_rate AS contact_rate_56, t0.synced AS synced_57, t0.reference_id AS reference_id_58, t0.is_pending_featuring AS is_pending_featuring_59, t0.pending_featuring_type AS pending_featuring_type_60, t0.rate_status AS rate_status_61, t0.is_rate_reviewed AS is_rate_reviewed_62, t0.is_call_request AS is_call_request_63, t0.is_shown_in_homepage AS is_shown_in_homepage_64, t0.is_commercial AS is_commercial_65, t0.is_resale AS is_resale_66, t0.is_rent AS is_rent_67, t0.is_primary AS is_primary_68, t0.is_mortgage_approved AS is_mortgage_approved_69, t0.meta_title AS meta_title_70, t0.meta_description AS meta_description_71, t0.is_mortgage AS is_mortgage_72, t0.eligible_for_mortgage AS eligible_for_mortgage_73, t0.property_registration_status AS property_registration_status_74, t0.advertiser_number AS advertiser_number_75, t0.authorization_number AS authorization_number_76, t0.freezed_at AS freezed_at_77, t0.eligible_for_bumpup AS eligible_for_bumpup_78, t0.waiting_time AS waiting_time_79, t0.reference_number AS reference_number_80, t0.parent_id AS parent_id_81, t0.relist_id AS relist_id_82, t0.section_id AS section_id_83, t0.property_type_id AS property_type_id_84, t0.location_id AS location_id_85, t0.compound_location_id AS compound_location_id_86, t0.user_id AS user_id_87, t0.compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0.id = '376';

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 = ?

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 = 1;

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 = ?

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 = 820;

SELECT
  COUNT(*)
FROM
  listings t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 1;

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 = ?

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 = 376;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 IN (?)

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 IN (NULL);

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

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 = 1 ORDER BY t0.id DESC LIMIT 2;

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 = ?

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 = 398;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.category AS category_4,
  t0.pending_photos_status AS pending_photos_status_5,
  t0.pending_payment_status AS pending_payment_status_6,
  t0.relist_status AS relist_status_7,
  t0.seller_role AS seller_role_8,
  t0.area AS area_9,
  t0.price AS price_10,
  t0.address AS address_11,
  t0.center_lat AS center_lat_12,
  t0.center_lng AS center_lng_13,
  t0.status AS status_14,
  t0.property_view AS property_view_15,
  t0.payment_method AS payment_method_16,
  t0.featured AS featured_17,
  t0.views AS views_18,
  t0.phone_counter AS phone_counter_19,
  t0.messages_counter AS messages_counter_20,
  t0.leads_counter AS leads_counter_21,
  t0.sent_notifiers AS sent_notifiers_22,
  t0.relist_counter AS relist_counter_23,
  t0.ip AS ip_24,
  t0.video_url AS video_url_25,
  t0.slug AS slug_26,
  t0.custom_slug AS custom_slug_27,
  t0.score AS score_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.pending_status_created_at AS pending_status_created_at_31,
  t0.published_at AS published_at_32,
  t0.expires_at AS expires_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.rejected_at AS rejected_at_35,
  t0.campaign AS campaign_36,
  t0.final_price AS final_price_37,
  t0.source_of_sale AS source_of_sale_38,
  t0.delete_reason AS delete_reason_39,
  t0.delete_reason_details AS delete_reason_details_40,
  t0.source AS source_41,
  t0.impressions AS impressions_42,
  t0.impressions_monthly_count AS impressions_monthly_count_43,
  t0.impressions_weekly_count AS impressions_weekly_count_44,
  t0.impression_updated_at AS impression_updated_at_45,
  t0.price_level AS price_level_46,
  t0.compound_status AS compound_status_47,
  t0.price_per_meter AS price_per_meter_48,
  t0.is_bumped AS is_bumped_49,
  t0.is_send_email AS is_send_email_50,
  t0.market_property_type AS market_property_type_51,
  t0.creation_source AS creation_source_52,
  t0.click_through_rate AS click_through_rate_53,
  t0.label AS label_54,
  t0.is_top_picks AS is_top_picks_55,
  t0.contact_rate AS contact_rate_56,
  t0.synced AS synced_57,
  t0.reference_id AS reference_id_58,
  t0.is_pending_featuring AS is_pending_featuring_59,
  t0.pending_featuring_type AS pending_featuring_type_60,
  t0.rate_status AS rate_status_61,
  t0.is_rate_reviewed AS is_rate_reviewed_62,
  t0.is_call_request AS is_call_request_63,
  t0.is_shown_in_homepage AS is_shown_in_homepage_64,
  t0.is_commercial AS is_commercial_65,
  t0.is_resale AS is_resale_66,
  t0.is_rent AS is_rent_67,
  t0.is_primary AS is_primary_68,
  t0.is_mortgage_approved AS is_mortgage_approved_69,
  t0.meta_title AS meta_title_70,
  t0.meta_description AS meta_description_71,
  t0.is_mortgage AS is_mortgage_72,
  t0.eligible_for_mortgage AS eligible_for_mortgage_73,
  t0.property_registration_status AS property_registration_status_74,
  t0.advertiser_number AS advertiser_number_75,
  t0.authorization_number AS authorization_number_76,
  t0.freezed_at AS freezed_at_77,
  t0.eligible_for_bumpup AS eligible_for_bumpup_78,
  t0.waiting_time AS waiting_time_79,
  t0.reference_number AS reference_number_80,
  t0.parent_id AS parent_id_81,
  t0.relist_id AS relist_id_82,
  t0.section_id AS section_id_83,
  t0.property_type_id AS property_type_id_84,
  t0.location_id AS location_id_85,
  t0.compound_location_id AS compound_location_id_86,
  t0.user_id AS user_id_87,
  t0.compound_field_id AS compound_field_id_88
FROM
  listings t0
WHERE
  (
    t0.status = ?
    AND t0.parent_id = ?
  )
ORDER BY
  t0.area ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pending_photos_status AS pending_photos_status_5, t0.pending_payment_status AS pending_payment_status_6, t0.relist_status AS relist_status_7, t0.seller_role AS seller_role_8, t0.area AS area_9, t0.price AS price_10, t0.address AS address_11, t0.center_lat AS center_lat_12, t0.center_lng AS center_lng_13, t0.status AS status_14, t0.property_view AS property_view_15, t0.payment_method AS payment_method_16, t0.featured AS featured_17, t0.views AS views_18, t0.phone_counter AS phone_counter_19, t0.messages_counter AS messages_counter_20, t0.leads_counter AS leads_counter_21, t0.sent_notifiers AS sent_notifiers_22, t0.relist_counter AS relist_counter_23, t0.ip AS ip_24, t0.video_url AS video_url_25, t0.slug AS slug_26, t0.custom_slug AS custom_slug_27, t0.score AS score_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.pending_status_created_at AS pending_status_created_at_31, t0.published_at AS published_at_32, t0.expires_at AS expires_at_33, t0.deleted_at AS deleted_at_34, t0.rejected_at AS rejected_at_35, t0.campaign AS campaign_36, t0.final_price AS final_price_37, t0.source_of_sale AS source_of_sale_38, t0.delete_reason AS delete_reason_39, t0.delete_reason_details AS delete_reason_details_40, t0.source AS source_41, t0.impressions AS impressions_42, t0.impressions_monthly_count AS impressions_monthly_count_43, t0.impressions_weekly_count AS impressions_weekly_count_44, t0.impression_updated_at AS impression_updated_at_45, t0.price_level AS price_level_46, t0.compound_status AS compound_status_47, t0.price_per_meter AS price_per_meter_48, t0.is_bumped AS is_bumped_49, t0.is_send_email AS is_send_email_50, t0.market_property_type AS market_property_type_51, t0.creation_source AS creation_source_52, t0.click_through_rate AS click_through_rate_53, t0.label AS label_54, t0.is_top_picks AS is_top_picks_55, t0.contact_rate AS contact_rate_56, t0.synced AS synced_57, t0.reference_id AS reference_id_58, t0.is_pending_featuring AS is_pending_featuring_59, t0.pending_featuring_type AS pending_featuring_type_60, t0.rate_status AS rate_status_61, t0.is_rate_reviewed AS is_rate_reviewed_62, t0.is_call_request AS is_call_request_63, t0.is_shown_in_homepage AS is_shown_in_homepage_64, t0.is_commercial AS is_commercial_65, t0.is_resale AS is_resale_66, t0.is_rent AS is_rent_67, t0.is_primary AS is_primary_68, t0.is_mortgage_approved AS is_mortgage_approved_69, t0.meta_title AS meta_title_70, t0.meta_description AS meta_description_71, t0.is_mortgage AS is_mortgage_72, t0.eligible_for_mortgage AS eligible_for_mortgage_73, t0.property_registration_status AS property_registration_status_74, t0.advertiser_number AS advertiser_number_75, t0.authorization_number AS authorization_number_76, t0.freezed_at AS freezed_at_77, t0.eligible_for_bumpup AS eligible_for_bumpup_78, t0.waiting_time AS waiting_time_79, t0.reference_number AS reference_number_80, t0.parent_id AS parent_id_81, t0.relist_id AS relist_id_82, t0.section_id AS section_id_83, t0.property_type_id AS property_type_id_84, t0.location_id AS location_id_85, t0.compound_location_id AS compound_location_id_86, t0.user_id AS user_id_87, t0.compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0.status = 2 AND t0.parent_id = 376) ORDER BY t0.area ASC;