Symfony Profiler

[
  "route" => "app_fiche_produit"
  "route_parameters" => [
    "_route" => "app_fiche_produit"
    "id_product" => "16"
    "id_categorie" => "12"
    "_controller" => "App\Controller\FicheProduitController::index"
  ]
  "request_uri" => "https://dev.spa.biz/fiche-produit/12-categorie/16"
  "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" => "App\EventSubscriber\CheckLangueSubscriber::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" => "127.0.0.1"
    "port" => 3306
    "user" => "c1spabiz_dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "c1spabiz_dev"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.image_produits_principale AS image_produits_principale_3, t0.stock AS stock_4, t0.price_ttc AS price_ttc_5, t0.price_ht AS price_ht_6, t0.tax_rate AS tax_rate_7, t0.ref AS ref_8, t0.is_selection AS is_selection_9, t0.price_product_ttc AS price_product_ttc_10, t0.price_product_ht AS price_product_ht_11, t0.tax_rate_product_ht AS tax_rate_product_ht_12, t0.price_service_ttc AS price_service_ttc_13, t0.price_service_ht AS price_service_ht_14, t0.tax_rate_service_ttc AS tax_rate_service_ttc_15, t0.is_coup_coeur AS is_coup_coeur_16, t0.template_pdf AS template_pdf_17, t0.finition_id AS finition_id_18, t0.produit_parent_id AS produit_parent_id_19 FROM produit t0 WHERE t0.id = ?"
  "params" => [
    1 => "16"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.produit_image_id AS produit_image_id_3, t0.color_id AS color_id_4 FROM image_produit t0 WHERE t0.produit_image_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.descriptions AS descriptions_2, c0_.image AS image_3, c0_.name_fr AS name_fr_4, c0_.descriptions_fr AS descriptions_fr_5, c0_.name_es AS name_es_6, c0_.descriptions_es AS descriptions_es_7, c0_.sous_categorie_id AS sous_categorie_id_8 FROM categorie c0_ WHERE c0_.sous_categorie_id IS NULL ORDER BY c0_.id ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.descriptions AS descriptions_3, t0.image AS image_4, t0.name_fr AS name_fr_5, t0.descriptions_fr AS descriptions_fr_6, t0.name_es AS name_es_7, t0.descriptions_es AS descriptions_es_8, t0.sous_categorie_id AS sous_categorie_id_9 FROM categorie t0 WHERE t0.id = ?"
  "params" => [
    1 => "12"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.dimensions AS dimensions_2, t0.conditionnement AS conditionnement_3, t0.nbr_rechauffeur AS nbr_rechauffeur_4, t0.led_chroma_peripherique AS led_chroma_peripherique_5, t0.colonne_eau_lumineuse AS colonne_eau_lumineuse_6, t0.cascade_led AS cascade_led_7, t0.aromatherapie AS aromatherapie_8, t0.skimmer AS skimmer_9, t0.ozonateur AS ozonateur_10, t0.systeme_antigel AS systeme_antigel_11, t0.volts AS volts_12, t0.chassis_inox_indestructible AS chassis_inox_indestructible_13, t0.socle_isolation_thermique AS socle_isolation_thermique_14, t0.nuage_led_sole AS nuage_led_sole_15, t0.system_appui_tete AS system_appui_tete_16, t0.jet_air AS jet_air_17, t0.places_assis AS places_assis_18, t0.places_allonge AS places_allonge_19, t0.enceinte AS enceinte_20, t0.volume AS volume_21, t0.poids AS poids_22, t0.capacite_spa AS capacite_spa_23, t0.jets_therapie AS jets_therapie_24, t0.jets_air AS jets_air_25, t0.jets_eau AS jets_eau_26, t0.jets_massage_cervical AS jets_massage_cervical_27, t0.turbo_jets_mollets AS turbo_jets_mollets_28, t0.appuis_tete AS appuis_tete_29, t0.radio AS radio_30, t0.leds_chromoterapie_perifs AS leds_chromoterapie_perifs_31, t0.gros_spot_leds AS gros_spot_leds_32, t0.cascade_leds AS cascade_leds_33, t0.spot_arc_en_ciel AS spot_arc_en_ciel_34, t0.acrylique_aristech_usa AS acrylique_aristech_usa_35, t0.triple_isolation AS triple_isolation_36, t0.puissance_pompe_aeau AS puissance_pompe_aeau_37, t0.tablette AS tablette_38, t0.fontaine_eau_lumineuse AS fontaine_eau_lumineuse_39, t0.gamme AS gamme_40, t0.finition_buses AS finition_buses_41, t0.enceinte_avec_leds AS enceinte_avec_leds_42, t0.enceinte_sans_leds AS enceinte_sans_leds_43, t0.cascade_non_leds AS cascade_non_leds_44, t0.chassis_acier_galvanise AS chassis_acier_galvanise_45, t0.prix_public_conseille AS prix_public_conseille_46, t0.aff_dimensions AS aff_dimensions_47, t0.aff_conditionnement AS aff_conditionnement_48, t0.aff_nbr_rechauffeur AS aff_nbr_rechauffeur_49, t0.aff_led_chroma_peripherique AS aff_led_chroma_peripherique_50, t0.aff_colonne_eau_lumineuse AS aff_colonne_eau_lumineuse_51, t0.aff_cascade_led AS aff_cascade_led_52, t0.aff_aromatherapie AS aff_aromatherapie_53, t0.aff_skimmer AS aff_skimmer_54, t0.aff_ozonateur AS aff_ozonateur_55, t0.aff_systeme_antigel AS aff_systeme_antigel_56, t0.aff_volts AS aff_volts_57, t0.aff_chassis_inox_indestructible AS aff_chassis_inox_indestructible_58, t0.aff_socle_isolation_thermique AS aff_socle_isolation_thermique_59, t0.aff_nuage_led_sole AS aff_nuage_led_sole_60, t0.aff_system_appui_tete AS aff_system_appui_tete_61, t0.aff_jet_air AS aff_jet_air_62, t0.aff_places_assis AS aff_places_assis_63, t0.aff_places_allonge AS aff_places_allonge_64, t0.aff_volume AS aff_volume_65, t0.aff_poids AS aff_poids_66, t0.aff_capacite_spa AS aff_capacite_spa_67, t0.aff_jets_therapie AS aff_jets_therapie_68, t0.aff_jets_air AS aff_jets_air_69, t0.aff_jets_eau AS aff_jets_eau_70, t0.aff_jets_massage_cervical AS aff_jets_massage_cervical_71, t0.aff_turbo_jets_mollets AS aff_turbo_jets_mollets_72, t0.aff_appuis_tete AS aff_appuis_tete_73, t0.aff_radio AS aff_radio_74, t0.aff_bluetooth AS aff_bluetooth_75, t0.aff_wifi AS aff_wifi_76, t0.aff_leds_chromoterapie_perifs AS aff_leds_chromoterapie_perifs_77, t0.aff_gros_spot_leds AS aff_gros_spot_leds_78, t0.aff_cascade_leds AS aff_cascade_leds_79, t0.aff_spot_arc_en_ciel AS aff_spot_arc_en_ciel_80, t0.aff_pompes_aair AS aff_pompes_aair_81, t0.aff_acrylique_aristech_usa AS aff_acrylique_aristech_usa_82, t0.aff_triple_isolation AS aff_triple_isolation_83, t0.aff_puissance_pompe_aeau AS aff_puissance_pompe_aeau_84, t0.aff_tablette AS aff_tablette_85, t0.aff_fontaine_eau_lumineuse AS aff_fontaine_eau_lumineuse_86, t0.aff_gamme AS aff_gamme_87, t0.aff_finition_buses AS aff_finition_buses_88, t0.aff_enceinte_avec_leds AS aff_enceinte_avec_leds_89, t0.aff_enceinte_sans_leds AS aff_enceinte_sans_leds_90, t0.aff_cascade_non_leds AS aff_cascade_non_leds_91, t0.aff_chassis_acier_galvanise AS aff_chassis_acier_galvanise_92, t0.aff_prix_public_conseille AS aff_prix_public_conseille_93, t0.aff_garantie AS aff_garantie_94, t0.aff_puissance_pompes_aair AS aff_puissance_pompes_aair_95, t0.aff_pompe_pression_whirlpool AS aff_pompe_pression_whirlpool_96, t0.aff_pompe_filtration_whirlpool AS aff_pompe_filtration_whirlpool_97, t0.aff_puissance_rechauffeur AS aff_puissance_rechauffeur_98, t0.aff_isolation_thermo_iso14000 AS aff_isolation_thermo_iso14000_99, t0.aff_commande_adistance AS aff_commande_adistance_100, t0.angle_leds AS angle_leds_101, t0.aff_angle_leds AS aff_angle_leds_102, t0.place_semi_allonges AS place_semi_allonges_103, t0.place_levitation AS place_levitation_104, t0.aff_place_semi_allonges AS aff_place_semi_allonges_105, t0.aff_place_levitation AS aff_place_levitation_106, t0.produit_id AS produit_id_107, t0.finition_id AS finition_id_108 FROM produit_related_version t0 WHERE t0.produit_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.image_produits_principale AS image_produits_principale_2, p0_.stock AS stock_3, p0_.price_ttc AS price_ttc_4, p0_.price_ht AS price_ht_5, p0_.tax_rate AS tax_rate_6, p0_.ref AS ref_7, p0_.is_selection AS is_selection_8, p0_.price_product_ttc AS price_product_ttc_9, p0_.price_product_ht AS price_product_ht_10, p0_.tax_rate_product_ht AS tax_rate_product_ht_11, p0_.price_service_ttc AS price_service_ttc_12, p0_.price_service_ht AS price_service_ht_13, p0_.tax_rate_service_ttc AS tax_rate_service_ttc_14, p0_.is_coup_coeur AS is_coup_coeur_15, p0_.template_pdf AS template_pdf_16, p0_.finition_id AS finition_id_17, p0_.produit_parent_id AS produit_parent_id_18 FROM produit p0_ WHERE p0_.produit_parent_id = ? OR p0_.id = ? ORDER BY p0_.finition_id ASC"
  "params" => [
    1 => "16"
    2 => "16"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.descriptions AS descriptions_4, t0.note AS note_5, t0.image AS image_6, t0.produit_id AS produit_id_7 FROM avis_client t0 WHERE t0.produit_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM produit_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.descriptions AS descriptions_3, t0.image AS image_4, t0.name_fr AS name_fr_5, t0.descriptions_fr AS descriptions_fr_6, t0.name_es AS name_es_7, t0.descriptions_es AS descriptions_es_8, t0.sous_categorie_id AS sous_categorie_id_9 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.tax_rate AS tax_rate_4 FROM `option` t0 INNER JOIN produit_option ON t0.id = produit_option.option_id WHERE produit_option.produit_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.tax_rate AS tax_rate_4 FROM garantie t0 INNER JOIN produit_garantie ON t0.id = produit_garantie.garantie_id WHERE produit_garantie.produit_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.price_ht AS price_ht_3, t0.price_ttc AS price_ttc_4, t0.tax_rate AS tax_rate_5, t0.descriptions AS descriptions_6 FROM finition t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.pompe_pression_whirlpool AS pompe_pression_whirlpool_2, t0.pompe_filtration_whirlpool AS pompe_filtration_whirlpool_3, t0.puissance_rechauffeur AS puissance_rechauffeur_4, t0.isolation_thermo_iso14000 AS isolation_thermo_iso14000_5, t0.commande_adistance AS commande_adistance_6, t0.pompes_aair AS pompes_aair_7, t0.wifi AS wifi_8, t0.bluetooth AS bluetooth_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM produit_related_version_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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\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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]