Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "use_savepoints" => true
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u363484990_iut_udc"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))"
    ]
    "defaultTableOptions" => []
    "dbname" => "u363484990_iut_data"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain"
]

[
  "sql" => "SELECT redirect.id FROM kuma_redirects redirect WHERE (? LIKE REPLACE(redirect.origin, '*', '%')) AND ((redirect.domain IS NULL) OR (redirect.domain = '') OR (redirect.domain = ?))"
  "params" => [
    1 => "/liut/formations/formation-1"
    2 => "iut-udc.online"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT k0_.lang AS lang_0, k0_.online AS online_1, k0_.title AS title_2, k0_.slug AS slug_3, k0_.url AS url_4, k0_.weight AS weight_5, k0_.created AS created_6, k0_.updated AS updated_7, k0_.id AS id_8, k1_.type AS type_9, k1_.owner AS owner_10, k1_.created AS created_11, k1_.updated AS updated_12, k1_.ref_id AS ref_id_13, k1_.ref_entity_name AS ref_entity_name_14, k1_.id AS id_15, k0_.node_id AS node_id_16, k0_.public_node_version_id AS public_node_version_id_17, k1_.node_translation_id AS node_translation_id_18, k1_.origin_id AS origin_id_19 FROM kuma_node_translations k0_ INNER JOIN kuma_nodes k2_ ON k0_.node_id = k2_.id AND (k0_.node_id = k2_.id) LEFT JOIN kuma_node_versions k1_ ON k0_.public_node_version_id = k1_.id AND (k0_.public_node_version_id = k1_.id) WHERE k2_.deleted = ? AND k0_.lang = ? AND k0_.url = ? ORDER BY k0_.online DESC LIMIT 1"
  "params" => [
    1 => 0
    2 => "fr"
    3 => "liut/formations/formation-1"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
  ]
]

[
  "route" => "_slug"
  "route_parameters" => [
    "_controller" => "Kunstmaan\NodeBundle\Controller\SlugController::slugAction"
    "preview" => false
    "url" => "liut/formations/formation-1"
    "_locale" => "fr"
    "_route" => "_slug"
    "_nodeTranslation" => Kunstmaan\NodeBundle\Entity\NodeTranslation {#975
      #id: "21"
      #node: Proxies\__CG__\Kunstmaan\NodeBundle\Entity\Node {#878 …}
      #lang: "fr"
      #online: true
      #title: "Formation 1"
      #slug: "formation-1"
      #url: "liut/formations/formation-1"
      #publicNodeVersion: Kunstmaan\NodeBundle\Entity\NodeVersion {#838 …}
      #nodeVersions: Doctrine\ORM\PersistentCollection {#856 …}
      #weight: 1
      #created: DateTime @1737532619 {#864
        date: 2025-01-22 07:56:59.0 UTC (+00:00)
      }
      #updated: DateTime @1737532702 {#786
        date: 2025-01-22 07:58:22.0 UTC (+00:00)
      }
    }
  ]
  "request_uri" => "https://iut-udc.online/liut/formations/formation-1"
  "method" => "GET"
]

[
  "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\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.request"
  "listener" => "Kunstmaan\AdminBundle\EventListener\AdminLocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Kunstmaan\AdminBundle\EventListener\PasswordCheckListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Kunstmaan\AdminBundle\EventListener\SessionSecurityListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "FOS\HttpCacheBundle\EventListener\Php8AttributesListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Stof\DoctrineExtensionsBundle\EventListener\LocaleListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.admission AS admission_1, t0.programme AS programme_2, t0.debouche AS debouche_3, t0.date AS date_4, t0.summary AS summary_5, t0.title AS title_6, t0.page_title AS page_title_7, t0.id AS id_8 FROM app_formations_pages t0 WHERE t0.id = ?"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kunstmaan_node.slug.security"
  "listener" => "Kunstmaan\NodeBundle\EventListener\SlugSecurityListener::onSlugSecurityEvent"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => "SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.deleted AS deleted_4, t0.hidden_from_nav AS hidden_from_nav_5, t0.ref_entity_name AS ref_entity_name_6, t0.internal_name AS internal_name_7, t0.id AS id_8, t0.parent_id AS parent_id_9 FROM kuma_nodes t0 WHERE t0.id = ?"
  "params" => [
    1 => "21"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ INNER JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = ? AND (k0_.lft <= 36 AND k0_.rgt >= 37) ORDER BY k0_.lft ASC"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_author AS meta_author_3, t0.meta_robots AS meta_robots_4, t0.og_type AS og_type_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.extra_metadata AS extra_metadata_8, t0.ref_id AS ref_id_9, t0.ref_entity_name AS ref_entity_name_10, t0.og_url AS og_url_11, t0.og_article_author AS og_article_author_12, t0.og_article_publisher AS og_article_publisher_13, t0.og_article_section AS og_article_section_14, t0.twitter_title AS twitter_title_15, t0.twitter_description AS twitter_description_16, t0.twitter_site AS twitter_site_17, t0.twitter_creator AS twitter_creator_18, t0.id AS id_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM kuma_seo t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1"
  "params" => [
    1 => "3"
    2 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = ?) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = ? AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC"
  "params" => [
    1 => "fr"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ INNER JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = ? AND (k0_.lft <= 36 AND k0_.rgt >= 37) ORDER BY k0_.lft ASC"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.page_id AS page_id_1, t0.page_entity_name AS page_entity_name_2, t0.page_template AS page_template_3, t0.id AS id_4 FROM kuma_page_template_configuration t0 WHERE t0.page_id = ? AND t0.page_entity_name = ? LIMIT 1"
  "params" => [
    1 => "3"
    2 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT a0_.admission AS admission_0, a0_.programme AS programme_1, a0_.debouche AS debouche_2, a0_.date AS date_3, a0_.summary AS summary_4, a0_.title AS title_5, a0_.page_title AS page_title_6, a0_.id AS id_7 FROM app_formations_pages a0_ INNER JOIN kuma_node_versions k1_ ON (a0_.id = k1_.ref_id) INNER JOIN kuma_node_translations k2_ ON (k2_.public_node_version_id = k1_.id) INNER JOIN kuma_nodes k3_ ON (k2_.node_id = k3_.id) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = ? ORDER BY a0_.date DESC"
  "params" => [
    1 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.type AS type_1, t0.owner AS owner_2, t0.created AS created_3, t0.updated AS updated_4, t0.ref_id AS ref_id_5, t0.ref_entity_name AS ref_entity_name_6, t0.id AS id_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1"
  "params" => [
    1 => "6"
    2 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.type AS type_1, t0.owner AS owner_2, t0.created AS created_3, t0.updated AS updated_4, t0.ref_id AS ref_id_5, t0.ref_entity_name AS ref_entity_name_6, t0.id AS id_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1"
  "params" => [
    1 => "4"
    2 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.type AS type_1, t0.owner AS owner_2, t0.created AS created_3, t0.updated AS updated_4, t0.ref_id AS ref_id_5, t0.ref_entity_name AS ref_entity_name_6, t0.id AS id_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1"
  "params" => [
    1 => "3"
    2 => "App\Entity\Pages\FormationsPage"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.pageId AS pageId_2, t0.pageEntityname AS pageEntityname_3, t0.context AS context_4, t0.sequencenumber AS sequencenumber_5, t0.page_part_id AS page_part_id_6, t0.page_part_entityname AS page_part_entityname_7, t0.created AS created_8, t0.updated AS updated_9 FROM kuma_page_part_refs t0 WHERE t0.pageId = ? AND t0.pageEntityname = ? AND t0.context = ? ORDER BY t0.sequencenumber ASC"
  "params" => [
    1 => "3"
    2 => "App\Entity\Pages\FormationsPage"
    3 => "main"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "event" => "kernel.view"
  "listener" => "Kunstmaan\NodeBundle\EventListener\RenderContextListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView"
]

[
  "event" => "kernel.response"
  "listener" => "FOS\HttpCacheBundle\EventListener\CacheControlListener::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" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SurrogateListener::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\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Kunstmaan\NodeBundle\EventListener\FixDateListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Kunstmaan\AdminBundle\EventListener\ToolbarListener::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" => "Kunstmaan\AdminBundle\EventListener\SessionSecurityListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "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"
]