Symfony Profiler

[
  "route" => "fo_search_marque"
  "route_parameters" => [
    "_route" => "fo_search_marque"
    "marqueSlug" => "bmw"
    "marqueId" => "3"
    "_controller" => "App\Controller\FO\ListingVNController::listing"
  ]
  "request_uri" => "http://vehicules-neufs.neubauer.fr/recherche/bmw/3?page=1"
  "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"
]

[
  "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 t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3 FROM marque t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "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_.id = ?"
  "params" => [
    1 => 1
    2 => 3
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT v0_.id AS id_0, v0_.id AS id_1 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_.id = ? ORDER BY CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, v0_.id DESC LIMIT 20"
  "params" => [
    1 => 1
    2 => 3
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.identifiant_vn AS identifiant_vn_1, v0_.numero_chassis AS numero_chassis_2, v0_.modele AS modele_3, v0_.titre AS titre_4, v0_.prix_neuf AS prix_neuf_5, v0_.prix_remise AS prix_remise_6, v0_.kilometrage AS kilometrage_7, v0_.motorisation AS motorisation_8, v0_.cylindree AS cylindree_9, v0_.date_immat AS date_immat_10, v0_.immatriculation AS immatriculation_11, v0_.boite_vitesse AS boite_vitesse_12, v0_.garantie AS garantie_13, v0_.carrosserie AS carrosserie_14, v0_.poids_avide AS poids_avide_15, v0_.transmission AS transmission_16, v0_.emissions_co2 AS emissions_co2_17, v0_.crit_air AS crit_air_18, v0_.puissance_din AS puissance_din_19, v0_.puissance_fiscale AS puissance_fiscale_20, v0_.nb_places AS nb_places_21, v0_.nb_portes AS nb_portes_22, v0_.couleur_exterieure AS couleur_exterieure_23, v0_.sellerie AS sellerie_24, v0_.nb_jours_en_stock AS nb_jours_en_stock_25, v0_.options_et_equipements AS options_et_equipements_26, v0_.visuels AS visuels_27, v0_.commentaire AS commentaire_28, v0_.is_published AS is_published_29, v0_.modifier_backend AS modifier_backend_30, v0_.flux AS flux_31, v0_.is_supprimed AS is_supprimed_32, v0_.create_at AS create_at_33, v0_.update_at AS update_at_34, m1_.id AS id_35, m1_.nom AS nom_36, m1_.type AS type_37, c2_.id AS id_38, c2_.nom AS nom_39, c2_.adresse AS adresse_40, c2_.telephone AS telephone_41, v0_.marque_id AS marque_id_42, v0_.concession_id AS concession_id_43 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_.id = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, v0_.id DESC"
  "params" => [
    1 => 1
    2 => 3
    3 => 9278
    4 => 9319
    5 => 9698
    6 => 9653
    7 => 9666
    8 => 9711
    9 => 9820
    10 => 9643
    11 => 9699
    12 => 9318
    13 => 9599
    14 => 9806
    15 => 10457
    16 => 9710
    17 => 9673
    18 => 10491
    19 => 9714
    20 => 9713
    21 => 9804
    22 => 9648
  ]
  "types" => [
    1 => 5
    2 => 1
    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 v0_.id AS id_0, v0_.id AS id_1, v0_.identifiant_vn AS identifiant_vn_2, v0_.numero_chassis AS numero_chassis_3, v0_.modele AS modele_4, v0_.titre AS titre_5, v0_.prix_neuf AS prix_neuf_6, v0_.prix_remise AS prix_remise_7, v0_.kilometrage AS kilometrage_8, v0_.motorisation AS motorisation_9, v0_.cylindree AS cylindree_10, v0_.date_immat AS date_immat_11, v0_.immatriculation AS immatriculation_12, v0_.boite_vitesse AS boite_vitesse_13, v0_.garantie AS garantie_14, v0_.carrosserie AS carrosserie_15, v0_.poids_avide AS poids_avide_16, v0_.transmission AS transmission_17, v0_.emissions_co2 AS emissions_co2_18, v0_.crit_air AS crit_air_19, v0_.puissance_din AS puissance_din_20, v0_.puissance_fiscale AS puissance_fiscale_21, v0_.nb_places AS nb_places_22, v0_.nb_portes AS nb_portes_23, v0_.couleur_exterieure AS couleur_exterieure_24, v0_.sellerie AS sellerie_25, v0_.nb_jours_en_stock AS nb_jours_en_stock_26, v0_.options_et_equipements AS options_et_equipements_27, v0_.visuels AS visuels_28, v0_.commentaire AS commentaire_29, v0_.is_published AS is_published_30, v0_.modifier_backend AS modifier_backend_31, v0_.flux AS flux_32, v0_.is_supprimed AS is_supprimed_33, v0_.create_at AS create_at_34, v0_.update_at AS update_at_35, m1_.id AS id_36, m1_.nom AS nom_37, m1_.type AS type_38, c2_.id AS id_39, c2_.nom AS nom_40, c2_.adresse AS adresse_41, c2_.telephone AS telephone_42 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_.id = ? ORDER BY CASE WHEN v0_.prix_neuf IS NOT NULL AND v0_.prix_neuf > 0 AND v0_.prix_remise IS NOT NULL AND v0_.prix_remise > 0 AND v0_.prix_remise < v0_.prix_neuf THEN (100 * (v0_.prix_neuf - v0_.prix_remise) / v0_.prix_neuf) ELSE 0 END DESC, v0_.id DESC"
  "params" => [
    1 => 1
    2 => 3
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

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