GET https://www.recette.smileanimations.fr/

Query Metrics

30 Database Queries
10 Different statements
14.41 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "MAINTENANCE"
]
2 0.55 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "ACTIVE_TEMPLATE"
]
3 0.52 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_TYPE"
  "mailer"
]
4 0.51 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_SMTP_HOST"
  "mailer"
]
5 0.45 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_PORT"
  "mailer"
]
6 0.46 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_ENCRYPTION"
  "mailer"
]
7 0.38 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_SENDER_EMAIL"
  "mailer"
]
8 0.33 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.comment AS comment_5 FROM setting t0 WHERE t0.setting_key = ? AND t0.setting_group = ? LIMIT 1
Parameters:
[
  "MAILER_SECRET_KEY"
  "mailer"
]
9 0.39 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.updated_at AS updated_at_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.dimensions AS dimensions_6, t0.item AS item_7 FROM media t0
Parameters:
[]
10 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.is_visible = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
11 0.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.canonical_url AS canonical_url_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.og_image AS og_image_8, t0.updated_at AS updated_at_9, t0.x_card AS x_card_10, t0.route_name AS route_name_11, t0.slug AS slug_12, t0.is_default AS is_default_13 FROM seo t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "app_home"
]
12 0.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.canonical_url AS canonical_url_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.og_image AS og_image_8, t0.updated_at AS updated_at_9, t0.x_card AS x_card_10, t0.route_name AS route_name_11, t0.slug AS slug_12, t0.is_default AS is_default_13 FROM seo t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
13 1.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.disabled_at AS disabled_at_3, t0.enabled AS enabled_4, t0.file_name AS file_name_5, t0.file_size AS file_size_6, t0.mime_type AS mime_type_7, t0.dimensions AS dimensions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.vimeo_uri AS vimeo_uri_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.enabled = ? AND t0.parent_id IS NULL
Parameters:
[
  1
]
14 1.27 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  86
]
15 0.37 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  90
]
16 0.30 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  94
]
17 0.27 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  95
]
18 0.27 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  96
]
19 0.28 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  100
]
20 0.28 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  101
]
21 0.28 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.description AS description_2, v0_.vimeo_url AS vimeo_url_3, v0_.icon AS icon_4, v0_.thumbnail AS thumbnail_5, v0_.difficulty_level AS difficulty_level_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.published_at AS published_at_9, v0_.enabled AS enabled_10, v0_.player AS player_11, v0_.vimeo_id AS vimeo_id_12, v0_.preview AS preview_13, v0_.category_id AS category_id_14 FROM video v0_ WHERE v0_.enabled = 1 AND v0_.preview = 1 AND v0_.category_id = ? LIMIT 1
Parameters:
[
  105
]
22 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  6
]
23 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  7
]
24 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  8
]
25 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enabled AS enabled_4, t0.configuration AS configuration_5 FROM component t0 WHERE t0.id = ?
Parameters:
[
  1
]
26 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  9
]
27 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  10
]
28 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  11
]
29 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  12
]
30 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.item_order AS item_order_4, t0.is_visible AS is_visible_5, t0.position AS position_6, t0.external_link AS external_link_7, t0.anchor AS anchor_8, t0.parent_id AS parent_id_9 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  13
]

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\Setting 8
App\Entity\MenuItem 8
App\Entity\Category 8
App\Entity\Media 6
App\Entity\Video 4
App\Entity\Component 1

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\Media No errors.
App\Entity\MenuItem No errors.
App\Entity\Seo No errors.
App\Entity\Category No errors.
App\Entity\Video No errors.
App\Entity\PlaylistVideo No errors.
App\Entity\Component No errors.