Query Metrics
14
Database Queries
8
Different statements
3.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.53 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
| 2 | 0.32 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.28 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.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:
[
1
]
|
| 5 | 0.22 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.22 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.22 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.17 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.17 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.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:
[
3
]
|
| 12 | 0.20 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.37 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.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:
[
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\PriceGroup | No errors. |
| App\Entity\Hook | No errors. |
| App\Entity\ModuleHook | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\ModuleCarousel | No errors. |
| App\Entity\ModuleCarouselItem | No errors. |
| App\Entity\ModuleText | No errors. |
| App\Entity\ModuleFeatured | No errors. |
| App\Entity\ModuleFeaturedItem | No errors. |
| App\Entity\Product | No errors. |