Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.token_key AS token_key_2,
  t0.refresh_token_key AS refresh_token_key_3,
  t0.expires_at AS expires_at_4,
  t0.refresh_expires_at AS refresh_expires_at_5,
  t0.last_active_date AS last_active_date_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.email AS email_12,
  t10.password AS password_13,
  t10.first_name AS first_name_14,
  t10.last_name AS last_name_15,
  t10.gender AS gender_16,
  t10.phone_number AS phone_number_17,
  t10.active AS active_18,
  t10.login_token AS login_token_19,
  t10.password_reset_token AS password_reset_token_20,
  t10.password_reset_token_expires_at AS password_reset_token_expires_at_21,
  t10.activation_token AS activation_token_22,
  t10.activation_token_expires_at AS activation_token_expires_at_23,
  t10.email_confirmed_at AS email_confirmed_at_24,
  t10.google_id AS google_id_25,
  t10.firebase_id AS firebase_id_26,
  t10.google_avatar_url AS google_avatar_url_27,
  t10.created_at AS created_at_28,
  t10.updated_at AS updated_at_29
FROM
  tokens t0
  INNER JOIN users t10 ON t0.user_id = t10.id
WHERE
  t0.user_id IN (?)

SELECT t0.id AS id_1, t0.token_key AS token_key_2, t0.refresh_token_key AS refresh_token_key_3, t0.expires_at AS expires_at_4, t0.refresh_expires_at AS refresh_expires_at_5, t0.last_active_date AS last_active_date_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.email AS email_12, t10.password AS password_13, t10.first_name AS first_name_14, t10.last_name AS last_name_15, t10.gender AS gender_16, t10.phone_number AS phone_number_17, t10.active AS active_18, t10.login_token AS login_token_19, t10.password_reset_token AS password_reset_token_20, t10.password_reset_token_expires_at AS password_reset_token_expires_at_21, t10.activation_token AS activation_token_22, t10.activation_token_expires_at AS activation_token_expires_at_23, t10.email_confirmed_at AS email_confirmed_at_24, t10.google_id AS google_id_25, t10.firebase_id AS firebase_id_26, t10.google_avatar_url AS google_avatar_url_27, t10.created_at AS created_at_28, t10.updated_at AS updated_at_29 FROM tokens t0 INNER JOIN users t10 ON t0.user_id = t10.id WHERE t0.user_id IN (38);

UPDATE
  tokens
SET
  last_active_date = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE tokens SET last_active_date = '2026-06-18 10:16:35', updated_at = '2026-06-18 10:16:35' WHERE id = 319;

SELECT
  t0.id AS id_1,
  t0.token_key AS token_key_2,
  t0.refresh_token_key AS refresh_token_key_3,
  t0.expires_at AS expires_at_4,
  t0.refresh_expires_at AS refresh_expires_at_5,
  t0.last_active_date AS last_active_date_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.email AS email_12,
  t10.password AS password_13,
  t10.first_name AS first_name_14,
  t10.last_name AS last_name_15,
  t10.gender AS gender_16,
  t10.phone_number AS phone_number_17,
  t10.active AS active_18,
  t10.login_token AS login_token_19,
  t10.password_reset_token AS password_reset_token_20,
  t10.password_reset_token_expires_at AS password_reset_token_expires_at_21,
  t10.activation_token AS activation_token_22,
  t10.activation_token_expires_at AS activation_token_expires_at_23,
  t10.email_confirmed_at AS email_confirmed_at_24,
  t10.google_id AS google_id_25,
  t10.firebase_id AS firebase_id_26,
  t10.google_avatar_url AS google_avatar_url_27,
  t10.created_at AS created_at_28,
  t10.updated_at AS updated_at_29
FROM
  tokens t0
  INNER JOIN users t10 ON t0.user_id = t10.id
WHERE
  t0.token_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token_key AS token_key_2, t0.refresh_token_key AS refresh_token_key_3, t0.expires_at AS expires_at_4, t0.refresh_expires_at AS refresh_expires_at_5, t0.last_active_date AS last_active_date_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.email AS email_12, t10.password AS password_13, t10.first_name AS first_name_14, t10.last_name AS last_name_15, t10.gender AS gender_16, t10.phone_number AS phone_number_17, t10.active AS active_18, t10.login_token AS login_token_19, t10.password_reset_token AS password_reset_token_20, t10.password_reset_token_expires_at AS password_reset_token_expires_at_21, t10.activation_token AS activation_token_22, t10.activation_token_expires_at AS activation_token_expires_at_23, t10.email_confirmed_at AS email_confirmed_at_24, t10.google_id AS google_id_25, t10.firebase_id AS firebase_id_26, t10.google_avatar_url AS google_avatar_url_27, t10.created_at AS created_at_28, t10.updated_at AS updated_at_29 FROM tokens t0 INNER JOIN users t10 ON t0.user_id = t10.id WHERE t0.token_key = '7f0090a73810eeb7e6a07ea699ce84df74c50341e31a3ce68f66ac654871d5e0623047e0311b68fc79998202f1939bb153dc68b7da5b4a6db5a47c8d656a3d7a' LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.domain AS domain_1,
  n0_.content AS content_2,
  n0_.created_at AS created_at_3,
  n0_.updated_at AS updated_at_4,
  u1_.id AS id_5,
  u1_.email AS email_6,
  u1_.password AS password_7,
  u1_.first_name AS first_name_8,
  u1_.last_name AS last_name_9,
  u1_.gender AS gender_10,
  u1_.phone_number AS phone_number_11,
  u1_.active AS active_12,
  u1_.login_token AS login_token_13,
  u1_.password_reset_token AS password_reset_token_14,
  u1_.password_reset_token_expires_at AS password_reset_token_expires_at_15,
  u1_.activation_token AS activation_token_16,
  u1_.activation_token_expires_at AS activation_token_expires_at_17,
  u1_.email_confirmed_at AS email_confirmed_at_18,
  u1_.google_id AS google_id_19,
  u1_.firebase_id AS firebase_id_20,
  u1_.google_avatar_url AS google_avatar_url_21,
  u1_.created_at AS created_at_22,
  u1_.updated_at AS updated_at_23,
  u2_.id AS id_24,
  u2_.email AS email_25,
  u2_.password AS password_26,
  u2_.first_name AS first_name_27,
  u2_.last_name AS last_name_28,
  u2_.gender AS gender_29,
  u2_.phone_number AS phone_number_30,
  u2_.active AS active_31,
  u2_.login_token AS login_token_32,
  u2_.password_reset_token AS password_reset_token_33,
  u2_.password_reset_token_expires_at AS password_reset_token_expires_at_34,
  u2_.activation_token AS activation_token_35,
  u2_.activation_token_expires_at AS activation_token_expires_at_36,
  u2_.email_confirmed_at AS email_confirmed_at_37,
  u2_.google_id AS google_id_38,
  u2_.firebase_id AS firebase_id_39,
  u2_.google_avatar_url AS google_avatar_url_40,
  u2_.created_at AS created_at_41,
  u2_.updated_at AS updated_at_42,
  n0_.type AS type_43,
  n0_.created_by AS created_by_44,
  n0_.updated_by AS updated_by_45,
  p3_.project_id AS project_id_46
FROM
  project_note p3_
  INNER JOIN note n0_ ON p3_.id = n0_.id
  INNER JOIN project p4_ ON p3_.project_id = p4_.id
  LEFT JOIN users u1_ ON n0_.created_by = u1_.id
  LEFT JOIN users u2_ ON n0_.updated_by = u2_.id
WHERE
  n0_.id IN (
    SELECT
      p5_.id
    FROM
      project_note p5_
      INNER JOIN note n6_ ON p5_.id = n6_.id
      INNER JOIN project p7_ ON p5_.project_id = p7_.id
    WHERE
      p7_.id = ?
      AND n6_.domain = ?
  )
ORDER BY
  n0_.created_at DESC
LIMIT
  100

SELECT n0_.id AS id_0, n0_.domain AS domain_1, n0_.content AS content_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.email AS email_6, u1_.password AS password_7, u1_.first_name AS first_name_8, u1_.last_name AS last_name_9, u1_.gender AS gender_10, u1_.phone_number AS phone_number_11, u1_.active AS active_12, u1_.login_token AS login_token_13, u1_.password_reset_token AS password_reset_token_14, u1_.password_reset_token_expires_at AS password_reset_token_expires_at_15, u1_.activation_token AS activation_token_16, u1_.activation_token_expires_at AS activation_token_expires_at_17, u1_.email_confirmed_at AS email_confirmed_at_18, u1_.google_id AS google_id_19, u1_.firebase_id AS firebase_id_20, u1_.google_avatar_url AS google_avatar_url_21, u1_.created_at AS created_at_22, u1_.updated_at AS updated_at_23, u2_.id AS id_24, u2_.email AS email_25, u2_.password AS password_26, u2_.first_name AS first_name_27, u2_.last_name AS last_name_28, u2_.gender AS gender_29, u2_.phone_number AS phone_number_30, u2_.active AS active_31, u2_.login_token AS login_token_32, u2_.password_reset_token AS password_reset_token_33, u2_.password_reset_token_expires_at AS password_reset_token_expires_at_34, u2_.activation_token AS activation_token_35, u2_.activation_token_expires_at AS activation_token_expires_at_36, u2_.email_confirmed_at AS email_confirmed_at_37, u2_.google_id AS google_id_38, u2_.firebase_id AS firebase_id_39, u2_.google_avatar_url AS google_avatar_url_40, u2_.created_at AS created_at_41, u2_.updated_at AS updated_at_42, n0_.type AS type_43, n0_.created_by AS created_by_44, n0_.updated_by AS updated_by_45, p3_.project_id AS project_id_46 FROM project_note p3_ INNER JOIN note n0_ ON p3_.id = n0_.id INNER JOIN project p4_ ON p3_.project_id = p4_.id LEFT JOIN users u1_ ON n0_.created_by = u1_.id LEFT JOIN users u2_ ON n0_.updated_by = u2_.id WHERE n0_.id IN (SELECT p5_.id FROM project_note p5_ INNER JOIN note n6_ ON p5_.id = n6_.id INNER JOIN project p7_ ON p5_.project_id = p7_.id WHERE p7_.id = 4 AND n6_.domain = 'delivery_overall') ORDER BY n0_.created_at DESC LIMIT 100;

SELECT
  p0_.name AS name_0,
  u1_.scope_type AS scope_type_1,
  u1_.scope_id AS scope_id_2,
  u1_.resource_iri AS resource_iri_3
FROM
  permission p0_
  INNER JOIN user_permission u1_ ON p0_.id = u1_.permission_id
WHERE
  u1_.user_id = ?
  AND p0_.name IN (?, ?, ?)
  AND (
    u1_.scope_type = ?
    OR u1_.resource_iri IS NULL
  )
  AND (
    u1_.scope_id = ?
    OR u1_.resource_iri IS NULL
  )
GROUP BY
  p0_.id,
  u1_.resource_iri
ORDER BY
  u1_.resource_iri ASC

SELECT p0_.name AS name_0, u1_.scope_type AS scope_type_1, u1_.scope_id AS scope_id_2, u1_.resource_iri AS resource_iri_3 FROM permission p0_ INNER JOIN user_permission u1_ ON p0_.id = u1_.permission_id WHERE u1_.user_id = 38 AND p0_.name IN ('project:read', 'project:update', ':') AND (u1_.scope_type = 'project' OR u1_.resource_iri IS NULL) AND (u1_.scope_id = 4 OR u1_.resource_iri IS NULL) GROUP BY p0_.id, u1_.resource_iri ORDER BY u1_.resource_iri ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.product_owner AS product_owner_3,
  t0.type AS type_4,
  t0.status AS status_5,
  t0.start_date AS start_date_6,
  t0.initial_end_date AS initial_end_date_7,
  t0.actual_end_date AS actual_end_date_8,
  t0.go_live_date AS go_live_date_9,
  t0.vertical AS vertical_10,
  t0.calibration AS calibration_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.project_manager_id AS project_manager_id_14,
  t0.engineering_lead_id AS engineering_lead_id_15,
  t0.head_id AS head_id_16,
  t0.director_id AS director_id_17,
  t18.id AS id_19,
  t18.minutes_per_man_day AS minutes_per_man_day_20,
  t18.project_id AS project_id_21,
  t0.created_by AS created_by_22,
  t23.id AS id_24,
  t23.email AS email_25,
  t23.password AS password_26,
  t23.first_name AS first_name_27,
  t23.last_name AS last_name_28,
  t23.gender AS gender_29,
  t23.phone_number AS phone_number_30,
  t23.active AS active_31,
  t23.login_token AS login_token_32,
  t23.password_reset_token AS password_reset_token_33,
  t23.password_reset_token_expires_at AS password_reset_token_expires_at_34,
  t23.activation_token AS activation_token_35,
  t23.activation_token_expires_at AS activation_token_expires_at_36,
  t23.email_confirmed_at AS email_confirmed_at_37,
  t23.google_id AS google_id_38,
  t23.firebase_id AS firebase_id_39,
  t23.google_avatar_url AS google_avatar_url_40,
  t23.created_at AS created_at_41,
  t23.updated_at AS updated_at_42,
  t0.updated_by AS updated_by_43,
  t44.id AS id_45,
  t44.email AS email_46,
  t44.password AS password_47,
  t44.first_name AS first_name_48,
  t44.last_name AS last_name_49,
  t44.gender AS gender_50,
  t44.phone_number AS phone_number_51,
  t44.active AS active_52,
  t44.login_token AS login_token_53,
  t44.password_reset_token AS password_reset_token_54,
  t44.password_reset_token_expires_at AS password_reset_token_expires_at_55,
  t44.activation_token AS activation_token_56,
  t44.activation_token_expires_at AS activation_token_expires_at_57,
  t44.email_confirmed_at AS email_confirmed_at_58,
  t44.google_id AS google_id_59,
  t44.firebase_id AS firebase_id_60,
  t44.google_avatar_url AS google_avatar_url_61,
  t44.created_at AS created_at_62,
  t44.updated_at AS updated_at_63
FROM
  project t0
  LEFT JOIN project_settings t18 ON t18.project_id = t0.id
  LEFT JOIN users t23 ON t0.created_by = t23.id
  LEFT JOIN users t44 ON t0.updated_by = t44.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.product_owner AS product_owner_3, t0.type AS type_4, t0.status AS status_5, t0.start_date AS start_date_6, t0.initial_end_date AS initial_end_date_7, t0.actual_end_date AS actual_end_date_8, t0.go_live_date AS go_live_date_9, t0.vertical AS vertical_10, t0.calibration AS calibration_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.project_manager_id AS project_manager_id_14, t0.engineering_lead_id AS engineering_lead_id_15, t0.head_id AS head_id_16, t0.director_id AS director_id_17, t18.id AS id_19, t18.minutes_per_man_day AS minutes_per_man_day_20, t18.project_id AS project_id_21, t0.created_by AS created_by_22, t23.id AS id_24, t23.email AS email_25, t23.password AS password_26, t23.first_name AS first_name_27, t23.last_name AS last_name_28, t23.gender AS gender_29, t23.phone_number AS phone_number_30, t23.active AS active_31, t23.login_token AS login_token_32, t23.password_reset_token AS password_reset_token_33, t23.password_reset_token_expires_at AS password_reset_token_expires_at_34, t23.activation_token AS activation_token_35, t23.activation_token_expires_at AS activation_token_expires_at_36, t23.email_confirmed_at AS email_confirmed_at_37, t23.google_id AS google_id_38, t23.firebase_id AS firebase_id_39, t23.google_avatar_url AS google_avatar_url_40, t23.created_at AS created_at_41, t23.updated_at AS updated_at_42, t0.updated_by AS updated_by_43, t44.id AS id_45, t44.email AS email_46, t44.password AS password_47, t44.first_name AS first_name_48, t44.last_name AS last_name_49, t44.gender AS gender_50, t44.phone_number AS phone_number_51, t44.active AS active_52, t44.login_token AS login_token_53, t44.password_reset_token AS password_reset_token_54, t44.password_reset_token_expires_at AS password_reset_token_expires_at_55, t44.activation_token AS activation_token_56, t44.activation_token_expires_at AS activation_token_expires_at_57, t44.email_confirmed_at AS email_confirmed_at_58, t44.google_id AS google_id_59, t44.firebase_id AS firebase_id_60, t44.google_avatar_url AS google_avatar_url_61, t44.created_at AS created_at_62, t44.updated_at AS updated_at_63 FROM project t0 LEFT JOIN project_settings t18 ON t18.project_id = t0.id LEFT JOIN users t23 ON t0.created_by = t23.id LEFT JOIN users t44 ON t0.updated_by = t44.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 38;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  project_note p1_
  INNER JOIN note n0_ ON p1_.id = n0_.id
  INNER JOIN project p2_ ON p1_.project_id = p2_.id
  LEFT JOIN users u3_ ON n0_.created_by = u3_.id
  LEFT JOIN users u4_ ON n0_.updated_by = u4_.id
WHERE
  n0_.id IN (
    SELECT
      p5_.id
    FROM
      project_note p5_
      INNER JOIN note n6_ ON p5_.id = n6_.id
      INNER JOIN project p7_ ON p5_.project_id = p7_.id
    WHERE
      p7_.id = ?
      AND n6_.domain = ?
  )

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM project_note p1_ INNER JOIN note n0_ ON p1_.id = n0_.id INNER JOIN project p2_ ON p1_.project_id = p2_.id LEFT JOIN users u3_ ON n0_.created_by = u3_.id LEFT JOIN users u4_ ON n0_.updated_by = u4_.id WHERE n0_.id IN (SELECT p5_.id FROM project_note p5_ INNER JOIN note n6_ ON p5_.id = n6_.id INNER JOIN project p7_ ON p5_.project_id = p7_.id WHERE p7_.id = 4 AND n6_.domain = 'delivery_overall');

SELECT
  p0_.name AS name_0,
  NULLIF(1, 1) AS sclr_1,
  NULLIF(1, 1) AS sclr_2,
  NULLIF(1, 1) AS sclr_3
FROM
  permission p0_
  INNER JOIN role_permission r2_ ON p0_.id = r2_.permission_id
  INNER JOIN role r1_ ON r1_.id = r2_.role_id
  INNER JOIN user_role u4_ ON r1_.id = u4_.role_id
  INNER JOIN users u3_ ON u3_.id = u4_.user_id
WHERE
  u3_.id = ?
  AND p0_.name IN (?, ?, ?)

SELECT p0_.name AS name_0, NULLIF(1, 1) AS sclr_1, NULLIF(1, 1) AS sclr_2, NULLIF(1, 1) AS sclr_3 FROM permission p0_ INNER JOIN role_permission r2_ ON p0_.id = r2_.permission_id INNER JOIN role r1_ ON r1_.id = r2_.role_id INNER JOIN user_role u4_ ON r1_.id = u4_.role_id INNER JOIN users u3_ ON u3_.id = u4_.user_id WHERE u3_.id = 38 AND p0_.name IN ('project:read', 'project:update', ':');

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.gender AS gender_6,
  t0.phone_number AS phone_number_7,
  t0.active AS active_8,
  t0.login_token AS login_token_9,
  t0.password_reset_token AS password_reset_token_10,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_expires_at AS activation_token_expires_at_13,
  t0.email_confirmed_at AS email_confirmed_at_14,
  t0.google_id AS google_id_15,
  t0.firebase_id AS firebase_id_16,
  t0.google_avatar_url AS google_avatar_url_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.gender AS gender_6, t0.phone_number AS phone_number_7, t0.active AS active_8, t0.login_token AS login_token_9, t0.password_reset_token AS password_reset_token_10, t0.password_reset_token_expires_at AS password_reset_token_expires_at_11, t0.activation_token AS activation_token_12, t0.activation_token_expires_at AS activation_token_expires_at_13, t0.email_confirmed_at AS email_confirmed_at_14, t0.google_id AS google_id_15, t0.firebase_id AS firebase_id_16, t0.google_avatar_url AS google_avatar_url_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM users t0 WHERE t0.email = 'tomislav.levak@q.agency' LIMIT 1;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";