https://lena.antallis-dev.com/

Query Metrics

92 Database Queries
5 Different statements
51.47 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.image AS image_3, t0.imagemini AS imagemini_4, t0.status_id AS status_id_5, t6.id AS id_7, t6.label AS label_8 FROM menu t0 LEFT JOIN status t6 ON t0.status_id = t6.id
Parameters:
[]
2 2.91 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id INNER JOIN menu_item ON t0.id = menu_item.item_id WHERE menu_item.menu_id = ?
Parameters:
[
  1
]
3 0.54 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id INNER JOIN menu_item ON t0.id = menu_item.item_id WHERE menu_item.menu_id = ?
Parameters:
[
  2
]
4 1.80 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id INNER JOIN menu_item ON t0.id = menu_item.item_id WHERE menu_item.menu_id = ?
Parameters:
[
  3
]
5 2.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  1
]
6 0.55 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  4
]
7 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  7
]
8 0.61 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id INNER JOIN menu_item ON t0.id = menu_item.item_id WHERE menu_item.menu_id = ?
Parameters:
[
  4
]
9 0.52 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  2
]
10 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  3
]
11 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  6
]
12 0.89 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.image AS image_4, t0.imagemini AS imagemini_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.label AS label_9 FROM item t0 LEFT JOIN category t7 ON t0.category_id = t7.id
Parameters:
[]
13 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  5
]
14 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  9
]
15 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  10
]
16 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  11
]
17 0.49 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  12
]
18 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  13
]
19 0.56 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  14
]
20 0.51 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  15
]
21 0.51 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  16
]
22 0.46 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  17
]
23 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  18
]
24 0.90 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  19
]
25 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  20
]
26 0.46 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  21
]
27 0.46 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  22
]
28 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  23
]
29 0.44 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  24
]
30 0.43 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  25
]
31 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  26
]
32 0.83 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  27
]
33 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  28
]
34 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  29
]
35 0.44 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  30
]
36 0.41 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  31
]
37 0.55 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  32
]
38 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  33
]
39 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  34
]
40 0.53 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  35
]
41 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  36
]
42 0.46 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  37
]
43 0.41 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  38
]
44 0.47 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  39
]
45 0.43 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  40
]
46 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  41
]
47 0.42 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  43
]
48 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  44
]
49 0.70 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  45
]
50 1.63 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  46
]
51 0.92 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  47
]
52 0.67 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  48
]
53 0.56 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  49
]
54 0.58 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  50
]
55 0.51 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  51
]
56 0.76 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  53
]
57 0.32 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  54
]
58 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  55
]
59 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  56
]
60 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  57
]
61 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  58
]
62 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  59
]
63 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  60
]
64 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  61
]
65 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  62
]
66 0.38 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  63
]
67 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  64
]
68 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  65
]
69 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  66
]
70 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  67
]
71 0.34 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  68
]
72 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  69
]
73 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  70
]
74 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  71
]
75 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  72
]
76 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  73
]
77 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  74
]
78 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  75
]
79 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  76
]
80 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  77
]
81 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  78
]
82 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  79
]
83 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  80
]
84 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  81
]
85 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  82
]
86 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  83
]
87 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  84
]
88 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  85
]
89 0.35 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  86
]
90 0.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  87
]
91 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM criterion t0 INNER JOIN item_criterion ON t0.id = item_criterion.criterion_id WHERE item_criterion.item_id = ?
Parameters:
[
  88
]
92 1.41 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.image AS image_4, t0.imagemini AS imagemini_5 FROM cake t0
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.

Entities Mapping

Class Mapping errors
App\Entity\Menu No errors.
App\Entity\Category No errors.
App\Entity\Item No errors.
App\Entity\Criterion No errors.
App\Entity\Cake No errors.
App\Entity\Offer No errors.
App\Entity\Status No errors.