Symfony Profiler

[
  "route" => "dtc_article_afficher"
  "route_parameters" => [
    "_route" => "dtc_article_afficher"
    "_controller" => "App\Controller\Articles\ArticleController::AfficherAction"
    "slug" => "verin-gaz-u8-405mm-460n-chapes-fogv405460c"
    "id" => "2674"
  ]
  "request_uri" => "https://epobi-tl.devweb.pro/produits/verin-gaz-u8-405mm-460n-chapes-fogv405460c-2674"
  "method" => "GET"
]

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

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

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

[
  "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\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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.request"
  "listener" => "Symfony\Bridge\Monolog\Processor\RouteProcessor::addRouteData"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\TrackingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "epobi_tl"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))"
    ]
    "defaultTableOptions" => []
    "dbname" => "epobi_tl"
    "serverVersion" => "15"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origine AS origine_2, t0.provenance AS provenance_3, t0.code_produit AS code_produit_4, t0.id_import AS id_import_5, t0.id_import_2 AS id_import_2_6, t0.donnees_import AS donnees_import_7, t0.libelle AS libelle_8, t0.nomenclature_douaniere AS nomenclature_douaniere_9, t0.unspsc AS unspsc_10, t0.ugs AS ugs_11, t0.ean AS ean_12, t0.libelle_secondaire AS libelle_secondaire_13, t0.date AS date_14, t0.dateCalculCump AS dateCalculCump_15, t0.dateProchaineDispo AS dateProchaineDispo_16, t0.date_supression AS date_supression_17, t0.date_maj AS date_maj_18, t0.date_maj_prix AS date_maj_prix_19, t0.reference AS reference_20, t0.reference_interne AS reference_interne_21, t0.reference_appel_1 AS reference_appel_1_22, t0.reference_appel_2 AS reference_appel_2_23, t0.reference_appel_3 AS reference_appel_3_24, t0.reference_appel_4 AS reference_appel_4_25, t0.reference_appel_5 AS reference_appel_5_26, t0.reference_appel_6 AS reference_appel_6_27, t0.reference_appel_7 AS reference_appel_7_28, t0.reference_appel_8 AS reference_appel_8_29, t0.reference_appel_9 AS reference_appel_9_30, t0.reference_appel_10 AS reference_appel_10_31, t0.reference_appel_11 AS reference_appel_11_32, t0.reference_client AS reference_client_33, t0.reference_fournisseur AS reference_fournisseur_34, t0.prix_base AS prix_base_35, t0.prix_revient AS prix_revient_36, t0.frais_fonctionnement AS frais_fonctionnement_37, t0.prix_vente AS prix_vente_38, t0.taux_marge AS taux_marge_39, t0.marge AS marge_40, t0.marge_reelle AS marge_reelle_41, t0.ecotaxe AS ecotaxe_42, t0.ecocontribution AS ecocontribution_43, t0.pump AS pump_44, t0.cpump AS cpump_45, t0.remise_max AS remise_max_46, t0.type_remise_max AS type_remise_max_47, t0.description AS description_48, t0.description_courte AS description_courte_49, t0.commentaire AS commentaire_50, t0.commentaire_achat AS commentaire_achat_51, t0.stock AS stock_52, t0.stock_reserve AS stock_reserve_53, t0.stock_reserve_fabrication AS stock_reserve_fabrication_54, t0.conditionnement AS conditionnement_55, t0.largeur AS largeur_56, t0.longueur AS longueur_57, t0.profondeur AS profondeur_58, t0.hauteur AS hauteur_59, t0.poids AS poids_60, t0.colis AS colis_61, t0.nomenclature_validee AS nomenclature_validee_62, t0.non_preparable AS non_preparable_63, t0.statut AS statut_64, t0.universel AS universel_65, t0.sur_prestashop AS sur_prestashop_66, t0.est_commentaire AS est_commentaire_67, t0.num_serie_obligatoire AS num_serie_obligatoire_68, t0.archive AS archive_69, t0.non_stocke AS non_stocke_70, t0.non_commandable AS non_commandable_71, t0.a_commander AS a_commander_72, t0.a_suggerer AS a_suggerer_73, t0.a_fabriquer AS a_fabriquer_74, t0.afficher_composant_pdf_interne AS afficher_composant_pdf_interne_75, t0.afficher_composant_pdf_externe AS afficher_composant_pdf_externe_76, t0.virtuel AS virtuel_77, t0.maj_prix AS maj_prix_78, t0.a_consigner AS a_consigner_79, t0.consigne AS consigne_80, t0.stock_auto AS stock_auto_81, t0.arret_gamme AS arret_gamme_82, t0.seuil_critique AS seuil_critique_83, t0.seuil_commande_f_mini AS seuil_commande_f_mini_84, t0.seuil_commande_f_maxi AS seuil_commande_f_maxi_85, t0.ral_fournisseur AS ral_fournisseur_86, t0.produit_interne AS produit_interne_87, t0.temporaire AS temporaire_88, t0.quantite_conseillee_mini AS quantite_conseillee_mini_89, t0.quantite_conseillee AS quantite_conseillee_90, t0.quantite_conseillee_maxi AS quantite_conseillee_maxi_91, t0.coefficient_px_base_px_vente AS coefficient_px_base_px_vente_92, t0.nom_web AS nom_web_93, t0.delai_reappro AS delai_reappro_94, t0.reference_web AS reference_web_95, t0.reference_fournisseur_web AS reference_fournisseur_web_96, t0.description_web AS description_web_97, t0.resume_web AS resume_web_98, t0.frais_ports_texte_web AS frais_ports_texte_web_99, t0.title_seo_web AS title_seo_web_100, t0.url_web AS url_web_101, t0.message_qd_en_stock AS message_qd_en_stock_102, t0.main_oeuvre AS main_oeuvre_103, t0.prestation AS prestation_104, t0.divers AS divers_105, t0.divers_composes AS divers_composes_106, t0.declinaison AS declinaison_107, t0.mouvemente AS mouvemente_108, t0.maj_poids AS maj_poids_109, t0.maj_prix_base AS maj_prix_base_110, t0.cond_achat AS cond_achat_111, t0.commentaire_dimensions AS commentaire_dimensions_112, t0.maj_composes AS maj_composes_113, t0.dispo AS dispo_114, t0.maj_dispo AS maj_dispo_115, t0.numero_reference AS numero_reference_116, t0.estParent AS estParent_117, t0.capacite_production AS capacite_production_118, t0.maj_capacite_prod AS maj_capacite_prod_119, t0.pump_hors_frais AS pump_hors_frais_120, t0.maj_pump AS maj_pump_121, t0.id_prestahop AS id_prestahop_122, t0.id_combination_prestahop AS id_combination_prestahop_123, t0.oqton_urn AS oqton_urn_124, t0.oqton_material_urn AS oqton_material_urn_125, t0.a_publier AS a_publier_126, t0.date_a_publier AS date_a_publier_127, t0.position AS position_128, t0.article_remplacement_id AS article_remplacement_id_129, t0.niveau_un_id AS niveau_un_id_130, t0.niveau_deux_id AS niveau_deux_id_131, t0.niveau_trois_id AS niveau_trois_id_132, t0.niveau_quatre_id AS niveau_quatre_id_133, t0.regle_taxe_id AS regle_taxe_id_134, t0.regle_taxe_achat_id AS regle_taxe_achat_id_135, t0.utilisateur_id AS utilisateur_id_136, t0.categorie_remise_article_id AS categorie_remise_article_id_137, t0.marque_id AS marque_id_138, t0.finition_id AS finition_id_139, t0.caisse_id AS caisse_id_140, t0.atelier_id AS atelier_id_141, t0.famille_compta_id AS famille_compta_id_142, t0.type_id AS type_id_143, t0.unite_mesure_id AS unite_mesure_id_144, t0.fournisseur_defaut_id AS fournisseur_defaut_id_145, t0.condition_achat_defaut_id AS condition_achat_defaut_id_146, t0.article_enconsigne_id AS article_enconsigne_id_147, t0.parent_id AS parent_id_148, t0.article_declinaison_parent_id AS article_declinaison_parent_id_149, t0.transporteur_id AS transporteur_id_150, t0.transporteur2_id AS transporteur2_id_151 FROM article__article t0 WHERE t0.id = ? AND ((t0.date_supression IS NULL))"
  "params" => [
    1 => "2674"
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.id_import AS id_import_3, t0.logo AS logo_4, t0.libelle AS libelle_5, t0.date AS date_6, t0.description AS description_7, t0.description_courte AS description_courte_8, t0.date_supression AS date_supression_9, t0.date_maj AS date_maj_10, t0.statut AS statut_11, t0.position AS position_12, t0.logo_nb AS logo_nb_13, t0.visible_accueil_ep_obi AS visible_accueil_ep_obi_14, t0.statut_api AS statut_api_15, t0.utilisateur_id AS utilisateur_id_16 FROM article__marque t0 WHERE t0.id = ? AND ((t0.date_supression IS NULL))"
  "params" => [
    1 => 213
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.diviseur AS diviseur_1, a0_.multiple AS multiple_2, a0_.type AS type_3, a0_.indifferent AS indifferent_4, a0_.parent_id AS parent_id_5, a0_.enfant_id AS enfant_id_6 FROM article__article_complement_option a0_ INNER JOIN article__article a1_ ON a0_.parent_id = a1_.id AND (a1_.date_supression IS NULL) INNER JOIN article__article a2_ ON a0_.enfant_id = a2_.id AND (a2_.date_supression IS NULL) LEFT JOIN article__marque a3_ ON a2_.marque_id = a3_.id AND (a3_.date_supression IS NULL) LEFT JOIN client__client_marque c4_ ON (c4_.marque_id = a2_.marque_id AND c4_.client_id = ?) WHERE a1_.id = ? AND a2_.statut = ? AND a0_.type = ? AND ((a3_.id IS NULL OR a3_.statut = 1)) AND c4_.id IS NULL"
  "params" => [
    1 => 0
    2 => 2674
    3 => 1
    4 => "option"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.diviseur AS diviseur_1, a0_.multiple AS multiple_2, a0_.type AS type_3, a0_.indifferent AS indifferent_4, a0_.parent_id AS parent_id_5, a0_.enfant_id AS enfant_id_6 FROM article__article_complement_option a0_ INNER JOIN article__article a1_ ON a0_.parent_id = a1_.id AND (a1_.date_supression IS NULL) INNER JOIN article__article a2_ ON a0_.enfant_id = a2_.id AND (a2_.date_supression IS NULL) LEFT JOIN article__marque a3_ ON a2_.marque_id = a3_.id AND (a3_.date_supression IS NULL) LEFT JOIN client__client_marque c4_ ON (c4_.marque_id = a2_.marque_id AND c4_.client_id = ?) WHERE a1_.id = ? AND a2_.statut = ? AND a0_.type = ? AND ((a3_.id IS NULL OR a3_.statut = 1)) AND c4_.id IS NULL"
  "params" => [
    1 => 0
    2 => 2674
    3 => 1
    4 => "complement"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.article_id AS article_id_3, t0.document_id AS document_id_4 FROM fo_document_article t0 WHERE t0.article_id = ?"
  "params" => [
    1 => 2674
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.signature_mail AS signature_mail_2, t0.texte_facture AS texte_facture_3, t0.logo AS logo_4, t0.afficher_donnees_import AS afficher_donnees_import_5, t0.date AS date_6, t0.en_inventaire AS en_inventaire_7, t0.date_debut_inventaire AS date_debut_inventaire_8, t0.date_fin_inventaire AS date_fin_inventaire_9, t0.date_maj AS date_maj_10, t0.libelle AS libelle_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.numTva AS numTva_14, t0.adresse AS adresse_15, t0.adresse_complementaire AS adresse_complementaire_16, t0.code_postal AS code_postal_17, t0.ville AS ville_18, t0.pays AS pays_19, t0.telephone AS telephone_20, t0.fax AS fax_21, t0.siteWeb AS siteWeb_22, t0.siret AS siret_23, t0.ape AS ape_24, t0.email AS email_25, t0.emailTest AS emailTest_26, t0.mailTest AS mailTest_27, t0.dateDebutExercice AS dateDebutExercice_28, t0.dateFinExercice AS dateFinExercice_29, t0.note_service AS note_service_30, t0.mailer_user AS mailer_user_31, t0.mailer_password AS mailer_password_32, t0.mailer_host AS mailer_host_33, t0.mailer_port AS mailer_port_34, t0.bandeau_email AS bandeau_email_35, t0.date_debut_texte_bandeau AS date_debut_texte_bandeau_36, t0.date_fin_texte_bandeau AS date_fin_texte_bandeau_37, t0.statut_texte_bandeau AS statut_texte_bandeau_38, t0.utilisateur_id AS utilisateur_id_39, t0.famille_compta_frais_fixe_id AS famille_compta_frais_fixe_id_40, t0.famille_compta_frais_port_id AS famille_compta_frais_port_id_41, t0.famille_compta_frais_annexes_id AS famille_compta_frais_annexes_id_42 FROM societe__societe t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.document_commercial_id AS document_commercial_id_2, t0.ordre AS ordre_3, t0.libelle AS libelle_4, t0.date AS date_5, t0.dateMaj AS dateMaj_6, t0.dateSuppression AS dateSuppression_7, t0.action_statut_commande_id AS action_statut_commande_id_8, t0.utilisateur_id AS utilisateur_id_9 FROM commerciale__statut_commande t0 WHERE t0.document_commercial_id = ? AND t0.ordre = ? AND ((t0.dateSuppression IS NULL)) LIMIT 1"
  "params" => [
    1 => 14
    2 => "1"
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.a_bloquer AS a_bloquer_2, t0.canal_vente AS canal_vente_3, t0.reference_market_place AS reference_market_place_4, t0.bascule_comptabilite AS bascule_comptabilite_5, t0.kilometrage AS kilometrage_6, t0.duree_validite AS duree_validite_7, t0.delai_relance AS delai_relance_8, t0.modifiable AS modifiable_9, t0.bp_auto AS bp_auto_10, t0.avoir_utilise AS avoir_utilise_11, t0.franco_port AS franco_port_12, t0.avecTaxe AS avecTaxe_13, t0.visible AS visible_14, t0.marge AS marge_15, t0.taux_marge AS taux_marge_16, t0.texte_facture AS texte_facture_17, t0.type_document_commercial_id AS type_document_commercial_id_18, t0.nb_colis AS nb_colis_19, t0.date_insertion AS date_insertion_20, t0.date_echeance AS date_echeance_21, t0.date_confirmation_preparation AS date_confirmation_preparation_22, t0.date_confirmation_expedition AS date_confirmation_expedition_23, t0.date_premiere_confirmation_expedition AS date_premiere_confirmation_expedition_24, t0.date_force_expedie AS date_force_expedie_25, t0.date_force_annule AS date_force_annule_26, t0.delai_livraison AS delai_livraison_27, t0.date_relance AS date_relance_28, t0.date_approximative_reception AS date_approximative_reception_29, t0.date_expedition AS date_expedition_30, t0.date_bon AS date_bon_31, t0.date_annulation AS date_annulation_32, t0.date AS date_33, t0.dateMaj AS dateMaj_34, t0.dateSuppression AS dateSuppression_35, t0.numero_reference AS numero_reference_36, t0.numero_suivi AS numero_suivi_37, t0.reference AS reference_38, t0.reference_prestashop AS reference_prestashop_39, t0.origine_saisie AS origine_saisie_40, t0.origine AS origine_41, t0.id_import AS id_import_42, t0.valide_manuellement AS valide_manuellement_43, t0.perdu AS perdu_44, t0.total_tva AS total_tva_45, t0.frais_port_supplementaire AS frais_port_supplementaire_46, t0.taux_tva_frais_port AS taux_tva_frais_port_47, t0.total_frais_port AS total_frais_port_48, t0.total_frais_port_ttc AS total_frais_port_ttc_49, t0.total_tva_frais_port AS total_tva_frais_port_50, t0.total_poids AS total_poids_51, t0.total_ttc AS total_ttc_52, t0.total AS total_53, t0.total_ht_avec_frais_port AS total_ht_avec_frais_port_54, t0.ville_livraison_txt AS ville_livraison_txt_55, t0.pays_livraison_txt AS pays_livraison_txt_56, t0.code_postal_livraison_txt AS code_postal_livraison_txt_57, t0.libelle_livraison AS libelle_livraison_58, t0.numero_livraison AS numero_livraison_59, t0.rue_livraison AS rue_livraison_60, t0.complement_livraison AS complement_livraison_61, t0.complement_livraison_2 AS complement_livraison_2_62, t0.pays_facturation_txt AS pays_facturation_txt_63, t0.ville_facturation_txt AS ville_facturation_txt_64, t0.code_postal_facturation_txt AS code_postal_facturation_txt_65, t0.libelle_facturation AS libelle_facturation_66, t0.numero_facturation AS numero_facturation_67, t0.rue_facturation AS rue_facturation_68, t0.complement_facturation AS complement_facturation_69, t0.complement_facturation_2 AS complement_facturation_2_70, t0.reference_client AS reference_client_71, t0.commentaire AS commentaire_72, t0.travaux AS travaux_73, t0.commentaire_annulation AS commentaire_annulation_74, t0.temps_passe AS temps_passe_75, t0.temps_facture AS temps_facture_76, t0.a_facturer AS a_facturer_77, t0.deja_facture AS deja_facture_78, t0.multi_bl AS multi_bl_79, t0.attente_facturation AS attente_facturation_80, t0.date_validation_bat AS date_validation_bat_81, t0.statut_bat AS statut_bat_82, t0.date_transfert_compta AS date_transfert_compta_83, t0.numero_lettrage AS numero_lettrage_84, t0.lettrage AS lettrage_85, t0.solde AS solde_86, t0.statut_a_modifier AS statut_a_modifier_87, t0.prenom AS prenom_88, t0.nom AS nom_89, t0.prenom_facturation AS prenom_facturation_90, t0.nom_facturation AS nom_facturation_91, t0.civilite AS civilite_92, t0.date_reception_fournisseur AS date_reception_fournisseur_93, t0.date_livraison_souhaitee AS date_livraison_souhaitee_94, t0.date_livraison_theorique AS date_livraison_theorique_95, t0.date_expedition_theorique AS date_expedition_theorique_96, t0.telephone AS telephone_97, t0.telephone2 AS telephone2_98, t0.email AS email_99, t0.telephone_facturation AS telephone_facturation_100, t0.telephone_facturation2 AS telephone_facturation2_101, t0.adresse_validee_manuellement AS adresse_validee_manuellement_102, t0.date_export_bext AS date_export_bext_103, t0.date_max_expedition_min AS date_max_expedition_min_104, t0.date_max_expedition_max AS date_max_expedition_max_105, t0.maj AS maj_106, t0.archive AS archive_107, t0.code_iso_facturation AS code_iso_facturation_108, t0.state_or_province_facturation AS state_or_province_facturation_109, t0.code_iso_livraison AS code_iso_livraison_110, t0.state_or_province_livraison AS state_or_province_livraison_111, t0.date_mail_facture AS date_mail_facture_112, t0.date_calcul_marge AS date_calcul_marge_113, t0.point_retrait AS point_retrait_114, t0.delivery_mode AS delivery_mode_115, t0.total_ttc_devise AS total_ttc_devise_116, t0.taux_change AS taux_change_117, t0.sended_to_oqton AS sended_to_oqton_118, t0.payplug_id AS payplug_id_119, t0.telephone_livraison AS telephone_livraison_120, t0.email_livraison AS email_livraison_121, t0.payplug_montant AS payplug_montant_122, t0.statut_attente AS statut_attente_123, t0.niveau_un_id AS niveau_un_id_124, t0.projet_id AS projet_id_125, t0.taxe_id AS taxe_id_126, t0.taxe_frais_port_id AS taxe_frais_port_id_127, t0.compte_market_place_id AS compte_market_place_id_128, t0.rapport_bext_id AS rapport_bext_id_129, t0.statut_commande_market_place_id AS statut_commande_market_place_id_130, t0.vehicules_client_id AS vehicules_client_id_131, t0.devis_id AS devis_id_132, t0.facture_id AS facture_id_133, t0.bl_id AS bl_id_134, t0.bp_id AS bp_id_135, t0.commande_id AS commande_id_136, t0.contact_livraison_id AS contact_livraison_id_137, t0.contact_facturation_id AS contact_facturation_id_138, t0.contact_acheteur_id AS contact_acheteur_id_139, t0.client_id AS client_id_140, t0.raison_anomalie_id AS raison_anomalie_id_141, t0.transporteur_id AS transporteur_id_142, t0.statut_paiement_id AS statut_paiement_id_143, t0.statut_commande_id AS statut_commande_id_144, t0.etat_commande_id AS etat_commande_id_145, t0.utilisateur_id AS utilisateur_id_146, t0.createur_id AS createur_id_147, t0.utilisateur_valide_manuellement_id AS utilisateur_valide_manuellement_id_148, t0.mecanicien_id AS mecanicien_id_149, t0.secteur_geographique_id AS secteur_geographique_id_150, t0.commercial_id AS commercial_id_151, t0.assistante_commercial_id AS assistante_commercial_id_152, t0.adresse_livraison_id AS adresse_livraison_id_153, t0.pays_livraison_id AS pays_livraison_id_154, t0.ville_livraison_id AS ville_livraison_id_155, t0.code_postal_livraison_id AS code_postal_livraison_id_156, t0.adresse_facturation_id AS adresse_facturation_id_157, t0.pays_facturation_id AS pays_facturation_id_158, t0.ville_facturation_id AS ville_facturation_id_159, t0.code_postal_facturation_id AS code_postal_facturation_id_160, t0.modereglement_id AS modereglement_id_161, t0.mode_reglement_market_place_id AS mode_reglement_market_place_id_162, t0.delai_paiement_id AS delai_paiement_id_163, t0.lcr_id AS lcr_id_164, t0.mode_expedition_id AS mode_expedition_id_165, t0.commande_parent_id AS commande_parent_id_166, t0.devise_id AS devise_id_167, t0.export_compta_id AS export_compta_id_168, t0.rapport_cloture_id AS rapport_cloture_id_169, t0.caisse_id AS caisse_id_170 FROM commerciale__commande t0 WHERE t0.statut_commande_id IS NULL AND t0.utilisateur_id IS NULL AND t0.type_document_commercial_id = ? AND ((t0.dateSuppression IS NULL)) LIMIT 1"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seller_product_id AS seller_product_id_2, t0.libelle AS libelle_3, t0.libelle_secondaire AS libelle_secondaire_4, t0.numero_serie AS numero_serie_5, t0.commentaire AS commentaire_6, t0.commentaire_prive AS commentaire_prive_7, t0.commentaire_suppl AS commentaire_suppl_8, t0.date AS date_9, t0.date_supression AS date_supression_10, t0.date_maj AS date_maj_11, t0.date_maj_prix AS date_maj_prix_12, t0.date_priorisation AS date_priorisation_13, t0.reference AS reference_14, t0.reference_client AS reference_client_15, t0.reference_fournisseur AS reference_fournisseur_16, t0.prix_base AS prix_base_17, t0.prix_unitaire_ttc AS prix_unitaire_ttc_18, t0.description AS description_19, t0.description_courte AS description_courte_20, t0.largeur AS largeur_21, t0.profondeur AS profondeur_22, t0.hauteur AS hauteur_23, t0.poids AS poids_24, t0.a_consigner AS a_consigner_25, t0.forcer AS forcer_26, t0.bloquer AS bloquer_27, t0.consigne AS consigne_28, t0.tva_achat AS tva_achat_29, t0.tva_vente AS tva_vente_30, t0.quantite AS quantite_31, t0.coefficient_conditionnement AS coefficient_conditionnement_32, t0.quantite_dispo AS quantite_dispo_33, t0.quantite_deja_preparee_simplifie AS quantite_deja_preparee_simplifie_34, t0.quantite_deja_preparee AS quantite_deja_preparee_35, t0.maj_quantite_deja_preparee AS maj_quantite_deja_preparee_36, t0.ral_client AS ral_client_37, t0.ral AS ral_38, t0.rar AS rar_39, t0.quantite_reprise AS quantite_reprise_40, t0.remise AS remise_41, t0.remise_supplementaire AS remise_supplementaire_42, t0.position AS position_43, t0.total_ht AS total_ht_44, t0.total_with_tax AS total_with_tax_45, t0.tva AS tva_46, t0.pump AS pump_47, t0.cump AS cump_48, t0.etiquettes AS etiquettes_49, t0.generer_fabriquer AS generer_fabriquer_50, t0.maj_condition_achat AS maj_condition_achat_51, t0.checked AS checked_52, t0.frais_annexes AS frais_annexes_53, t0.frais_port AS frais_port_54, t0.reste_a_reprendre AS reste_a_reprendre_55, t0.date_livraison_theorique AS date_livraison_theorique_56, t0.date_expedition_theorique AS date_expedition_theorique_57, t0.ecocontribution AS ecocontribution_58, t0.id_import AS id_import_59, t0.commision_montant AS commision_montant_60, t0.commision_taux_tva AS commision_taux_tva_61, t0.commision_tva AS commision_tva_62, t0.remboursement_montant AS remboursement_montant_63, t0.remboursement_commision_montant_ht AS remboursement_commision_montant_ht_64, t0.remboursement_commision_tva AS remboursement_commision_tva_65, t0.date_approximative_reception AS date_approximative_reception_66, t0.prix_achat_unitaire_avec_frais AS prix_achat_unitaire_avec_frais_67, t0.ajouter_frais_prix_achat AS ajouter_frais_prix_achat_68, t0.total_ttc_devise AS total_ttc_devise_69, t0.taux_change AS taux_change_70, t0.fabrication_etiquette AS fabrication_etiquette_71, t0.prix_avec_remise AS prix_avec_remise_72, t0.article_id AS article_id_73, t0.transporteur_id AS transporteur_id_74, t0.article_composant_id AS article_composant_id_75, t0.article_associe_id AS article_associe_id_76, t0.remise_initial_id AS remise_initial_id_77, t0.commande_id AS commande_id_78, t0.litige_id AS litige_id_79, t0.commande_fournisseur_id AS commande_fournisseur_id_80, t0.fabrication_id AS fabrication_id_81, t0.fabrication_multiple_id AS fabrication_multiple_id_82, t0.taxe_id AS taxe_id_83, t0.devis_id AS devis_id_84, t0.article_commande_parent_id AS article_commande_parent_id_85, t0.article_commande_id AS article_commande_id_86, t0.condition_achat_id AS condition_achat_id_87, t0.article_commande_repris_id AS article_commande_repris_id_88, t0.article_commande_associe_id AS article_commande_associe_id_89, t0.article_market_place_id AS article_market_place_id_90, t0.fichier_id AS fichier_id_91 FROM commerciale__article_commande t0 WHERE t0.commande_id = ? ORDER BY t0.position ASC, t0.id ASC"
  "params" => [
    1 => 159
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    SELECT c.id, c.libelle\n
            FROM article__categorie c\n
            INNER JOIN article__article_categorie ac ON ac.categorie_id = c.id\n
            LEFT JOIN article__categorie child ON child.categorie_parent_id = c.id AND child.statut = 1\n
            WHERE ac.article_id = 2674\n
            AND c.statut = 1\n
            AND child.id IS NULL;\n
            
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.id_import AS id_import_3, t0.id_prestahop AS id_prestahop_4, t0.logo AS logo_5, t0.logo2 AS logo2_6, t0.libelle AS libelle_7, t0.date AS date_8, t0.date_supression AS date_supression_9, t0.date_maj AS date_maj_10, t0.statut AS statut_11, t0.home_page_prestashop AS home_page_prestashop_12, t0.position AS position_13, t0.additive AS additive_14, t0.market_place_id AS market_place_id_15, t0.profil_amazon_id AS profil_amazon_id_16, t0.utilisateur_id AS utilisateur_id_17, t0.categorie_amazon_id AS categorie_amazon_id_18, t0.categorie_cdiscount_id AS categorie_cdiscount_id_19, t0.categorie_price_minister_id AS categorie_price_minister_id_20, t0.categorie_ebay_id AS categorie_ebay_id_21, t0.categorie_wordpress_id AS categorie_wordpress_id_22, t0.categorie_wordpress_woo_id AS categorie_wordpress_woo_id_23, t0.categorie_prestahop_id AS categorie_prestahop_id_24, t0.categorie_parent_id AS categorie_parent_id_25 FROM article__categorie t0 WHERE t0.id = ? AND ((t0.date_supression IS NULL))"
  "params" => [
    1 => 1243
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.id_import AS id_import_3, t0.id_prestahop AS id_prestahop_4, t0.logo AS logo_5, t0.logo2 AS logo2_6, t0.libelle AS libelle_7, t0.date AS date_8, t0.date_supression AS date_supression_9, t0.date_maj AS date_maj_10, t0.statut AS statut_11, t0.home_page_prestashop AS home_page_prestashop_12, t0.position AS position_13, t0.additive AS additive_14, t0.market_place_id AS market_place_id_15, t0.profil_amazon_id AS profil_amazon_id_16, t0.utilisateur_id AS utilisateur_id_17, t0.categorie_amazon_id AS categorie_amazon_id_18, t0.categorie_cdiscount_id AS categorie_cdiscount_id_19, t0.categorie_price_minister_id AS categorie_price_minister_id_20, t0.categorie_ebay_id AS categorie_ebay_id_21, t0.categorie_wordpress_id AS categorie_wordpress_id_22, t0.categorie_wordpress_woo_id AS categorie_wordpress_woo_id_23, t0.categorie_prestahop_id AS categorie_prestahop_id_24, t0.categorie_parent_id AS categorie_parent_id_25 FROM article__categorie t0 WHERE t0.id = ? AND ((t0.date_supression IS NULL))"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id_prestashop AS id_prestashop_2, t0.url AS url_3, t0.date AS date_4, t0.extension AS extension_5, t0.position AS position_6, t0.affichage_web AS affichage_web_7, t0.id_import AS id_import_8, t0.id_import_woo AS id_import_woo_9, t0.ulid AS ulid_10, t0.article_id AS article_id_11 FROM article__image t0 WHERE t0.article_id = ? ORDER BY t0.position ASC LIMIT 100"
  "params" => [
    1 => 2674
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date AS date_3, t0.dateSuppression AS dateSuppression_4, t0.dateMaj AS dateMaj_5, t0.taux_defaut AS taux_defaut_6, t0.ordre AS ordre_7, t0.utilisateur_id AS utilisateur_id_8 FROM taxte__regle_taxe t0 WHERE t0.id = ? AND ((t0.dateSuppression IS NULL))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.quantite AS quantite_2, a0_.article_id AS article_id_3 FROM article__date_dispo a0_ WHERE a0_.article_id = ? AND ((a0_.date >= ? OR a0_.date IS NULL)) AND a0_.quantite > ? ORDER BY CASE WHEN a0_.date IS NULL THEN 1 ELSE 0 END ASC, a0_.date ASC LIMIT 10"
  "params" => [
    1 => 2674
    2 => "2026-05-10 00:00:00"
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.dossier AS dossier_4, t0.lien AS lien_5, t0.statut AS statut_6, t0.mobile AS mobile_7, t0.position AS position_8, t0.date_debut AS date_debut_9, t0.date_fin AS date_fin_10, t0.articles AS articles_11, t0.societe_id AS societe_id_12 FROM fo__document t0 WHERE t0.id = ?"
  "params" => [
    1 => 422
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.date AS date_3, t0.extension AS extension_4, t0.position AS position_5, t0.affichage_web AS affichage_web_6, t0.article_id AS article_id_7 FROM article__document t0 WHERE t0.article_id = ?"
  "params" => [
    1 => 2674
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    SELECT a.id,a.marque_id,a.modele_id,a.type_id,m.libelle as libelle_marque,mo.libelle as libelle_modele,t.libelle as libelle_type \n
                    FROM vehicule__application as a\n
                    LEFT JOIN vehicule__marque as m ON a.marque_id = m.id       \n
                    LEFT JOIN vehicule__modele as mo ON a.modele_id = mo.id       \n
                    LEFT JOIN vehicule__type as t ON a.type_id = t.id       \n
                    WHERE article_id = '2674'
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "epobi_tl"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "epobi_tl"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               t.ENGINE,\n
               t.AUTO_INCREMENT,\n
               t.TABLE_COMMENT,\n
               t.CREATE_OPTIONS,\n
               t.TABLE_COLLATION,\n
               ccsa.CHARACTER_SET_NAME\n
          FROM information_schema.TABLES t\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n
                ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "epobi_tl"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
    AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'epobi_tl' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "epobi_tl"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\n
           c.COLUMN_TYPE       AS type,\n
           c.IS_NULLABLE        AS `null`,\n
           c.COLUMN_KEY         AS `key`,\n
           c.COLUMN_DEFAULT     AS `default`,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT     AS comment,\n
           c.CHARACTER_SET_NAME AS characterset,\n
           c.COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS c\n
        INNER JOIN information_schema.TABLES t\n
            ON t.TABLE_NAME = c.TABLE_NAME\n
         WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "epobi_tl"
    2 => "epobi_tl"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "epobi_tl"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\Subscriber\GestionComerciale\ActiviteSubscriber::processActivite"
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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\Bridge\Monolog\Processor\RouteProcessor::removeRouteData"
]

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