GET https://optixs-2014.greendot.cz/powerline-e-8-qt-p

Query Metrics

86 Database Queries
30 Different statements
19.61 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.96 ms
(20.20%)
33
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:
[
  65952
]
1.69 ms
(8.61%)
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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 p0_.sequence ASC
Parameters:
[
  1
  2
  2143
  2143
  1
]
1.62 ms
(8.24%)
7
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN product_information_block p2_ ON i0_.id = p2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND p2_.product_id = ? ORDER BY p2_.sequence ASC
Parameters:
[
  1
  1
  416
]
1.59 ms
(8.11%)
6
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_type c1_ ON p0_.category_type_id = c1_.id LEFT JOIN category_product c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = ? AND c1_.id IN (?) AND c2_.product_id = ? ORDER BY c2_.sequence ASC
Parameters:
[
  1
  7
  416
]
1.52 ms
(7.77%)
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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
]
1.04 ms
(5.31%)
2
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.88 ms
(4.48%)
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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 = ? AND p0_.category_type_id = ? ORDER BY p0_.sequence ASC
Parameters:
[
  1
  2
  2141
  2141
  1
  2
]
0.85 ms
(4.35%)
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 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 = ? AND p0_.category_type_id <> ? ORDER BY p0_.sequence ASC
Parameters:
[
  1
  2
  2141
  2141
  1
  2
]
0.83 ms
(4.22%)
4
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:
[
  2141
]
0.70 ms
(3.57%)
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.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.sequence AS sequence_8, t0.javascript AS javascript_9, t0.text_general AS text_general_10, t0.state AS state_11, t0.external_id AS external_id_12, t0.is_indexable AS is_indexable_13, t0.meta_description AS meta_description_14, t0.producer_id AS producer_id_15, t0.upload_id AS upload_id_16 FROM product t0 WHERE t0.slug = ? AND ((t0.is_active != 0)) LIMIT 1
Parameters:
[
  "powerline-e-8-qt"
]
0.44 ms
(2.26%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active != 0))
Parameters:
[
  416
]
0.42 ms
(2.15%)
3
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  1179
]
0.41 ms
(2.08%)
1
SELECT p0_.id AS id_0, p0_.data AS data_1, p0_.sequence AS sequence_2, p0_.parameter_group_id AS parameter_group_id_3, p0_.category_id AS category_id_4, p0_.product_variant_id AS product_variant_id_5, p0_.person_id AS person_id_6 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p1_.is_product_parameter = 1 AND p0_.product_variant_id IN (?) GROUP BY p0_.parameter_group_id
Parameters:
[
  378
]
0.35 ms
(1.79%)
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.34 ms
(1.76%)
2
SELECT u0_.id AS id_0, u0_.type AS type_1 FROM upload_group u0_ LEFT JOIN product_upload_group p1_ ON u0_.id = p1_.upload_group_id WHERE p1_.product_id = ? AND u0_.type = ?
Parameters:
[
  416
  0
]
0.33 ms
(1.69%)
2
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_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.id <> ? AND u0_.upload_group_id IN (?)
Parameters:
[
  4582
  4582
]
0.30 ms
(1.51%)
1
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = ? AND p0_.valid_from <= ? AND (p0_.valid_until >= ? OR p0_.valid_until IS NULL) GROUP BY p0_.minimal_amount ORDER BY p0_.minimal_amount DESC, p0_.price ASC
Parameters:
[
  378
  "2024-12-22 17:10:49"
  "2024-12-22 17:10:49"
]
0.23 ms
(1.19%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.vat AS vat_3, t0.minimal_amount AS minimal_amount_4, t0.discount AS discount_5, t0.valid_from AS valid_from_6, t0.valid_until AS valid_until_7, t0.created AS created_8, t0.is_package AS is_package_9, t0.min_price AS min_price_10, t0.product_variant_id AS product_variant_id_11, t0.event_id AS event_id_12 FROM price t0 WHERE t0.product_variant_id = ? ORDER BY t0.minimal_amount ASC
Parameters:
[
  378
]
0.23 ms
(1.19%)
1
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.state AS state_5, i0_.is_reusable AS is_reusable_6, i0_.information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id WHERE i0_.is_active = ? AND i1_.id = ? AND c2_.category_id = ? ORDER BY c2_.sequence ASC
Parameters:
[
  1
  12
  2319
]
0.21 ms
(1.08%)
1
SELECT DISTINCT p0_.id AS id_0 FROM parameter p1_ LEFT JOIN parameter_group p0_ ON p1_.parameter_group_id = p0_.id WHERE p0_.is_product_parameter = 1 AND p1_.product_variant_id IN (?)
Parameters:
[
  378
]
0.20 ms
(1.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active != 0)) ORDER BY t0.external_id ASC
Parameters:
[
  416
]
0.19 ms
(0.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.description_mail AS description_mail_4, t0.description_duration AS description_duration_5, t0.html AS html_6, t0.icon AS icon_7, t0.duration AS duration_8, t0.price AS price_9, t0.free_from_price AS free_from_price_10, t0.squence AS squence_11, t0.country AS country_12, t0.state_url AS state_url_13, t0.section AS section_14, t0.is_enabled AS is_enabled_15, t0.vat AS vat_16 FROM transportation t0 ORDER BY t0.squence ASC
Parameters:
[]
0.19 ms
(0.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.type_id AS type_id_5, t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_6 FROM parameter_group t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Packing Unit"
]
0.17 ms
(0.88%)
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.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id = ?
Parameters:
[
  1179
]
0.17 ms
(0.86%)
1
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4 FROM category_product t0 WHERE t0.product_id = ?
Parameters:
[
  416
]
0.16 ms
(0.83%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.department AS department_4, t0.email AS email_5, t0.phone AS phone_6, t0.room AS room_7, t0.user_id AS user_id_8, t0.title_before AS title_before_9, t0.title_after AS title_after_10, t0.description AS description_11, t0.slug AS slug_12, t0.is_active AS is_active_13, t0.upload_id AS upload_id_14 FROM person t0 WHERE t0.id = ?
Parameters:
[
  42
]
0.15 ms
(0.77%)
1
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.person_id AS person_id_4 FROM product_person t0 WHERE t0.product_id = ?
Parameters:
[
  416
]
0.15 ms
(0.75%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sequence AS sequence_4, t0.label_type_id AS label_type_id_5 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = ?
Parameters:
[
  2319
]
0.14 ms
(0.72%)
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_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_super_id WHERE p1_.category_sub_id IN (NULL) AND p0_.is_active = 1
Parameters:
[]
0.14 ms
(0.70%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.title AS title_4, t0.description AS description_5, t0.html AS html_6, t0.is_menu AS is_menu_7, t0.slug AS slug_8, t0.upload_id AS upload_id_9 FROM producer t0 WHERE t0.id = ?
Parameters:
[
  85
]

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\Product
  • The mappings App\Entity\Project\Product#productUploadGroup and App\Entity\Project\ProductUploadGroup#Product are inconsistent with each other.
App\Entity\Project\Producer No errors.
App\Entity\Project\Upload No errors.
App\Entity\Project\ProductVariant No errors.
App\Entity\Project\Review No errors.
App\Entity\Project\CategoryProduct 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\ProductPerson No errors.
App\Entity\Project\Colour No errors.
App\Entity\Project\Availability No errors.
App\Entity\Project\PurchaseProductVariant No errors.
App\Entity\Project\Video No errors.
App\Entity\Project\Parameter 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\ProductVariantUploadGroup No errors.
App\Entity\Project\Event No errors.
App\Entity\Project\Transportation No errors.
App\Entity\Project\Purchase No errors.
App\Entity\Project\PaymentType No errors.
App\Entity\Project\ParameterGroup No errors.
App\Entity\Project\ParameterGroupType No errors.
App\Entity\Project\ParameterGroupFilterType No errors.
App\Entity\Project\Category No errors.
App\Entity\Project\Person No errors.
App\Entity\Project\MenuType No errors.
App\Entity\Project\CategoryMenuType No errors.
App\Entity\Project\CategoryCategory No errors.
App\Entity\Project\CategoryType No errors.
App\Entity\Project\Label No errors.
App\Entity\Project\CategoryFile No errors.
App\Entity\Project\Comment No errors.
App\Entity\Project\CategoryPerson No errors.
App\Entity\Project\CategoryEvent No errors.
App\Entity\Project\CategoryUploadGroup No errors.
App\Entity\Project\SubMenuType No errors.
App\Entity\Project\ProducerUploadGroup No errors.
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\UploadType No errors.
App\Entity\Project\EventType No errors.
App\Entity\Project\PurchaseEvent No errors.
App\Entity\Project\Client No errors.
App\Entity\Project\Note No errors.
App\Entity\PurchaseTracking No errors.
App\Entity\Project\CategoryParamGroup
  • The association App\Entity\Project\CategoryParamGroup#category refers to the inverse side field App\Entity\Project\Category#paramGroupCategories which does not exist.
App\Entity\Project\ProductParamGroup
  • The association App\Entity\Project\ProductParamGroup#product refers to the inverse side field App\Entity\Project\Product#productParamGroups which does not exist.
App\Entity\Project\PersonUploadGroup No errors.
App\Entity\Project\LabelType No errors.
App\Entity\Project\File No errors.
App\Entity\Project\EventUploadGroup
  • The association App\Entity\Project\EventUploadGroup#Event refers to the inverse side field App\Entity\Project\Event#eventUploadGroups which does not exist.
App\Entity\Project\ClientDiscount No errors.
App\Entity\Project\InformationBlock
  • The mappings App\Entity\Project\InformationBlock#informationBlockType and App\Entity\Project\InformationBlockType#informationBlocks are inconsistent with each other.
App\Entity\Project\InformationBlockType
  • The association App\Entity\Project\InformationBlockType#informationBlocks refers to the owning side field App\Entity\Project\InformationBlock#InformationBlockType which does not exist.
App\Entity\Project\ProductInformationBlock No errors.
App\Entity\Project\CategoryInformationBlock No errors.
App\Entity\Project\EventInformationBlock No errors.
App\Entity\Project\PersonInformationBlock No errors.