GET https://confection-mada.fr/

Query Metrics

23 Database Queries
12 Different statements
21.46 ms Query time
0 Invalid entities
38 Managed entities

Grouped Statements

Show all queries

Time Count Info
7.17 ms
(33.43%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.metadescription AS metadescription_6, t0.metakeyword AS metakeyword_7, t0.slug AS slug_8, t0.price AS price_9, t0.flag AS flag_10 FROM produit t0 INNER JOIN produit_category ON t0.id = produit_category.produit_id WHERE produit_category.category_id = ?
Parameters:
[
  29
]
2.85 ms
(13.27%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN produit_category ON t0.id = produit_category.category_id WHERE produit_category.produit_id = ?
Parameters:
[
  141
]
2.80 ms
(13.06%)
3
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.image AS image_3, p0_.created_at AS created_at_4, p0_.metadescription AS metadescription_5, p0_.metakeyword AS metakeyword_6, p0_.slug AS slug_7, p0_.price AS price_8, p0_.flag AS flag_9 FROM produit p0_ WHERE p0_.flag = ? ORDER BY p0_.created_at DESC
Parameters:
[
  "Nouveaute"
]
2.40 ms
(11.19%)
1
SELECT d0_.id AS id_0, d0_.objet AS objet_1, d0_.value AS value_2, d0_.end_date AS end_date_3, d0_.image AS image_4, d0_.created_at AS created_at_5 FROM discount d0_ ORDER BY d0_.id DESC LIMIT 1
Parameters:
[]
1.90 ms
(8.84%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.telephone AS telephone_5, t0.email AS email_6, t0.whatsapp AS whatsapp_7, t0.instagram AS instagram_8, t0.facebook AS facebook_9, t0.linkedin AS linkedin_10, t0.tiktok AS tiktok_11, t0.logo AS logo_12, t0.icon AS icon_13, t0.responsable AS responsable_14 FROM shop t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
1.08 ms
(5.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0
Parameters:
[]
0.63 ms
(2.96%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.created_at AS created_at_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ ORDER BY c0_.id DESC LIMIT 1
Parameters:
[]
0.60 ms
(2.82%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.is_read = ?
Parameters:
[
  0
]
0.58 ms
(2.71%)
1
SELECT COUNT(a0_.id) AS sclr_0 FROM admin_activity a0_ WHERE a0_.is_read = ?
Parameters:
[
  0
]
0.50 ms
(2.33%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.description AS description_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Slides"
]
0.47 ms
(2.19%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.created_at AS created_at_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ ORDER BY c0_.id DESC LIMIT 5
Parameters:
[]
0.46 ms
(2.16%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.image AS image_3, p0_.created_at AS created_at_4, p0_.metadescription AS metadescription_5, p0_.metakeyword AS metakeyword_6, p0_.slug AS slug_7, p0_.price AS price_8, p0_.flag AS flag_9 FROM produit p0_ ORDER BY p0_.created_at DESC LIMIT 8
Parameters:
[]

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\Produit 30
App\Entity\Produit\Category 6
App\Entity\Discount\Discount 1
App\Entity\Shop\Shop 1

Entities Mapping