Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.created_at AS created_at_6,
  t0.is_active AS is_active_7,
  t0.company_id AS company_id_8
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7, t0.company_id AS company_id_8 FROM "user" t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unique_code AS unique_code_3,
  t0.ico AS ico_4,
  t0.specialization AS specialization_5,
  t0.user_limit AS user_limit_6,
  t0.created_at AS created_at_7,
  t0.is_active AS is_active_8
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_code AS unique_code_3, t0.ico AS ico_4, t0.specialization AS specialization_5, t0.user_limit AS user_limit_6, t0.created_at AS created_at_7, t0.is_active AS is_active_8 FROM company t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.payment_transaction_id AS payment_transaction_id_5,
  t0.last_payment_date AS last_payment_date_6,
  t0.next_payment_date AS next_payment_date_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.company_id AS company_id_10,
  t0.plan_id AS plan_id_11
FROM
  subscription t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.payment_transaction_id AS payment_transaction_id_5, t0.last_payment_date AS last_payment_date_6, t0.next_payment_date AS next_payment_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.company_id AS company_id_10, t0.plan_id AS plan_id_11 FROM subscription t0 WHERE t0.company_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.type AS type_2,
  c0_.created_at AS created_at_3,
  c0_.last_message_at AS last_message_at_4,
  c0_.company_id AS company_id_5,
  c0_.created_by_id AS created_by_id_6
FROM
  conversation c0_
  INNER JOIN conversation_participant c1_ ON c0_.id = c1_.conversation_id
WHERE
  c1_.user_id = ?
  AND c0_.company_id = ?
ORDER BY
  c0_.last_message_at DESC,
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.created_at AS created_at_3, c0_.last_message_at AS last_message_at_4, c0_.company_id AS company_id_5, c0_.created_by_id AS created_by_id_6 FROM conversation c0_ INNER JOIN conversation_participant c1_ ON c0_.id = c1_.conversation_id WHERE c1_.user_id = 1 AND c0_.company_id = 1 ORDER BY c0_.last_message_at DESC, c0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.joined_at AS joined_at_3,
  t0.last_read_at AS last_read_at_4,
  t0.is_muted AS is_muted_5,
  t0.conversation_id AS conversation_id_6,
  t0.user_id AS user_id_7
FROM
  conversation_participant t0
WHERE
  t0.conversation_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.is_muted AS is_muted_5, t0.conversation_id AS conversation_id_6, t0.user_id AS user_id_7 FROM conversation_participant t0 WHERE t0.conversation_id = 1;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  message m0_
WHERE
  m0_.conversation_id = ?
  AND m0_.sender_id <> ?
  AND m0_.created_at > ?

SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.conversation_id = 1 AND m0_.sender_id <> 1 AND m0_.created_at > '2026-03-25 12:38:56';

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.joined_at AS joined_at_3,
  t0.last_read_at AS last_read_at_4,
  t0.is_muted AS is_muted_5,
  t0.conversation_id AS conversation_id_6,
  t0.user_id AS user_id_7
FROM
  conversation_participant t0
WHERE
  t0.conversation_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.joined_at AS joined_at_3, t0.last_read_at AS last_read_at_4, t0.is_muted AS is_muted_5, t0.conversation_id AS conversation_id_6, t0.user_id AS user_id_7 FROM conversation_participant t0 WHERE t0.conversation_id = 2;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  message m0_
WHERE
  m0_.conversation_id = ?
  AND m0_.sender_id <> ?
  AND m0_.created_at > ?

SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.conversation_id = 2 AND m0_.sender_id <> 1 AND m0_.created_at > '2026-03-25 12:24:44';

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.created_at AS created_at_5,
  u0_.is_active AS is_active_6,
  u0_.company_id AS company_id_7
FROM
  "user" u0_
WHERE
  u0_.company_id = ?
  AND u0_.is_active = ?
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.created_at AS created_at_5, u0_.is_active AS is_active_6, u0_.company_id AS company_id_7 FROM "user" u0_ WHERE u0_.company_id = 1 AND u0_.is_active = 1 ORDER BY u0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.type AS type_2,
  c0_.created_at AS created_at_3,
  c0_.last_message_at AS last_message_at_4,
  c0_.company_id AS company_id_5,
  c0_.created_by_id AS created_by_id_6
FROM
  conversation c0_
WHERE
  c0_.id = ?
  AND c0_.company_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.created_at AS created_at_3, c0_.last_message_at AS last_message_at_4, c0_.company_id AS company_id_5, c0_.created_by_id AS created_by_id_6 FROM conversation c0_ WHERE c0_.id = 1 AND c0_.company_id = 1;

SELECT
  m0_.id AS id_0,
  m0_.content AS content_1,
  m0_.type AS type_2,
  m0_.created_at AS created_at_3,
  m0_.edited_at AS edited_at_4,
  m0_.is_deleted AS is_deleted_5,
  m0_.metadata AS metadata_6,
  m0_.conversation_id AS conversation_id_7,
  m0_.sender_id AS sender_id_8,
  m0_.sender_partner_id AS sender_partner_id_9,
  m0_.reply_to_id AS reply_to_id_10
FROM
  message m0_
WHERE
  m0_.conversation_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  50

SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.type AS type_2, m0_.created_at AS created_at_3, m0_.edited_at AS edited_at_4, m0_.is_deleted AS is_deleted_5, m0_.metadata AS metadata_6, m0_.conversation_id AS conversation_id_7, m0_.sender_id AS sender_id_8, m0_.sender_partner_id AS sender_partner_id_9, m0_.reply_to_id AS reply_to_id_10 FROM message m0_ WHERE m0_.conversation_id = 1 ORDER BY m0_.created_at DESC LIMIT 50;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  conversation_participant
SET
  last_read_at = ?
WHERE
  id = ?

UPDATE conversation_participant SET last_read_at = '2026-04-14 10:44:26' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.reference_number AS reference_number_1,
  c0_.service_type AS service_type_2,
  c0_.custom_service_type AS custom_service_type_3,
  c0_.description AS description_4,
  c0_.notes AS notes_5,
  c0_.date_from AS date_from_6,
  c0_.date_to AS date_to_7,
  c0_.logistics_required AS logistics_required_8,
  c0_.status AS status_9,
  c0_.partner_response AS partner_response_10,
  c0_.responded_at AS responded_at_11,
  c0_.attachments AS attachments_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.partner_id AS partner_id_15,
  c0_.project_id AS project_id_16,
  c0_.item_id AS item_id_17,
  c0_.created_by_id AS created_by_id_18,
  c0_.conversation_id AS conversation_id_19
FROM
  cooperation c0_
WHERE
  c0_.conversation_id = ?

SELECT c0_.id AS id_0, c0_.reference_number AS reference_number_1, c0_.service_type AS service_type_2, c0_.custom_service_type AS custom_service_type_3, c0_.description AS description_4, c0_.notes AS notes_5, c0_.date_from AS date_from_6, c0_.date_to AS date_to_7, c0_.logistics_required AS logistics_required_8, c0_.status AS status_9, c0_.partner_response AS partner_response_10, c0_.responded_at AS responded_at_11, c0_.attachments AS attachments_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.partner_id AS partner_id_15, c0_.project_id AS project_id_16, c0_.item_id AS item_id_17, c0_.created_by_id AS created_by_id_18, c0_.conversation_id AS conversation_id_19 FROM cooperation c0_ WHERE c0_.conversation_id = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.edited_at AS edited_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.metadata AS metadata_7,
  t0.conversation_id AS conversation_id_8,
  t0.sender_id AS sender_id_9,
  t0.sender_partner_id AS sender_partner_id_10,
  t0.reply_to_id AS reply_to_id_11
FROM
  message t0
WHERE
  t0.conversation_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.is_deleted AS is_deleted_6, t0.metadata AS metadata_7, t0.conversation_id AS conversation_id_8, t0.sender_id AS sender_id_9, t0.sender_partner_id AS sender_partner_id_10, t0.reply_to_id AS reply_to_id_11 FROM message t0 WHERE t0.conversation_id = 1 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.edited_at AS edited_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.metadata AS metadata_7,
  t0.conversation_id AS conversation_id_8,
  t0.sender_id AS sender_id_9,
  t0.sender_partner_id AS sender_partner_id_10,
  t0.reply_to_id AS reply_to_id_11
FROM
  message t0
WHERE
  t0.conversation_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.is_deleted AS is_deleted_6, t0.metadata AS metadata_7, t0.conversation_id AS conversation_id_8, t0.sender_id AS sender_id_9, t0.sender_partner_id AS sender_partner_id_10, t0.reply_to_id AS reply_to_id_11 FROM message t0 WHERE t0.conversation_id = 2 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ico AS ico_3,
  t0.description AS description_4,
  t0.specializations AS specializations_5,
  t0.contact_email AS contact_email_6,
  t0.contact_phone AS contact_phone_7,
  t0.contact_name AS contact_name_8,
  t0.address AS address_9,
  t0.city AS city_10,
  t0.postal_code AS postal_code_11,
  t0.country AS country_12,
  t0.website AS website_13,
  t0.logo_url AS logo_url_14,
  t0.status AS status_15,
  t0.accepting_orders AS accepting_orders_16,
  t0.is_verified AS is_verified_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.verified_at AS verified_at_20,
  t0.roles AS roles_21,
  t0.password AS password_22
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ico AS ico_3, t0.description AS description_4, t0.specializations AS specializations_5, t0.contact_email AS contact_email_6, t0.contact_phone AS contact_phone_7, t0.contact_name AS contact_name_8, t0.address AS address_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.country AS country_12, t0.website AS website_13, t0.logo_url AS logo_url_14, t0.status AS status_15, t0.accepting_orders AS accepting_orders_16, t0.is_verified AS is_verified_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.verified_at AS verified_at_20, t0.roles AS roles_21, t0.password AS password_22 FROM partner t0 WHERE t0.id = 1;