GET https://www.new.pakom-el.hr/shop/opsavi-i-hidroizolacija/opsavi-kombinirani

Response
200 OK
IP
216.73.216.221
Profiled on
Token
edf725

Query Metrics

78 Database Queries
15 Different statements
117.90 ms Query time
0 Invalid entities
300 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.16 ms 
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1
Parameters: 
[
  "pakom"
  "hr"
  "/shop/opsavi-i-hidroizolacija/opsavi-kombinirani"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.80 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE p0_.uuid = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?)))
Parameters: 
[
  "hr"
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.60 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  329
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.36 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  330
]
View formatted query    View runnable query    Explain query    View query backtrace
5 6.11 ms 
SELECT DISTINCT p0_.uuid AS uuid_0, p0_.webspaceKey AS webspaceKey_1, p1_.title AS title_2, p0_.lft AS lft_3 FROM pa_pages p0_ INNER JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid) LEFT JOIN pa_pages p2_ ON (p2_.uuid = ?) WHERE p1_.locale = ? AND p1_.stage = ? AND p1_.version = ? AND p1_.templateKey IN (?) AND p0_.lft > p2_.lft AND p0_.rgt < p2_.rgt ORDER BY p0_.lft ASC
Parameters: 
[
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
  "hr"
  "live"
  0
  "product-display-page"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 3.44 ms 
SELECT COUNT(DISTINCT p0_.uuid) AS sclr_0 FROM pa_pages p0_ INNER JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid) LEFT JOIN pa_pages p2_ ON (p2_.uuid = ?) WHERE p1_.locale = ? AND p1_.stage = ? AND p1_.version = ? AND p1_.templateKey IN (?) AND p0_.lft > p2_.lft AND p0_.rgt < p2_.rgt
Parameters: 
[
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
  "hr"
  "live"
  0
  "product-display-page"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 3.96 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p0_.parent_id AS parent_id_56, p0_.idUsersCreator AS idUsersCreator_57, p0_.idUsersChanger AS idUsersChanger_58, p1_.route_id AS route_id_59, p1_.pageUuid AS pageUuid_60, p1_.author_id AS author_id_61, p1_.idUsersCreator AS idUsersCreator_62, p1_.idUsersChanger AS idUsersChanger_63, t2_.idUsersCreator AS idUsersCreator_64, t2_.idUsersChanger AS idUsersChanger_65, c3_.idCategoriesParent AS idCategoriesParent_66, c3_.idUsersCreator AS idUsersCreator_67, c3_.idUsersChanger AS idUsersChanger_68, c4_.idCategories AS idCategories_69, c4_.idUsersCreator AS idUsersCreator_70, c4_.idUsersChanger AS idUsersChanger_71, r5_.parent_id AS parent_id_72 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p6_ ON (p6_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p7_ ON p1_.id = p7_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p7_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p8_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id WHERE p0_.uuid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p6_.locale = ? AND p6_.stage = ? AND p6_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?)))
Parameters: 
[
  "hr"
  "01a0a54b-1680-79e4-b6b2-b2adb12cd455"
  "01a0a54b-1809-7137-8a05-3f352468f7a4"
  "01a0a54b-1987-7e16-9e14-5aa2ea9a2bac"
  "01a0a54b-1b14-71e3-bbdf-eb4599e0545b"
  "01a0a54b-1dc5-74fc-8c2c-f21375556fb9"
  "01a0a54b-1f59-7d26-b20d-0fa0d9288507"
  "01a0a54b-20f9-79ab-82ce-efc138bb3d9e"
  "01a0a54b-2289-7a5a-99c3-9399e36ae938"
  "01a0a54b-2437-786a-b8ed-6dbe9cc393a5"
  "01a0a54b-25d5-7574-bf86-f58373109f0c"
  "01a0a54b-2794-7ee0-a572-befb259e6a71"
  "01a0a54b-293d-7631-b706-1498c884dc8f"
  "01a0a54b-2e3f-7e53-b1fa-fb4bcf026dd3"
  "01a0a54b-2ff3-7492-9416-9b482591375c"
  "01a0a54b-31ab-71fb-b757-4e54da65f7d1"
  "01a0a54b-3365-7d6d-a004-fab95eba5093"
  "01a0a54b-352a-712e-92b4-1a80a5f7f340"
  "01a0a54b-80e4-7943-81cf-daef40dc45b9"
  "01a0a54b-8ab7-7099-8c8e-894ae877340d"
  "01a0a54b-8d36-71c8-8073-6f2bf0b211e2"
  "01a0a54b-9080-73b2-9ec3-3ebfed1ed5df"
  "01a0a54b-931d-7157-93d3-5312bf1c9bba"
  "01a0a54b-95a8-7386-bb05-4ddb90884778"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.42 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  791
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  792
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  797
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.19 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  798
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.20 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  803
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.19 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  804
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  809
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  810
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  815
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  816
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  821
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  822
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  827
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  828
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  833
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  834
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  839
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  840
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  845
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  846
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  851
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.22 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  852
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  857
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  858
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.23 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  875
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.21 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  876
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  881
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.25 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  882
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.27 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  887
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  888
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.27 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  893
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  894
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  899
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.25 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  900
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1115
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.25 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1116
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1139
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1140
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1145
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1146
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.26 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1151
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.24 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1152
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.27 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1157
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.25 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1158
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.29 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1163
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.28 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters: 
[
  1164
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.72 ms 
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE r0_.locale IN (?) AND r0_.resource_key = ? AND r0_.resource_id = ?
Parameters: 
[
  "hr"
  "pages"
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.46 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background AS background_4, t0.text_color AS text_color_5, t0.active AS active_6 FROM app_ribbon t0 WHERE t0.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.33 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background AS background_4, t0.text_color AS text_color_5, t0.active AS active_6 FROM app_ribbon t0 WHERE t0.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
57 8.07 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 2.00 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.41 ms 
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
60 2.08 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
61 1.75 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
62 1.71 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
63 1.70 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
64 1.87 ms 
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
65 8.03 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
66 6.50 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 7.65 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
68 8.03 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
69 8.05 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 1.69 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.uuid = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
71 3.55 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.lft < ? AND p0_.rgt > ? AND p0_.webspaceKey = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  282
  329
  "pakom"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
72 1.70 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.uuid = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "01a0a458-1f97-7c68-a29c-029ff8bc3922"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
73 2.90 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.lft < ? AND p0_.rgt > ? AND p0_.webspaceKey = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  282
  329
  "pakom"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
74 5.80 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 6.72 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
76 5.54 ms 
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters: 
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
View formatted query    View runnable query    Explain query    View query backtrace
77 1.00 ms 
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
Parameters: 
[
  "www.new.pakom-el.hr"
  "dev"
  "pakom"
]
View formatted query    View runnable query    Explain query    View query backtrace
78 1.25 ms 
SELECT p0_.uuid AS uuid_0, p1_.title AS title_1, r2_.slug AS slug_2, p0_.webspaceKey AS webspaceKey_3, p1_.linkProvider AS linkProvider_4, p1_.linkData AS linkData_5 FROM pa_page_dimension_contents p1_ INNER JOIN pa_pages p0_ ON p1_.pageUuid = p0_.uuid LEFT JOIN ro_routes r2_ ON p1_.route_id = r2_.id WHERE p0_.uuid IN (?, ?, ?, ?, ?) AND p1_.locale = ? AND p1_.stage = ? AND p1_.version = ?
Parameters: 
[
  "019e77eb-a1e0-7703-ae9a-506b674a3983"
  "019e6edf-01c9-74b7-86bd-af058e886dc0"
  "019e746c-6ebc-74cf-a5c4-383845e60a95"
  "019e6e90-5d8e-7c0d-bbbf-24422c30c71a"
  "019e756c-e086-7d24-bf2c-092e06ab9b14"
  "hr"
  "live"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Sulu\Page\Domain\Model\PageDimensionContent 114
Sulu\Route\Domain\Model\Route 57
Sulu\Page\Domain\Model\Page 57
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext 41
Sulu\Bundle\MediaBundle\Entity\Media 6
Sulu\Bundle\MediaBundle\Entity\File 6
Sulu\Bundle\MediaBundle\Entity\FileVersion 6
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta 6
App\Entity\User 2
Sulu\Bundle\ContactBundle\Entity\Contact 1
App\Entity\Ribbon 1
Sulu\Bundle\MediaBundle\Entity\Collection 1
Sulu\Bundle\MediaBundle\Entity\CollectionMeta 1
Sulu\Bundle\MediaBundle\Entity\CollectionType 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ReferenceBundle\Domain\Model\Reference No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Article\Domain\Model\Article No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Route\Domain\Model\Route No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Article\Domain\Model\ArticleDimensionContent No errors.
Sulu\Page\Domain\Model\Page No errors.
Sulu\Page\Domain\Model\PageDimensionContent No errors.
Sulu\Snippet\Domain\Model\Snippet No errors.
Sulu\Snippet\Domain\Model\SnippetDimensionContent No errors.
Sulu\Snippet\Domain\Model\SnippetArea No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\Entity\User No errors.
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext No errors.
App\Entity\Ribbon No errors.
Sulu\Bundle\MediaBundle\Entity\Media 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\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
App\Entity\Cart No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions No errors.
App\Entity\UserOrder No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting 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\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.