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

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

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

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

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

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
  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.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
  t0.id AS id_1,
  t0.story_points AS story_points_2,
  t0.min_minutes AS min_minutes_3,
  t0.max_minutes AS max_minutes_4,
  t0.project_settings_id AS project_settings_id_5
FROM
  story_point_mapping t0
WHERE
  t0.project_settings_id = ?
ORDER BY
  t0.story_points ASC

SELECT t0.id AS id_1, t0.story_points AS story_points_2, t0.min_minutes AS min_minutes_3, t0.max_minutes AS max_minutes_4, t0.project_settings_id AS project_settings_id_5 FROM story_point_mapping t0 WHERE t0.project_settings_id = 1 ORDER BY t0.story_points ASC;