https://restapp.chappliweb.fr/accueil

Query Metrics

65 Database Queries
4 Different statements
56.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_name AS image_name_8, t0.displayed_on_menu_yes_no AS displayed_on_menu_yes_no_9 FROM meal t0 ORDER BY t0.type ASC
Parameters:
[]
2 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_name AS image_name_8, t0.displayed_on_menu_yes_no AS displayed_on_menu_yes_no_9 FROM meal t0 ORDER BY t0.type ASC
Parameters:
[]
3 2.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  16
]
4 5.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  16
]
5 1.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  31
]
6 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  32
]
7 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  34
]
8 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  35
]
9 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  36
]
10 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  39
]
11 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  45
]
12 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  17
]
13 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  17
]
14 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  33
]
15 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  41
]
16 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  18
]
17 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  18
]
18 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  12
]
19 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  13
]
20 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  16
]
21 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  18
]
22 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  21
]
23 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  22
]
24 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  29
]
25 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  38
]
26 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  40
]
27 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  42
]
28 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  43
]
29 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  19
]
30 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  19
]
31 1.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  44
]
32 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  46
]
33 1.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  12
]
34 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  12
]
35 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  9
]
36 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  25
]
37 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  26
]
38 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  27
]
39 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  13
]
40 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  13
]
41 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  14
]
42 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  47
]
43 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  48
]
44 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  14
]
45 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  14
]
46 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  28
]
47 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  30
]
48 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  15
]
49 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  15
]
50 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  49
]
51 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  50
]
52 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  8
]
53 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  8
]
54 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  15
]
55 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  20
]
56 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  9
]
57 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  9
]
58 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  17
]
59 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  37
]
60 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  10
]
61 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  10
]
62 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  19
]
63 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM tags t0 INNER JOIN meal_tags ON t0.id = meal_tags.tags_id WHERE meal_tags.meal_id = ?
Parameters:
[
  11
]
64 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN meal_ingredient ON t0.id = meal_ingredient.ingredient_id WHERE meal_ingredient.meal_id = ?
Parameters:
[
  11
]
65 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.image_name AS image_name_5 FROM allergen t0 INNER JOIN ingredient_allergen ON t0.id = ingredient_allergen.allergen_id WHERE ingredient_allergen.ingredient_id = ?
Parameters:
[
  23
]

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\Meal No errors.
App\Entity\Ingredient No errors.
App\Entity\Tags No errors.
App\Entity\Allergen No errors.