Query Metrics
6
Database Queries
6
Different statements
1.66 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.30 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_actif AS is_actif_6, t0.last_login AS last_login_7, t0.reset_token AS reset_token_8, t0.prenom AS prenom_9, t0.nom AS nom_10, t0.adresse_email_assistant AS adresse_email_assistant_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.fonction AS fonction_14, t0.secteur AS secteur_15, t0.photo AS photo_16, t0.date_modification AS date_modification_17, t0.email_auth_code AS email_auth_code_18, t0.site_id AS site_id_19, t0.suppleant_commercial_id AS suppleant_commercial_id_20 FROM utilisateur_back t0 WHERE t0.id = ?
Parameters:
[
71
]
|
| 2 | 0.37 ms |
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.contenu_html AS contenu_html_2, f0_.image AS image_3, f0_.fichier_pdf AS fichier_pdf_4, f0_.fichier_html AS fichier_html_5, f0_.is_actif AS is_actif_6, f0_.lft AS lft_7, f0_.lvl AS lvl_8, f0_.rgt AS rgt_9, f0_.date_modification AS date_modification_10, f0_.icone AS icone_11, f0_.is_stock_visible_fo AS is_stock_visible_fo_12, f0_.icone_rose AS icone_rose_13, f0_.parent_id AS parent_id_14, f0_.famille_erp_id AS famille_erp_id_15 FROM famille_article f0_ WHERE f0_.lvl = ? ORDER BY f0_.libelle ASC
Parameters:
[
0
]
|
| 3 | 0.31 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM produit p0_ LEFT JOIN famille_article f1_ ON p0_.famille_id = f1_.id LEFT JOIN fournisseur f2_ ON p0_.fournisseur_id = f2_.id WHERE p0_.is_delete = 0 OR p0_.is_delete IS NULL
Parameters:
[] |
| 4 | 0.19 ms |
SELECT DISTINCT p0_.id AS id_0 FROM produit p0_ LEFT JOIN famille_article f1_ ON p0_.famille_id = f1_.id LEFT JOIN fournisseur f2_ ON p0_.fournisseur_id = f2_.id WHERE p0_.is_delete = 0 OR p0_.is_delete IS NULL LIMIT 15
Parameters:
[] |
| 5 | 0.26 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_actif AS is_actif_6, t0.last_login AS last_login_7, t0.reset_token AS reset_token_8, t0.prenom AS prenom_9, t0.nom AS nom_10, t0.adresse_email_assistant AS adresse_email_assistant_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.fonction AS fonction_14, t0.secteur AS secteur_15, t0.photo AS photo_16, t0.date_modification AS date_modification_17, t0.email_auth_code AS email_auth_code_18, t0.site_id AS site_id_19, t0.suppleant_commercial_id AS suppleant_commercial_id_20 FROM utilisateur_back t0 WHERE t0.suppleant_commercial_id = ?
Parameters:
[
71
]
|
| 6 | 0.23 ms |
SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ LEFT JOIN utilisateur u1_ ON t0_.utilisateur_id = u1_.id LEFT JOIN client c2_ ON u1_.client_id = c2_.id LEFT JOIN client_adresse c3_ ON c2_.id = c3_.client_id WHERE t0_.statut = ?
Parameters:
[
"en_attente_reponse"
]
|
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\UtilisateurBack | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\ClientAdresse | No errors. |
| App\Entity\TicketMessage | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\ProduitSpecifique | No errors. |
| App\Entity\Famille | No errors. |
| App\Entity\FamilleEvenement | No errors. |
| App\Entity\Fournisseur | No errors. |
| App\Entity\ClientCatalogueExclu | No errors. |
| App\Entity\DevisDemandeAchat | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\ClientEvenement | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\ClientProfilEvenement | No errors. |
| App\Entity\OffresProchilab | No errors. |
| App\Entity\ProduitLot | No errors. |
| App\Entity\TauxTva | No errors. |
| App\Entity\ConfigurationGenerale | No errors. |
| App\Entity\Utilisateur | No errors. |
| App\Entity\EvenementProduit | No errors. |
| App\Entity\CategorisationArticleValeur | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\ContenuSpecifique | No errors. |
| App\Entity\FamilleErp | No errors. |
| App\Entity\ClientRemiseFamille | No errors. |