GET https://mua.greendot.cz/en/udalost/mezi-obci-a-statem

Query Metrics

63 Database Queries
9 Different statements
17.66 ms Query time
11 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.22 ms
(52.23%)
41
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "35"
  "en"
  "App\Entity\Project\Event"
]
3.47 ms
(19.64%)
5
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_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id LEFT JOIN menu_type m1_ ON m1_.id = c2_.menu_type_id LEFT JOIN p_category_category p3_ ON p0_.id = p3_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p3_.category_super_id = ? AND m1_.id = ? ORDER BY p0_.sequence ASC
Parameters:
[
  1
  2
  55
  55
  1
]
1.42 ms
(8.05%)
7
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:
[
  67
]
1.40 ms
(7.94%)
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_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id LEFT JOIN menu_type m1_ ON m1_.id = c2_.menu_type_id LEFT JOIN p_category_category p3_ ON p0_.id = p3_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND m1_.id = ? AND p3_.id IS NULL ORDER BY p0_.sequence ASC
Parameters:
[
  1
  2
  4
]
0.79 ms
(4.50%)
3
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.upload_group_id AS upload_group_id_13 FROM upload u0_ LEFT JOIN upload_group u1_ ON u0_.upload_group_id = u1_.id LEFT JOIN event_upload_group e2_ ON u1_.id = e2_.upload_group_id WHERE u1_.type = ? AND e2_.event_id = ?
Parameters:
[
  1
  35
]
0.46 ms
(2.62%)
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.43 ms
(2.43%)
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_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_event c1_ ON p0_.id = c1_.category_id WHERE c1_.event_id = ? AND p0_.category_type_id = ? AND p0_.id > 10 ORDER BY p0_.sequence ASC
Parameters:
[
  35
  10
]
0.23 ms
(1.31%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.conversion_rate AS conversion_rate_4, t0.rounding AS rounding_5, t0.is_default AS is_default_6 FROM currency t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
0.23 ms
(1.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.location AS location_5, t0.description AS description_6, t0.html AS html_7, t0.price AS price_8, t0.state AS state_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.is_deleted AS is_deleted_12, t0.length AS length_13, t0.event_type_id AS event_type_id_14 FROM event t0 WHERE t0.slug = ? AND ((t0.is_active = 1 and t0.is_deleted = 0)) LIMIT 1
Parameters:
[
  "mezi-obci-a-statem"
]

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\Project\Currency No errors.
App\Entity\Project\Event No errors.
App\Entity\Project\EventType No errors.
App\Entity\Project\CategoryEvent No errors.
App\Entity\Project\PurchaseEvent No errors.
App\Entity\Project\EventUploadGroup No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\Project\MenuType No errors.
App\Entity\Project\Category No errors.
App\Entity\Project\CategoryCategory No errors.
App\Entity\Project\CategoryType No errors.
App\Entity\Project\Upload No errors.
App\Entity\Project\Label No errors.
App\Entity\Project\CategoryFile No errors.
App\Entity\Project\Parameter No errors.
App\Entity\Project\CategoryProduct No errors.
App\Entity\Project\Comment No errors.
App\Entity\Project\CategoryPerson No errors.
App\Entity\Project\CategoryUploadGroup No errors.
App\Entity\Project\SubMenuType No errors.
App\Entity\Project\Purchase
  • The mappings App\Entity\Project\Purchase#PaymentType and App\Entity\Project\PaymentType#purchases are inconsistent with each other.
  • The association App\Entity\Project\Purchase#Client refers to the inverse side field App\Entity\Project\Client#purchases which does not exist.
App\Entity\Project\UploadGroup
  • The mappings App\Entity\Project\UploadGroup#productUploadGroup and App\Entity\Project\ProductUploadGroup#UploadGroup are inconsistent with each other.
App\Entity\Project\Product
  • The mappings App\Entity\Project\Product#productUploadGroup and App\Entity\Project\ProductUploadGroup#Product are inconsistent with each other.
App\Entity\Project\ProductVariant
  • The mappings App\Entity\Project\ProductVariant#purchaseProductVariant and App\Entity\Project\PurchaseProductVariant#ProductVariant are inconsistent with each other.
App\Entity\Project\Producer No errors.
App\Entity\Project\File No errors.
App\Entity\Project\ParameterGroup
  • The association App\Entity\Project\ParameterGroup#type refers to the inverse side field App\Entity\Project\ParameterGroupType#parameterGroups which does not exist.
App\Entity\Project\Person No errors.
App\Entity\Project\Client
  • The mappings App\Entity\Project\Client#orders and App\Entity\Project\Purchase#Client are inconsistent with each other.
App\Entity\Project\PaymentType
  • The association App\Entity\Project\PaymentType#purchases refers to the owning side field App\Entity\Project\Purchase#Payment which does not exist.
App\Entity\Project\Transportation No errors.
App\Entity\Project\PurchaseProductVariant
  • The association App\Entity\Project\PurchaseProductVariant#ProductVariant refers to the inverse side field App\Entity\Project\ProductVariant#orderProductVariants which does not exist.
App\Entity\Project\Note No errors.
App\Entity\Project\Payment No errors.
App\Entity\Project\PersonUploadGroup No errors.
App\Entity\Project\ProductVariantUploadGroup No errors.
App\Entity\Project\ProductUploadGroup
  • The association App\Entity\Project\ProductUploadGroup#UploadGroup refers to the inverse side field App\Entity\Project\UploadGroup#productUploadGroups which does not exist.
  • The association App\Entity\Project\ProductUploadGroup#Product refers to the inverse side field App\Entity\Project\Product#productUploadGroups which does not exist.
App\Entity\Project\Review No errors.
App\Entity\Project\Colour No errors.
App\Entity\Project\Video No errors.
App\Entity\Project\Availability No errors.
App\Entity\Project\Price
  • The association App\Entity\Project\Price#event refers to the inverse side field App\Entity\Project\Event#price which is not defined as association.
  • The association App\Entity\Project\Price#event refers to the inverse side field App\Entity\Project\Event#price which does not exist.
App\Entity\Project\ParameterGroupType
  • The association App\Entity\Project\ParameterGroupType#type refers to the owning side field App\Entity\Project\ParameterGroup#parameterGroups which does not exist.
App\Entity\Project\ClientDiscount No errors.