Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.public_name AS public_name_3,
  t0.short_description AS short_description_4,
  t0.text AS text_5,
  t0.thumb AS thumb_6,
  t0.image AS image_7,
  t0.address AS address_8,
  t0.gps AS gps_9,
  t0.slug AS slug_10,
  t0.is_active AS is_active_11,
  t0.video AS video_12,
  t0.cover_brochure AS cover_brochure_13,
  t0.brochure AS brochure_14,
  t0.prestations AS prestations_15,
  t0.is_published AS is_published_16,
  t0.is_project_price_published AS is_project_price_published_17,
  t0.is_featured AS is_featured_18,
  t0.lat AS lat_19,
  t0.lng AS lng_20,
  t0.second_long_text AS second_long_text_21,
  t0.project_manager_id AS project_manager_id_22,
  t0.city_id AS city_id_23,
  t0.country_state_id AS country_state_id_24
FROM
  residence t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.public_name AS public_name_3, t0.short_description AS short_description_4, t0.text AS text_5, t0.thumb AS thumb_6, t0.image AS image_7, t0.address AS address_8, t0.gps AS gps_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.video AS video_12, t0.cover_brochure AS cover_brochure_13, t0.brochure AS brochure_14, t0.prestations AS prestations_15, t0.is_published AS is_published_16, t0.is_project_price_published AS is_project_price_published_17, t0.is_featured AS is_featured_18, t0.lat AS lat_19, t0.lng AS lng_20, t0.second_long_text AS second_long_text_21, t0.project_manager_id AS project_manager_id_22, t0.city_id AS city_id_23, t0.country_state_id AS country_state_id_24 FROM residence t0 WHERE t0.is_active = 1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:12:\\\"3.147.57.145\\\";s:7:\\\"referer\\\";s:47:\\\"https://affinia.online/residence/whatsapp_dummy\\\";s:14:\\\"acceptLanguage\\\";N;s:3:\\\"uri\\\";s:33:\\\"https://affinia.online/residences\\\";s:7:\\\"cookies\\\";a:3:{s:11:\\\"sf_redirect\\\";s:310:\\\"{\\\"token\\\":\\\"50fccf\\\",\\\"route\\\":\\\"app_residence_show\\\",\\\"method\\\":\\\"GET\\\",\\\"controller\\\":{\\\"class\\\":\\\"App\\\\\\\\Controller\\\\\\\\Web\\\\\\\\WebPropertyController\\\",\\\"method\\\":\\\"showResidence\\\",\\\"file\\\":\\\"\\\\/var\\\\/www\\\\/affiniaAgency\\\\/affiniaAgencyPlus\\\\/src\\\\/Controller\\\\/Web\\\\/WebPropertyController.php\\\",\\\"line\\\":223},\\\"status_code\\\":302,\\\"status_text\\\":\\\"Found\\\"}\\\";s:9:\\\"PHPSESSID\\\";s:26:\\\"8os0e2l3c0trtnnm4uqkm9csgp\\\";s:6:\\\"EVSSID\\\";s:36:\\\"f0fd4929-6a42-46f6-9546-c0cf2e8878bb\\\";}s:6:\\\"params\\\";a:0:{}s:7:\\\"dateAdd\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2024-11-05 06:44:05.475469\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:9:\\\"phpsessid\\\";s:26:\\\"8os0e2l3c0trtnnm4uqkm9csgp\\\";s:12:\\\"utm_campaign\\\";N;s:10:\\\"utm_source\\\";N;s:6:\\\"EVSSID\\\";s:36:\\\"f0fd4929-6a42-46f6-9546-c0cf2e8878bb\\\";}}}', '[]', 'default', '2024-11-05 06:44:05', '2024-11-05 06:44:05');

"COMMIT"

"COMMIT";