Symfony Profiler

[
  "route" => "app_product_index"
  "route_parameters" => [
    "_route" => "app_product_index"
    "_controller" => "App\Controller\FrontController\ProductController::index"
  ]
  "request_uri" => "https://rapeto.net/produit/"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "91.216.107.185"
    "port" => 3306
    "user" => "rapet2201000"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "rapet2201000"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.stock AS stock_3, p0_.desctription AS desctription_4, p0_.picture AS picture_5, p0_.linkspictures AS linkspictures_6, p0_.statdispo AS statdispo_7, p0_.stateval AS stateval_8, p0_.statetype AS statetype_9, p0_.statetypes AS statetypes_10, p0_.points AS points_11, p0_.search_count AS search_count_12, p0_.key_word AS key_word_13, p0_.modules AS modules_14, p0_.enabled AS enabled_15, COUNT(d1_.id) AS sclr_16, p0_.user_add_id AS user_add_id_17, p0_.fkcategorie_id AS fkcategorie_id_18, p0_.fksous_categorie_id AS fksous_categorie_id_19, p0_.fkdevise_id AS fkdevise_id_20, p0_.shop_id AS shop_id_21 FROM product p0_ INNER JOIN details_orders d1_ ON (d1_.idproduct_id = p0_.id) WHERE p0_.enabled = 1 AND p0_.statdispo > 0 GROUP BY p0_.id ORDER BY sclr_16 DESC LIMIT 12"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.stock AS stock_3, p0_.desctription AS desctription_4, p0_.picture AS picture_5, p0_.linkspictures AS linkspictures_6, p0_.statdispo AS statdispo_7, p0_.stateval AS stateval_8, p0_.statetype AS statetype_9, p0_.statetypes AS statetypes_10, p0_.points AS points_11, p0_.search_count AS search_count_12, p0_.key_word AS key_word_13, p0_.modules AS modules_14, p0_.enabled AS enabled_15, p0_.user_add_id AS user_add_id_16, p0_.fkcategorie_id AS fkcategorie_id_17, p0_.fksous_categorie_id AS fksous_categorie_id_18, p0_.fkdevise_id AS fkdevise_id_19, p0_.shop_id AS shop_id_20 FROM product p0_ WHERE p0_.enabled = 1 AND p0_.statdispo > 0 ORDER BY p0_.id DESC LIMIT 4"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM devise t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 106
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 104
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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.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"
]