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.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
  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);

"START TRANSACTION"

"START TRANSACTION";

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;

"COMMIT"

"COMMIT";

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;

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
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.current_status AS current_status_2,
  d0_.previous_status AS previous_status_3,
  d0_.trend AS trend_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.product_owner AS product_owner_7,
  p1_.type AS type_8,
  p1_.status AS status_9,
  p1_.start_date AS start_date_10,
  p1_.initial_end_date AS initial_end_date_11,
  p1_.actual_end_date AS actual_end_date_12,
  p1_.go_live_date AS go_live_date_13,
  p1_.vertical AS vertical_14,
  p1_.calibration AS calibration_15,
  p1_.created_at AS created_at_16,
  p1_.updated_at AS updated_at_17,
  d0_.project_id AS project_id_18,
  p1_.project_manager_id AS project_manager_id_19,
  p1_.engineering_lead_id AS engineering_lead_id_20,
  p1_.head_id AS head_id_21,
  p1_.director_id AS director_id_22,
  p1_.created_by AS created_by_23,
  p1_.updated_by AS updated_by_24
FROM
  delivery_metric d0_
  INNER JOIN project p1_ ON d0_.project_id = p1_.id
WHERE
  d0_.id IN (
    SELECT
      d2_.id
    FROM
      delivery_metric d2_
      INNER JOIN project p3_ ON d2_.project_id = p3_.id
    WHERE
      p3_.id = ?
  )
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.current_status AS current_status_2, d0_.previous_status AS previous_status_3, d0_.trend AS trend_4, p1_.id AS id_5, p1_.name AS name_6, p1_.product_owner AS product_owner_7, p1_.type AS type_8, p1_.status AS status_9, p1_.start_date AS start_date_10, p1_.initial_end_date AS initial_end_date_11, p1_.actual_end_date AS actual_end_date_12, p1_.go_live_date AS go_live_date_13, p1_.vertical AS vertical_14, p1_.calibration AS calibration_15, p1_.created_at AS created_at_16, p1_.updated_at AS updated_at_17, d0_.project_id AS project_id_18, p1_.project_manager_id AS project_manager_id_19, p1_.engineering_lead_id AS engineering_lead_id_20, p1_.head_id AS head_id_21, p1_.director_id AS director_id_22, p1_.created_by AS created_by_23, p1_.updated_by AS updated_by_24 FROM delivery_metric d0_ INNER JOIN project p1_ ON d0_.project_id = p1_.id WHERE d0_.id IN (SELECT d2_.id FROM delivery_metric d2_ INNER JOIN project p3_ ON d2_.project_id = p3_.id WHERE p3_.id = 4) ORDER BY d0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.minutes_per_man_day AS minutes_per_man_day_2,
  t0.project_id AS project_id_3
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.minutes_per_man_day AS minutes_per_man_day_2, t0.project_id AS project_id_3 FROM project_settings t0 WHERE t0.project_id = 4;

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.id IN (?)

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.id IN (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.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 (1);

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