https://pprod.multilabo.com/admin/produit/

Query Metrics

6 Database Queries
6 Different statements
1.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.