Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.error AS error_3,
  t0.note AS note_4,
  t0.date_created AS date_created_5,
  t0.media_type AS media_type_6,
  t0.media_url AS media_url_7,
  t0.media_original_name AS media_original_name_8,
  t0.form_field_id AS form_field_id_9,
  t0.lang_id AS lang_id_10
FROM
  forms_fields_i18n t0
WHERE
  t0.form_field_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.error AS error_3, t0.note AS note_4, t0.date_created AS date_created_5, t0.media_type AS media_type_6, t0.media_url AS media_url_7, t0.media_original_name AS media_original_name_8, t0.form_field_id AS form_field_id_9, t0.lang_id AS lang_id_10 FROM forms_fields_i18n t0 WHERE t0.form_field_id = 830 AND t0.lang_id = 2 LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  f0_.id AS id_0,
  f0_.meta_key AS meta_key_1,
  f0_.type AS type_2,
  f0_.group_key AS group_key_3,
  f1_.label AS label_4,
  (s2_.title) AS sclr_5,
  p3_.title AS title_6
FROM
  forms_fields f0_
  INNER JOIN scenes_roles_forms s4_ ON (s4_.form_field_id = f0_.id)
  INNER JOIN scenes_roles s2_ ON (s4_.scene_role_id = s2_.id)
  INNER JOIN scenes s5_ ON (s5_.id = s2_.scene_id)
  INNER JOIN projects p3_ ON (p3_.id = s5_.project_id)
  INNER JOIN forms_fields_i18n f1_ ON (f1_.form_field_id = f0_.id)
  INNER JOIN lang l6_ ON (l6_.id = f1_.lang_id)
WHERE
  p3_.id = ?
  AND f0_.group_key NOT LIKE '%role.comment%'
  AND l6_.id = ?
  AND f0_.meta_key NOT IN (
    'birthday_check', 'privacy_check'
  )
GROUP BY
  f0_.meta_key
ORDER BY
  f0_.sort ASC

SELECT f0_.id AS id_0, f0_.meta_key AS meta_key_1, f0_.type AS type_2, f0_.group_key AS group_key_3, f1_.label AS label_4, (s2_.title) AS sclr_5, p3_.title AS title_6 FROM forms_fields f0_ INNER JOIN scenes_roles_forms s4_ ON (s4_.form_field_id = f0_.id) INNER JOIN scenes_roles s2_ ON (s4_.scene_role_id = s2_.id) INNER JOIN scenes s5_ ON (s5_.id = s2_.scene_id) INNER JOIN projects p3_ ON (p3_.id = s5_.project_id) INNER JOIN forms_fields_i18n f1_ ON (f1_.form_field_id = f0_.id) INNER JOIN lang l6_ ON (l6_.id = f1_.lang_id) WHERE p3_.id = '95' AND f0_.group_key NOT LIKE '%role.comment%' AND l6_.id = 2 AND f0_.meta_key NOT IN ('birthday_check', 'privacy_check') GROUP BY f0_.meta_key ORDER BY f0_.sort ASC;

SELECT
  s0_.id AS id_0,
  s0_.required AS required_1,
  s0_.example_file AS example_file_2,
  s0_.date_created AS date_created_3,
  s0_.hash AS hash_4,
  s0_.status AS status_5,
  s0_.sort AS sort_6,
  s1_.id AS id_7,
  s1_.title AS title_8,
  s1_.description AS description_9,
  s1_.status AS status_10,
  s1_.image_reference_file AS image_reference_file_11,
  s1_.image_reference_original_name AS image_reference_original_name_12,
  s1_.date_created AS date_created_13,
  s2_.id AS id_14,
  s2_.name AS name_15,
  s2_.date_created AS date_created_16,
  p3_.id AS id_17,
  p3_.title AS title_18,
  p3_.hash AS hash_19,
  p3_.subtitle AS subtitle_20,
  p3_.logo_brand AS logo_brand_21,
  p3_.logo_production AS logo_production_22,
  p3_.date_created AS date_created_23,
  p3_.status AS status_24,
  p3_.grid AS grid_25,
  p3_.grid_viewer AS grid_viewer_26,
  p3_.image_compression AS image_compression_27,
  p3_.video_compression AS video_compression_28,
  p3_.reference_file_1 AS reference_file_1_29,
  p3_.reference_file_2 AS reference_file_2_30,
  f4_.id AS id_31,
  f4_.meta_key AS meta_key_32,
  f4_.size_col AS size_col_33,
  f4_.type AS type_34,
  f4_.sort AS sort_35,
  f4_.group_key AS group_key_36,
  f4_.searchable AS searchable_37,
  f4_.date_created AS date_created_38,
  f4_.default_checked AS default_checked_39,
  f4_.keyword AS keyword_40,
  f4_.reference AS reference_41,
  f4_.allow_note AS allow_note_42,
  f4_.allow_media AS allow_media_43,
  f4_.media_types AS media_types_44,
  s0_.scene_role_id AS scene_role_id_45,
  s0_.form_field_id AS form_field_id_46,
  s0_.parent_option_id AS parent_option_id_47,
  s1_.scene_id AS scene_id_48,
  s2_.project_id AS project_id_49,
  p3_.headquarter_id AS headquarter_id_50,
  p3_.project_type_id AS project_type_id_51,
  f4_.generic_question_id AS generic_question_id_52
FROM
  scenes_roles_forms s0_
  INNER JOIN scenes_roles s1_ ON s0_.scene_role_id = s1_.id
  INNER JOIN scenes s2_ ON s1_.scene_id = s2_.id
  INNER JOIN projects p3_ ON s2_.project_id = p3_.id
  INNER JOIN forms_fields f4_ ON s0_.form_field_id = f4_.id
WHERE
  p3_.id = ?
  AND s0_.status = 1
  AND s0_.parent_option_id IS NULL
  AND f4_.group_key IN (?, ?)
  AND f4_.group_key <> ?
  AND f4_.type <> ?
ORDER BY
  s1_.id ASC,
  s0_.sort ASC

SELECT s0_.id AS id_0, s0_.required AS required_1, s0_.example_file AS example_file_2, s0_.date_created AS date_created_3, s0_.hash AS hash_4, s0_.status AS status_5, s0_.sort AS sort_6, s1_.id AS id_7, s1_.title AS title_8, s1_.description AS description_9, s1_.status AS status_10, s1_.image_reference_file AS image_reference_file_11, s1_.image_reference_original_name AS image_reference_original_name_12, s1_.date_created AS date_created_13, s2_.id AS id_14, s2_.name AS name_15, s2_.date_created AS date_created_16, p3_.id AS id_17, p3_.title AS title_18, p3_.hash AS hash_19, p3_.subtitle AS subtitle_20, p3_.logo_brand AS logo_brand_21, p3_.logo_production AS logo_production_22, p3_.date_created AS date_created_23, p3_.status AS status_24, p3_.grid AS grid_25, p3_.grid_viewer AS grid_viewer_26, p3_.image_compression AS image_compression_27, p3_.video_compression AS video_compression_28, p3_.reference_file_1 AS reference_file_1_29, p3_.reference_file_2 AS reference_file_2_30, f4_.id AS id_31, f4_.meta_key AS meta_key_32, f4_.size_col AS size_col_33, f4_.type AS type_34, f4_.sort AS sort_35, f4_.group_key AS group_key_36, f4_.searchable AS searchable_37, f4_.date_created AS date_created_38, f4_.default_checked AS default_checked_39, f4_.keyword AS keyword_40, f4_.reference AS reference_41, f4_.allow_note AS allow_note_42, f4_.allow_media AS allow_media_43, f4_.media_types AS media_types_44, s0_.scene_role_id AS scene_role_id_45, s0_.form_field_id AS form_field_id_46, s0_.parent_option_id AS parent_option_id_47, s1_.scene_id AS scene_id_48, s2_.project_id AS project_id_49, p3_.headquarter_id AS headquarter_id_50, p3_.project_type_id AS project_type_id_51, f4_.generic_question_id AS generic_question_id_52 FROM scenes_roles_forms s0_ INNER JOIN scenes_roles s1_ ON s0_.scene_role_id = s1_.id INNER JOIN scenes s2_ ON s1_.scene_id = s2_.id INNER JOIN projects p3_ ON s2_.project_id = p3_.id INNER JOIN forms_fields f4_ ON s0_.form_field_id = f4_.id WHERE p3_.id = 95 AND s0_.status = 1 AND s0_.parent_option_id IS NULL AND f4_.group_key IN ('form.group.role', 'form.group.media.role') AND f4_.group_key <> 'form.group.role.comment' AND f4_.type <> 8 ORDER BY s1_.id ASC, s0_.sort ASC;

SELECT
  p.`title` AS projectTitle,
  s.`name` AS sceneTitle,
  sr.`title` AS roleTitle,
  u.`email`,
  u.`id` AS userId,
  usrfs.`status`
FROM
  users_scenes_roles_forms_status usrfs
  INNER JOIN users_scenes_roles_forms usrf ON usrf.id = usrfs.user_scene_role_form_id
  INNER JOIN scenes_roles sr ON sr.id = usrf.scene_role_id
  INNER JOIN scenes s ON s.id = sr.scene_id
  INNER JOIN projects p ON p.id = s.project_id
  INNER JOIN users_forms_fields uff ON usrf.user_id = uff.user_id
  INNER JOIN (
    SELECT
      ff.id AS form_field_id,
      ff.meta_key,
      uff.user_id,
      uff.value
    FROM
      forms_fields ff
      INNER JOIN users_forms_fields uff ON ff.id = uff.form_field_id
    WHERE
      ff.meta_key IN ('')
    GROUP BY
      ff.id,
      ff.meta_key,
      uff.user_id,
      uff.value
  ) AS meta ON meta.form_field_id = uff.form_field_id
  AND meta.user_id = uff.user_id
  INNER JOIN users u ON u.id = usrf.user_id
WHERE
  p.id = 95
  AND usrfs.status = 1
  AND usrfs.`level` = 4
GROUP BY
  usrfs.user_scene_role_form_id;

SELECT 
            p.`title` AS projectTitle,
            s.`name` AS sceneTitle,
            sr.`title` AS roleTitle,
            u.`email`,
            u.`id` AS userId,
            usrfs.`status`
            
        FROM 
            users_scenes_roles_forms_status usrfs
        INNER JOIN 
            users_scenes_roles_forms usrf ON usrf.id = usrfs.user_scene_role_form_id
        INNER JOIN 
            scenes_roles sr ON sr.id = usrf.scene_role_id
        INNER JOIN 
            scenes s ON s.id = sr.scene_id
        INNER JOIN 
            projects p ON p.id = s.project_id
        INNER JOIN 
            users_forms_fields uff ON usrf.user_id = uff.user_id 
        INNER JOIN (
            SELECT 
                ff.id AS form_field_id, 
                ff.meta_key, 
                uff.user_id, 
                uff.value
            FROM 
                forms_fields ff
            INNER JOIN 
                users_forms_fields uff ON ff.id = uff.form_field_id
            WHERE 
                ff.meta_key IN ('') 
            GROUP BY 
                ff.id, ff.meta_key, uff.user_id, uff.value
        ) AS meta ON meta.form_field_id = uff.form_field_id AND meta.user_id = uff.user_id
        INNER JOIN 
            users u ON u.id = usrf.user_id 
        WHERE 
            p.id = 95  
             AND usrfs.status = 1 AND usrfs.`level` = 4
        GROUP BY 
            usrfs.user_scene_role_form_id;;

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.roles AS roles_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.date_created AS date_created_7,
  t0.status AS status_8,
  t0.forgot_code AS forgot_code_9,
  t0.forgot_date_expires AS forgot_date_expires_10,
  t0.lang_id AS lang_id_11,
  t0.selected_headquarter AS selected_headquarter_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.roles AS roles_3, t0.email AS email_4, t0.password AS password_5, t0.name AS name_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.forgot_code AS forgot_code_9, t0.forgot_date_expires AS forgot_date_expires_10, t0.lang_id AS lang_id_11, t0.selected_headquarter AS selected_headquarter_12 FROM users t0 WHERE t0.id = 1032;

SELECT
  t0.id AS id_1,
  t0.relation_id AS relation_id_2,
  t0.type AS type_3,
  t0.title AS title_4,
  t0.date_created AS date_created_5,
  t0.sendType AS sendType_6,
  t0.status AS status_7,
  t0.action AS action_8,
  t0.from_user_id AS from_user_id_9,
  t0.to_user_id AS to_user_id_10
FROM
  notifications t0
WHERE
  t0.status = ?
  AND t0.to_user_id = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.type AS type_3, t0.title AS title_4, t0.date_created AS date_created_5, t0.sendType AS sendType_6, t0.status AS status_7, t0.action AS action_8, t0.from_user_id AS from_user_id_9, t0.to_user_id AS to_user_id_10 FROM notifications t0 WHERE t0.status = 0 AND t0.to_user_id = 1032 AND t0.type = 0;

SELECT
  t0.id AS id_1,
  t0.last_interaction_date AS last_interaction_date_2,
  t0.user_id AS user_id_3,
  t0.project_id AS project_id_4
FROM
  user_recent_projects_interactions t0
WHERE
  t0.user_id = ?
  AND t0.project_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_interaction_date AS last_interaction_date_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM user_recent_projects_interactions t0 WHERE t0.user_id = 1032 AND t0.project_id = 95 LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.meta_key AS meta_key_1,
  e0_.role_level AS role_level_2,
  e0_.date_created AS date_created_3,
  e0_.project_id AS project_id_4,
  e0_.config_saved_by AS config_saved_by_5
FROM
  excel_config e0_
  INNER JOIN projects p1_ ON (p1_.id = e0_.project_id)
WHERE
  p1_.id = ?
  AND e0_.role_level >= ?

SELECT e0_.id AS id_0, e0_.meta_key AS meta_key_1, e0_.role_level AS role_level_2, e0_.date_created AS date_created_3, e0_.project_id AS project_id_4, e0_.config_saved_by AS config_saved_by_5 FROM excel_config e0_ INNER JOIN projects p1_ ON (p1_.id = e0_.project_id) WHERE p1_.id = '95' AND e0_.role_level >= 0;

SELECT
  t0.id AS id_1,
  t0.meta_key AS meta_key_2,
  t0.meta_value AS meta_value_3,
  t0.date_created AS date_created_4
FROM
  config t0
WHERE
  t0.meta_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.date_created AS date_created_4 FROM config t0 WHERE t0.meta_key = 'roles' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.hash AS hash_3,
  t0.subtitle AS subtitle_4,
  t0.logo_brand AS logo_brand_5,
  t0.logo_production AS logo_production_6,
  t0.date_created AS date_created_7,
  t0.status AS status_8,
  t0.grid AS grid_9,
  t0.grid_viewer AS grid_viewer_10,
  t0.image_compression AS image_compression_11,
  t0.video_compression AS video_compression_12,
  t0.reference_file_1 AS reference_file_1_13,
  t0.reference_file_2 AS reference_file_2_14,
  t0.headquarter_id AS headquarter_id_15,
  t0.project_type_id AS project_type_id_16
FROM
  projects t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.hash AS hash_3, t0.subtitle AS subtitle_4, t0.logo_brand AS logo_brand_5, t0.logo_production AS logo_production_6, t0.date_created AS date_created_7, t0.status AS status_8, t0.grid AS grid_9, t0.grid_viewer AS grid_viewer_10, t0.image_compression AS image_compression_11, t0.video_compression AS video_compression_12, t0.reference_file_1 AS reference_file_1_13, t0.reference_file_2 AS reference_file_2_14, t0.headquarter_id AS headquarter_id_15, t0.project_type_id AS project_type_id_16 FROM projects t0 WHERE t0.id = '95' LIMIT 1;

UPDATE
  user_recent_projects_interactions
SET
  last_interaction_date = ?
WHERE
  id = ?

UPDATE user_recent_projects_interactions SET last_interaction_date = '2026-04-21 14:33:04' WHERE id = 289;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.default_lang AS default_lang_4
FROM
  lang t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.default_lang AS default_lang_4 FROM lang t0 WHERE t0.id = 2;