Symfony Profiler

[
  "route" => "app_allsejours"
  "route_parameters" => [
    "_route" => "app_allsejours"
    "_controller" => "App\Controller\AllsejoursController::index"
  ]
  "request_uri" => "https://newarcanciane.devsoft-pro.com/tous-les-sejours"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppAuthenticator"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\MaintenanceSubscriber::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"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u633188633_arcanciane"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u633188633_arcanciane"
    "serverVersion" => "mariadb-10.4.27"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.Metatitle AS Metatitle_19, t0.Metadescription AS Metadescription_20, t0.Metakeywords AS Metakeywords_21, t0.lienaafficher AS lienaafficher_22, t0.EstVisible AS EstVisible_23, t0.DateCreation AS DateCreation_24, t0.DateModification AS DateModification_25, t0.IDRegion AS IDRegion_26, t0.IDTheme AS IDTheme_27, t0.IDCategorieOffre AS IDCategorieOffre_28, t0.IDHebergement AS IDHebergement_29, t0.IDTypeFormule AS IDTypeFormule_30, t0.IDTypePrestation AS IDTypePrestation_31, t0.IDTypeEtatsejour AS IDTypeEtatsejour_32, t0.IDTypeLogement AS IDTypeLogement_33 FROM Sejour t0 WHERE t0.EstVisible = ? ORDER BY t0.NomSejour ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0"
]

[
  "sql" => "SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0"
]

[
  "sql" => "SELECT t0.IDBanner AS IDBanner_1, t0.ImageBanner AS ImageBanner_2, t0.TitreBanner AS TitreBanner_3, t0.SoustitreBanner AS SoustitreBanner_4, t0.Libelle AS Libelle_5, t0.AltImageBanner AS AltImageBanner_6 FROM Banner t0 WHERE t0.Libelle = ? LIMIT 1"
  "params" => [
    1 => "allsejours"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1, s0_.DescriptionCourte AS DescriptionCourte_2, s0_.Ville AS Ville_3, s0_.CP AS CP_4, s0_.DescriptionLongue AS DescriptionLongue_5, s0_.DescriptionRegion AS DescriptionRegion_6, s0_.ConseilsVisites AS ConseilsVisites_7, s0_.DureeSejour AS DureeSejour_8, s0_.NbreJour AS NbreJour_9, s0_.NbreNuit AS NbreNuit_10, s0_.motCle AS motCle_11, s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12, s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13, s0_.EstNouveaute AS EstNouveaute_14, s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15, s0_.TarifSejour AS TarifSejour_16, s0_.NoteGenerale AS NoteGenerale_17, s0_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour WHERE s0_.EstVisible = ? GROUP BY s0_.IDSejour, s0_.NomSejour, s0_.DescriptionCourte, s0_.Ville, s0_.CP, s0_.DescriptionLongue, s0_.DescriptionRegion, s0_.ConseilsVisites, s0_.DureeSejour, s0_.NbreJour, s0_.NbreNuit, s0_.motCle, s0_.EstCoupDeCoeur, s0_.RangCoupDeCoeur, s0_.EstNouveaute, s0_.ImageMiseEnAvant, s0_.TarifSejour, s0_.NoteGenerale, s0_.Metatitle, s0_.Metadescription, s0_.Metakeywords, s0_.lienaafficher, s0_.EstVisible, s0_.DateCreation, s0_.DateModification, s0_.IDRegion, s0_.IDTheme, s0_.IDCategorieOffre, s0_.IDHebergement, s0_.IDTypeFormule, s0_.IDTypePrestation, s0_.IDTypeEtatsejour, s0_.IDTypeLogement ORDER BY s0_.NomSejour ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT t0.IDTypeFormule AS IDTypeFormule_1, t0.NomTypeFormule AS NomTypeFormule_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.EstActif AS EstActif_4 FROM Catalogue t0 WHERE t0.IDTypeFormule = ?"
  "params" => [
    1 => "9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDTypeLogement AS IDTypeLogement_1, t0.LibelleTypeLogement AS LibelleTypeLogement_2 FROM TypeLogement t0 WHERE t0.IDTypeLogement = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDTypePrestation AS IDTypePrestation_1, t0.LibellePrestation AS LibellePrestation_2 FROM TypePrestation t0 WHERE t0.IDTypePrestation = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = ? ORDER BY t0.DatDebut DESC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDTypeFormule AS IDTypeFormule_1, t0.NomTypeFormule AS NomTypeFormule_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.EstActif AS EstActif_4 FROM Catalogue t0 WHERE t0.IDTypeFormule = ?"
  "params" => [
    1 => "14"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDTypeLogement AS IDTypeLogement_1, t0.LibelleTypeLogement AS LibelleTypeLogement_2 FROM TypeLogement t0 WHERE t0.IDTypeLogement = ?"
  "params" => [
    1 => "4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDTypePrestation AS IDTypePrestation_1, t0.LibellePrestation AS LibellePrestation_2 FROM TypePrestation t0 WHERE t0.IDTypePrestation = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = ? ORDER BY t0.DatDebut DESC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = ? ORDER BY t0.DatDebut DESC"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDPagePublique AS IDPagePublique_1, t0.NomPage AS NomPage_2, t0.TitrePage AS TitrePage_3, t0.ContenuPage AS ContenuPage_4, t0.Metatitle AS Metatitle_5, t0.Metadescription AS Metadescription_6, t0.Metakeywords AS Metakeywords_7, t0.EstActif AS EstActif_8, t0.EstBlog AS EstBlog_9, t0.ImageMiseEnAvant AS ImageMiseEnAvant_10, t0.LienPageAfficher AS LienPageAfficher_11, t0.LibelleBanner AS LibelleBanner_12 FROM PagePublique t0 WHERE t0.LienPageAfficher = ? LIMIT 1"
  "params" => [
    1 => "faq"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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\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\Security\Http\RememberMe\ResponseListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]