Query Metrics

14 Database Queries
8 Different statements
2.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[]
2 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.key AS key_3, t0.template AS template_4, t0.width AS width_5, t0.height AS height_6 FROM hooks t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "homepage"
]
3 0.21 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.category_condition AS category_condition_3, t0.order_num AS order_num_4, t0.size_class AS size_class_5, t0.module_id AS module_id_6, t0.hook_id AS hook_id_7 FROM module_hooks t0 WHERE t0.hook_id = ? AND t0.enabled = ? ORDER BY t0.order_num ASC
Parameters:
[
  1
  1
]
4 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.template AS template_4, t0.template_dir AS template_dir_5, t0.entity AS entity_6, t0.route AS route_7, t0.has_options AS has_options_8, t0.has_conditions AS has_conditions_9, t0.has_title AS has_title_10, t0.defaults AS defaults_11, t0.is_resizable AS is_resizable_12, t0.hook_disabled AS hook_disabled_13, t0.order_num AS order_num_14, t0.hooked AS hooked_15 FROM modules t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.16 ms
SELECT t0.id AS id_1, t0.speed AS speed_2, t0.display AS display_3, t0.module_hook_id AS module_hook_id_4 FROM module_carousels t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  1
]
6 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.template AS template_4, t0.template_dir AS template_dir_5, t0.entity AS entity_6, t0.route AS route_7, t0.has_options AS has_options_8, t0.has_conditions AS has_conditions_9, t0.has_title AS has_title_10, t0.defaults AS defaults_11, t0.is_resizable AS is_resizable_12, t0.hook_disabled AS hook_disabled_13, t0.order_num AS order_num_14, t0.hooked AS hooked_15 FROM modules t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.13 ms
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.content_fr AS content_fr_3, t0.title_en AS title_en_4, t0.content_en AS content_en_5, t0.module_hook_id AS module_hook_id_6 FROM module_texts t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  2
]
8 0.11 ms
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.content_fr AS content_fr_3, t0.title_en AS title_en_4, t0.content_en AS content_en_5, t0.module_hook_id AS module_hook_id_6 FROM module_texts t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  11
]
9 0.14 ms
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.content_fr AS content_fr_3, t0.title_en AS title_en_4, t0.content_en AS content_en_5, t0.module_hook_id AS module_hook_id_6 FROM module_texts t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  12
]
10 0.14 ms
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.content_fr AS content_fr_3, t0.title_en AS title_en_4, t0.content_en AS content_en_5, t0.module_hook_id AS module_hook_id_6 FROM module_texts t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  13
]
11 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.template AS template_4, t0.template_dir AS template_dir_5, t0.entity AS entity_6, t0.route AS route_7, t0.has_options AS has_options_8, t0.has_conditions AS has_conditions_9, t0.has_title AS has_title_10, t0.defaults AS defaults_11, t0.is_resizable AS is_resizable_12, t0.hook_disabled AS hook_disabled_13, t0.order_num AS order_num_14, t0.hooked AS hooked_15 FROM modules t0 WHERE t0.id = ?
Parameters:
[
  3
]
12 0.14 ms
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.module_hook_id AS module_hook_id_4 FROM module_featured t0 WHERE t0.module_hook_id = ? LIMIT 1
Parameters:
[
  15
]
13 0.17 ms
SELECT t0.id AS id_1, t0.order_num AS order_num_2, t0.module_featured_id AS module_featured_id_3, t0.product_id AS product_id_4 FROM module_featured_items t0 WHERE t0.module_featured_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  1
]
14 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.template AS template_4, t0.template_dir AS template_dir_5, t0.entity AS entity_6, t0.route AS route_7, t0.has_options AS has_options_8, t0.has_conditions AS has_conditions_9, t0.has_title AS has_title_10, t0.defaults AS defaults_11, t0.is_resizable AS is_resizable_12, t0.hook_disabled AS hook_disabled_13, t0.order_num AS order_num_14, t0.hooked AS hooked_15 FROM modules t0 WHERE t0.id = ?
Parameters:
[
  5
]

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.