Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.service AS service_6,
  t0.phone AS phone_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.service AS service_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = 11;

SELECT
  banfn,
  bnfpo,
  lgort,
  statut,
  po_number,
  has_po,
  qty_needed,
  qty_ordered,
  qty_delivered,
  price_da,
  price_po,
  DATE_FORMAT(create_date, '%Y-%m-%d') AS create_date,
  DATE_FORMAT(delivery_date, '%Y-%m-%d') AS delivery_date,
  DATE_FORMAT(
    date_livraison_fournisseur, '%Y-%m-%d'
  ) AS date_livraison_fournisseur,
  DATE_FORMAT(date_reception, '%Y-%m-%d') AS date_reception,
  supplier_name,
  otp_element,
  -- 🔹 Code article
  JSON_UNQUOTE(
    JSON_EXTRACT(raw_row, '$."Article"')
  ) AS article,
  -- 🔹 Désignation article (texte commande)
  COALESCE(
    JSON_UNQUOTE(
      JSON_EXTRACT(
        raw_row, '$."D\\u00e9signation article"'
      )
    ),
    JSON_UNQUOTE(
      JSON_EXTRACT(
        raw_row, '$."D\\u00e9signation"'
      )
    ),
    JSON_UNQUOTE(
      JSON_EXTRACT(
        raw_row, '$."Désignation article"'
      )
    ),
    JSON_UNQUOTE(
      JSON_EXTRACT(raw_row, '$."Désignation"')
    )
  ) AS designation,
  -- 🔹 Texte DA (comme dans dashboard DA)
  JSON_UNQUOTE(
    JSON_EXTRACT(
      raw_row, '$."D\\u00e9signation (2)"'
    )
  ) AS texte_da,
  raw_row
FROM
  da_demande_achat
WHERE
  banfn IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT 
                        banfn,
                        bnfpo,
                        lgort,
                        statut,
                        po_number,
                        has_po,
                        qty_needed,
                        qty_ordered,
                        qty_delivered,
                        price_da,
                        price_po,

                        DATE_FORMAT(create_date, '%Y-%m-%d')                AS create_date,
                        DATE_FORMAT(delivery_date, '%Y-%m-%d')              AS delivery_date,
                        DATE_FORMAT(date_livraison_fournisseur, '%Y-%m-%d') AS date_livraison_fournisseur,
                        DATE_FORMAT(date_reception, '%Y-%m-%d')             AS date_reception,

                        supplier_name,
                        otp_element,

                        -- 🔹 Code article
                        JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."Article"')) AS article,

                        -- 🔹 Désignation article (texte commande)
                        COALESCE(
                            JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."D\\u00e9signation article"')),
                            JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."D\\u00e9signation"')),
                            JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."Désignation article"')),
                            JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."Désignation"'))
                        ) AS designation,

                        -- 🔹 Texte DA (comme dans dashboard DA)
                        JSON_UNQUOTE(JSON_EXTRACT(raw_row, '$."D\\u00e9signation (2)"')) AS texte_da,

                        raw_row
                    FROM da_demande_achat
                    WHERE banfn IN (11536869,11536873,11536595,11536600,11536833,11536617,11536832,11536710,11536705,11536676,11536591,11536674,11536671,11536548)
                ;

SELECT
  d0_.id AS id_0,
  d0_.created_at AS created_at_1,
  d0_.reference AS reference_2,
  d0_.total_ht AS total_ht_3,
  d0_.updated_at AS updated_at_4,
  d0_.remise_commerciale AS remise_commerciale_5,
  d0_.remise_en_p100 AS remise_en_p100_6,
  d0_.version AS version_7,
  d0_.description AS description_8,
  d0_.numero_dossier AS numero_dossier_9,
  d0_.id_monday AS id_monday_10,
  d0_.contact_name AS contact_name_11,
  d0_.contact_email AS contact_email_12,
  d0_.contact_phone_number AS contact_phone_number_13,
  d0_.contact_mobile_number AS contact_mobile_number_14,
  d0_.item_id_monday AS item_id_monday_15,
  d0_.adresse_livraison AS adresse_livraison_16,
  d0_.address AS address_17,
  d0_.contact_livraison AS contact_livraison_18,
  d0_.delivery_fee_manual AS delivery_fee_manual_19,
  d0_.delivery_fee_note AS delivery_fee_note_20,
  d0_.locked_by_userd_id AS locked_by_userd_id_21,
  d0_.locked_at AS locked_at_22,
  d0_.compte_commercial_id AS compte_commercial_id_23
FROM
  devis d0_
  INNER JOIN bon_de_livraison b1_ ON d0_.id = b1_.devis_id
WHERE
  b1_.partially_delivered = ?
GROUP BY
  d0_.id

SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.reference AS reference_2, d0_.total_ht AS total_ht_3, d0_.updated_at AS updated_at_4, d0_.remise_commerciale AS remise_commerciale_5, d0_.remise_en_p100 AS remise_en_p100_6, d0_.version AS version_7, d0_.description AS description_8, d0_.numero_dossier AS numero_dossier_9, d0_.id_monday AS id_monday_10, d0_.contact_name AS contact_name_11, d0_.contact_email AS contact_email_12, d0_.contact_phone_number AS contact_phone_number_13, d0_.contact_mobile_number AS contact_mobile_number_14, d0_.item_id_monday AS item_id_monday_15, d0_.adresse_livraison AS adresse_livraison_16, d0_.address AS address_17, d0_.contact_livraison AS contact_livraison_18, d0_.delivery_fee_manual AS delivery_fee_manual_19, d0_.delivery_fee_note AS delivery_fee_note_20, d0_.locked_by_userd_id AS locked_by_userd_id_21, d0_.locked_at AS locked_at_22, d0_.compte_commercial_id AS compte_commercial_id_23 FROM devis d0_ INNER JOIN bon_de_livraison b1_ ON d0_.id = b1_.devis_id WHERE b1_.partially_delivered = 1 GROUP BY d0_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.commerciaux AS commerciaux_3,
  t0.affecte_a AS affecte_a_4,
  t0.type AS type_5,
  t0.status AS status_6,
  t0.interet AS interet_7,
  t0.tag_prioriry AS tag_prioriry_8,
  t0.email AS email_9,
  t0.telephone AS telephone_10,
  t0.mobile AS mobile_11,
  t0.adresse AS adresse_12,
  t0.adresse_old AS adresse_old_13,
  t0.adresse_complement AS adresse_complement_14,
  t0.adresse_rue AS adresse_rue_15,
  t0.adresse_cp AS adresse_cp_16,
  t0.adresse_ville AS adresse_ville_17,
  t0.remarques AS remarques_18,
  t0.tag_sector AS tag_sector_19,
  t0.my_group AS my_group_20,
  t0.site_web AS site_web_21,
  t0.pays AS pays_22,
  t0.region AS region_23,
  t0.origine AS origine_24,
  t0.effectifs AS effectifs_25,
  t0.fichier AS fichier_26,
  t0.tag_main_product AS tag_main_product_27,
  t0.tag_deals_part AS tag_deals_part_28,
  t0.agent AS agent_29,
  t0.commentaires AS commentaires_30,
  t0.commercial_local AS commercial_local_31,
  t0.commercial_sav AS commercial_sav_32,
  t0.commercial_service AS commercial_service_33,
  t0.opportunites_en_cours AS opportunites_en_cours_34,
  t0.id_monday AS id_monday_35,
  t0.monday_board_id AS monday_board_id_36,
  t0.type_index AS type_index_37,
  t0.qualification_index AS qualification_index_38,
  t0.secteur1_index AS secteur1_index_39,
  t0.secteur2_index AS secteur2_index_40,
  t0.secteur3_index AS secteur3_index_41,
  t0.groupe_id AS groupe_id_42,
  t0.pays_dropdown_id AS pays_dropdown_id_43,
  t0.effectifs_id AS effectifs_id_44,
  t0.reservation_honor_index AS reservation_honor_index_45,
  t0.teleprospection_index AS teleprospection_index_46,
  t0.reseaux_index AS reseaux_index_47,
  t0.upload_pipeline_index AS upload_pipeline_index_48
FROM
  compte_commerciaux t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.commerciaux AS commerciaux_3, t0.affecte_a AS affecte_a_4, t0.type AS type_5, t0.status AS status_6, t0.interet AS interet_7, t0.tag_prioriry AS tag_prioriry_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.mobile AS mobile_11, t0.adresse AS adresse_12, t0.adresse_old AS adresse_old_13, t0.adresse_complement AS adresse_complement_14, t0.adresse_rue AS adresse_rue_15, t0.adresse_cp AS adresse_cp_16, t0.adresse_ville AS adresse_ville_17, t0.remarques AS remarques_18, t0.tag_sector AS tag_sector_19, t0.my_group AS my_group_20, t0.site_web AS site_web_21, t0.pays AS pays_22, t0.region AS region_23, t0.origine AS origine_24, t0.effectifs AS effectifs_25, t0.fichier AS fichier_26, t0.tag_main_product AS tag_main_product_27, t0.tag_deals_part AS tag_deals_part_28, t0.agent AS agent_29, t0.commentaires AS commentaires_30, t0.commercial_local AS commercial_local_31, t0.commercial_sav AS commercial_sav_32, t0.commercial_service AS commercial_service_33, t0.opportunites_en_cours AS opportunites_en_cours_34, t0.id_monday AS id_monday_35, t0.monday_board_id AS monday_board_id_36, t0.type_index AS type_index_37, t0.qualification_index AS qualification_index_38, t0.secteur1_index AS secteur1_index_39, t0.secteur2_index AS secteur2_index_40, t0.secteur3_index AS secteur3_index_41, t0.groupe_id AS groupe_id_42, t0.pays_dropdown_id AS pays_dropdown_id_43, t0.effectifs_id AS effectifs_id_44, t0.reservation_honor_index AS reservation_honor_index_45, t0.teleprospection_index AS teleprospection_index_46, t0.reseaux_index AS reseaux_index_47, t0.upload_pipeline_index AS upload_pipeline_index_48 FROM compte_commerciaux t0 WHERE t0.id IN (993, 1003, 994, 1221, 909);