Symfony Profiler

[
  "route" => "fo_stock_thematique"
  "route_parameters" => [
    "_route" => "fo_stock_thematique"
    "thematiqueSlug" => "autos"
    "_controller" => "App\Controller\FO\ListingVNController::listing"
  ]
  "request_uri" => "http://vehicules-neufs.neubauer.fr/stock/autos/?ordre=prix_croissant"
  "method" => "GET"
]

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

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

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

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

[
  "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" => "ContainerOss9ngm\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

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

[
  "params" => [
    "use_savepoints" => true
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "rds-aurora-neubauer-dedie-1-cluster.cluster-cxdsj6gdol0y.eu-west-3.rds.amazonaws.com"
    "port" => 3306
    "user" => "user_neubauerVN"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "neubauer_vn"
    "serverVersion" => "5.7"
  ]
]

[
  "sql" => "SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = ? AND m1_.type = ?"
  "params" => [
    1 => 1
    2 => "auto"
  ]
  "types" => [
    1 => 5
    2 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT v0_.id AS id_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_2, v0_.id AS id_3 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = ? AND m1_.type = ? ORDER BY sclr_1 ASC, sclr_2 ASC, v0_.id DESC LIMIT 20"
  "params" => [
    1 => 1
    2 => "auto"
  ]
  "types" => [
    1 => 5
    2 => 2
  ]
]

[
  "sql" => "SELECT (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, v0_.id AS id_2, v0_.identifiant_vn AS identifiant_vn_3, v0_.numero_chassis AS numero_chassis_4, v0_.modele AS modele_5, v0_.titre AS titre_6, v0_.prix_neuf AS prix_neuf_7, v0_.prix_remise AS prix_remise_8, v0_.kilometrage AS kilometrage_9, v0_.motorisation AS motorisation_10, v0_.cylindree AS cylindree_11, v0_.date_immat AS date_immat_12, v0_.immatriculation AS immatriculation_13, v0_.boite_vitesse AS boite_vitesse_14, v0_.garantie AS garantie_15, v0_.carrosserie AS carrosserie_16, v0_.poids_avide AS poids_avide_17, v0_.transmission AS transmission_18, v0_.emissions_co2 AS emissions_co2_19, v0_.crit_air AS crit_air_20, v0_.puissance_din AS puissance_din_21, v0_.puissance_fiscale AS puissance_fiscale_22, v0_.nb_places AS nb_places_23, v0_.nb_portes AS nb_portes_24, v0_.couleur_exterieure AS couleur_exterieure_25, v0_.sellerie AS sellerie_26, v0_.nb_jours_en_stock AS nb_jours_en_stock_27, v0_.options_et_equipements AS options_et_equipements_28, v0_.visuels AS visuels_29, v0_.commentaire AS commentaire_30, v0_.is_published AS is_published_31, v0_.modifier_backend AS modifier_backend_32, v0_.flux AS flux_33, v0_.is_supprimed AS is_supprimed_34, v0_.create_at AS create_at_35, v0_.update_at AS update_at_36, m1_.id AS id_37, m1_.nom AS nom_38, m1_.type AS type_39, c2_.id AS id_40, c2_.nom AS nom_41, c2_.adresse AS adresse_42, c2_.telephone AS telephone_43, v0_.marque_id AS marque_id_44, v0_.concession_id AS concession_id_45 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = ? AND m1_.type = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_1 ASC, sclr_0 ASC, v0_.id DESC"
  "params" => [
    1 => 1
    2 => "auto"
    3 => 10526
    4 => 11437
    5 => 10525
    6 => 10524
    7 => 11105
    8 => 10529
    9 => 10531
    10 => 10527
    11 => 11177
    12 => 10528
    13 => 10521
    14 => 10668
    15 => 10530
    16 => 10523
    17 => 10532
    18 => 10522
    19 => 9820
    20 => 9711
    21 => 10534
    22 => 10770
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
  ]
]

[
  "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\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.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 m0_.id AS id_0, COUNT(v1_.id) AS sclr_1 FROM vehicule_neuf v1_ LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id WHERE v1_.is_supprimed = 0 AND v1_.is_published = ? GROUP BY m0_.id"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.type = ? ORDER BY m0_.nom ASC"
  "params" => [
    1 => "auto"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.type = ? ORDER BY m0_.nom ASC"
  "params" => [
    1 => "moto"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT (CASE WHEN v0_.prix_remise IS NULL OR v0_.prix_remise = 0 THEN v0_.prix_neuf ELSE v0_.prix_remise END) AS sclr_0, (CASE WHEN (v0_.prix_remise IS NULL AND v0_.prix_neuf IS NULL) THEN 1 ELSE 0 END) AS sclr_1, v0_.id AS id_2, v0_.id AS id_3, v0_.identifiant_vn AS identifiant_vn_4, v0_.numero_chassis AS numero_chassis_5, v0_.modele AS modele_6, v0_.titre AS titre_7, v0_.prix_neuf AS prix_neuf_8, v0_.prix_remise AS prix_remise_9, v0_.kilometrage AS kilometrage_10, v0_.motorisation AS motorisation_11, v0_.cylindree AS cylindree_12, v0_.date_immat AS date_immat_13, v0_.immatriculation AS immatriculation_14, v0_.boite_vitesse AS boite_vitesse_15, v0_.garantie AS garantie_16, v0_.carrosserie AS carrosserie_17, v0_.poids_avide AS poids_avide_18, v0_.transmission AS transmission_19, v0_.emissions_co2 AS emissions_co2_20, v0_.crit_air AS crit_air_21, v0_.puissance_din AS puissance_din_22, v0_.puissance_fiscale AS puissance_fiscale_23, v0_.nb_places AS nb_places_24, v0_.nb_portes AS nb_portes_25, v0_.couleur_exterieure AS couleur_exterieure_26, v0_.sellerie AS sellerie_27, v0_.nb_jours_en_stock AS nb_jours_en_stock_28, v0_.options_et_equipements AS options_et_equipements_29, v0_.visuels AS visuels_30, v0_.commentaire AS commentaire_31, v0_.is_published AS is_published_32, v0_.modifier_backend AS modifier_backend_33, v0_.flux AS flux_34, v0_.is_supprimed AS is_supprimed_35, v0_.create_at AS create_at_36, v0_.update_at AS update_at_37, m1_.id AS id_38, m1_.nom AS nom_39, m1_.type AS type_40, c2_.id AS id_41, c2_.nom AS nom_42, c2_.adresse AS adresse_43, c2_.telephone AS telephone_44 FROM vehicule_neuf v0_ LEFT JOIN marque m1_ ON v0_.marque_id = m1_.id LEFT JOIN concession c2_ ON v0_.concession_id = c2_.id WHERE v0_.is_supprimed = 0 AND v0_.is_published = ? AND m1_.type = ? ORDER BY sclr_1 ASC, sclr_0 ASC, v0_.id DESC"
  "params" => [
    1 => 1
    2 => "auto"
  ]
  "types" => [
    1 => 5
    2 => 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\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"
]