Query Metrics

22 Database Queries
10 Different statements
3.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[]
2 0.15 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.18 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.15 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.14 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.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:
[
  2
]
7 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:
[
  2
]
8 0.10 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.10 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.10 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.11 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.18 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.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:
[
  5
]
15 0.20 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
16 0.21 ms
SELECT t0.id AS id_1, t0.img_fr AS img_fr_2, t0.img_mobile_fr AS img_mobile_fr_3, t0.url_fr AS url_fr_4, t0.img_en AS img_en_5, t0.img_mobile_en AS img_mobile_en_6, t0.url_en AS url_en_7, t0.order_num AS order_num_8, t0.module_carousel_id AS module_carousel_id_9, t0.price_group_id AS price_group_id_10 FROM module_carousel_items t0 WHERE t0.module_carousel_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  1
]
17 0.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
18 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
19 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
20 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
21 0.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
22 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]

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.