Symfony Profiler

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.updated_at AS updated_at_1
FROM
  devis d0_
WHERE
  d0_.id = ?
  OR LOWER(
    CONCAT(d0_.reference, '')
  ) LIKE ?
  OR d0_.total_ht = ?
  OR d0_.remise_commerciale = ?
  OR d0_.remise_en_p100 = ?
  OR LOWER(
    CONCAT(d0_.version, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.description, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.numero_dossier, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.id_monday, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_name, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_email, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_phone_number, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_mobile_number, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.item_id_monday, '')
  ) LIKE ?
  OR LOWER(d0_.adresse_livraison) LIKE ?
  OR LOWER(d0_.address) LIKE ?
  OR LOWER(d0_.contact_livraison) LIKE ?
  OR d0_.delivery_fee_manual = ?
  OR LOWER(
    CONCAT(d0_.delivery_fee_note, '')
  ) LIKE ?
  OR d0_.locked_by_userd_id = ?
ORDER BY
  d0_.updated_at DESC
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0, d0_.updated_at AS updated_at_1 FROM devis d0_ WHERE d0_.id = 5836 OR LOWER(CONCAT(d0_.reference, '')) LIKE '%5836%' OR d0_.total_ht = 5836 OR d0_.remise_commerciale = 5836 OR d0_.remise_en_p100 = 5836 OR LOWER(CONCAT(d0_.version, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.description, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.numero_dossier, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.id_monday, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_name, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_email, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_phone_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_mobile_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.item_id_monday, '')) LIKE '%5836%' OR LOWER(d0_.adresse_livraison) LIKE '%5836%' OR LOWER(d0_.address) LIKE '%5836%' OR LOWER(d0_.contact_livraison) LIKE '%5836%' OR d0_.delivery_fee_manual = 5836 OR LOWER(CONCAT(d0_.delivery_fee_note, '')) LIKE '%5836%' OR d0_.locked_by_userd_id = 5836 ORDER BY d0_.updated_at DESC LIMIT 20;

SELECT
  count(*) AS sclr_0
FROM
  devis d0_
WHERE
  d0_.id = ?
  OR LOWER(
    CONCAT(d0_.reference, '')
  ) LIKE ?
  OR d0_.total_ht = ?
  OR d0_.remise_commerciale = ?
  OR d0_.remise_en_p100 = ?
  OR LOWER(
    CONCAT(d0_.version, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.description, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.numero_dossier, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.id_monday, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_name, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_email, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_phone_number, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.contact_mobile_number, '')
  ) LIKE ?
  OR LOWER(
    CONCAT(d0_.item_id_monday, '')
  ) LIKE ?
  OR LOWER(d0_.adresse_livraison) LIKE ?
  OR LOWER(d0_.address) LIKE ?
  OR LOWER(d0_.contact_livraison) LIKE ?
  OR d0_.delivery_fee_manual = ?
  OR LOWER(
    CONCAT(d0_.delivery_fee_note, '')
  ) LIKE ?
  OR d0_.locked_by_userd_id = ?

SELECT count(*) AS sclr_0 FROM devis d0_ WHERE d0_.id = 5836 OR LOWER(CONCAT(d0_.reference, '')) LIKE '%5836%' OR d0_.total_ht = 5836 OR d0_.remise_commerciale = 5836 OR d0_.remise_en_p100 = 5836 OR LOWER(CONCAT(d0_.version, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.description, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.numero_dossier, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.id_monday, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_name, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_email, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_phone_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_mobile_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.item_id_monday, '')) LIKE '%5836%' OR LOWER(d0_.adresse_livraison) LIKE '%5836%' OR LOWER(d0_.address) LIKE '%5836%' OR LOWER(d0_.contact_livraison) LIKE '%5836%' OR d0_.delivery_fee_manual = 5836 OR LOWER(CONCAT(d0_.delivery_fee_note, '')) LIKE '%5836%' OR d0_.locked_by_userd_id = 5836;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.total_ligne AS total_ligne_3,
  t0.prix_unitaire AS prix_unitaire_4,
  t0.fully_delivered AS fully_delivered_5,
  t0.quantite_restante_alivrer AS quantite_restante_alivrer_6,
  t0.partially_delivered AS partially_delivered_7,
  t0.delai AS delai_8,
  t0.commentaire AS commentaire_9,
  t0.designation AS designation_10,
  t0.code_article AS code_article_11,
  t0.prf AS prf_12,
  t0.devis_id AS devis_id_13,
  t0.article_id AS article_id_14,
  t15.id AS id_16,
  t15.name AS name_17,
  t15.designation AS designation_18,
  t15.fabricant AS fabricant_19,
  t15.reference_fabricant AS reference_fabricant_20,
  t15.type AS type_21,
  t15.prf AS prf_22,
  t15.unite_de_prix AS unite_de_prix_23,
  t15.date_validite_tarif AS date_validite_tarif_24,
  t15.code_tarif AS code_tarif_25,
  t15.code_douanier AS code_douanier_26,
  t15.dimentions AS dimentions_27,
  t15.poids AS poids_28,
  t15.pays_origine AS pays_origine_29,
  t15.numero_magasin AS numero_magasin_30,
  t15.emplacement_magasin AS emplacement_magasin_31,
  t15.created_at AS created_at_32,
  t15.image AS image_33,
  t15.id_monday AS id_monday_34,
  t15.updated_at AS updated_at_35,
  t15.updated_by AS updated_by_36,
  t15.coeff_prix_id AS coeff_prix_id_37,
  t0.coeff_prix_id AS coeff_prix_id_38
FROM
  devis_ligne t0
  INNER JOIN article t15 ON t0.article_id = t15.id
WHERE
  t0.devis_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.total_ligne AS total_ligne_3, t0.prix_unitaire AS prix_unitaire_4, t0.fully_delivered AS fully_delivered_5, t0.quantite_restante_alivrer AS quantite_restante_alivrer_6, t0.partially_delivered AS partially_delivered_7, t0.delai AS delai_8, t0.commentaire AS commentaire_9, t0.designation AS designation_10, t0.code_article AS code_article_11, t0.prf AS prf_12, t0.devis_id AS devis_id_13, t0.article_id AS article_id_14, t15.id AS id_16, t15.name AS name_17, t15.designation AS designation_18, t15.fabricant AS fabricant_19, t15.reference_fabricant AS reference_fabricant_20, t15.type AS type_21, t15.prf AS prf_22, t15.unite_de_prix AS unite_de_prix_23, t15.date_validite_tarif AS date_validite_tarif_24, t15.code_tarif AS code_tarif_25, t15.code_douanier AS code_douanier_26, t15.dimentions AS dimentions_27, t15.poids AS poids_28, t15.pays_origine AS pays_origine_29, t15.numero_magasin AS numero_magasin_30, t15.emplacement_magasin AS emplacement_magasin_31, t15.created_at AS created_at_32, t15.image AS image_33, t15.id_monday AS id_monday_34, t15.updated_at AS updated_at_35, t15.updated_by AS updated_by_36, t15.coeff_prix_id AS coeff_prix_id_37, t0.coeff_prix_id AS coeff_prix_id_38 FROM devis_ligne t0 INNER JOIN article t15 ON t0.article_id = t15.id WHERE t0.devis_id = 561;

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_
WHERE
  (
    d0_.id = ?
    OR LOWER(
      CONCAT(d0_.reference, '')
    ) LIKE ?
    OR d0_.total_ht = ?
    OR d0_.remise_commerciale = ?
    OR d0_.remise_en_p100 = ?
    OR LOWER(
      CONCAT(d0_.version, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.description, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.numero_dossier, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.id_monday, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.contact_name, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.contact_email, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.contact_phone_number, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.contact_mobile_number, '')
    ) LIKE ?
    OR LOWER(
      CONCAT(d0_.item_id_monday, '')
    ) LIKE ?
    OR LOWER(d0_.adresse_livraison) LIKE ?
    OR LOWER(d0_.address) LIKE ?
    OR LOWER(d0_.contact_livraison) LIKE ?
    OR d0_.delivery_fee_manual = ?
    OR LOWER(
      CONCAT(d0_.delivery_fee_note, '')
    ) LIKE ?
    OR d0_.locked_by_userd_id = ?
  )
  AND d0_.id IN (?, ?)
ORDER BY
  d0_.updated_at DESC

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_ WHERE (d0_.id = 5836 OR LOWER(CONCAT(d0_.reference, '')) LIKE '%5836%' OR d0_.total_ht = 5836 OR d0_.remise_commerciale = 5836 OR d0_.remise_en_p100 = 5836 OR LOWER(CONCAT(d0_.version, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.description, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.numero_dossier, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.id_monday, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_name, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_email, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_phone_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.contact_mobile_number, '')) LIKE '%5836%' OR LOWER(CONCAT(d0_.item_id_monday, '')) LIKE '%5836%' OR LOWER(d0_.adresse_livraison) LIKE '%5836%' OR LOWER(d0_.address) LIKE '%5836%' OR LOWER(d0_.contact_livraison) LIKE '%5836%' OR d0_.delivery_fee_manual = 5836 OR LOWER(CONCAT(d0_.delivery_fee_note, '')) LIKE '%5836%' OR d0_.locked_by_userd_id = 5836) AND d0_.id IN (561, 482) ORDER BY d0_.updated_at DESC;

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 (909, 411);

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 = 3;