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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT DISTINCT p0_.id AS id_0, p0_.gamme_id AS sclr_1 FROM produit p0_ LEFT JOIN gamme g1_ ON p0_.gamme_id = g1_.id ORDER BY p0_.gamme_id DESC LIMIT 20
Parameters:
[]
2 0.30 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_ LEFT JOIN gamme g1_ ON p0_.gamme_id = g1_.id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.gamme_id DESC
Parameters:
[
  417
  422
  420
  418
  416
  415
  423
  419
  414
  413
  412
  411
  410
  409
  421
  408
  407
  406
  405
  404
]
3 0.21 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM produit p0_ LEFT JOIN gamme g1_ ON p0_.gamme_id = g1_.id
Parameters:
[]
4 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:
[
  9
]
5 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:
[
  8
]
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:
[
  7
]
7 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
]
8 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:
[
  4
]
9 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
]
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:
[
  2
]
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:
[
  1
]

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.