GET https://confection-mada.fr/

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
7.17 ms
(28.45%)
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:
[]
4.77 ms
(18.91%)
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
]
3.91 ms
(15.49%)
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
]
1.87 ms
(7.43%)
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"
]
1.67 ms
(6.63%)
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.37 ms
(5.44%)
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:
[]
1.05 ms
(4.15%)
1
SELECT COUNT(a0_.id) AS sclr_0 FROM admin_activity a0_ WHERE a0_.is_read = ?
Parameters:
[
  0
]
0.96 ms
(3.80%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ WHERE m0_.is_read = ?
Parameters:
[
  0
]
0.81 ms
(3.19%)
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:
[]
0.62 ms
(2.46%)
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.60 ms
(2.37%)
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.42 ms
(1.67%)
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:
[]

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