Symfony Profiler

[
  "route" => "config_export_talents_project"
  "route_parameters" => [
    "_route" => "config_export_talents_project"
    "_controller" => "App\Controller\ScenesController::configExportExcelProject"
    "hqName" => "ES"
    "projectId" => "95"
  ]
  "request_uri" => "https://lane.tridenia.es/scenes/ES/95/excel"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "lanecasting.cluster-cdkq0ao4aq0q.eu-west-1.rds.amazonaws.com"
    "port" => 3306
    "user" => "lncstng"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "lanecasting"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1032
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "judith@lane-casting.com"
]

[
  "sql" => "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"
  "params" => [
    1 => "95"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1032
    2 => 95
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "UPDATE user_recent_projects_interactions SET last_interaction_date = ? WHERE id = ?"
  "params" => [
    1 => "2026-04-21 14:33:04"
    2 => 289
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 0
    2 => 1032
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\Middleware\ControllerSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\Middleware\NotificationSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerPif6fxF\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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 >= ?"
  "params" => [
    1 => "95"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

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

[
  "sql" => "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"
  "params" => [
    1 => "roles"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "95"
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 95
    2 => "form.group.role"
    3 => "form.group.media.role"
    4 => "form.group.role.comment"
    5 => 8
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 2
    5 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 830
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 831
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 832
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 987
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 988
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 990
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 991
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 924
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 986
    2 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]