Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.deal_type AS deal_type_2,
  t0.price AS price_3,
  t0.date_added AS date_added_4,
  t0.date_updated AS date_updated_5,
  t0.date_expires AS date_expires_6,
  t0.status AS status_7,
  t0.is_negotiable AS is_negotiable_8,
  t0.is_featured AS is_featured_9,
  t0.description AS description_10,
  t0.deposit AS deposit_11,
  t0.charges AS charges_12,
  t0.services AS services_13,
  t0.assigned_at AS assigned_at_14,
  t0.contract_end_at AS contract_end_at_15,
  t0.assignment_type AS assignment_type_16,
  t0.is_published AS is_published_17,
  t0.slug AS slug_18,
  t0.uuid AS uuid_19,
  t0.property_id AS property_id_20,
  t0.album_id AS album_id_21,
  t0.customer_id AS customer_id_22,
  t0.employee_id AS employee_id_23
FROM
  listing t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.deal_type AS deal_type_2, t0.price AS price_3, t0.date_added AS date_added_4, t0.date_updated AS date_updated_5, t0.date_expires AS date_expires_6, t0.status AS status_7, t0.is_negotiable AS is_negotiable_8, t0.is_featured AS is_featured_9, t0.description AS description_10, t0.deposit AS deposit_11, t0.charges AS charges_12, t0.services AS services_13, t0.assigned_at AS assigned_at_14, t0.contract_end_at AS contract_end_at_15, t0.assignment_type AS assignment_type_16, t0.is_published AS is_published_17, t0.slug AS slug_18, t0.uuid AS uuid_19, t0.property_id AS property_id_20, t0.album_id AS album_id_21, t0.customer_id AS customer_id_22, t0.employee_id AS employee_id_23 FROM listing t0 WHERE t0.slug = 'Appartement-T1-Centre-Ville-7-faf0a403-300f-47bf-9695-4ccac2bfdf41' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.state AS state_3,
  t0.floor AS floor_4,
  t0.exact_area AS exact_area_5,
  t0.date_add AS date_add_6,
  t0.usable_area AS usable_area_7,
  t0.plan AS plan_8,
  t0.short_description AS short_description_9,
  t0.long_description AS long_description_10,
  t0.thumb AS thumb_11,
  t0.slug AS slug_12,
  t0.address AS address_13,
  t0.number_rooms AS number_rooms_14,
  t0.number_bathrooms AS number_bathrooms_15,
  t0.lat AS lat_16,
  t0.lng AS lng_17,
  t0.google_street_link AS google_street_link_18,
  t0.year_built AS year_built_19,
  t0.materport AS materport_20,
  t0.video AS video_21,
  t0.video_youtube AS video_youtube_22,
  t0.type_id AS type_id_23,
  t0.residence_id AS residence_id_24,
  t0.customer_id AS customer_id_25,
  t0.album_id AS album_id_26,
  t0.city_id AS city_id_27,
  t0.department_id AS department_id_28,
  t0.provider_id AS provider_id_29,
  t0.provider_lead_id AS provider_lead_id_30
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.floor AS floor_4, t0.exact_area AS exact_area_5, t0.date_add AS date_add_6, t0.usable_area AS usable_area_7, t0.plan AS plan_8, t0.short_description AS short_description_9, t0.long_description AS long_description_10, t0.thumb AS thumb_11, t0.slug AS slug_12, t0.address AS address_13, t0.number_rooms AS number_rooms_14, t0.number_bathrooms AS number_bathrooms_15, t0.lat AS lat_16, t0.lng AS lng_17, t0.google_street_link AS google_street_link_18, t0.year_built AS year_built_19, t0.materport AS materport_20, t0.video AS video_21, t0.video_youtube AS video_youtube_22, t0.type_id AS type_id_23, t0.residence_id AS residence_id_24, t0.customer_id AS customer_id_25, t0.album_id AS album_id_26, t0.city_id AS city_id_27, t0.department_id AS department_id_28, t0.provider_id AS provider_id_29, t0.provider_lead_id AS provider_lead_id_30 FROM property t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.public_title AS public_title_3,
  t0.thumb AS thumb_4,
  t0.image AS image_5,
  t0.short_description AS short_description_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.text AS text_9,
  t0.is_habitation AS is_habitation_10,
  t0.is_collectif AS is_collectif_11
FROM
  property_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.public_title AS public_title_3, t0.thumb AS thumb_4, t0.image AS image_5, t0.short_description AS short_description_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.text AS text_9, t0.is_habitation AS is_habitation_10, t0.is_collectif AS is_collectif_11 FROM property_type t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.residence_id AS residence_id_4,
  t5.id AS id_6,
  t5.name AS name_7,
  t5.state AS state_8,
  t5.floor AS floor_9,
  t5.exact_area AS exact_area_10,
  t5.date_add AS date_add_11,
  t5.usable_area AS usable_area_12,
  t5.plan AS plan_13,
  t5.short_description AS short_description_14,
  t5.long_description AS long_description_15,
  t5.thumb AS thumb_16,
  t5.slug AS slug_17,
  t5.address AS address_18,
  t5.number_rooms AS number_rooms_19,
  t5.number_bathrooms AS number_bathrooms_20,
  t5.lat AS lat_21,
  t5.lng AS lng_22,
  t5.google_street_link AS google_street_link_23,
  t5.year_built AS year_built_24,
  t5.materport AS materport_25,
  t5.video AS video_26,
  t5.video_youtube AS video_youtube_27,
  t5.type_id AS type_id_28,
  t5.residence_id AS residence_id_29,
  t5.customer_id AS customer_id_30,
  t5.album_id AS album_id_31,
  t5.city_id AS city_id_32,
  t5.department_id AS department_id_33,
  t5.provider_id AS provider_id_34,
  t5.provider_lead_id AS provider_lead_id_35,
  t36.id AS id_37,
  t36.deal_type AS deal_type_38,
  t36.price AS price_39,
  t36.date_added AS date_added_40,
  t36.date_updated AS date_updated_41,
  t36.date_expires AS date_expires_42,
  t36.status AS status_43,
  t36.is_negotiable AS is_negotiable_44,
  t36.is_featured AS is_featured_45,
  t36.description AS description_46,
  t36.deposit AS deposit_47,
  t36.charges AS charges_48,
  t36.services AS services_49,
  t36.assigned_at AS assigned_at_50,
  t36.contract_end_at AS contract_end_at_51,
  t36.assignment_type AS assignment_type_52,
  t36.is_published AS is_published_53,
  t36.slug AS slug_54,
  t36.uuid AS uuid_55,
  t36.property_id AS property_id_56,
  t36.album_id AS album_id_57,
  t36.customer_id AS customer_id_58,
  t36.employee_id AS employee_id_59
FROM
  album t0
  LEFT JOIN property t5 ON t5.album_id = t0.id
  LEFT JOIN listing t36 ON t36.album_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.residence_id AS residence_id_4, t5.id AS id_6, t5.name AS name_7, t5.state AS state_8, t5.floor AS floor_9, t5.exact_area AS exact_area_10, t5.date_add AS date_add_11, t5.usable_area AS usable_area_12, t5.plan AS plan_13, t5.short_description AS short_description_14, t5.long_description AS long_description_15, t5.thumb AS thumb_16, t5.slug AS slug_17, t5.address AS address_18, t5.number_rooms AS number_rooms_19, t5.number_bathrooms AS number_bathrooms_20, t5.lat AS lat_21, t5.lng AS lng_22, t5.google_street_link AS google_street_link_23, t5.year_built AS year_built_24, t5.materport AS materport_25, t5.video AS video_26, t5.video_youtube AS video_youtube_27, t5.type_id AS type_id_28, t5.residence_id AS residence_id_29, t5.customer_id AS customer_id_30, t5.album_id AS album_id_31, t5.city_id AS city_id_32, t5.department_id AS department_id_33, t5.provider_id AS provider_id_34, t5.provider_lead_id AS provider_lead_id_35, t36.id AS id_37, t36.deal_type AS deal_type_38, t36.price AS price_39, t36.date_added AS date_added_40, t36.date_updated AS date_updated_41, t36.date_expires AS date_expires_42, t36.status AS status_43, t36.is_negotiable AS is_negotiable_44, t36.is_featured AS is_featured_45, t36.description AS description_46, t36.deposit AS deposit_47, t36.charges AS charges_48, t36.services AS services_49, t36.assigned_at AS assigned_at_50, t36.contract_end_at AS contract_end_at_51, t36.assignment_type AS assignment_type_52, t36.is_published AS is_published_53, t36.slug AS slug_54, t36.uuid AS uuid_55, t36.property_id AS property_id_56, t36.album_id AS album_id_57, t36.customer_id AS customer_id_58, t36.employee_id AS employee_id_59 FROM album t0 LEFT JOIN property t5 ON t5.album_id = t0.id LEFT JOIN listing t36 ON t36.album_id = t0.id WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.alt AS alt_2,
  t0.image AS image_3,
  t0.album_id AS album_id_4
FROM
  album_image t0
WHERE
  t0.album_id = ?

SELECT t0.id AS id_1, t0.alt AS alt_2, t0.image AS image_3, t0.album_id AS album_id_4 FROM album_image t0 WHERE t0.album_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icone AS icone_3
FROM
  feature t0
  INNER JOIN property_feature ON t0.id = property_feature.feature_id
WHERE
  property_feature.property_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icone AS icone_3 FROM feature t0 INNER JOIN property_feature ON t0.id = property_feature.feature_id WHERE property_feature.property_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.is_displayed AS is_displayed_6,
  t0.distance AS distance_7,
  t0.address AS address_8,
  t0.text AS text_9,
  t0.residence_id AS residence_id_10,
  t0.property_id AS property_id_11
FROM
  nearby_services t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.is_displayed AS is_displayed_6, t0.distance AS distance_7, t0.address AS address_8, t0.text AS text_9, t0.residence_id AS residence_id_10, t0.property_id AS property_id_11 FROM nearby_services t0 WHERE t0.property_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.zip AS zip_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.insee_code AS insee_code_6,
  t0.country_id AS country_id_7,
  t0.state_id AS state_id_8
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.insee_code AS insee_code_6, t0.country_id AS country_id_7, t0.state_id AS state_id_8 FROM city t0 WHERE t0.id = 2765;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.iso_code AS iso_code_4,
  t0.thumb AS thumb_5,
  t0.image AS image_6,
  t0.country_id AS country_id_7
FROM
  state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.iso_code AS iso_code_4, t0.thumb AS thumb_5, t0.image AS image_6, t0.country_id AS country_id_7 FROM state t0 WHERE t0.id = 12;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:50:\\\"App\\\\Messenger\\\\Message\\\\TrackingKernelRequestMessage\\\":1:{s:59:\\\"\\0App\\\\Messenger\\\\Message\\\\TrackingKernelRequestMessage\\0content\\\";a:12:{s:9:\\\"userAgent\\\";s:103:\\\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\\\";s:2:\\\"ip\\\";s:11:\\\"3.144.82.26\\\";s:7:\\\"referer\\\";N;s:14:\\\"acceptLanguage\\\";N;s:3:\\\"uri\\\";s:98:\\\"https://affinia.online/listings/Appartement-T1-Centre-Ville-7-faf0a403-300f-47bf-9695-4ccac2bfdf41\\\";s:7:\\\"cookies\\\";a:0:{}s:6:\\\"params\\\";a:0:{}s:7:\\\"dateAdd\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2024-11-05 04:38:46.631325\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:9:\\\"phpsessid\\\";N;s:12:\\\"utm_campaign\\\";N;s:10:\\\"utm_source\\\";N;s:6:\\\"EVSSID\\\";s:36:\\\"e771bbd6-9826-4d39-a055-780212eb5874\\\";}}}', '[]', 'default', '2024-11-05 04:38:46', '2024-11-05 04:38:46');

"COMMIT"

"COMMIT";