Query Metrics

40 Database Queries
13 Different statements
14.52 ms Query time
0 Invalid entities
57 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.15 ms
(21.68%)
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:
[
  3807
]
3.10 ms
(21.35%)
10
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.label_type_id AS label_type_id_6 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = ?
Parameters:
[
  71
]
1.92 ms
(13.25%)
6
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:
[
  4
]
1.58 ms
(10.91%)
3
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 category_menu_type c1_ ON p0_.id = c1_.category_id LEFT JOIN p_category_category p2_ ON p0_.id = p2_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p2_.category_super_id = ? AND c1_.menu_type_id = ? ORDER BY p2_.sequence ASC
Parameters:
[
  1
  2
  68
  68
  1
]
1.27 ms
(8.74%)
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_ 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.77 ms
(5.29%)
2
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"
]
0.55 ms
(3.78%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.41 ms
(2.85%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  68
]
0.39 ms
(2.71%)
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.38 ms
(2.60%)
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 sub_menu_type t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  6
]
0.35 ms
(2.43%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1
Parameters:
[
  "cs"
]
0.33 ms
(2.28%)
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 = ? LIMIT 1
Parameters:
[
  1
]
0.31 ms
(2.13%)
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 sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?
Parameters:
[
  68
]

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 26
Greendot\EshopBundle\Entity\Project\Upload 10
Greendot\EshopBundle\Entity\Project\UploadGroup 10
Greendot\EshopBundle\Entity\Project\CategoryType 7
Greendot\EshopBundle\Entity\Project\MenuType 2
Greendot\EshopBundle\Entity\Project\Currency 1
Greendot\EshopBundle\Entity\Project\SubMenuType 1

Entities Mapping

Class Mapping errors
Greendot\EshopBundle\Entity\Project\Currency No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate No errors.
Greendot\EshopBundle\Entity\Project\Category No errors.
Greendot\EshopBundle\Entity\Project\CategoryType No errors.
Greendot\EshopBundle\Entity\Project\Upload No errors.
Greendot\EshopBundle\Entity\Project\Label No errors.
Greendot\EshopBundle\Entity\Project\CategoryFile No errors.
Greendot\EshopBundle\Entity\Project\CategoryCategory No errors.
Greendot\EshopBundle\Entity\Project\Parameter No errors.
Greendot\EshopBundle\Entity\Project\CategoryProduct No errors.
Greendot\EshopBundle\Entity\Project\Comment No errors.
Greendot\EshopBundle\Entity\Project\CategoryPerson No errors.
Greendot\EshopBundle\Entity\Project\CategoryEvent No errors.
Greendot\EshopBundle\Entity\Project\CategoryUploadGroup No errors.
Greendot\EshopBundle\Entity\Project\CategoryMenuType No errors.
Greendot\EshopBundle\Entity\Project\SubMenuType No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup No errors.
Greendot\EshopBundle\Entity\Project\Settings No errors.
Greendot\EshopBundle\Entity\Project\MenuType No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup No errors.
Greendot\EshopBundle\Entity\Project\Product No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant No errors.
Greendot\EshopBundle\Entity\Project\Producer No errors.
Greendot\EshopBundle\Entity\Project\Person No errors.
Greendot\EshopBundle\Entity\Project\UploadType No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock No errors.
Greendot\EshopBundle\Entity\Project\LabelType No errors.
Greendot\EshopBundle\Entity\Project\File No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup No errors.
Greendot\EshopBundle\Entity\Project\ParameterType No errors.
Greendot\EshopBundle\Entity\Project\Client No errors.
Greendot\EshopBundle\Entity\Project\Event No errors.