GET https://pfm.texol.fr/admin/gamme

Query Metrics

11 Database Queries
4 Different statements
2.19 ms Query time
0 Invalid entities
31 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT DISTINCT g0_.id AS id_0 FROM gamme g0_ LIMIT 20
Parameters:
[]
2 0.23 ms
SELECT g0_.id AS id_0, g0_.titre AS titre_1, g0_.couleur_principale AS couleur_principale_2, g0_.couleur_secondaire AS couleur_secondaire_3, g0_.couleur_bordure AS couleur_bordure_4 FROM gamme g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  7
  8
  9
]
3 0.14 ms
SELECT count(*) AS sclr_0 FROM gamme g0_
Parameters:
[]
4 0.22 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  1
]
5 0.17 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  2
]
6 0.16 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  3
]
7 0.16 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  4
]
8 0.15 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  5
]
9 0.14 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  7
]
10 0.15 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  8
]
11 0.14 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 WHERE t0.gamme_id = ?
Parameters:
[
  9
]

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 21
App\Entity\Gamme 8
App\Entity\ProduitGroupement 2

Entities Mapping

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