Symfony Profiler

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.auto_reviewed_at AS auto_reviewed_at_33,
  t0.expires_at AS expires_at_34,
  t0.deleted_at AS deleted_at_35,
  t0.rejected_at AS rejected_at_36,
  t0.campaign AS campaign_37,
  t0.final_price AS final_price_38,
  t0.source_of_sale AS source_of_sale_39,
  t0.delete_reason AS delete_reason_40,
  t0.delete_reason_details AS delete_reason_details_41,
  t0.source AS source_42,
  t0.impressions AS impressions_43,
  t0.impressions_monthly_count AS impressions_monthly_count_44,
  t0.impressions_weekly_count AS impressions_weekly_count_45,
  t0.impression_updated_at AS impression_updated_at_46,
  t0.price_level AS price_level_47,
  t0.compound_status AS compound_status_48,
  t0.price_per_meter AS price_per_meter_49,
  t0.is_bumped AS is_bumped_50,
  t0.is_send_email AS is_send_email_51,
  t0.is_availability_email_sent AS is_availability_email_sent_52,
  t0.market_property_type AS market_property_type_53,
  t0.creation_source AS creation_source_54,
  t0.click_through_rate AS click_through_rate_55,
  t0.label AS label_56,
  t0.is_top_picks AS is_top_picks_57,
  t0.contact_rate AS contact_rate_58,
  t0.synced AS synced_59,
  t0.reference_id AS reference_id_60,
  t0.is_pending_featuring AS is_pending_featuring_61,
  t0.pending_featuring_type AS pending_featuring_type_62,
  t0.rate_status AS rate_status_63,
  t0.is_rate_reviewed AS is_rate_reviewed_64,
  t0.is_call_request AS is_call_request_65,
  t0.is_shown_in_homepage AS is_shown_in_homepage_66,
  t0.is_commercial AS is_commercial_67,
  t0.is_resale AS is_resale_68,
  t0.is_rent AS is_rent_69,
  t0.is_primary AS is_primary_70,
  t0.is_mortgage_approved AS is_mortgage_approved_71,
  t0.meta_title AS meta_title_72,
  t0.meta_description AS meta_description_73,
  t0.is_mortgage AS is_mortgage_74,
  t0.eligible_for_mortgage AS eligible_for_mortgage_75,
  t0.property_registration_status AS property_registration_status_76,
  t0.advertiser_number AS advertiser_number_77,
  t0.authorization_number AS authorization_number_78,
  t0.freezed_at AS freezed_at_79,
  t0.eligible_for_bumpup AS eligible_for_bumpup_80,
  t0.waiting_time AS waiting_time_81,
  t0.reference_number AS reference_number_82,
  t0.is_hold AS is_hold_83,
  t0.is_ai_content AS is_ai_content_84,
  t0.ai_review AS ai_review_85,
  t0.rating_review_status AS rating_review_status_86,
  t0.parent_id AS parent_id_87,
  t0.relist_id AS relist_id_88,
  t0.section_id AS section_id_89,
  t0.property_type_id AS property_type_id_90,
  t0.location_id AS location_id_91,
  t0.compound_location_id AS compound_location_id_92,
  t0.user_id AS user_id_93,
  t0.compound_field_id AS compound_field_id_94,
  t0.brochure_id AS brochure_id_95,
  t0.valuation_id AS valuation_id_96
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.auto_reviewed_at AS auto_reviewed_at_33, t0.expires_at AS expires_at_34, t0.deleted_at AS deleted_at_35, t0.rejected_at AS rejected_at_36, t0.campaign AS campaign_37, t0.final_price AS final_price_38, t0.source_of_sale AS source_of_sale_39, t0.delete_reason AS delete_reason_40, t0.delete_reason_details AS delete_reason_details_41, t0.source AS source_42, t0.impressions AS impressions_43, t0.impressions_monthly_count AS impressions_monthly_count_44, t0.impressions_weekly_count AS impressions_weekly_count_45, t0.impression_updated_at AS impression_updated_at_46, t0.price_level AS price_level_47, t0.compound_status AS compound_status_48, t0.price_per_meter AS price_per_meter_49, t0.is_bumped AS is_bumped_50, t0.is_send_email AS is_send_email_51, t0.is_availability_email_sent AS is_availability_email_sent_52, t0.market_property_type AS market_property_type_53, t0.creation_source AS creation_source_54, t0.click_through_rate AS click_through_rate_55, t0.label AS label_56, t0.is_top_picks AS is_top_picks_57, t0.contact_rate AS contact_rate_58, t0.synced AS synced_59, t0.reference_id AS reference_id_60, t0.is_pending_featuring AS is_pending_featuring_61, t0.pending_featuring_type AS pending_featuring_type_62, t0.rate_status AS rate_status_63, t0.is_rate_reviewed AS is_rate_reviewed_64, t0.is_call_request AS is_call_request_65, t0.is_shown_in_homepage AS is_shown_in_homepage_66, t0.is_commercial AS is_commercial_67, t0.is_resale AS is_resale_68, t0.is_rent AS is_rent_69, t0.is_primary AS is_primary_70, t0.is_mortgage_approved AS is_mortgage_approved_71, t0.meta_title AS meta_title_72, t0.meta_description AS meta_description_73, t0.is_mortgage AS is_mortgage_74, t0.eligible_for_mortgage AS eligible_for_mortgage_75, t0.property_registration_status AS property_registration_status_76, t0.advertiser_number AS advertiser_number_77, t0.authorization_number AS authorization_number_78, t0.freezed_at AS freezed_at_79, t0.eligible_for_bumpup AS eligible_for_bumpup_80, t0.waiting_time AS waiting_time_81, t0.reference_number AS reference_number_82, t0.is_hold AS is_hold_83, t0.is_ai_content AS is_ai_content_84, t0.ai_review AS ai_review_85, t0.rating_review_status AS rating_review_status_86, t0.parent_id AS parent_id_87, t0.relist_id AS relist_id_88, t0.section_id AS section_id_89, t0.property_type_id AS property_type_id_90, t0.location_id AS location_id_91, t0.compound_location_id AS compound_location_id_92, t0.user_id AS user_id_93, t0.compound_field_id AS compound_field_id_94, t0.brochure_id AS brochure_id_95, t0.valuation_id AS valuation_id_96 FROM listings t0 WHERE t0.id = '390';

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

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

SELECT
  i0_.id AS id_0,
  i0_.type AS type_1,
  i0_.user_ip AS user_ip_2,
  i0_.created_at AS created_at_3,
  i0_.source AS source_4,
  i0_.campaign AS campaign_5,
  i0_.user_id AS user_id_6,
  i0_.listing_id AS listing_id_7
FROM
  interactions i0_
WHERE
  i0_.listing_id = ?
  AND i0_.type = ?
  AND i0_.user_ip = ?
  AND i0_.created_at >= ?
ORDER BY
  i0_.id DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.user_ip AS user_ip_2, i0_.created_at AS created_at_3, i0_.source AS source_4, i0_.campaign AS campaign_5, i0_.user_id AS user_id_6, i0_.listing_id AS listing_id_7 FROM interactions i0_ WHERE i0_.listing_id = 390 AND i0_.type = 4 AND i0_.user_ip = '10.244.220.183' AND i0_.created_at >= '2025-12-16 06:09:10' ORDER BY i0_.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO interactions (
  type, user_ip, created_at, source,
  campaign, user_id, listing_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO interactions (type, user_ip, created_at, source, campaign, user_id, listing_id) VALUES (4, '10.244.220.183', '2025-12-18 06:09:10', 'interaction-service', NULL, NULL, 390);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  listings
SET
  views = ?
WHERE
  id = ?

UPDATE listings SET views = 40 WHERE id = 390;

"COMMIT"

"COMMIT";

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

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

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.section_id AS section_id_5
FROM
  sections_translations t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = 3;

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