https://hormen.dev.brilo.work/demmo

Query Metrics

431 Database Queries
190 Different statements
296.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.99 ms
(3.71%)
34
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?
Parameters:
[
  351
]
10.44 ms
(3.52%)
5
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND a1_.radiation_direct IN (?) ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
  "nepřímé odrazem"
]
6.20 ms
(2.09%)
4
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND a1_.chromaticity IN (?) ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
  "2700K Teplá bílá"
]
4.49 ms
(1.52%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion = 'Hliníkový reflektor' OR a1_.dispersion LIKE 'Hliníkový reflektor,%' OR a1_.dispersion LIKE '%,Hliníkový reflektor,%' OR a1_.dispersion LIKE '%,Hliníkový reflektor') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.44 ms
(1.50%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion = 'Optiky' OR a1_.dispersion LIKE 'Optiky,%' OR a1_.dispersion LIKE '%,Optiky,%' OR a1_.dispersion LIKE '%,Optiky') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.43 ms
(1.49%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion = 'Mřížka' OR a1_.dispersion LIKE 'Mřížka,%' OR a1_.dispersion LIKE '%,Mřížka,%' OR a1_.dispersion LIKE '%,Mřížka') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.23 ms
(1.43%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.mechanical_durability = 'IK08' OR a1_.mechanical_durability LIKE 'IK08,%' OR a1_.mechanical_durability LIKE '%,IK08,%' OR a1_.mechanical_durability LIKE '%,IK08') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.19 ms
(1.42%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.driver = '1DIM' OR a1_.driver LIKE '1DIM,%' OR a1_.driver LIKE '%,1DIM,%' OR a1_.driver LIKE '%,1DIM') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.13 ms
(1.39%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.driver = '4DIM ZHAGA' OR a1_.driver LIKE '4DIM ZHAGA,%' OR a1_.driver LIKE '%,4DIM ZHAGA,%' OR a1_.driver LIKE '%,4DIM ZHAGA') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.04 ms
(1.36%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.mechanical_durability = 'IK00' OR a1_.mechanical_durability LIKE 'IK00,%' OR a1_.mechanical_durability LIKE '%,IK00,%' OR a1_.mechanical_durability LIKE '%,IK00') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.03 ms
(1.36%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.driver = '4DIM NEMA' OR a1_.driver LIKE '4DIM NEMA,%' OR a1_.driver LIKE '%,4DIM NEMA,%' OR a1_.driver LIKE '%,4DIM NEMA') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
4.01 ms
(1.36%)
27
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target_id AS target_id_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
Parameters:
[
  37
]
4.00 ms
(1.35%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.supplements = 'Přepěťová ochrana 6kV' OR a1_.supplements LIKE 'Přepěťová ochrana 6kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 6kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 6kV') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
3.87 ms
(1.31%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_min = '-20°C' OR a1_.temp_min LIKE '-20°C,%' OR a1_.temp_min LIKE '%,-20°C,%' OR a1_.temp_min LIKE '%,-20°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
3.86 ms
(1.30%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.supplements = 'Přepěťová ochrana 10kV' OR a1_.supplements LIKE 'Přepěťová ochrana 10kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 10kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 10kV') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
3.82 ms
(1.29%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.supplements = 'Přepěťová ochrana 20kV' OR a1_.supplements LIKE 'Přepěťová ochrana 20kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 20kV,%' OR a1_.supplements LIKE '%,Přepěťová ochrana 20kV') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
3.05 ms
(1.03%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 90°' OR a1_.dispersion_variant LIKE 'Optika 90°,%' OR a1_.dispersion_variant LIKE '%,Optika 90°,%' OR a1_.dispersion_variant LIKE '%,Optika 90°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
3.05 ms
(1.03%)
1
SELECT MIN(a0_.input_power) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.99 ms
(1.01%)
1
SELECT MAX(a0_.efficiency) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.97 ms
(1.00%)
1
SELECT MAX(a0_.input_power) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.93 ms
(0.99%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Acrylic satin / Acrylic satin' OR a1_.dispersion_variant LIKE 'Acrylic satin / Acrylic satin,%' OR a1_.dispersion_variant LIKE '%,Acrylic satin / Acrylic satin,%' OR a1_.dispersion_variant LIKE '%,Acrylic satin / Acrylic satin') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.88 ms
(0.97%)
1
SELECT MIN(a0_.efficiency) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.85 ms
(0.96%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) ORDER BY a0_.code ASC) dctrn_result) dctrn_table
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.77 ms
(0.93%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.type = 'Veřejné osvětlení' OR a1_.type LIKE 'Veřejné osvětlení,%' OR a1_.type LIKE '%,Veřejné osvětlení,%' OR a1_.type LIKE '%,Veřejné osvětlení') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.74 ms
(0.92%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'PMMA Opal' OR a1_.dispersion_variant LIKE 'PMMA Opal,%' OR a1_.dispersion_variant LIKE '%,PMMA Opal,%' OR a1_.dispersion_variant LIKE '%,PMMA Opal') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.71 ms
(0.91%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Polovestavné' OR a1_.fixation LIKE 'Polovestavné,%' OR a1_.fixation LIKE '%,Polovestavné,%' OR a1_.fixation LIKE '%,Polovestavné') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.66 ms
(0.90%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Montáž na sloup' OR a1_.fixation LIKE 'Montáž na sloup,%' OR a1_.fixation LIKE '%,Montáž na sloup,%' OR a1_.fixation LIKE '%,Montáž na sloup') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.63 ms
(0.89%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Nástěnné' OR a1_.fixation LIKE 'Nástěnné,%' OR a1_.fixation LIKE '%,Nástěnné,%' OR a1_.fixation LIKE '%,Nástěnné') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.61 ms
(0.88%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'V043-Chodci-Silnice' OR a1_.dispersion_variant LIKE 'V043-Chodci-Silnice,%' OR a1_.dispersion_variant LIKE '%,V043-Chodci-Silnice,%' OR a1_.dispersion_variant LIKE '%,V043-Chodci-Silnice') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.61 ms
(0.88%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 25°' OR a1_.dispersion_variant LIKE 'Reflektor 25°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 25°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 25°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.59 ms
(0.88%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'V054-Plochy' OR a1_.dispersion_variant LIKE 'V054-Plochy,%' OR a1_.dispersion_variant LIKE '%,V054-Plochy,%' OR a1_.dispersion_variant LIKE '%,V054-Plochy') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.58 ms
(0.87%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Parabolická mřížka' OR a1_.dispersion_variant LIKE 'Parabolická mřížka,%' OR a1_.dispersion_variant LIKE '%,Parabolická mřížka,%' OR a1_.dispersion_variant LIKE '%,Parabolická mřížka') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.58 ms
(0.87%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 60°' OR a1_.dispersion_variant LIKE 'Optika 60°,%' OR a1_.dispersion_variant LIKE '%,Optika 60°,%' OR a1_.dispersion_variant LIKE '%,Optika 60°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.56 ms
(0.87%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 48°' OR a1_.dispersion_variant LIKE 'Reflektor 48°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 48°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 48°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.55 ms
(0.86%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 84-35°' OR a1_.dispersion_variant LIKE 'Optika 84-35°,%' OR a1_.dispersion_variant LIKE '%,Optika 84-35°,%' OR a1_.dispersion_variant LIKE '%,Optika 84-35°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.55 ms
(0.86%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 21°' OR a1_.dispersion_variant LIKE 'Reflektor 21°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 21°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 21°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.54 ms
(0.86%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'V038-Chodci-Komunikace' OR a1_.dispersion_variant LIKE 'V038-Chodci-Komunikace,%' OR a1_.dispersion_variant LIKE '%,V038-Chodci-Komunikace,%' OR a1_.dispersion_variant LIKE '%,V038-Chodci-Komunikace') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.54 ms
(0.86%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Vestavné' OR a1_.fixation LIKE 'Vestavné,%' OR a1_.fixation LIKE '%,Vestavné,%' OR a1_.fixation LIKE '%,Vestavné') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.53 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 30°' OR a1_.dispersion_variant LIKE 'Optika 30°,%' OR a1_.dispersion_variant LIKE '%,Optika 30°,%' OR a1_.dispersion_variant LIKE '%,Optika 30°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.53 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 32°' OR a1_.dispersion_variant LIKE 'Reflektor 32°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 32°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 32°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.52 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 36°' OR a1_.dispersion_variant LIKE 'Reflektor 36°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 36°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 36°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.51 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.cri = 'Ra > 70' OR a1_.cri LIKE 'Ra > 70,%' OR a1_.cri LIKE '%,Ra > 70,%' OR a1_.cri LIKE '%,Ra > 70') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.50 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP40' OR a1_.protect_class LIKE 'IP40,%' OR a1_.protect_class LIKE '%,IP40,%' OR a1_.protect_class LIKE '%,IP40') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.50 ms
(0.85%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Obdélník' OR a1_.shape LIKE 'Obdélník,%' OR a1_.shape LIKE '%,Obdélník,%' OR a1_.shape LIKE '%,Obdélník') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.49 ms
(0.84%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Reflektor 50°' OR a1_.dispersion_variant LIKE 'Reflektor 50°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 50°,%' OR a1_.dispersion_variant LIKE '%,Reflektor 50°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.48 ms
(0.84%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP65' OR a1_.protect_class LIKE 'IP65,%' OR a1_.protect_class LIKE '%,IP65,%' OR a1_.protect_class LIKE '%,IP65') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.48 ms
(0.84%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 80-40°' OR a1_.dispersion_variant LIKE 'Optika 80-40°,%' OR a1_.dispersion_variant LIKE '%,Optika 80-40°,%' OR a1_.dispersion_variant LIKE '%,Optika 80-40°') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.47 ms
(0.84%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Microprisma / Acrylic satin' OR a1_.dispersion_variant LIKE 'Microprisma / Acrylic satin,%' OR a1_.dispersion_variant LIKE '%,Microprisma / Acrylic satin,%' OR a1_.dispersion_variant LIKE '%,Microprisma / Acrylic satin') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.44 ms
(0.83%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Oblouk' OR a1_.shape LIKE 'Oblouk,%' OR a1_.shape LIKE '%,Oblouk,%' OR a1_.shape LIKE '%,Oblouk') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.44 ms
(0.82%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Specifický' OR a1_.shape LIKE 'Specifický,%' OR a1_.shape LIKE '%,Specifický,%' OR a1_.shape LIKE '%,Specifický') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.44 ms
(0.82%)
19
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  "/cmf/hormen/contents"
  "default_live"
]
2.44 ms
(0.82%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_min = '-40°C' OR a1_.temp_min LIKE '-40°C,%' OR a1_.temp_min LIKE '%,-40°C,%' OR a1_.temp_min LIKE '%,-40°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.43 ms
(0.82%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP66' OR a1_.protect_class LIKE 'IP66,%' OR a1_.protect_class LIKE '%,IP66,%' OR a1_.protect_class LIKE '%,IP66') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.43 ms
(0.82%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Čtverec' OR a1_.shape LIKE 'Čtverec,%' OR a1_.shape LIKE '%,Čtverec,%' OR a1_.shape LIKE '%,Čtverec') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.41 ms
(0.81%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP54' OR a1_.protect_class LIKE 'IP54,%' OR a1_.protect_class LIKE '%,IP54,%' OR a1_.protect_class LIKE '%,IP54') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.40 ms
(0.81%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Optika 25° asym.' OR a1_.dispersion_variant LIKE 'Optika 25° asym.,%' OR a1_.dispersion_variant LIKE '%,Optika 25° asym.,%' OR a1_.dispersion_variant LIKE '%,Optika 25° asym.') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.39 ms
(0.81%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP67' OR a1_.protect_class LIKE 'IP67,%' OR a1_.protect_class LIKE '%,IP67,%' OR a1_.protect_class LIKE '%,IP67') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.39 ms
(0.81%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Grafitová šedá' OR a1_.color LIKE 'Grafitová šedá,%' OR a1_.color LIKE '%,Grafitová šedá,%' OR a1_.color LIKE '%,Grafitová šedá') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.38 ms
(0.80%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Lineární' OR a1_.shape LIKE 'Lineární,%' OR a1_.shape LIKE '%,Lineární,%' OR a1_.shape LIKE '%,Lineární') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.38 ms
(0.80%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '50°C' OR a1_.temp_max LIKE '50°C,%' OR a1_.temp_max LIKE '%,50°C,%' OR a1_.temp_max LIKE '%,50°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.37 ms
(0.80%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Kartáčovaný elox' OR a1_.color LIKE 'Kartáčovaný elox,%' OR a1_.color LIKE '%,Kartáčovaný elox,%' OR a1_.color LIKE '%,Kartáčovaný elox') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.37 ms
(0.80%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '35°C' OR a1_.temp_max LIKE '35°C,%' OR a1_.temp_max LIKE '%,35°C,%' OR a1_.temp_max LIKE '%,35°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.36 ms
(0.80%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '65°C' OR a1_.temp_max LIKE '65°C,%' OR a1_.temp_max LIKE '%,65°C,%' OR a1_.temp_max LIKE '%,65°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.35 ms
(0.79%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '30°C' OR a1_.temp_max LIKE '30°C,%' OR a1_.temp_max LIKE '%,30°C,%' OR a1_.temp_max LIKE '%,30°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.35 ms
(0.79%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion = 'Microprismatický kryt' OR a1_.dispersion LIKE 'Microprismatický kryt,%' OR a1_.dispersion LIKE '%,Microprismatický kryt,%' OR a1_.dispersion LIKE '%,Microprismatický kryt') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.34 ms
(0.79%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '45°C' OR a1_.temp_max LIKE '45°C,%' OR a1_.temp_max LIKE '%,45°C,%' OR a1_.temp_max LIKE '%,45°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.24 ms
(0.76%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Elox' OR a1_.color LIKE 'Elox,%' OR a1_.color LIKE '%,Elox,%' OR a1_.color LIKE '%,Elox') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
2.04 ms
(0.69%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.resource_type = 'LED moduly' OR a1_.resource_type LIKE 'LED moduly,%' OR a1_.resource_type LIKE '%,LED moduly,%' OR a1_.resource_type LIKE '%,LED moduly') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.99 ms
(0.67%)
11
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters:
[
  "/cmf/hormen/routes/cs/demmo"
  "default_live"
]
1.99 ms
(0.67%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.mechanical_durability = 'IK02' OR a1_.mechanical_durability LIKE 'IK02,%' OR a1_.mechanical_durability LIKE '%,IK02,%' OR a1_.mechanical_durability LIKE '%,IK02') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.98 ms
(0.67%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.driver = 'EVG' OR a1_.driver LIKE 'EVG,%' OR a1_.driver LIKE '%,EVG,%' OR a1_.driver LIKE '%,EVG') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.98 ms
(0.67%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND a1_.supply_voltage IN (?) ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
  "AC 230V 50Hz"
]
1.97 ms
(0.66%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_min = '0°C' OR a1_.temp_min LIKE '0°C,%' OR a1_.temp_min LIKE '%,0°C,%' OR a1_.temp_min LIKE '%,0°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.94 ms
(0.66%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.driver = 'DALI' OR a1_.driver LIKE 'DALI,%' OR a1_.driver LIKE '%,DALI,%' OR a1_.driver LIKE '%,DALI') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.90 ms
(0.64%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class_el = 'I' OR a1_.protect_class_el LIKE 'I,%' OR a1_.protect_class_el LIKE '%,I,%' OR a1_.protect_class_el LIKE '%,I') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.86 ms
(0.63%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion = 'Opálový kryt' OR a1_.dispersion LIKE 'Opálový kryt,%' OR a1_.dispersion LIKE '%,Opálový kryt,%' OR a1_.dispersion LIKE '%,Opálový kryt') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.85 ms
(0.62%)
1
SELECT MIN(a0_.dimension_a) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.82 ms
(0.62%)
1
SELECT MIN(a0_.luminous_flux) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.80 ms
(0.61%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26, a0_.image_id AS image_id_27, a0_.product_family_id AS product_family_id_28, a0_.product_category_id AS product_category_id_29, a0_.idRoute AS idRoute_30, a0_.idUsersCreator AS idUsersCreator_31, a0_.idUsersChanger AS idUsersChanger_32 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) ORDER BY a0_.code ASC LIMIT 18
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.72 ms
(0.58%)
1
SELECT MIN(a0_.dimension_b) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.71 ms
(0.58%)
1
SELECT MAX(a0_.luminous_flux) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.66 ms
(0.56%)
1
SELECT MAX(a0_.dimension_a) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.63 ms
(0.55%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Přisazené' OR a1_.fixation LIKE 'Přisazené,%' OR a1_.fixation LIKE '%,Přisazené,%' OR a1_.fixation LIKE '%,Přisazené') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.62 ms
(0.55%)
1
SELECT MAX(a0_.dimension_b) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.60 ms
(0.54%)
1
SELECT MIN(a0_.dimension_c) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.60 ms
(0.54%)
1
SELECT MAX(a0_.dimension_c) AS sclr_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.59 ms
(0.54%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.type = 'Interiérové LED svítidlo' OR a1_.type LIKE 'Interiérové LED svítidlo,%' OR a1_.type LIKE '%,Interiérové LED svítidlo,%' OR a1_.type LIKE '%,Interiérové LED svítidlo') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.56 ms
(0.53%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.fixation = 'Závěsné' OR a1_.fixation LIKE 'Závěsné,%' OR a1_.fixation LIKE '%,Závěsné,%' OR a1_.fixation LIKE '%,Závěsné') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.40 ms
(0.47%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Microprisma' OR a1_.dispersion_variant LIKE 'Microprisma,%' OR a1_.dispersion_variant LIKE '%,Microprisma,%' OR a1_.dispersion_variant LIKE '%,Microprisma') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.30 ms
(0.44%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.protect_class = 'IP20' OR a1_.protect_class LIKE 'IP20,%' OR a1_.protect_class LIKE '%,IP20,%' OR a1_.protect_class LIKE '%,IP20') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.27 ms
(0.43%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Bílá' OR a1_.color LIKE 'Bílá,%' OR a1_.color LIKE '%,Bílá,%' OR a1_.color LIKE '%,Bílá') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.26 ms
(0.42%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.shape = 'Kruh' OR a1_.shape LIKE 'Kruh,%' OR a1_.shape LIKE '%,Kruh,%' OR a1_.shape LIKE '%,Kruh') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.24 ms
(0.42%)
6
SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
Parameters:
[
  "default_live"
  "6779ed4e-72e3-4e01-ab7d-c6b8e8f17fb0"
]
1.22 ms
(0.41%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Šedá' OR a1_.color LIKE 'Šedá,%' OR a1_.color LIKE '%,Šedá,%' OR a1_.color LIKE '%,Šedá') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.21 ms
(0.41%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.import_id AS import_id_3, t0.slug AS slug_4, t0.category AS category_5, t0.uuid AS uuid_6, t0.webspace AS webspace_7, t0.locale AS locale_8, t0.state AS state_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.seo_canonical_url AS seo_canonical_url_13, t0.seo_no_index AS seo_no_index_14, t0.seo_no_follow AS seo_no_follow_15, t0.seo_hide_in_sitemap AS seo_hide_in_sitemap_16, t0.social_og_title AS social_og_title_17, t0.social_og_description AS social_og_description_18, t0.social_twitter_title AS social_twitter_title_19, t0.social_twitter_description AS social_twitter_description_20, t0.created AS created_21, t0.changed AS changed_22, t0.image_id AS image_id_23, t0.product_category_id AS product_category_id_24, t0.idRoute AS idRoute_25, t0.idUsersCreator AS idUsersCreator_26, t0.idUsersChanger AS idUsersChanger_27 FROM app_product_families t0 WHERE t0.import_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "DEMMO"
  "cs"
]
1.21 ms
(0.41%)
6
SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20 FROM co_contacts t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.18 ms
(0.40%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.cri = 'Ra > 80' OR a1_.cri LIKE 'Ra > 80,%' OR a1_.cri LIKE '%,Ra > 80,%' OR a1_.cri LIKE '%,Ra > 80') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.18 ms
(0.40%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.color = 'Černá' OR a1_.color LIKE 'Černá,%' OR a1_.color LIKE '%,Černá,%' OR a1_.color LIKE '%,Černá') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.18 ms
(0.40%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.temp_max = '25°C' OR a1_.temp_max LIKE '25°C,%' OR a1_.temp_max LIKE '%,25°C,%' OR a1_.temp_max LIKE '%,25°C') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.09 ms
(0.37%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.slug AS slug_3, a0_.code AS code_4, a0_.category AS category_5, a0_.family AS family_6, a0_.description AS description_7, a0_.uuid AS uuid_8, a0_.webspace AS webspace_9, a0_.locale AS locale_10, a0_.state AS state_11, a0_.blocks AS blocks_12, a0_.content_blocks AS content_blocks_13, a0_.seo_title AS seo_title_14, a0_.seo_description AS seo_description_15, a0_.seo_keywords AS seo_keywords_16, a0_.seo_canonical_url AS seo_canonical_url_17, a0_.seo_no_index AS seo_no_index_18, a0_.seo_no_follow AS seo_no_follow_19, a0_.seo_hide_in_sitemap AS seo_hide_in_sitemap_20, a0_.social_og_title AS social_og_title_21, a0_.social_og_description AS social_og_description_22, a0_.social_twitter_title AS social_twitter_title_23, a0_.social_twitter_description AS social_twitter_description_24, a0_.created AS created_25, a0_.changed AS changed_26 FROM app_products a0_ INNER JOIN app_product_variants a1_ ON a0_.id = a1_.product_id WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_family_id IN (?) AND (a1_.dispersion_variant = 'Acrylic Satin' OR a1_.dispersion_variant LIKE 'Acrylic Satin,%' OR a1_.dispersion_variant LIKE '%,Acrylic Satin,%' OR a1_.dispersion_variant LIKE '%,Acrylic Satin') ORDER BY a0_.code ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  22
]
1.07 ms
(0.36%)
6
SELECT t0.value AS value_1, t0.id AS id_2 FROM co_notes t0 INNER JOIN co_contact_notes ON t0.id = co_contact_notes.idNotes WHERE co_contact_notes.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.97 ms
(0.33%)
4
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.title AS title_3, t0.active AS active_4, t0.category AS category_5, t0.family AS family_6, t0.type AS type_7, t0.fixation AS fixation_8, t0.luminous_flux AS luminous_flux_9, t0.cri AS cri_10, t0.chromaticity AS chromaticity_11, t0.dispersion_variant AS dispersion_variant_12, t0.protect_class AS protect_class_13, t0.radiation_direct AS radiation_direct_14, t0.shape AS shape_15, t0.dimension_a AS dimension_a_16, t0.dimension_b AS dimension_b_17, t0.dimension_c AS dimension_c_18, t0.color AS color_19, t0.temp_max AS temp_max_20, t0.temp_min AS temp_min_21, t0.input_power AS input_power_22, t0.efficiency AS efficiency_23, t0.protect_class_el AS protect_class_el_24, t0.supply_voltage AS supply_voltage_25, t0.resource_type AS resource_type_26, t0.status_new AS status_new_27, t0.mechanical_durability AS mechanical_durability_28, t0.dispersion AS dispersion_29, t0.driver AS driver_30, t0.supplements AS supplements_31, t0.dimension AS dimension_32, t0.color_ral AS color_ral_33, t0.material AS material_34, t0.driver_function AS driver_function_35, t0.weight AS weight_36, t0.luminous_flux_supply AS luminous_flux_supply_37, t0.alive_led AS alive_led_38, t0.guarantee AS guarantee_39, t0.variant_use AS variant_use_40, t0.accessories AS accessories_41, t0.description AS description_42, t0.uuid AS uuid_43, t0.webspace AS webspace_44, t0.locale AS locale_45, t0.state AS state_46, t0.created AS created_47, t0.changed AS changed_48, t0.image_id AS image_id_49, t0.product_id AS product_id_50, t0.product_family_id AS product_family_id_51, t0.product_category_id AS product_category_id_52, t0.image_schema_id AS image_schema_id_53, t0.image_curves_id AS image_curves_id_54, t0.ltd_curves_id AS ltd_curves_id_55, t0.idUsersCreator AS idUsersCreator_56, t0.idUsersChanger AS idUsersChanger_57 FROM app_product_variants t0 WHERE t0.title = ? AND t0.active = ?
Parameters:
[
  "DEMMO LED"
  1
]
0.95 ms
(0.32%)
6
SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idContacts = ?
Parameters:
[
  1
]
0.84 ms
(0.28%)
3
SELECT DATABASE()
Parameters:
[]
0.79 ms
(0.27%)
5
SELECT t0.id AS id_1, t0.page_uuid AS page_uuid_2, t0.icon_id AS icon_id_3 FROM app_icon_settings t0 WHERE t0.page_uuid = ? LIMIT 1
Parameters:
[
  "14437c0c-581b-4b07-9486-792849324ff8"
]
0.75 ms
(0.25%)
6
SELECT t0.main AS main_1, t0.id AS id_2, t0.idAddresses AS idAddresses_3, t0.idContacts AS idContacts_4 FROM co_contact_addresses t0 WHERE t0.idContacts = ?
Parameters:
[
  1
]
0.74 ms
(0.25%)
6
SELECT t0.phone AS phone_1, t0.id AS id_2, t0.idPhoneTypes AS idPhoneTypes_3 FROM co_phones t0 INNER JOIN co_contact_phones ON t0.id = co_contact_phones.idPhones WHERE co_contact_phones.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.70 ms
(0.24%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.import_id AS import_id_3, t0.slug AS slug_4, t0.category AS category_5, t0.uuid AS uuid_6, t0.webspace AS webspace_7, t0.locale AS locale_8, t0.state AS state_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.seo_canonical_url AS seo_canonical_url_13, t0.seo_no_index AS seo_no_index_14, t0.seo_no_follow AS seo_no_follow_15, t0.seo_hide_in_sitemap AS seo_hide_in_sitemap_16, t0.social_og_title AS social_og_title_17, t0.social_og_description AS social_og_description_18, t0.social_twitter_title AS social_twitter_title_19, t0.social_twitter_description AS social_twitter_description_20, t0.created AS created_21, t0.changed AS changed_22, t0.image_id AS image_id_23, t0.product_category_id AS product_category_id_24, t0.idRoute AS idRoute_25, t0.idUsersCreator AS idUsersCreator_26, t0.idUsersChanger AS idUsersChanger_27 FROM app_product_families t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
0.66 ms
(0.22%)
6
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idContacts AS idContacts_3 FROM co_contact_locales t0 WHERE t0.idContacts = ?
Parameters:
[
  1
]
0.65 ms
(0.22%)
3
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[
  "4dbf57e2-9258-4c72-a2d2-d4ac2a954c5f"
  "default_live"
]
0.64 ms
(0.22%)
6
SELECT t0.crop_x AS crop_x_1, t0.crop_y AS crop_y_2, t0.crop_width AS crop_width_3, t0.crop_height AS crop_height_4, t0.format_key AS format_key_5, t0.fileVersion AS fileVersion_6 FROM me_format_options t0 WHERE t0.fileVersion = ?
Parameters:
[
  45
]
0.64 ms
(0.22%)
6
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idFileVersions AS idFileVersions_3 FROM me_file_version_content_languages t0 WHERE t0.idFileVersions = ?
Parameters:
[
  45
]
0.64 ms
(0.21%)
6
SELECT t0.category_key AS category_key_1, t0.default_locale AS default_locale_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.depth AS depth_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.idCategoriesParent AS idCategoriesParent_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN me_file_version_categories ON t0.id = me_file_version_categories.idCategories WHERE me_file_version_categories.idFileVersions = ? ORDER BY t0.id ASC
Parameters:
[
  45
]
0.63 ms
(0.21%)
6
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 INNER JOIN co_contact_medias ON t0.id = co_contact_medias.idMedias WHERE co_contact_medias.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.63 ms
(0.21%)
4
SELECT t0.position AS position_1, t0.product_id AS product_id_2, t0.media_id AS media_id_3 FROM app_product_icons t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  66
]
0.63 ms
(0.21%)
6
SELECT t0.fax AS fax_1, t0.id AS id_2, t0.idFaxTypes AS idFaxTypes_3 FROM co_faxes t0 INNER JOIN co_contact_faxes ON t0.id = co_contact_faxes.idFaxes WHERE co_contact_faxes.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.61 ms
(0.21%)
6
SELECT t0.category_key AS category_key_1, t0.default_locale AS default_locale_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.depth AS depth_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.idCategoriesParent AS idCategoriesParent_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN co_contact_categories ON t0.id = co_contact_categories.idCategories WHERE co_contact_categories.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.61 ms
(0.20%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.import_id AS import_id_3, t0.slug AS slug_4, t0.category AS category_5, t0.uuid AS uuid_6, t0.webspace AS webspace_7, t0.locale AS locale_8, t0.state AS state_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.seo_canonical_url AS seo_canonical_url_13, t0.seo_no_index AS seo_no_index_14, t0.seo_no_follow AS seo_no_follow_15, t0.seo_hide_in_sitemap AS seo_hide_in_sitemap_16, t0.social_og_title AS social_og_title_17, t0.social_og_description AS social_og_description_18, t0.social_twitter_title AS social_twitter_title_19, t0.social_twitter_description AS social_twitter_description_20, t0.created AS created_21, t0.changed AS changed_22, t0.image_id AS image_id_23, t0.product_category_id AS product_category_id_24, t0.idRoute AS idRoute_25, t0.idUsersCreator AS idUsersCreator_26, t0.idUsersChanger AS idUsersChanger_27 FROM app_product_families t0 WHERE t0.uuid = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "9e35915a-a9cb-4c68-b0aa-444bd9a3cdfb"
  "cs"
]
0.60 ms
(0.20%)
6
SELECT t0.email AS email_1, t0.id AS id_2, t0.idEmailTypes AS idEmailTypes_3 FROM co_emails t0 INNER JOIN co_contact_emails ON t0.id = co_contact_emails.idEmails WHERE co_contact_emails.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.59 ms
(0.20%)
6
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM ta_tags t0 INNER JOIN co_contact_tags ON t0.id = co_contact_tags.idTags WHERE co_contact_tags.idContacts = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.58 ms
(0.20%)
3
SELECT t0.username AS username_1, t0.password AS password_2, t0.locale AS locale_3, t0.salt AS salt_4, t0.locked AS locked_5, t0.enabled AS enabled_6, t0.lastLogin AS lastLogin_7, t0.confirmationKey AS confirmationKey_8, t0.passwordResetToken AS passwordResetToken_9, t0.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_10, t0.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_11, t0.privateKey AS privateKey_12, t0.apiKey AS apiKey_13, t0.email AS email_14, t0.id AS id_15, t0.created AS created_16, t0.changed AS changed_17, t18.method AS method_19, t18.options AS options_20, t18.id AS id_21, t18.idUsers AS idUsers_22, t0.idContacts AS idContacts_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM se_users t0 LEFT JOIN se_user_two_factors t18 ON t18.idUsers = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(0.20%)
6
SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_contact_social_media_profiles ON t0.id = co_contact_social_media_profiles.idSocialMediaProfiles WHERE co_contact_social_media_profiles.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.56 ms
(0.19%)
6
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idFileVersions AS idFileVersions_3 FROM me_file_version_publish_languages t0 WHERE t0.idFileVersions = ?
Parameters:
[
  45
]
0.56 ms
(0.19%)
6
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM ta_tags t0 INNER JOIN me_file_version_tags ON t0.id = me_file_version_tags.idTags WHERE me_file_version_tags.idFileVersions = ?
Parameters:
[
  45
]
0.55 ms
(0.19%)
6
SELECT t0.url AS url_1, t0.id AS id_2, t0.idUrlTypes AS idUrlTypes_3 FROM co_urls t0 INNER JOIN co_contact_urls ON t0.id = co_contact_urls.idUrls WHERE co_contact_urls.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.55 ms
(0.18%)
1
SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
Parameters:
[
  "/demmo"
  "cs"
]
0.52 ms
(0.17%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 INNER JOIN app_product_family_social_og_images ON t0.id = app_product_family_social_og_images.media_id WHERE app_product_family_social_og_images.product_family_id = ?
Parameters:
[
  22
]
0.51 ms
(0.17%)
4
SELECT t0.position AS position_1, t0.id AS id_2 FROM co_positions t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.50 ms
(0.17%)
4
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters:
[
  39
]
0.50 ms
(0.17%)
6
SELECT t0.bankName AS bankName_1, t0.bic AS bic_2, t0.iban AS iban_3, t0.public AS public_4, t0.id AS id_5 FROM co_bank_account t0 INNER JOIN co_contact_bank_accounts ON t0.id = co_contact_bank_accounts.idBankAccounts WHERE co_contact_bank_accounts.idContacts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.49 ms
(0.17%)
6
SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = ?
Parameters:
[
  45
]
0.46 ms
(0.15%)
3
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idUsers AS idUsers_3, t0.idRoles AS idRoles_4 FROM se_user_roles t0 WHERE t0.idUsers = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.44 ms
(0.15%)
4
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters:
[
  39
]
0.42 ms
(0.14%)
4
SELECT t0.name AS name_1, t0.id AS id_2 FROM co_social_media_profile_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.41 ms
(0.14%)
1
SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c0_.identification_number AS identification_number_18, c0_.tax_identification_number AS tax_identification_number_19, c0_.case_number AS case_number_20, c1_.category_key AS category_key_21, c1_.default_locale AS default_locale_22, c1_.lft AS lft_23, c1_.rgt AS rgt_24, c1_.depth AS depth_25, c1_.id AS id_26, c1_.created AS created_27, c1_.changed AS changed_28, c2_.translation AS translation_29, c2_.locale AS locale_30, c2_.description AS description_31, c2_.id AS id_32, c2_.created AS created_33, c2_.changed AS changed_34, c3_.main AS main_35, c3_.id AS id_36, c4_.title AS title_37, c4_.primaryAddress AS primaryAddress_38, c4_.deliveryAddress AS deliveryAddress_39, c4_.billingAddress AS billingAddress_40, c4_.street AS street_41, c4_.number AS number_42, c4_.addition AS addition_43, c4_.zip AS zip_44, c4_.city AS city_45, c4_.state AS state_46, c4_.countryCode AS countryCode_47, c4_.postboxNumber AS postboxNumber_48, c4_.postboxPostcode AS postboxPostcode_49, c4_.postboxCity AS postboxCity_50, c4_.latitude AS latitude_51, c4_.longitude AS longitude_52, c4_.note AS note_53, c4_.id AS id_54, c5_.name AS name_55, c5_.id AS id_56, c6_.lft AS lft_57, c6_.rgt AS rgt_58, c6_.depth AS depth_59, c6_.name AS name_60, c6_.externalId AS externalId_61, c6_.number AS number_62, c6_.corporation AS corporation_63, c6_.note AS note_64, c6_.uid AS uid_65, c6_.registerNumber AS registerNumber_66, c6_.placeOfJurisdiction AS placeOfJurisdiction_67, c6_.mainEmail AS mainEmail_68, c6_.mainPhone AS mainPhone_69, c6_.mainFax AS mainFax_70, c6_.mainUrl AS mainUrl_71, c6_.id AS id_72, c6_.created AS created_73, c6_.changed AS changed_74, c6_.identification_number AS identification_number_75, c6_.tax_identification_number AS tax_identification_number_76, c6_.case_number AS case_number_77, c7_.url AS url_78, c7_.id AS id_79, c8_.name AS name_80, c8_.id AS id_81, c9_.phone AS phone_82, c9_.id AS id_83, c10_.name AS name_84, c10_.id AS id_85, c11_.email AS email_86, c11_.id AS id_87, c12_.name AS name_88, c12_.id AS id_89, c13_.value AS value_90, c13_.id AS id_91, c14_.fax AS fax_92, c14_.id AS id_93, c15_.name AS name_94, c15_.id AS id_95, c16_.bankName AS bankName_96, c16_.bic AS bic_97, c16_.iban AS iban_98, c16_.public AS public_99, c16_.id AS id_100, t17_.name AS name_101, t17_.id AS id_102, c18_.firstName AS firstName_103, c18_.middleName AS middleName_104, c18_.lastName AS lastName_105, c18_.birthday AS birthday_106, c18_.salutation AS salutation_107, c18_.formOfAddress AS formOfAddress_108, c18_.newsletter AS newsletter_109, c18_.gender AS gender_110, c18_.note AS note_111, c18_.mainEmail AS mainEmail_112, c18_.mainPhone AS mainPhone_113, c18_.mainFax AS mainFax_114, c18_.mainUrl AS mainUrl_115, c18_.id AS id_116, c18_.created AS created_117, c18_.changed AS changed_118, m19_.id AS id_119, m19_.created AS created_120, m19_.changed AS changed_121, c0_.idContactsMain AS idContactsMain_122, c0_.idAccountsParent AS idAccountsParent_123, c0_.logo AS logo_124, c0_.idUsersCreator AS idUsersCreator_125, c0_.idUsersChanger AS idUsersChanger_126, c1_.idCategoriesParent AS idCategoriesParent_127, c1_.idUsersCreator AS idUsersCreator_128, c1_.idUsersChanger AS idUsersChanger_129, c2_.idCategories AS idCategories_130, c2_.idUsersCreator AS idUsersCreator_131, c2_.idUsersChanger AS idUsersChanger_132, c3_.idAddresses AS idAddresses_133, c3_.idAccounts AS idAccounts_134, c4_.idAdressTypes AS idAdressTypes_135, c6_.idContactsMain AS idContactsMain_136, c6_.idAccountsParent AS idAccountsParent_137, c6_.logo AS logo_138, c6_.idUsersCreator AS idUsersCreator_139, c6_.idUsersChanger AS idUsersChanger_140, c7_.idUrlTypes AS idUrlTypes_141, c9_.idPhoneTypes AS idPhoneTypes_142, c11_.idEmailTypes AS idEmailTypes_143, c14_.idFaxTypes AS idFaxTypes_144, t17_.idUsersCreator AS idUsersCreator_145, t17_.idUsersChanger AS idUsersChanger_146, c18_.idTitles AS idTitles_147, c18_.avatar AS avatar_148, c18_.idUsersCreator AS idUsersCreator_149, c18_.idUsersChanger AS idUsersChanger_150, m19_.idMediaTypes AS idMediaTypes_151, m19_.idPreviewImage AS idPreviewImage_152, m19_.idCollections AS idCollections_153, m19_.idUsersCreator AS idUsersCreator_154, m19_.idUsersChanger AS idUsersChanger_155 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_social_media_profiles c27_ ON c0_.id = c27_.idAccounts LEFT JOIN co_social_media_profiles c26_ ON c26_.id = c27_.idSocialMediaProfiles LEFT JOIN co_social_media_profile_types c28_ ON c26_.idSocialMediaTypes = c28_.id LEFT JOIN co_account_bank_accounts c29_ ON c0_.id = c29_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c29_.idBankAccounts LEFT JOIN co_account_tags c30_ ON c0_.id = c30_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c30_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c31_ ON c0_.id = c31_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c31_.idMedias WHERE c0_.id = ? ORDER BY c1_.id ASC, c7_.id ASC, c9_.id ASC, c11_.id ASC, c13_.id ASC, c14_.id ASC, c16_.id ASC, t17_.name ASC, m19_.id ASC
Parameters:
[
  1
]
0.37 ms
(0.12%)
2
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[]
0.36 ms
(0.12%)
3
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idGroups AS idGroups_3, t0.idUsers AS idUsers_4 FROM se_user_groups t0 WHERE t0.idUsers = ?
Parameters:
[
  1
]
0.34 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 INNER JOIN app_product_family_social_twitter_images ON t0.id = app_product_family_social_twitter_images.media_id WHERE app_product_family_social_twitter_images.product_family_id = ?
Parameters:
[
  22
]
0.34 ms
(0.11%)
4
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters:
[
  39
]
0.32 ms
(0.11%)
3
SELECT t0.settingsValue AS settingsValue_1, t0.settingsKey AS settingsKey_2, t0.idUsers AS idUsers_3 FROM se_user_settings t0 WHERE t0.idUsers = ?
Parameters:
[
  1
]
0.30 ms
(0.10%)
1
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters:
[
  "hormen.dev.brilo.work"
  "dev"
  "hormen"
]
0.30 ms
(0.10%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:cs-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:cs-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:cs-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/hormen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
0.29 ms
(0.10%)
2
SELECT t0.title AS title_1, t0.primaryAddress AS primaryAddress_2, t0.deliveryAddress AS deliveryAddress_3, t0.billingAddress AS billingAddress_4, t0.street AS street_5, t0.number AS number_6, t0.addition AS addition_7, t0.zip AS zip_8, t0.city AS city_9, t0.state AS state_10, t0.countryCode AS countryCode_11, t0.postboxNumber AS postboxNumber_12, t0.postboxPostcode AS postboxPostcode_13, t0.postboxCity AS postboxCity_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.note AS note_17, t0.id AS id_18, t0.idAdressTypes AS idAdressTypes_19 FROM co_addresses t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.29 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 INNER JOIN co_account_medias ON t0.id = co_account_medias.idMedias WHERE co_account_medias.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.26 ms
(0.09%)
1
SELECT DISTINCT a0_.type AS type_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ?
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.24 ms
(0.08%)
1
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
Parameters:
[
  "default_live"
  "/cmf/hormen/contents/o-hormen"
  "/cmf/hormen/contents/reference"
  "/cmf/hormen/contents/kariera"
  "/cmf/hormen/contents/ke-stazeni"
  "/cmf/hormen/contents/kontakty"
]
0.24 ms
(0.08%)
1
SELECT t0.name AS name_1, t0.role_key AS role_key_2, t0.securitySystem AS securitySystem_3, t0.anonymous AS anonymous_4, t0.id AS id_5, t0.created AS created_6, t0.changed AS changed_7, t0.idSecurityTypes AS idSecurityTypes_8, t0.idUsersCreator AS idUsersCreator_9, t0.idUsersChanger AS idUsersChanger_10 FROM se_roles t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.23 ms
(0.08%)
1
SELECT DISTINCT a0_.product_code AS product_code_0, a0_.title AS title_1 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.product_code IN (?, ?, ?)
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
  "Přepěťová ochrana 10kV"
  "Přepěťová ochrana 20kV"
  "Přepěťová ochrana 6kV"
]
0.22 ms
(0.08%)
1
SELECT DISTINCT a0_.resource_type AS resource_type_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.resource_type <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.22 ms
(0.07%)
1
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  "/cmf/hormen/contents/o-hormen"
  "/cmf/hormen/contents/reference"
  "/cmf/hormen/contents/kariera"
  "/cmf/hormen/contents/ke-stazeni"
  "/cmf/hormen/contents/kontakty"
  "default_live"
]
0.22 ms
(0.07%)
1
SELECT DISTINCT a0_.supplements AS supplements_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.supplements <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.21 ms
(0.07%)
1
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
0.21 ms
(0.07%)
1
SELECT DISTINCT a0_.temp_max AS temp_max_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.temp_max <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.21 ms
(0.07%)
1
SELECT DISTINCT a0_.protect_class AS protect_class_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.protect_class <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.21 ms
(0.07%)
1
SELECT DISTINCT a0_.dispersion AS dispersion_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.dispersion <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.20 ms
(0.07%)
1
SELECT DISTINCT a0_.radiation_direct AS radiation_direct_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.radiation_direct <> '' ORDER BY a0_.radiation_direct ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.20 ms
(0.07%)
1
SELECT DISTINCT a0_.driver AS driver_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.driver <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.20 ms
(0.07%)
1
SELECT DISTINCT a0_.protect_class_el AS protect_class_el_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.protect_class_el <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.19 ms
(0.07%)
1
SELECT DISTINCT a0_.mechanical_durability AS mechanical_durability_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.mechanical_durability <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.18 ms
(0.06%)
1
SELECT DISTINCT a0_.shape AS shape_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.shape <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.18 ms
(0.06%)
1
SELECT DISTINCT a0_.temp_min AS temp_min_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.temp_min <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.16 ms
(0.05%)
1
SELECT DISTINCT a0_.supply_voltage AS supply_voltage_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.supply_voltage <> '' ORDER BY a0_.supply_voltage ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.16 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.import_id AS import_id_3, t0.slug AS slug_4, t0.category AS category_5, t0.uuid AS uuid_6, t0.webspace AS webspace_7, t0.locale AS locale_8, t0.state AS state_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.seo_canonical_url AS seo_canonical_url_13, t0.seo_no_index AS seo_no_index_14, t0.seo_no_follow AS seo_no_follow_15, t0.seo_hide_in_sitemap AS seo_hide_in_sitemap_16, t0.social_og_title AS social_og_title_17, t0.social_og_description AS social_og_description_18, t0.social_twitter_title AS social_twitter_title_19, t0.social_twitter_description AS social_twitter_description_20, t0.created AS created_21, t0.changed AS changed_22, t0.image_id AS image_id_23, t0.product_category_id AS product_category_id_24, t0.idRoute AS idRoute_25, t0.idUsersCreator AS idUsersCreator_26, t0.idUsersChanger AS idUsersChanger_27 FROM app_product_families t0 WHERE t0.category = ? ORDER BY t0.title ASC
Parameters:
[
  "kat-interier"
]
0.16 ms
(0.05%)
1
SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.depth AS depth_3, t0.name AS name_4, t0.externalId AS externalId_5, t0.number AS number_6, t0.corporation AS corporation_7, t0.note AS note_8, t0.uid AS uid_9, t0.registerNumber AS registerNumber_10, t0.placeOfJurisdiction AS placeOfJurisdiction_11, t0.mainEmail AS mainEmail_12, t0.mainPhone AS mainPhone_13, t0.mainFax AS mainFax_14, t0.mainUrl AS mainUrl_15, t0.id AS id_16, t0.created AS created_17, t0.changed AS changed_18, t0.identification_number AS identification_number_19, t0.tax_identification_number AS tax_identification_number_20, t0.case_number AS case_number_21, t0.idContactsMain AS idContactsMain_22, t0.idAccountsParent AS idAccountsParent_23, t0.logo AS logo_24, t0.idUsersCreator AS idUsersCreator_25, t0.idUsersChanger AS idUsersChanger_26 FROM co_accounts t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.15 ms
(0.05%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '427bdde6-cc5b-4258-ac91-018df503a347' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:cs-state"]/sv:value'), ' ', ','))) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
0.15 ms
(0.05%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM co_address_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.15 ms
(0.05%)
1
SELECT DISTINCT a0_.cri AS cri_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.cri <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.15 ms
(0.05%)
1
SELECT DISTINCT a0_.dispersion_variant AS dispersion_variant_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.dispersion_variant <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.15 ms
(0.05%)
1
SELECT DISTINCT a0_.fixation AS fixation_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.fixation <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.14 ms
(0.05%)
1
SELECT DISTINCT a0_.chromaticity AS chromaticity_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.chromaticity <> '' ORDER BY a0_.chromaticity ASC
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.14 ms
(0.05%)
1
SELECT t0.context AS context_1, t0.module AS module_2, t0.permissions AS permissions_3, t0.id AS id_4, t0.idRoles AS idRoles_5 FROM se_permissions t0 WHERE t0.idRoles = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.14 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.import_id AS import_id_4, t0.content AS content_5, t0.uuid AS uuid_6, t0.webspace AS webspace_7, t0.locale AS locale_8, t0.state AS state_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.seo_canonical_url AS seo_canonical_url_13, t0.seo_no_index AS seo_no_index_14, t0.seo_no_follow AS seo_no_follow_15, t0.seo_hide_in_sitemap AS seo_hide_in_sitemap_16, t0.social_og_title AS social_og_title_17, t0.social_og_description AS social_og_description_18, t0.social_twitter_title AS social_twitter_title_19, t0.social_twitter_description AS social_twitter_description_20, t0.created AS created_21, t0.changed AS changed_22, t0.idRoute AS idRoute_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM app_product_categories t0 WHERE t0.import_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "kat-interier"
  "cs"
]
0.14 ms
(0.05%)
1
SELECT t0.url AS url_1, t0.id AS id_2, t0.idUrlTypes AS idUrlTypes_3 FROM co_urls t0 INNER JOIN co_account_urls ON t0.id = co_account_urls.idUrls WHERE co_account_urls.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.13 ms
(0.05%)
1
SELECT DISTINCT a0_.color AS color_0 FROM app_product_variants a0_ WHERE a0_.webspace = ? AND a0_.locale = ? AND a0_.state = ? AND a0_.active = ? AND a0_.color <> ''
Parameters:
[
  "hormen"
  "cs"
  "published"
  1
]
0.13 ms
(0.04%)
1
SELECT t0.settingKey AS settingKey_1, t0.value AS value_2, t0.id AS id_3, t0.roleId AS roleId_4 FROM se_role_settings t0 WHERE t0.roleId = ?
Parameters:
[
  1
]
0.13 ms
(0.04%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM co_email_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.13 ms
(0.04%)
1
SELECT t0.name AS name_1, t0.id AS id_2 FROM co_phone_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.12 ms
(0.04%)
1
SELECT t0.main AS main_1, t0.id AS id_2, t0.idAddresses AS idAddresses_3, t0.idAccounts AS idAccounts_4 FROM co_account_addresses t0 WHERE t0.idAccounts = ?
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT t0.email AS email_1, t0.id AS id_2, t0.idEmailTypes AS idEmailTypes_3 FROM co_emails t0 INNER JOIN co_account_emails ON t0.id = co_account_emails.idEmails WHERE co_account_emails.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.id AS id_3 FROM me_media_types t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.11 ms
(0.04%)
1
SELECT t0.category_key AS category_key_1, t0.default_locale AS default_locale_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.depth AS depth_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.idCategoriesParent AS idCategoriesParent_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN co_account_categories ON t0.id = co_account_categories.idCategories WHERE co_account_categories.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT t0.value AS value_1, t0.id AS id_2 FROM co_notes t0 INNER JOIN co_account_notes ON t0.id = co_account_notes.idNotes WHERE co_account_notes.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT t0.phone AS phone_1, t0.id AS id_2, t0.idPhoneTypes AS idPhoneTypes_3 FROM co_phones t0 INNER JOIN co_account_phones ON t0.id = co_account_phones.idPhones WHERE co_account_phones.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.11 ms
(0.04%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/hormen/contents/katalog-produktu' LIMIT 1
Parameters:
[
  "default_live"
]
0.10 ms
(0.04%)
1
SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idAccounts = ?
Parameters:
[
  1
]
0.08 ms
(0.03%)
1
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
0.08 ms
(0.03%)
1
SELECT t0.fax AS fax_1, t0.id AS id_2, t0.idFaxTypes AS idFaxTypes_3 FROM co_faxes t0 INNER JOIN co_account_faxes ON t0.id = co_account_faxes.idFaxes WHERE co_account_faxes.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.08 ms
(0.03%)
1
SELECT t0.bankName AS bankName_1, t0.bic AS bic_2, t0.iban AS iban_3, t0.public AS public_4, t0.id AS id_5 FROM co_bank_account t0 INNER JOIN co_account_bank_accounts ON t0.id = co_account_bank_accounts.idBankAccounts WHERE co_account_bank_accounts.idAccounts = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.08 ms
(0.03%)
1
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM ta_tags t0 INNER JOIN co_account_tags ON t0.id = co_account_tags.idTags WHERE co_account_tags.idAccounts = ? ORDER BY t0.name ASC
Parameters:
[
  1
]

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
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\RouteBundle\Entity\Route No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\Entity\ProductFamily No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
App\Entity\Contact No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting No errors.
Sulu\Bundle\SecurityBundle\Entity\Role No errors.
Sulu\Bundle\SecurityBundle\Entity\SecurityType No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact No errors.
Sulu\Bundle\ContactBundle\Entity\Url No errors.
Sulu\Bundle\ContactBundle\Entity\Note No errors.
Sulu\Bundle\ContactBundle\Entity\Email No errors.
Sulu\Bundle\ContactBundle\Entity\Phone No errors.
Sulu\Bundle\ContactBundle\Entity\Fax No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\ContactBundle\Entity\Position No errors.
Sulu\Bundle\ContactBundle\Entity\Account No errors.
App\Entity\Account No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType No errors.
Sulu\Bundle\ContactBundle\Entity\Address No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType No errors.
Sulu\Bundle\MediaBundle\Entity\File No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions No errors.
Sulu\Bundle\ContactBundle\Entity\AccountAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AddressType No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
App\Entity\IconSettings No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
App\Entity\ProductVariant No errors.
App\Entity\ProductIcon No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.