Query Metrics

15 Database Queries
9 Different statements
3.03 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[]
2 0.24 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.24 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.21 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.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:
[
  2
]
7 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:
[
  2
]
8 0.16 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.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:
[
  12
]
10 0.16 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.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:
[
  3
]
12 0.18 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.22 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
]
15 0.26 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.

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.
App\Entity\ProductAttribute No errors.
App\Entity\ProductModel No errors.
App\Entity\ProductDescription No errors.
App\Entity\Picture No errors.
App\Entity\PictureProduct No errors.
App\Entity\Manufacturer No errors.
App\Entity\ProductCountryRestriction No errors.
App\Entity\ProductToProductExtraField No errors.
App\Entity\ProductPrice No errors.
App\Entity\TaxClass No errors.
App\Entity\Attribute No errors.
App\Entity\ProductAttributeDescription No errors.
App\Entity\ProductModelAttribute
  • The association App\Entity\ProductModelAttribute#descriptions refers to the owning side field App\Entity\ProductModelAttributeDescription#productAttribute which does not exist.
App\Entity\ProductModelDescription No errors.
App\Entity\ProductModelCountryRestriction No errors.
App\Entity\ProductModelVariant No errors.
App\Entity\Language No errors.
App\Entity\PictureDescription No errors.
App\Entity\ManufacturerDescription No errors.
App\Entity\ManufacturerCountry No errors.
App\Entity\Country No errors.
App\Entity\ProductExtraField No errors.
App\Entity\TaxRate No errors.