Symfony Profiler

SELECT
  o.id,
  forwarding_frequency,
  o.legal_name,
  o.bal,
  o.status_invoice_payed,
  o.uniq_id,
  pa.street_address
FROM
  organization o
  INNER JOIN store s ON o.store_id = s.id
  INNER JOIN postal_address pa ON s.postal_address_id = pa.id
  INNER JOIN letter l ON l.organization_id = o.id
  INNER JOIN subscription sub ON sub.organization_id = o.id
  INNER JOIN service sv ON sub.id = sv.subscription_id
  INNER JOIN product p ON sv.product_id = p.id
WHERE
  o.head_quarters_address_type IN (:headQuarters)
  AND pa.postal_code = :postalCode
  AND sub.has_blocked_service = false
  AND o.status <> :canceled
  AND o.forwarding_frequency = :frequency
  AND pa.street_address IS NOT NULL
  AND l.status = 'TO_BE_SENT'
  AND l.type IN (:typeOfLetter)
  AND sub.active = TRUE
  AND p.unique_key = 'REEXPEDITION_COURRIER';

SELECT o.id, forwarding_frequency, o.legal_name, o.bal, o.status_invoice_payed, o.uniq_id,  pa.street_address FROM organization o INNER JOIN store s ON o.store_id = s.id INNER JOIN postal_address pa ON s.postal_address_id = pa.id INNER JOIN letter l ON l.organization_id = o.id INNER JOIN subscription sub ON sub.organization_id = o.id INNER JOIN service sv ON sub.id = sv.subscription_id INNER JOIN product p ON sv.product_id = p.id WHERE o.head_quarters_address_type IN ('CONTRACT_DOMICILIATION', 'POSTAL_DOMICILIATION') AND pa.postal_code = 75008 AND sub.has_blocked_service = false AND o.status <> 'CANCELLED' AND o.forwarding_frequency = 'WEEKLY' AND pa.street_address IS NOT NULL AND l.status = 'TO_BE_SENT' AND l.type IN ('NOTICE', 'LETTER', 'LETTER_WITH_AR', 'BAILIFF_NOTICE', 'BAILIFF_DEED') AND sub.active = TRUE  AND p.unique_key = 'REEXPEDITION_COURRIER' ;;

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.phone_number AS phone_number_2,
  a0_.password AS password_3,
  a0_.roles AS roles_4,
  a0_.lastname AS lastname_5,
  a0_.firstname AS firstname_6,
  a0_.created_at AS created_at_7,
  a0_.registration_source AS registration_source_8,
  a0_.honorific_prefix AS honorific_prefix_9,
  a0_.reset_token AS reset_token_10,
  a0_.reset_token_expiration_date AS reset_token_expiration_date_11,
  a0_.uniq_id AS uniq_id_12,
  a0_.code_confirmation AS code_confirmation_13,
  a0_.updated_at AS updated_at_14,
  a0_.is_active AS is_active_15
FROM
  app_users a0_
WHERE
  a0_.email = ?
  OR a0_.phone_number = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'davy@digidom.pro' OR a0_.phone_number = 'davy@digidom.pro';

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

INSERT INTO messenger_export (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:31:\\\"App\\\\Message\\\\ResendLetterMessage\\\":9:{s:35:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0id\\\";s:3:\\\"END\\\";s:52:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0forwardingFrequency\\\";s:6:\\\"WEEKLY\\\";s:42:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0legalName\\\";N;s:36:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0bal\\\";N;s:51:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0statusInvoicePayed\\\";N;s:39:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0uniqId\\\";N;s:43:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0postalCode\\\";i:75008;s:45:\\\"\\0App\\\\Message\\\\ResendLetterMessage\\0initialCount\\\";i:0;s:4:\\\"date\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2024-08-10 14:30:00.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:13:\\\"Europe/Berlin\\\";}}}', '[]', 'default', '2024-11-05 16:00:13', '2024-11-05 16:00:13');