Symfony Profiler

[
  "route" => "projects_homepage_dev"
  "route_parameters" => [
    "_route" => "projects_homepage_dev"
    "_controller" => "App\Controller\DefaultController::projectsHomepage"
    "subdomaine" => "creai-na"
  ]
  "request_uri" => "https://dev.creai-na.galic.fr/"
  "method" => "GET"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\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"
]

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

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

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

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

[
  "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" => "ContainerHxk1VjS\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "galic"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "galic"
    "serverVersion" => "8.0.42"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.duree_lib AS duree_lib_5, t0.lieu_complement AS lieu_complement_6, t0.nb_plan_b AS nb_plan_b_7, t0.seuil_nb_inscrit AS seuil_nb_inscrit_8, t0.pre_titre AS pre_titre_9, t0.post_titre AS post_titre_10, t0.editorial AS editorial_11, t0.programme AS programme_12, t0.arrive AS arrive_13, t0.has_badge AS has_badge_14, t0.minisite AS minisite_15, t0.domaine AS domaine_16, t0.sub_domaine AS sub_domaine_17, t0.icon AS icon_18, t0.color AS color_19, t0.header_nom AS header_nom_20, t0.annulation_possible AS annulation_possible_21, t0.commentaire_personne_active AS commentaire_personne_active_22, t0.commentaire_personne_help AS commentaire_personne_help_23, t0.badge_complement AS badge_complement_24, t0.montant_non_remboursable AS montant_non_remboursable_25, t0.comment_atelier AS comment_atelier_26, t0.participant_fonction_facultative AS participant_fonction_facultative_27, t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28, t0.nom AS nom_29, t0.description AS description_30, t0.comment_form AS comment_form_31, t0.comment_mail AS comment_mail_32, t0.date_limite_annulation AS date_limite_annulation_33, t0.date_limite_inscription AS date_limite_inscription_34, t0.date_limite_remplacement AS date_limite_remplacement_35, t0.specialite AS specialite_36, t0.actif AS actif_37, t0.nb_heures AS nb_heures_38, t0.code_youtube AS code_youtube_39, t0.montant_annulation AS montant_annulation_40, t0.brochure_nom AS brochure_nom_41, t0.image_nom AS image_nom_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.lieu_id AS lieu_id_45, t0.organisateur_id AS organisateur_id_46, t0.created_by_id AS created_by_id_47, t0.updated_by_id AS updated_by_id_48 FROM evenement t0 WHERE t0.sub_domaine = ? LIMIT 1"
  "params" => [
    1 => "creai-na"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1734
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prefixe AS prefixe_3, t0.sub_domain AS sub_domain_4, t0.adresse AS adresse_5, t0.complement AS complement_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.cedex AS cedex_9, t0.agrement_date AS agrement_date_10, t0.agrement_code AS agrement_code_11, t0.logo_url AS logo_url_12, t0.logo_name AS logo_name_13, t0.siret AS siret_14, t0.ape AS ape_15, t0.dom AS dom_16, t0.bic AS bic_17, t0.iban AS iban_18, t0.rib AS rib_19, t0.tel AS tel_20, t0.site AS site_21, t0.slug AS slug_22, t0.co_orga_only AS co_orga_only_23, t0.masculin AS masculin_24, t0.sans_article AS sans_article_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.username AS username_30, t28.confirmation_token AS confirmation_token_31, t28.password_requested_at AS password_requested_at_32, t28.roles AS roles_33, t28.email AS email_34, t28.email_canonical AS email_canonical_35, t28.enabled AS enabled_36, t28.salt AS salt_37, t28.password AS password_38, t28.last_login AS last_login_39, t28.nom AS nom_40, t28.prenom AS prenom_41, t28.homme AS homme_42, t28.fonction AS fonction_43, t28.signature_name AS signature_name_44, t28.organisateur_id AS organisateur_id_45, t28.dirige_id AS dirige_id_46, t28.gere_id AS gere_id_47, t28.journee_id AS journee_id_48, t28.evenement_id AS evenement_id_49, t50.id AS id_51, t50.username AS username_52, t50.confirmation_token AS confirmation_token_53, t50.password_requested_at AS password_requested_at_54, t50.roles AS roles_55, t50.email AS email_56, t50.email_canonical AS email_canonical_57, t50.enabled AS enabled_58, t50.salt AS salt_59, t50.password AS password_60, t50.last_login AS last_login_61, t50.nom AS nom_62, t50.prenom AS prenom_63, t50.homme AS homme_64, t50.fonction AS fonction_65, t50.signature_name AS signature_name_66, t50.organisateur_id AS organisateur_id_67, t50.dirige_id AS dirige_id_68, t50.gere_id AS gere_id_69, t50.journee_id AS journee_id_70, t50.evenement_id AS evenement_id_71, t0.dpo_id AS dpo_id_72 FROM organisateur t0 LEFT JOIN user t28 ON t28.dirige_id = t0.id LEFT JOIN user t50 ON t50.gere_id = t0.id WHERE t0.sub_domain = ? LIMIT 1"
  "params" => [
    1 => "creai-na"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1734
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.duree_lib AS duree_lib_4, e0_.lieu_complement AS lieu_complement_5, e0_.nb_plan_b AS nb_plan_b_6, e0_.seuil_nb_inscrit AS seuil_nb_inscrit_7, e0_.pre_titre AS pre_titre_8, e0_.post_titre AS post_titre_9, e0_.editorial AS editorial_10, e0_.programme AS programme_11, e0_.arrive AS arrive_12, e0_.has_badge AS has_badge_13, e0_.minisite AS minisite_14, e0_.domaine AS domaine_15, e0_.sub_domaine AS sub_domaine_16, e0_.icon AS icon_17, e0_.color AS color_18, e0_.header_nom AS header_nom_19, e0_.annulation_possible AS annulation_possible_20, e0_.commentaire_personne_active AS commentaire_personne_active_21, e0_.commentaire_personne_help AS commentaire_personne_help_22, e0_.badge_complement AS badge_complement_23, e0_.montant_non_remboursable AS montant_non_remboursable_24, e0_.comment_atelier AS comment_atelier_25, e0_.participant_fonction_facultative AS participant_fonction_facultative_26, e0_.send_email_admin_to_created_by AS send_email_admin_to_created_by_27, e0_.nom AS nom_28, e0_.description AS description_29, e0_.comment_form AS comment_form_30, e0_.comment_mail AS comment_mail_31, e0_.date_limite_annulation AS date_limite_annulation_32, e0_.date_limite_inscription AS date_limite_inscription_33, e0_.date_limite_remplacement AS date_limite_remplacement_34, e0_.specialite AS specialite_35, e0_.actif AS actif_36, e0_.nb_heures AS nb_heures_37, e0_.code_youtube AS code_youtube_38, e0_.montant_annulation AS montant_annulation_39, e0_.brochure_nom AS brochure_nom_40, e0_.image_nom AS image_nom_41, e0_.created_at AS created_at_42, e0_.updated_at AS updated_at_43, e0_.lieu_id AS lieu_id_44, e0_.organisateur_id AS organisateur_id_45, e0_.created_by_id AS created_by_id_46, e0_.updated_by_id AS updated_by_id_47 FROM evenement e0_ INNER JOIN organisateur o1_ ON e0_.organisateur_id = o1_.id LEFT JOIN evenement_coorga e2_ ON e0_.id = e2_.evenement_id LEFT JOIN organisateur o3_ ON e2_.coorga_id = o3_.id WHERE ((o1_.id = 1 OR o3_.id = 1)) AND (e0_.date_fin > CURRENT_DATE AND e0_.actif = 1)"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.Adresse AS Adresse_4, t0.CodePostal AS CodePostal_5, t0.Ville AS Ville_6, t0.email AS email_7, t0.tel AS tel_8, t0.indications AS indications_9, t0.maplink AS maplink_10, t0.image_nom AS image_nom_11, t0.prefixe AS prefixe_12, t0.complement AS complement_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM lieu t0 WHERE t0.id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1736
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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" => "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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