https://symfony.avt.pl/

Query Metrics

77 Database Queries
6 Different statements
3.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.98 ms
(76.98%)
67
SELECT t0.id AS id_1, t0.name AS name_2, t0.static_path AS static_path_3, t0.var_pattern AS var_pattern_4, t0.path AS path_5, t0.host AS host_6, t0.schemes AS schemes_7, t0.methods AS methods_8, t0.defaults AS defaults_9, t0.options AS options_10, t0.requirements AS requirements_11, t0.`condition` AS condition_12, t0.priority AS priority_13, t0.active AS active_14 FROM route t0 INNER JOIN menu_item_route_map ON t0.id = menu_item_route_map.route_id WHERE menu_item_route_map.item_id = ?
Parameters:
[
  27
]
0.30 ms
(7.86%)
6
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.position AS position_3, m0_.template AS template_4, m0_.menu_type AS menu_type_5, m0_.params AS params_6, m0_.cache AS cache_7, m0_.cache_type AS cache_type_8, m0_.state AS state_9, m0_.ordering AS ordering_10 FROM module m0_ WHERE m0_.position = ? ORDER BY m0_.ordering ASC
Parameters:
[
  "sg-left-top"
]
0.25 ms
(6.57%)
1
SELECT t1.id AS id_2, t1.section AS section_3, t0.value AS value_4, t1.type FROM setting_string t0 INNER JOIN setting t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  "meta.index_title"
]
0.14 ms
(3.68%)
1
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.name AS name_2, m0_.type AS type_3, m0_.lft AS lft_4, m0_.rgt AS rgt_5, m0_.depth AS depth_6, m0_.state AS state_7, m0_.content_count AS content_count_8, m0_.params AS params_9, m0_.menu_id AS menu_id_10, m0_.parent_id AS parent_id_11 FROM menu_item m0_ INNER JOIN menu_item_route_map m2_ ON m0_.id = m2_.item_id INNER JOIN route r1_ ON r1_.id = m2_.route_id WHERE m0_.depth > 0 AND m0_.type IN (?, ?, ?) ORDER BY m0_.lft ASC
Parameters:
[
  "content.list"
  "content.single"
  "content.clear"
]
0.10 ms
(2.53%)
1
SELECT t1.id AS id_2, t1.section AS section_3, t0.value AS value_4, t1.type FROM setting_int t0 INNER JOIN setting t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  "pagination.offset"
]
0.09 ms
(2.38%)
1
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.name AS name_2, m0_.type AS type_3, m0_.lft AS lft_4, m0_.rgt AS rgt_5, m0_.depth AS depth_6, m0_.state AS state_7, m0_.content_count AS content_count_8, m0_.params AS params_9, m0_.menu_id AS menu_id_10, m0_.parent_id AS parent_id_11 FROM menu_item m0_ INNER JOIN menu_item_route_map m2_ ON m0_.id = m2_.item_id INNER JOIN route r1_ ON r1_.id = m2_.route_id WHERE r1_.name = ? LIMIT 1
Parameters:
[
  "index"
]

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\Route No errors.
App\Entity\Settings\Setting No errors.
App\Entity\Settings\StringSetting No errors.
App\Entity\Category\Category No errors.
App\Entity\Image No errors.
App\Entity\Menu\Item No errors.
App\Entity\Menu\Menu No errors.
App\Entity\Module\Module No errors.
App\Entity\Settings\IntSetting No errors.
App\Entity\Shop\DeliveryMethod No errors.
App\Entity\Shop\PaymentMethod No errors.
App\Entity\CustomField\CustomFieldValue No errors.