Symfony Profiler

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_.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_.source AS source_41,
  l0_.impressions AS impressions_42,
  l0_.impressions_monthly_count AS impressions_monthly_count_43,
  l0_.impressions_weekly_count AS impressions_weekly_count_44,
  l0_.impression_updated_at AS impression_updated_at_45,
  l0_.price_level AS price_level_46,
  l0_.compound_status AS compound_status_47,
  l0_.price_per_meter AS price_per_meter_48,
  l0_.is_bumped AS is_bumped_49,
  l0_.is_send_email AS is_send_email_50,
  l0_.is_availability_email_sent AS is_availability_email_sent_51,
  l0_.market_property_type AS market_property_type_52,
  l0_.creation_source AS creation_source_53,
  l0_.click_through_rate AS click_through_rate_54,
  l0_.label AS label_55,
  l0_.is_top_picks AS is_top_picks_56,
  l0_.contact_rate AS contact_rate_57,
  l0_.synced AS synced_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,
  l0_.meta_title AS meta_title_71,
  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
FROM
  listings l0_
WHERE
  (
    l0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND (l0_.deleted_at IS NULL)
ORDER BY
  FIELD(
    l0_.id, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  ) ASC

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_.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_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_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, l0_.meta_title AS meta_title_71, 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 FROM listings l0_ WHERE (l0_.id IN ('3', '30', '196', '158', '388', '69', '234', '398', '105', '347', '145', '171', '118', '11', '292', '350', '365', '344', '141', '19')) AND (l0_.deleted_at IS NULL) ORDER BY FIELD(l0_.id, '3', '30', '196', '158', '388', '69', '234', '398', '105', '347', '145', '171', '118', '11', '292', '350', '365', '344', '141', '19') ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.listing_id AS listing_id_3,
  t0.custome_field_id AS custome_field_id_4
FROM
  listings_attributes t0
WHERE
  t0.listing_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.similar_identifier AS similar_identifier_6,
  t0.required AS required_7
FROM
  custom_fields t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = 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.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.similar_identifier AS similar_identifier_6,
  t0.required AS required_7
FROM
  custom_fields t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.similar_identifier AS similar_identifier_6,
  t0.required AS required_7
FROM
  custom_fields t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.similar_identifier AS similar_identifier_6,
  t0.required AS required_7
FROM
  custom_fields t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.id = 5;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_file_name AS original_file_name_3,
  t0.path AS path_4,
  t0.hash AS hash_5,
  t0.dimensions AS dimensions_6,
  t0.size AS size_7,
  t0.uploaded_at AS uploaded_at_8
FROM
  photos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = 221;

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.show_primary_only AS show_primary_only_22,
  t0.leads_counter AS leads_counter_23,
  t0.listings_counter AS listings_counter_24,
  t0.keyword AS keyword_25,
  t0.full_path AS full_path_26,
  t0.reference_id AS reference_id_27,
  t0.type AS type_28,
  t0.eligible_for_mortgage AS eligible_for_mortgage_29,
  t0.is_compound_location AS is_compound_location_30,
  t0.parent_id AS parent_id_31,
  t0.location_compound_id AS location_compound_id_32,
  t0.rating_id AS rating_id_33,
  t0.listing_id AS listing_id_34
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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = 40;