GET https://proklima.greendot.cz/_fragment/generate-menu/4

Query Metrics

19 Database Queries
6 Different statements
5.77 ms Query time
0 Invalid entities
66 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.53 ms
(43.76%)
10
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
Parameters:
[
  4173
]
1.05 ms
(18.21%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.05 ms
(18.17%)
2
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ WHERE p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p0_.sequence ASC
Parameters:
[
  13
]
0.54 ms
(9.34%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p1_.id IS NULL AND c2_.menu_type_id = ? ORDER BY c2_.sequence ASC
Parameters:
[
  1
  2
  4
]
0.33 ms
(5.65%)
1
SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1
Parameters:
[
  "after_registration_discount"
]
0.28 ms
(4.87%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = ?
Parameters:
[
  "4"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Greendot\EshopBundle\Entity\Project\Category 28
Greendot\EshopBundle\Entity\Project\Upload 21
Greendot\EshopBundle\Entity\Project\UploadGroup 10
Greendot\EshopBundle\Entity\Project\CategoryType 6
Greendot\EshopBundle\Entity\Project\MenuType 1