GET https://shop.lanig-simon.fr/

Query Metrics

27 Database Queries
8 Different statements
13.16 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.98 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.creation_date AS creation_date_2, p0_.modification_date AS modification_date_3 FROM product_category p0_
Parameters:
[]
2 1.28 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.description AS description_3, p0_.image_filename AS image_filename_4, p0_.creation_date AS creation_date_5, p0_.modification_date AS modification_date_6, p0_.category_id AS category_id_7 FROM product p0_ ORDER BY p0_.price ASC
Parameters:
[]
3 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM product_category t0
Parameters:
[]
4 1.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "logo_icon"
]
5 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "background_image"
]
6 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "background_color"
]
7 0.73 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.menu = ? ORDER BY t0.display_order ASC
Parameters:
[
  "header"
]
8 0.59 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.parent_id = ?
Parameters:
[
  15
]
9 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.markdown_content AS markdown_content_4, t0.creation_date AS creation_date_5, t0.modification_date AS modification_date_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 0.31 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.parent_id = ?
Parameters:
[
  16
]
11 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "logo_image"
]
12 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "logo_image"
]
13 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "server_name"
]
14 0.48 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
15 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "home_top_content"
]
16 0.57 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
17 0.38 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
18 0.34 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
19 0.31 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
20 0.27 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4 FROM basket t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
21 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "home_bottom_content"
]
22 0.38 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.menu = ? ORDER BY t0.display_order ASC
Parameters:
[
  "footer"
]
23 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.markdown_content AS markdown_content_4, t0.creation_date AS creation_date_5, t0.modification_date AS modification_date_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
  8
]
24 0.28 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.parent_id = ?
Parameters:
[
  17
]
25 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.markdown_content AS markdown_content_4, t0.creation_date AS creation_date_5, t0.modification_date AS modification_date_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
  9
]
26 0.30 ms
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.label AS label_3, t0.url AS url_4, t0.display_order AS display_order_5, t0.creation_date AS creation_date_6, t0.modification_date AS modification_date_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM menu_link t0 WHERE t0.parent_id = ?
Parameters:
[
  20
]
27 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "discord_invite_url"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\ProductAction No errors.
App\Entity\PurchaseProduct No errors.
App\Entity\Configuration No errors.
App\Entity\MenuLink No errors.
App\Entity\Page No errors.
App\Entity\Basket No errors.