Query Metrics
7
Database Queries
7
Different statements
7.79 ms
Query time
25
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.10 ms (26.96%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_base_abonne AS code_base_abonne_3, t0.email_abonne AS email_abonne_4, t0.tel1_abonne AS tel1_abonne_5, t0.tel2_abonne AS tel2_abonne_6, t0.adresse_abonne AS adresse_abonne_7, t0.description_abonne AS description_abonne_8, t0.etat_abonne AS etat_abonne_9, t0.siExploitation AS siExploitation_10, t0.si_principale AS si_principale_11, t0.type_action_abonne AS type_action_abonne_12, t0.adresse_web AS adresse_web_13, t0.date_ajout_abonne AS date_ajout_abonne_14, t0.date_edit_abonne AS date_edit_abonne_15, t0.titre_image AS titre_image_16, t0.url_image AS url_image_17, t0.type_presentation AS type_presentation_18, t0.langue AS langue_19, t0.configuration AS configuration_20, t0.type_abonne_id AS type_abonne_id_21, t0.template_id AS template_id_22, t0.partenaire_id AS partenaire_id_23, t0.devise_id AS devise_id_24, t0.pays_id AS pays_id_25 FROM abonne t0 WHERE t0.adresse_web = ? LIMIT 1
Parameters:
[
"monpoulet.coo.tg"
]
|
1.49 ms (19.08%) |
1 |
SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, p0_.code_genere AS code_genere_3, p0_.montanthtAchat AS montanthtAchat_4, p0_.description_produit AS description_produit_5, c2_.id AS id_6, p0_.code_genere AS code_genere_7, p0_.code_barre AS code_barre_8, c2_.type_categorie AS type_categorie_9, p0_.si_agricole AS si_agricole_10, p0_.si_agricole_parent AS si_agricole_parent_11, p0_.en_stock_produit AS en_stock_produit_12, p0_.si_semence AS si_semence_13, i3_.url_image AS url_image_14, d4_.libelle AS libelle_15 FROM produit p0_ INNER JOIN categorieproduit c2_ ON p0_.categorie_id = c2_.id INNER JOIN abonne a5_ ON p0_.abonne_id = a5_.id INNER JOIN devise d4_ ON a5_.devise_id = d4_.id INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id INNER JOIN image i3_ ON p0_.id = i3_.produit_id WHERE 1 = 1 AND p1_.etat_prix = 1 AND p0_.siEcommerce = 1 AND a5_.id = ? AND p0_.code_genere = ?
Parameters:
[ 67 "PR1498976508" ] |
1.06 ms (13.56%) |
1 |
SELECT p0_.id AS id_0, p1_.id AS id_1, p0_.nom_produit AS nom_produit_2, p1_.nom_produit AS nom_produit_3 FROM produit p0_ INNER JOIN carateristique_produit c2_ ON p0_.id = c2_.produit_id INNER JOIN produit p1_ ON c2_.produitparent_id = p1_.id INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id INNER JOIN categorieproduit c4_ ON p1_.categorie_id = c4_.id WHERE 1 = 1 AND p0_.etat_produit <> 2 AND p0_.id = ? AND a3_.id = ? ORDER BY p0_.nom_produit ASC
Parameters:
[ 2517 67 ] |
1.01 ms (13.01%) |
1 |
SELECT t0.id AS id_1, t0.code_produit AS code_produit_2, t0.nom_produit AS nom_produit_3, t0.description_produit AS description_produit_4, t0.poids_produit AS poids_produit_5, t0.frais_affecte_produit AS frais_affecte_produit_6, t0.marge_salariale_produit AS marge_salariale_produit_7, t0.siSysteme AS siSysteme_8, t0.siMelange AS siMelange_9, t0.seuil_produit AS seuil_produit_10, t0.en_stock_produit AS en_stock_produit_11, t0.fabricat_produit AS fabricat_produit_12, t0.date_publication AS date_publication_13, t0.date_commer AS date_commer_14, t0.date_modification AS date_modification_15, t0.id_auteur AS id_auteur_16, t0.etat_produit AS etat_produit_17, t0.quantite_detail AS quantite_detail_18, t0.etat_libelle AS etat_libelle_19, t0.siEcommerce AS siEcommerce_20, t0.montanthtAchat AS montanthtAchat_21, t0.montanthtvente AS montanthtvente_22, t0.tauxTva AS tauxTva_23, t0.couleur_produit AS couleur_produit_24, t0.montantttcvente AS montantttcvente_25, t0.autretaxe AS autretaxe_26, t0.si_conditionnement AS si_conditionnement_27, t0.si_transformation AS si_transformation_28, t0.si_vendable AS si_vendable_29, t0.si_semence AS si_semence_30, t0.rendement AS rendement_31, t0.si_accueil AS si_accueil_32, t0.titre_image AS titre_image_33, t0.code_genere AS code_genere_34, t0.si_agricole AS si_agricole_35, t0.si_agricole_parent AS si_agricole_parent_36, t0.type_saison AS type_saison_37, t0.type_qualite AS type_qualite_38, t0.si_affichage AS si_affichage_39, t0.url_image AS url_image_40, t0.action_comptable AS action_comptable_41, t0.code_barre AS code_barre_42, t0.melange_id AS melange_id_43, t0.categorie_id AS categorie_id_44, t0.produit_id AS produit_id_45, t0.compte AS compte_46, t0.produitsysteme_id AS produitsysteme_id_47, t0.carateristiqueproduit_id AS carateristiqueproduit_id_48, t0.unite_id AS unite_id_49, t0.abonne_id AS abonne_id_50 FROM produit t0 WHERE t0.abonne_id = ? AND t0.id = ? LIMIT 1
Parameters:
[ 67 "2517" ] |
0.97 ms (12.48%) |
1 |
SELECT DISTINCT c0_.id AS id_0, p1_.id AS id_1, p1_.info_prix AS info_prix_2, c0_.libelle AS libelle_3, p2_.id AS id_4 FROM prix_rigueur p1_ LEFT JOIN caracteristique_prix c0_ ON p1_.caracteristique_prix_id = c0_.id INNER JOIN produit p2_ ON p1_.produit_id = p2_.id INNER JOIN abonne a3_ ON p1_.abonne_id = a3_.id WHERE a3_.id = ? AND p1_.etat_prix <> ? AND p2_.id = ?
Parameters:
[ 67 2 2517 ] |
0.85 ms (10.94%) |
1 |
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.datePublication AS datePublication_2, m0_.contenuMenu AS contenuMenu_3, m0_.type_menu AS type_menu_4, m0_.etat_menu AS etat_menu_5, m0_.classHtmlMenu AS classHtmlMenu_6, m0_.ordre AS ordre_7, m0_.abonne_id AS abonne_id_8, m0_.menu_id AS menu_id_9 FROM menu m0_ INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id WHERE m0_.etat_menu = 1 AND a1_.id = 67 ORDER BY m0_.ordre ASC
Parameters:
[] |
0.31 ms (3.96%) |
1 |
SELECT t0.id AS id_1, t0.titre_image AS titre_image_2, t0.titre_template AS titre_template_3, t0.nom_dossier_template AS nom_dossier_template_4, t0.description_template AS description_template_5, t0.etat_template AS etat_template_6, t0.date_ajout_template AS date_ajout_template_7, t0.abonne_id AS abonne_id_8 FROM template t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\stock\InfoLivrer |
|
App\Entity\prod\SurfaceAnneeHistorique |
|
App\Entity\prod\Producteur |
|
App\Entity\cms\Menu |
|
App\Entity\stock\PrixRigueur |
|
App\Entity\user\TypeAbonne | No errors. |
App\Entity\cms\Template |
|
App\Entity\user\Partenaire | No errors. |
App\Entity\stock\Devise | No errors. |
App\Entity\stock\Pays | No errors. |
App\Entity\stock\CategorieProduit |
|
App\Entity\stock\PlanComptable |
|
App\Entity\stock\CarateristiqueProduit |
|
App\Entity\stock\Unite |
|
App\Entity\stock\CaisseProduit |
|
App\Entity\stock\ProduitAbonne |
|
App\Entity\stock\LigneCommande |
|
App\Entity\stock\ImageProduit | No errors. |
App\Entity\stock\Image |
|
App\Entity\stock\FournisseurProduit | No errors. |
App\Entity\stock\TypeProduit |
|
App\Entity\stock\Production |
|
App\Entity\stock\TraiteProduction | No errors. |
App\Entity\inspection\InspectionProduit |
|
App\Entity\prod\AnneeCampagne |
|
App\Entity\prod\SurfaceAnnee |
|
App\Entity\stock\InfoTraitement |
|
App\Entity\cms\Page |
|
App\Entity\stock\CaracteristiquePrix |
|