Query Metrics
14
Database Queries
14
Different statements
3.73 ms
Query time
9
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.89 ms (23.86%) |
1 |
SELECT s0_.id AS id_0, s0_.produit_en_gestion AS produit_en_gestion_1, s0_.numero AS numero_2, s0_.hscode AS hscode_3, s0_.donneur_d_ordre AS donneur_d_ordre_4, s0_.stock AS stock_5, s0_.tc AS tc_6, s0_.nom_scientifique AS nom_scientifique_7, s0_.origine AS origine_8, s0_.certification AS certification_9, s0_.idea_scoring AS idea_scoring_10, s0_.prod_annuelle AS prod_annuelle_11, s0_.crit_org AS crit_org_12, s0_.crit_ph AS crit_ph_13, s0_.crit_mic AS crit_mic_14, s0_.concervation AS concervation_15, s0_.domaine_d_utilisation AS domaine_d_utilisation_16, s0_.type_marq_ut AS type_marq_ut_17, s0_.type_marq_colis AS type_marq_colis_18, s0_.localisation_ut AS localisation_ut_19, s0_.localisation_colis AS localisation_colis_20, s0_.signification_marq_ut AS signification_marq_ut_21, s0_.signification_marq_colis AS signification_marq_colis_22, s0_.presentation AS presentation_23, s0_.nature_emballage AS nature_emballage_24, s0_.dimenssion AS dimenssion_25, s0_.poids_emballage AS poids_emballage_26, s0_.poids_fixe_ou_variable AS poids_fixe_ou_variable_27, s0_.poids_net AS poids_net_28, s0_.sous_emballage1 AS sous_emballage1_29, s0_.sous_emballage2 AS sous_emballage2_30, s0_.sous_emballage3 AS sous_emballage3_31, s0_.sous_emballage4 AS sous_emballage4_32, s0_.sous_emballage5 AS sous_emballage5_33, s0_.sous_emballage6 AS sous_emballage6_34, s0_.nombre_de_colis_par_couche AS nombre_de_colis_par_couche_35, s0_.nombre_de_couche_par_palette AS nombre_de_couche_par_palette_36, s0_.nombre_de_colis_par_palette AS nombre_de_colis_par_palette_37, s0_.nombre_d_unite_par_palette AS nombre_d_unite_par_palette_38, s0_.dimension_palette AS dimension_palette_39, s0_.poids_net_palette AS poids_net_palette_40, s0_.created_at AS created_at_41, s0_.px_spot AS px_spot_42, s0_.unite4 AS unite4_43, s0_.vol_disp AS vol_disp_44, s0_.qt_min AS qt_min_45, s0_.mandat_id AS mandat_id_46, s0_.filiere_id AS filiere_id_47, s0_.qualite_id AS qualite_id_48, s0_.qt_min_unite_id AS qt_min_unite_id_49, s0_.unite2_id AS unite2_id_50, s0_.unite1_id AS unite1_id_51, s0_.niveau_id AS niveau_id_52, s0_.unite3_id AS unite3_id_53, s0_.status_id AS status_id_54, s0_.stade_id AS stade_id_55 FROM sous_jacent s0_
Parameters:
[] |
0.45 ms (12.01%) |
1 |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.code AS code_2, a0_.raison AS raison_3, a0_.identifiant AS identifiant_4, a0_.adresse AS adresse_5, a0_.cp AS cp_6, a0_.tel AS tel_7, a0_.email AS email_8, a0_.dirigeant AS dirigeant_9, a0_.fonction AS fonction_10, a0_.produit AS produit_11, a0_.capacite AS capacite_12, a0_.prix_fob AS prix_fob_13, a0_.ut AS ut_14, a0_.certification AS certification_15, a0_.mode_reglement AS mode_reglement_16, a0_.banque AS banque_17, a0_.banque_adresse AS banque_adresse_18, a0_.code_swift AS code_swift_19, a0_.iban AS iban_20, a0_.num_compte AS num_compte_21, a0_.titulaire_compte AS titulaire_compte_22, a0_.gestionnaire_compte AS gestionnaire_compte_23, a0_.date_d AS date_d_24, a0_.tc AS tc_25, a0_.numero AS numero_26, a0_.pays AS pays_27, a0_.ville AS ville_28, a0_.website AS website_29, a0_.produit1 AS produit1_30, a0_.produit2 AS produit2_31, a0_.produit3 AS produit3_32, a0_.capacite1 AS capacite1_33, a0_.capacite2 AS capacite2_34, a0_.capacite3 AS capacite3_35, a0_.evaluation AS evaluation_36, a0_.prix_fob1 AS prix_fob1_37, a0_.prix_fob2 AS prix_fob2_38, a0_.prix_fob3 AS prix_fob3_39, a0_.certification1 AS certification1_40, a0_.certification2 AS certification2_41, a0_.certification3 AS certification3_42, a0_.gestionnaire_email AS gestionnaire_email_43, a0_.ut1 AS ut1_44, a0_.ut2 AS ut2_45, a0_.ut3 AS ut3_46, a0_.created_at AS created_at_47, a0_.envoi_echantillon AS envoi_echantillon_48, a0_.autres AS autres_49, a0_.activite AS activite_50, a0_.couriel AS couriel_51, a0_.port AS port_52, a0_.description AS description_53, a0_.referent AS referent_54, a0_.origine_dest AS origine_dest_55, a0_.spot_target AS spot_target_56, a0_.quantite_contactuelle AS quantite_contactuelle_57, a0_.lead_id AS lead_id_58, a0_.suivi_par_id AS suivi_par_id_59, a0_.devise_id AS devise_id_60, a0_.unite_id AS unite_id_61, a0_.sous_jacent_id AS sous_jacent_id_62, a0_.filiere_id AS filiere_id_63, a0_.sous_jacent1_id AS sous_jacent1_id_64, a0_.sous_jacent2_id AS sous_jacent2_id_65, a0_.niveau_id AS niveau_id_66, a0_.status_id AS status_id_67, a0_.base_id AS base_id_68, a0_.filiere1_id AS filiere1_id_69, a0_.filiere2_id AS filiere2_id_70, a0_.filiere3_id AS filiere3_id_71, a0_.duree_id AS duree_id_72, a0_.position_id AS position_id_73, a0_.nature_contrat_id AS nature_contrat_id_74 FROM admin_donneur_ordre a0_ INNER JOIN position p1_ ON a0_.position_id = p1_.id WHERE p1_.name = ?
Parameters:
[
"Vendeur"
]
|
0.39 ms (10.32%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.niveau AS niveau_4, t0.name AS name_5, t0.matricule AS matricule_6, t0.roles AS roles_7, t0.email_pro AS email_pro_8, t0.fonction AS fonction_9, t0.entry_at AS entry_at_10, t0.prenoms AS prenoms_11, t0.date_sortie AS date_sortie_12, t0.status_id AS status_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
17
]
|
0.38 ms (10.21%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.created_at AS created_at_3 FROM emballage e0_
Parameters:
[] |
0.29 ms (7.88%) |
1 |
SELECT u0_.id AS id_0, u0_.nom AS nom_1, u0_.description AS description_2 FROM unite u0_
Parameters:
[] |
0.26 ms (7.08%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.created_at AS created_at_3 FROM conditionnement c0_
Parameters:
[] |
0.26 ms (6.97%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.description AS description_3 FROM payment_method p0_
Parameters:
[] |
0.26 ms (6.89%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2 FROM devise d0_
Parameters:
[] |
0.18 ms (4.93%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.niveau AS niveau_3, u0_.name AS name_4, u0_.matricule AS matricule_5, u0_.roles AS roles_6, u0_.email_pro AS email_pro_7, u0_.fonction AS fonction_8, u0_.entry_at AS entry_at_9, u0_.prenoms AS prenoms_10, u0_.date_sortie AS date_sortie_11, u0_.status_id AS status_id_12 FROM user u0_
Parameters:
[] |
0.08 ms (2.25%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.formulaire AS formulaire_2, s0_.description AS description_3 FROM status s0_ WHERE LOWER(s0_.formulaire) LIKE ?
Parameters:
[
"%intention%achat%"
]
|
0.08 ms (2.09%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.created_at AS created_at_3 FROM exigence e0_
Parameters:
[] |
0.07 ms (1.99%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2 FROM products p0_
Parameters:
[] |
0.07 ms (1.82%) |
1 |
SELECT n0_.id AS id_0, n0_.niveau AS niveau_1, n0_.created_at AS created_at_2, n0_.description AS description_3 FROM niveau n0_
Parameters:
[] |
0.06 ms (1.69%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.niveau AS niveau_3, u0_.name AS name_4, u0_.matricule AS matricule_5, u0_.roles AS roles_6, u0_.email_pro AS email_pro_7, u0_.fonction AS fonction_8, u0_.entry_at AS entry_at_9, u0_.prenoms AS prenoms_10, u0_.date_sortie AS date_sortie_11, u0_.status_id AS status_id_12 FROM user u0_ INNER JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u1_.name = ?
Parameters:
[
"Autorisé"
]
|
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 |
|
App\Entity\UserStatus | No errors. |
App\Entity\PlaceDeMarche | No errors. |
App\Entity\TraitementDsDemdDachat | No errors. |
App\Entity\AdminDonneurOrdre |
|
App\Entity\LeveeDeFond | No errors. |
App\Entity\LetterOfIntentToPurchase |
|
App\Entity\Document | No errors. |
App\Entity\DemandeDeCotation | No errors. |
App\Entity\Prospect | No errors. |
App\Entity\RequeteDeFinancement | No errors. |
App\Entity\Visiteur | No errors. |
App\Entity\Abonne | No errors. |
App\Entity\Position | No errors. |
App\Entity\Devise | No errors. |
App\Entity\Unite | No errors. |
App\Entity\SousJacent |
|
App\Entity\Products | No errors. |
App\Entity\Niveau | No errors. |
App\Entity\Status | No errors. |
App\Entity\Incoterm |
|
App\Entity\Duree | No errors. |
App\Entity\NatureContrat | No errors. |
App\Entity\OperationDeCourtage | No errors. |
App\Entity\Appariement |
|
App\Entity\Quotation |
|
App\Entity\Transaction |
|
App\Entity\Operation | No errors. |
App\Entity\FraisDeCourtage | No errors. |
App\Entity\Emballage | No errors. |
App\Entity\Conditionnement | No errors. |
App\Entity\PaymentMethod | No errors. |
App\Entity\Exigence | No errors. |
App\Entity\Qualite | No errors. |
App\Entity\Stade |
|
App\Entity\AppelDeMarge | No errors. |
App\Entity\MatPremiere | No errors. |