Query Metrics
3
Database Queries
3
Different statements
144.34 ms
Query time
25
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
85.11 ms (58.96%) |
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.username_user = ? LIMIT 1
Parameters:
[
"alagunes"
]
|
53.58 ms (37.12%) |
1 |
SELECT l0_.id AS id_0, l0_.latitude AS latitude_1, l0_.longitude AS longitude_2, l0_.type_localisation AS type_localisation_3, l0_.code_genere AS code_genere_4, s1_.code_genere AS code_genere_5, 0 AS sclr_6, 3 AS sclr_7, u2_.nom_user AS nom_user_8, u2_.prenoms_user AS prenoms_user_9, l0_.tab_polygone AS tab_polygone_10 FROM localisation l0_ INNER JOIN surface_annee s1_ ON l0_.surfaceannee_id = s1_.id INNER JOIN producteur p3_ ON s1_.producteur_id = p3_.id INNER JOIN utilisateur u2_ ON p3_.utilisateur_id = u2_.id INNER JOIN producteur_abonne p4_ ON p3_.id = p4_.producteur_id INNER JOIN abonne a5_ ON p4_.abonne_id = a5_.id INNER JOIN zone_producteur z6_ ON p3_.id = z6_.producteur_id LEFT JOIN ville v7_ ON z6_.ville_id = v7_.id WHERE 1 = 1 AND p3_.etat_prod <> ? AND s1_.etat_surface_annee <> ? AND a5_.id = ? ORDER BY p3_.id DESC
Parameters:
[ 2 2 "94" ] |
5.65 ms (3.91%) |
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.id = ?
Parameters:
[
94
]
|
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\Utilisateur |
|
App\Entity\user\Profil |
|
App\Entity\stock\Ville |
|
App\Entity\stock\Entrepot |
|
App\Entity\stock\Caisse |
|
App\Entity\user\Abonne |
|
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\client\EtatClient | No errors. |
App\Entity\stock\Image |
|
App\Entity\prod\Certification |
|
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\prod\ProducteurAbonne |
|
App\Entity\stock\ZoneProducteur |
|