GET http://suntravelsetservices.net/public/admin/produit?page=1&sort%5Bdescription%5D=DESC

Query Metrics

23 Database Queries
7 Different statements
11.85 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT DISTINCT p0_.id AS id_0, p0_.description AS description_1 FROM produit p0_ ORDER BY p0_.description DESC LIMIT 20
Parameters:
[]
2 0.74 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.description AS description_2, p0_.contenu AS contenu_3, p0_.is_active AS is_active_4, p0_.pays_id AS pays_id_5, p0_.type_id AS type_id_6 FROM produit p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.description DESC
Parameters:
[
  1
  2
  3
  4
  5
  6
]
3 0.99 ms
SELECT count(*) AS sclr_0 FROM produit p0_
Parameters:
[]
4 0.55 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  7
]
5 1.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  22
]
6 0.60 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  1
]
7 0.57 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  1
]
8 0.46 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.41 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  2
]
10 0.47 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  2
]
11 0.46 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  2
]
12 0.43 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.47 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  3
]
14 0.45 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  3
]
15 0.50 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
16 0.48 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  4
]
17 0.44 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  4
]
18 0.32 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
19 0.32 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  5
]
20 0.30 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  5
]
21 0.34 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contentu AS contentu_4 FROM produit_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 0.55 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.contenu AS contenu_4, t0.produit_id AS produit_id_5 FROM produit_section t0 WHERE t0.produit_id = ?
Parameters:
[
  6
]
23 0.28 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0.produit_id = ?
Parameters:
[
  6
]

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\ProduitSection 13
App\Entity\ProduitPhoto 7
App\Entity\Produit 6
App\Entity\ProduitType 6
App\Entity\Pays 2

Entities Mapping

Class Mapping errors
App\Entity\Produit No errors.
App\Entity\Pays No errors.
App\Entity\ProduitType No errors.
App\Entity\ProduitPhoto No errors.
App\Entity\ProduitSection No errors.
App\Entity\Commande No errors.