GET https://pfm.texol.fr/admin/produit?page=1&sort%5Bcode_ean%5D=DESC

Query Metrics

11 Database Queries
4 Different statements
1.77 ms Query time
0 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 0.67 ms
SELECT DISTINCT p0_.id AS id_0, p0_.code_ean AS code_ean_1 FROM produit p0_ ORDER BY p0_.code_ean DESC LIMIT 20
Parameters:
[]
2 0.34 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.description AS description_2, p0_.code_ean AS code_ean_3, p0_.image_name AS image_name_4, p0_.updated_at AS updated_at_5, p0_.couleur_principale AS couleur_principale_6, p0_.couleur_secondaire AS couleur_secondaire_7, p0_.reduction_prix AS reduction_prix_8, p0_.reduction_unite AS reduction_unite_9, p0_.hidden AS hidden_10, p0_.gamme_id AS gamme_id_11, p0_.groupement_id AS groupement_id_12 FROM produit p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.code_ean DESC
Parameters:
[
  410
  409
  411
  412
  408
  414
  423
  422
  417
  419
  413
  406
  403
  415
  416
  420
  407
  405
  418
  404
]
3 0.09 ms
SELECT count(*) AS sclr_0 FROM produit p0_
Parameters:
[]
4 0.12 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.09 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  8
]
8 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  9
]
9 0.10 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  7
]
11 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  5
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Produit 20
App\Entity\Gamme 8
App\Entity\ProduitGroupement 2

Entities Mapping

Class Mapping errors
App\Entity\Produit No errors.
App\Entity\Gamme No errors.
App\Entity\ProduitGroupement No errors.
App\Entity\Operation No errors.