Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.property_type_id AS property_type_id_5
FROM
  property_types_translations t0
WHERE
  t0.property_type_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = 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.score AS score_31,
  t0.is_imported AS is_imported_32,
  t0.subscription_expiry_date AS subscription_expiry_date_33,
  t0.credit_expiry_date AS credit_expiry_date_34,
  t0.soft_churn_date AS soft_churn_date_35,
  t0.reach_count AS reach_count_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,
  t61.id AS id_62,
  t61.balance AS balance_63,
  t61.status AS status_64,
  t61.created_at AS created_at_65,
  t61.updated_at AS updated_at_66,
  t61.user_id AS user_id_67
FROM
  users t0
  LEFT JOIN wallets t61 ON t61.user_id = t0.id
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.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_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, t61.id AS id_62, t61.balance AS balance_63, t61.status AS status_64, t61.created_at AS created_at_65, t61.updated_at AS updated_at_66, t61.user_id AS user_id_67 FROM users t0 LEFT JOIN wallets t61 ON t61.user_id = t0.id WHERE t0.id = 1;

SELECT
  COUNT(*)
FROM
  listings t0
WHERE
  t0.user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  compound_locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM compound_locations_translations t0 WHERE t0.location_id = 1;

SELECT
  l0_.id AS id_0,
  COALESCE(t1_.content, l0_.title) AS title_1,
  COALESCE(t2_.content, l0_.description) AS description_2,
  l0_.category AS category_3,
  l0_.pending_photos_status AS pending_photos_status_4,
  l0_.pending_payment_status AS pending_payment_status_5,
  l0_.relist_status AS relist_status_6,
  l0_.seller_role AS seller_role_7,
  l0_.area AS area_8,
  l0_.price AS price_9,
  COALESCE(t3_.content, l0_.address) AS address_10,
  l0_.center_lat AS center_lat_11,
  l0_.center_lng AS center_lng_12,
  l0_.status AS status_13,
  l0_.property_view AS property_view_14,
  l0_.payment_method AS payment_method_15,
  l0_.featured AS featured_16,
  l0_.views AS views_17,
  l0_.phone_counter AS phone_counter_18,
  l0_.messages_counter AS messages_counter_19,
  l0_.leads_counter AS leads_counter_20,
  l0_.sent_notifiers AS sent_notifiers_21,
  l0_.relist_counter AS relist_counter_22,
  l0_.ip AS ip_23,
  l0_.video_url AS video_url_24,
  l0_.slug AS slug_25,
  l0_.custom_slug AS custom_slug_26,
  l0_.score AS score_27,
  l0_.created_at AS created_at_28,
  l0_.updated_at AS updated_at_29,
  l0_.pending_status_created_at AS pending_status_created_at_30,
  l0_.published_at AS published_at_31,
  l0_.auto_reviewed_at AS auto_reviewed_at_32,
  l0_.expires_at AS expires_at_33,
  l0_.deleted_at AS deleted_at_34,
  l0_.rejected_at AS rejected_at_35,
  l0_.campaign AS campaign_36,
  l0_.final_price AS final_price_37,
  l0_.source_of_sale AS source_of_sale_38,
  l0_.delete_reason AS delete_reason_39,
  l0_.delete_reason_details AS delete_reason_details_40,
  l0_.amenities AS amenities_41,
  l0_.source AS source_42,
  l0_.impressions AS impressions_43,
  l0_.impressions_monthly_count AS impressions_monthly_count_44,
  l0_.impressions_weekly_count AS impressions_weekly_count_45,
  l0_.impression_updated_at AS impression_updated_at_46,
  l0_.price_level AS price_level_47,
  l0_.compound_status AS compound_status_48,
  l0_.price_per_meter AS price_per_meter_49,
  l0_.is_bumped AS is_bumped_50,
  l0_.is_send_email AS is_send_email_51,
  l0_.is_availability_email_sent AS is_availability_email_sent_52,
  l0_.market_property_type AS market_property_type_53,
  l0_.creation_source AS creation_source_54,
  l0_.click_through_rate AS click_through_rate_55,
  l0_.label AS label_56,
  l0_.is_top_picks AS is_top_picks_57,
  l0_.contact_rate AS contact_rate_58,
  l0_.reference_id AS reference_id_59,
  l0_.is_pending_featuring AS is_pending_featuring_60,
  l0_.pending_featuring_type AS pending_featuring_type_61,
  l0_.rate_status AS rate_status_62,
  l0_.is_rate_reviewed AS is_rate_reviewed_63,
  l0_.is_call_request AS is_call_request_64,
  l0_.is_shown_in_homepage AS is_shown_in_homepage_65,
  l0_.is_commercial AS is_commercial_66,
  l0_.is_resale AS is_resale_67,
  l0_.is_rent AS is_rent_68,
  l0_.is_primary AS is_primary_69,
  l0_.is_mortgage_approved AS is_mortgage_approved_70,
  COALESCE(t4_.content, l0_.meta_title) AS meta_title_71,
  COALESCE(
    t5_.content, l0_.meta_description
  ) AS meta_description_72,
  l0_.is_mortgage AS is_mortgage_73,
  l0_.eligible_for_mortgage AS eligible_for_mortgage_74,
  l0_.property_registration_status AS property_registration_status_75,
  l0_.advertiser_number AS advertiser_number_76,
  l0_.authorization_number AS authorization_number_77,
  l0_.freezed_at AS freezed_at_78,
  l0_.eligible_for_bumpup AS eligible_for_bumpup_79,
  l0_.waiting_time AS waiting_time_80,
  l0_.reference_number AS reference_number_81,
  l0_.is_hold AS is_hold_82,
  l0_.is_ai_content AS is_ai_content_83,
  l0_.ai_review AS ai_review_84,
  l0_.rating_review_status AS rating_review_status_85,
  l0_.parent_id AS parent_id_86,
  l0_.relist_id AS relist_id_87,
  l0_.section_id AS section_id_88,
  l0_.property_type_id AS property_type_id_89,
  l0_.location_id AS location_id_90,
  l0_.compound_location_id AS compound_location_id_91,
  l0_.user_id AS user_id_92,
  l0_.compound_field_id AS compound_field_id_93,
  l0_.brochure_id AS brochure_id_94,
  l0_.valuation_id AS valuation_id_95,
  l0_.new_valuation_id AS new_valuation_id_96
FROM
  listings l0_
  LEFT JOIN listings_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'title'
  AND t1_.listing_id = l0_.id
  LEFT JOIN listings_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'description'
  AND t2_.listing_id = l0_.id
  LEFT JOIN listings_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'address'
  AND t3_.listing_id = l0_.id
  LEFT JOIN listings_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'metaTitle'
  AND t4_.listing_id = l0_.id
  LEFT JOIN listings_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'metaDescription'
  AND t5_.listing_id = l0_.id
WHERE
  (
    l0_.parent_id IS NULL
    AND l0_.category = ?
    AND l0_.status = ?
  )
  AND (l0_.deleted_at IS NULL)

SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.description) AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, COALESCE(t3_.content, l0_.address) AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, COALESCE(t4_.content, l0_.meta_title) AS meta_title_71, COALESCE(t5_.content, l0_.meta_description) AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95, l0_.new_valuation_id AS new_valuation_id_96 FROM listings l0_ LEFT JOIN listings_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.listing_id = l0_.id LEFT JOIN listings_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'description' AND t2_.listing_id = l0_.id LEFT JOIN listings_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'address' AND t3_.listing_id = l0_.id LEFT JOIN listings_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'metaTitle' AND t4_.listing_id = l0_.id LEFT JOIN listings_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'metaDescription' AND t5_.listing_id = l0_.id WHERE (l0_.parent_id IS NULL AND l0_.category = 3 AND l0_.status = 2) AND (l0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  (
    t0.activity = ?
    AND t0.parent_id = ?
  )
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE (t0.activity = 1 AND t0.parent_id = 1) ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_singular AS title_singular_3,
  t0.title_plural AS title_plural_4,
  t0.slug AS slug_5,
  t0.private AS private_6,
  t0.level AS level_7,
  t0._left AS _left_8,
  t0._right AS _right_9,
  t0.root AS root_10,
  t0.compound_related AS compound_related_11,
  t0.reference_id AS reference_id_12,
  t0.exchangeable AS exchangeable_13,
  t0.is_evaluable AS is_evaluable_14,
  t0.searchable AS searchable_15,
  t0.deleted_at AS deleted_at_16,
  t0.custom_order AS custom_order_17,
  t0.amenities AS amenities_18,
  t0.parent_id AS parent_id_19
FROM
  property_types t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.searchable AS searchable_15, t0.deleted_at AS deleted_at_16, t0.custom_order AS custom_order_17, t0.amenities AS amenities_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE ((t0.deleted_at IS NULL));

SELECT
  (l0_.compound_location_id) AS sclr_0,
  COUNT(l0_.id) AS sclr_1
FROM
  listings l0_
  INNER JOIN compound_locations c1_ ON l0_.compound_location_id = c1_.id
  AND (
    c1_.id = l0_.compound_location_id
  )
WHERE
  (
    c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    AND l0_.parent_id IS NULL
    AND l0_.category = ?
    AND l0_.status = ?
  )
  AND (l0_.deleted_at IS NULL)
GROUP BY
  l0_.compound_location_id

SELECT (l0_.compound_location_id) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ INNER JOIN compound_locations c1_ ON l0_.compound_location_id = c1_.id AND (c1_.id = l0_.compound_location_id) WHERE (c1_.id IN (1, 2, 3, 5, 6, 7, 8, 9, 10, 11, 12, 14) AND l0_.parent_id IS NULL AND l0_.category = 3 AND l0_.status = 2) AND (l0_.deleted_at IS NULL) GROUP BY l0_.compound_location_id;

SELECT
  (l0_.property_type_id) AS sclr_0,
  COUNT(l0_.id) AS sclr_1
FROM
  listings l0_
  INNER JOIN property_types p1_ ON l0_.property_type_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  AND (p1_.id = l0_.property_type_id)
WHERE
  (
    p1_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?
    )
    AND l0_.parent_id IS NULL
    AND l0_.category = ?
    AND l0_.status = ?
  )
  AND (l0_.deleted_at IS NULL)
GROUP BY
  l0_.property_type_id

SELECT (l0_.property_type_id) AS sclr_0, COUNT(l0_.id) AS sclr_1 FROM listings l0_ INNER JOIN property_types p1_ ON l0_.property_type_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.id = l0_.property_type_id) WHERE (p1_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 33, 36, 37, 38, 39, 40, 41, 42, 45, 46, 47, 48, 50, 53, 54, 55, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 92, 93, 94, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130) AND l0_.parent_id IS NULL AND l0_.category = 3 AND l0_.status = 2) AND (l0_.deleted_at IS NULL) GROUP BY l0_.property_type_id;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.coordinates AS coordinates_2,
  c0_.slug AS slug_3,
  c0_._left AS _left_4,
  c0_.level AS level_5,
  c0_._right AS _right_6,
  c0_.root AS root_7,
  c0_.activity AS activity_8,
  c0_.is_compound_location AS is_compound_location_9,
  c0_.type AS type_10,
  c0_.parent_id AS parent_id_11,
  c0_.listing_id AS listing_id_12,
  c0_.location_id AS location_id_13
FROM
  compound_locations c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.activity = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.coordinates AS coordinates_2, c0_.slug AS slug_3, c0_._left AS _left_4, c0_.level AS level_5, c0_._right AS _right_6, c0_.root AS root_7, c0_.activity AS activity_8, c0_.is_compound_location AS is_compound_location_9, c0_.type AS type_10, c0_.parent_id AS parent_id_11, c0_.listing_id AS listing_id_12, c0_.location_id AS location_id_13 FROM compound_locations c0_ WHERE c0_.parent_id IS NULL AND c0_.activity = 1;

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

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 = 'finish-type' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.lat AS lat_6,
  t0.lon AS lon_7,
  t0.zoom AS zoom_8,
  t0.coordinates AS coordinates_9,
  t0.searchable AS searchable_10,
  t0.home_filter AS home_filter_11,
  t0.statistics_filter AS statistics_filter_12,
  t0.neighborhood_filter AS neighborhood_filter_13,
  t0.compound_filter AS compound_filter_14,
  t0.estimate AS estimate_15,
  t0.disabled AS disabled_16,
  t0.level AS level_17,
  t0._left AS _left_18,
  t0._right AS _right_19,
  t0.root AS root_20,
  t0.show_primary_only AS show_primary_only_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.synonyms AS synonyms_24,
  t0.full_path AS full_path_25,
  t0.reference_id AS reference_id_26,
  t0.type AS type_27,
  t0.eligible_for_mortgage AS eligible_for_mortgage_28,
  t0.is_compound_location AS is_compound_location_29,
  t0.parent_id AS parent_id_30,
  t0.location_compound_id AS location_compound_id_31,
  t0.rating_id AS rating_id_32,
  t0.listing_id AS listing_id_33
FROM
  locations t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.level AS level_17, t0._left AS _left_18, t0._right AS _right_19, t0.root AS root_20, t0.show_primary_only AS show_primary_only_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.synonyms AS synonyms_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id IN ('1', '2', '3', '4', '5');

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.paragraph AS paragraph_2,
  c0_.place AS place_3,
  c0_.is_published AS is_published_4,
  c0_.by_owner_only AS by_owner_only_5,
  c0_.photo AS photo_6
FROM
  custom_paragraphs c0_
  INNER JOIN paragraphs_sections p2_ ON c0_.id = p2_.paragraph_id
  INNER JOIN sections s1_ ON s1_.id = p2_.section_id
WHERE
  s1_.id = ?
  AND c0_.place = ?
  AND (
    SELECT
      COUNT(*)
    FROM
      paragraphs_locations p3_
    WHERE
      p3_.paragraph_id = c0_.id
  ) = 0
  AND (
    SELECT
      COUNT(*)
    FROM
      paragraphs_compound_locations p4_
    WHERE
      p4_.paragraph_id = c0_.id
  ) = 0
  AND c0_.is_published = ?