Redirect 302 redirect from POST @admin_arc_validate (487510)

GET https://pciservice.fr/admin/devis

Query Metrics

26 Database Queries
7 Different statements
15.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.94 ms
(81.41%)
20
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 = ?
Parameters:
[
  139
]
0.65 ms
(4.11%)
1
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_.compte_commercial_id AS compte_commercial_id_17 FROM devis d0_ WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.updated_at DESC
Parameters:
[
  139
  138
  137
  136
  135
  57
  134
  133
  132
  131
  130
  129
  128
  127
  125
  126
  124
  123
  122
  121
]
0.57 ms
(3.57%)
1
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 FROM compte_commerciaux t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1002
  996
  985
  793
  802
  152
  784
  978
  694
  806
  987
  1005
  785
]
0.51 ms
(3.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_valid AS is_valid_6 FROM customer t0
Parameters:
[]
0.44 ms
(2.77%)
1
SELECT DISTINCT d0_.id AS id_0, d0_.updated_at AS updated_at_1 FROM devis d0_ ORDER BY d0_.updated_at DESC LIMIT 20
Parameters:
[]
0.41 ms
(2.60%)
1
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 = ?
Parameters:
[
  9
]
0.37 ms
(2.30%)
1
SELECT count(*) AS sclr_0 FROM devis d0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Devis No errors.
App\Entity\CompteCommerciaux No errors.
App\Entity\DevisLigne No errors.
App\Entity\BonDeLivraison No errors.
App\Entity\Article No errors.
App\Entity\CoeffPrix No errors.
App\Entity\BonDeLivraisonLigne No errors.
App\Entity\Customer No errors.