GET https://hncdev.com/

Query Metrics

47 Database Queries
7 Different statements
16.03 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.title AS title_4, t0.image AS image_5, t0.content AS content_6, t0.enable AS enable_7, t0.user_id AS user_id_8 FROM page t0 WHERE t0.link = ? LIMIT 1
Parameters:
[
  "homepage"
]
2 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM slider t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Slider Home Page"
]
3 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_address"
]
4 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_phone"
]
5 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_email"
]
6 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_twitter"
]
7 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_twitter"
]
8 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
9 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
10 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
11 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_instagram"
]
12 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_instagram"
]
13 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
14 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
15 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
16 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_youtube"
]
17 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_youtube"
]
18 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_logo"
]
19 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_name"
]
20 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_name"
]
21 0.31 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.link AS link_3, t0.orde AS orde_4, t0.parent_id AS parent_id_5 FROM menu t0 INNER JOIN page_menu ON t0.id = page_menu.menu_id WHERE page_menu.page_id = ?
Parameters:
[
  7
]
22 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.link AS link_3, t0.orde AS orde_4, t0.parent_id AS parent_id_5 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
23 0.24 ms
SELECT t0.id AS id_1, t0.item_title AS item_title_2, t0.item_subtitle AS item_subtitle_3, t0.item_image AS item_image_4, t0.item_link AS item_link_5, t0.item_text_link AS item_text_link_6, t0.slider_id AS slider_id_7 FROM slider_item t0 WHERE t0.slider_id = ?
Parameters:
[
  1
]
24 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Clients satisfaits"
]
25 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Projets réalisés"
]
26 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Gagnez des prix"
]
27 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_phone"
]
28 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_phone"
]
29 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_logo"
]
30 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_name"
]
31 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_name"
]
32 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_slogan"
]
33 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_address"
]
34 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_email"
]
35 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_phone"
]
36 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_twitter"
]
37 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_twitter"
]
38 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
39 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
40 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_facebook"
]
41 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
42 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
43 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_Linkedin"
]
44 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_youtube"
]
45 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_youtube"
]
46 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.valeur AS valeur_4 FROM site_info t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default_footer_menu_2"
]
47 0.37 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.link AS link_3, t0.orde AS orde_4, t0.parent_id AS parent_id_5 FROM menu t0 WHERE t0.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.

Entities Mapping

Class Mapping errors
App\Entity\Page
  • The association App\Entity\Page#id_block refers to the inverse side field App\Entity\SideBlock#id_block which does not exist.
  • The association App\Entity\Page#user refers to the inverse side field App\Entity\User#recepise which does not exist.
App\Entity\User No errors.
App\Entity\Menu No errors.
App\Entity\SideBlock
  • The mappings App\Entity\SideBlock#id_page and App\Entity\Page#id_block are inconsistent with each other.
App\Entity\Images No errors.
App\Entity\Slider No errors.
App\Entity\SliderItem No errors.
App\Entity\SiteInfo No errors.