Query Metrics
8
Database Queries
6
Different statements
24.33 ms
Query time
37
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
15.07 ms (61.95%) |
2 |
SELECT DISTINCT( MONTH(c.date_commande)) as mois FROM commande c INNER JOIN lignecommande lc on lc.commande_id = c.id INNER JOIN produit_abonne pa on lc.produitabonne_id = pa.id INNER JOIN produit p on pa.produit_id = p.id INNER JOIN abonne a on pa.abonne_id = a.id WHERE a.id =:abonneId AND YEAR(c.date_commande) =:annee GROUP BY p.nom_produit, MONTH(c.date_commande)
Parameters:
[ ":abonneId" => 94 ":annee" => "2024" ] |
5.76 ms (23.67%) |
1 |
SELECT p0_.id AS id_0, p0_.code_produit AS code_produit_1, p0_.nom_produit AS nom_produit_2, p0_.description_produit AS description_produit_3, p0_.poids_produit AS poids_produit_4, p0_.frais_affecte_produit AS frais_affecte_produit_5, p0_.marge_salariale_produit AS marge_salariale_produit_6, p0_.siSysteme AS siSysteme_7, p0_.siMelange AS siMelange_8, p0_.seuil_produit AS seuil_produit_9, p0_.en_stock_produit AS en_stock_produit_10, p0_.fabricat_produit AS fabricat_produit_11, p0_.date_publication AS date_publication_12, p0_.date_commer AS date_commer_13, p0_.date_modification AS date_modification_14, p0_.id_auteur AS id_auteur_15, p0_.etat_produit AS etat_produit_16, p0_.quantite_detail AS quantite_detail_17, p0_.etat_libelle AS etat_libelle_18, p0_.siEcommerce AS siEcommerce_19, p0_.montanthtAchat AS montanthtAchat_20, p0_.montanthtvente AS montanthtvente_21, p0_.tauxTva AS tauxTva_22, p0_.couleur_produit AS couleur_produit_23, p0_.montantttcvente AS montantttcvente_24, p0_.autretaxe AS autretaxe_25, p0_.si_conditionnement AS si_conditionnement_26, p0_.si_transformation AS si_transformation_27, p0_.si_vendable AS si_vendable_28, p0_.si_semence AS si_semence_29, p0_.rendement AS rendement_30, p0_.si_accueil AS si_accueil_31, p0_.titre_image AS titre_image_32, p0_.code_genere AS code_genere_33, p0_.si_agricole AS si_agricole_34, p0_.si_agricole_parent AS si_agricole_parent_35, p0_.type_saison AS type_saison_36, p0_.si_heritage AS si_heritage_37, p0_.type_qualite AS type_qualite_38, p0_.si_affichage AS si_affichage_39, p0_.url_image AS url_image_40, p0_.action_comptable AS action_comptable_41, p0_.code_barre AS code_barre_42, p0_.melange_id AS melange_id_43, p0_.categorie_id AS categorie_id_44, p0_.produit_id AS produit_id_45, p0_.compte AS compte_46, p0_.produitsysteme_id AS produitsysteme_id_47, p0_.carateristiqueproduit_id AS carateristiqueproduit_id_48, p0_.unite_id AS unite_id_49, p0_.abonne_id AS abonne_id_50 FROM produit p0_ INNER JOIN produit_abonne p1_ ON p0_.id = p1_.produit_id INNER JOIN abonne a2_ ON p1_.abonne_id = a2_.id WHERE p0_.si_agricole = ? AND p0_.si_agricole_parent <> ? AND a2_.id = ?
Parameters:
[ 1 1 94 ] |
1.96 ms (8.07%) |
1 |
SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
23270
]
|
0.97 ms (3.97%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.valeur AS valeur_3, t0.type_donnee AS type_donnee_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.type_param AS type_param_7, t0.affiche AS affiche_8 FROM param t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
2
]
|
0.32 ms (1.32%) |
1 |
SELECT t0.id AS id_1, t0.date_connexion AS date_connexion_2, t0.date_last_action AS date_last_action_3, t0.date_deconnexion AS date_deconnexion_4, t0.adresse_ip AS adresse_ip_5, t0.tab_id_actions AS tab_id_actions_6, t0.tab_date_actions AS tab_date_actions_7, t0.duree_connexion AS duree_connexion_8, t0.utilisateur_id AS utilisateur_id_9 FROM connexion t0 WHERE t0.id = ?
Parameters:
[
7289
]
|
0.25 ms (1.02%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.controleur_id AS controleur_id_4, t0.module_id AS module_id_5, t0.abonne_id AS abonne_id_6 FROM action t0 WHERE t0.nom = ? LIMIT 1
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\param\Param | No errors. |
App\Entity\user\Utilisateur |
|
App\Entity\user\Abonne |
|
App\Entity\stock\Produit |
|
App\Entity\user\Profil |
|
App\Entity\stock\Ville |
|
App\Entity\stock\Entrepot |
|
App\Entity\stock\Caisse |
|
App\Entity\user\Connexion | No errors. |
App\Entity\stock\Commande |
|
App\Entity\stock\Operation |
|
App\Entity\stock\CommandeTmp |
|
App\Entity\stock\Depassement | No errors. |
App\Entity\prod\SurfaceAnnee |
|
App\Entity\stock\SeTrouver | No errors. |
App\Entity\prod\Producteur |
|
App\Entity\inspection\InspectionRempli |
|
App\Entity\stock\Fournisseur |
|
App\Entity\client\Client |
|
App\Entity\stock\InfoTraitement |
|
App\Entity\stock\Transformation |
|
App\Entity\stock\ResultatTraitement | No errors. |
App\Entity\prod\Evenement |
|
App\Entity\prod\ProducteurEvenement |
|
App\Entity\user\HistoriqueAction |
|
App\Entity\user\HistoriqueActionUtilisateur | No errors. |
App\Entity\track\Localisation |
|
App\Entity\stock\Image |
|
App\Entity\user\Action |
|
App\Entity\user\Module |
|
App\Entity\user\Controleur | No errors. |
App\Entity\prod\TacheProduitEtapeCroissance |
|
App\Entity\stock\ProduitAbonne |
|
App\Entity\stock\CategorieProduit |
|
App\Entity\stock\PlanComptable |
|
App\Entity\stock\CarateristiqueProduit |
|
App\Entity\stock\Unite |
|
App\Entity\stock\CaisseProduit |
|
App\Entity\stock\LigneCommande |
|
App\Entity\stock\ImageProduit | No errors. |
App\Entity\stock\FournisseurProduit | No errors. |
App\Entity\stock\TypeProduit |
|
App\Entity\stock\Production |
|
App\Entity\stock\TraiteProduction | No errors. |
App\Entity\stock\PrixRigueur |
|
App\Entity\inspection\InspectionProduit |
|
App\Entity\prod\AnneeCampagne |
|