GET https://app-test.fr/composition

Query Metrics

67 Database Queries
6 Different statements
58.14 ms Query time
3 Invalid entities
4930 Managed entities

Queries

Group similar statements

# Time Info
1 0.78 ms
SELECT t0.id AS id_1, t0.produit_reference AS produit_reference_2, t0.is_active_produit AS is_active_produit_3, t0.is_coupure_produit AS is_coupure_produit_4, t0.is_in_active_produit AS is_in_active_produit_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.is_bouquet AS is_bouquet_8, t0.produit_id AS produit_id_9 FROM association t0 WHERE t0.is_bouquet = ?
Parameters:
[
  1
]
2 4.85 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
Parameters:
[]
3 2.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
Parameters:
[]
4 2.65 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
Parameters:
[]
5 1.04 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  3429
]
6 1.12 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  188
]
7 0.88 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  84
]
8 0.90 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  188
]
9 0.72 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  382
]
10 0.66 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  64
]
11 0.68 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  382
]
12 0.83 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  187
]
13 0.63 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  187
]
14 0.68 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  186
]
15 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  186
]
16 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  108
]
17 0.60 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  57
]
18 0.60 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  108
]
19 0.62 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  4414
]
20 0.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  255
]
21 0.68 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  68
]
22 0.61 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  255
]
23 0.65 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  166
]
24 0.61 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  166
]
25 0.74 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  167
]
26 0.81 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  167
]
27 0.85 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  164
]
28 0.77 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  164
]
29 0.84 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  158
]
30 0.66 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  158
]
31 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  147
]
32 0.62 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  74
]
33 0.56 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  147
]
34 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  148
]
35 0.56 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  148
]
36 0.63 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  150
]
37 0.62 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  79
]
38 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  150
]
39 1.03 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  104
]
40 0.91 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  104
]
41 0.84 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  149
]
42 0.77 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  149
]
43 0.95 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  105
]
44 0.79 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  75
]
45 0.72 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  105
]
46 0.68 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  4415
]
47 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  362
]
48 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  108
]
49 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  362
]
50 0.82 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  194
]
51 0.61 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  194
]
52 0.63 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  4416
]
53 0.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  165
]
54 0.83 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  165
]
55 0.76 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  140
]
56 0.65 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  140
]
57 0.76 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  373
]
58 0.79 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  73
]
59 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  373
]
60 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  109
]
61 0.81 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  109
]
62 0.64 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  4418
]
63 0.76 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  202
]
64 0.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  202
]
65 1.02 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  236
]
66 0.82 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  91
]
67 0.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  236
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MouvementWeb 4842
App\Entity\Qt 44
App\Entity\Composant 24
App\Entity\Fournisseur 10
App\Entity\Association 5
App\Entity\Produit 5

Entities Mapping

Class Mapping errors
App\Entity\Association No errors.
App\Entity\Produit No errors.
App\Entity\Qt No errors.
App\Entity\Composant
  • The mappings App\Entity\Composant#fournisseurs and App\Entity\Fournisseur#composants are inconsistent with each other.
  • The field App\Entity\Composant#qt is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Qt#composants does not contain the required 'mappedBy="qt"' attribute.
  • If association App\Entity\Composant#qt is many-to-one, then the inversed side App\Entity\Qt#composants has to be one-to-many.
  • The association App\Entity\Composant#commande refers to the inverse side field App\Entity\Commande#countCommande which does not exist.
App\Entity\MouvementWeb No errors.
App\Entity\MouvementTransporteur No errors.
App\Entity\MouvementWebAccessoires No errors.
App\Entity\Fournisseur
  • The association App\Entity\Fournisseur#composants refers to the owning side field App\Entity\Composant#fournisseur which does not exist.
  • The association App\Entity\Fournisseur#commandes refers to the owning side field App\Entity\Commande#fournisseur which does not exist.
  • The association App\Entity\Fournisseur#qtCommandes refers to the owning side field App\Entity\QtCommande#fournisseur which does not exist.
App\Entity\Commande
  • The mappings App\Entity\Commande#fournisseurs and App\Entity\Fournisseur#commandes are inconsistent with each other.
App\Entity\QtCommande No errors.
App\Entity\Mouvement No errors.
App\Entity\SousComposants No errors.