1
0.31 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . symbol AS symbol_2 , c0_ . rounding AS rounding_3 , c0_ . is_default AS is_default_4 , c0_ . default_locale AS default_locale_5 , c0_ . is_symbol_left AS is_symbol_left_6 , c0_ . is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_ . default_locale = ? LIMIT 1
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . symbol AS symbol_2 , c0_ . rounding AS rounding_3 , c0_ . is_default AS is_default_4 , c0_ . default_locale AS default_locale_5 , c0_ . is_symbol_left AS is_symbol_left_6 , c0_ . is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_ . default_locale = 'cs' LIMIT 1 ;
Copy
2
0.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0 WHERE t0 . is_default = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . rounding AS rounding_4 , t0 . is_default AS is_default_5 , t0 . default_locale AS default_locale_6 , t0 . is_symbol_left AS is_symbol_left_7 , t0 . is_deleted AS is_deleted_8 FROM currency t0 WHERE t0 . is_default = 1 LIMIT 1 ;
Copy
3
0.32 ms
SELECT s0_ . value AS value_0 FROM settings s0_ WHERE s0_ . name = ? ORDER BY s0_ . name ASC LIMIT 1
Parameters :
[
"after_registration_discount "
]
SELECT s0_ . value AS value_0 FROM settings s0_ WHERE s0_ . name = 'after_registration_discount' ORDER BY s0_ . name ASC LIMIT 1 ;
Copy
4
1.05 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_ . slug = ?
Parameters :
[
"ochrana-pri-praci-s-laserem "
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_ . slug = 'ochrana-pri-praci-s-laserem' ;
Copy
5
0.35 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . slug_prefix AS slug_prefix_4 , t0 . controller_name AS controller_name_5 FROM category_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . slug_prefix AS slug_prefix_4 , t0 . controller_name AS controller_name_5 FROM category_type t0 WHERE t0 . id = 20 ;
Copy
6
1.05 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_ . slug = ?
Parameters :
[
"ochrana-pri-praci-s-laserem "
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_ . slug = 'ochrana-pri-praci-s-laserem' ;
Copy
7
0.36 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = '4' ;
Copy
8
0.47 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN category_menu_type c2_ ON p0_ . id = c2_ . category_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p1_ . id IS NULL AND c2_ . menu_type_id = ? ORDER BY c2_ . sequence ASC
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN category_menu_type c2_ ON p0_ . id = c2_ . category_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p1_ . id IS NULL AND c2_ . menu_type_id = 4 ORDER BY c2_ . sequence ASC ;
Copy
9
0.34 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM menu_type t0 WHERE t0 . id = '1' ;
Copy
10
0.55 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN category_menu_type c2_ ON p0_ . id = c2_ . category_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p1_ . id IS NULL AND c2_ . menu_type_id = ? ORDER BY c2_ . sequence ASC
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN category_menu_type c2_ ON p0_ . id = c2_ . category_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p1_ . id IS NULL AND c2_ . menu_type_id = 1 ORDER BY c2_ . sequence ASC ;
Copy
11
0.36 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = 2141 ;
Copy
12
0.94 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p4_ . category_super_id = ? AND s2_ . id = ? AND p0_ . category_type_id IN (? ) ORDER BY p4_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2141
2141
1
2
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2141 AND p4_ . category_super_id = 2141 AND s2_ . id = 1 AND p0_ . category_type_id IN (2 ) ORDER BY p4_ . sequence ASC , p0_ . sequence ASC ;
Copy
13
0.83 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p4_ . category_super_id = ? AND s2_ . id = ? AND p0_ . category_type_id NOT IN (? ) ORDER BY p4_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2141
2141
1
2
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2141 AND p4_ . category_super_id = 2141 AND s2_ . id = 1 AND p0_ . category_type_id NOT IN (2 ) ORDER BY p4_ . sequence ASC , p0_ . sequence ASC ;
Copy
14
0.39 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = 2143 ;
Copy
15
0.89 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p4_ . category_super_id = ? AND s2_ . id = ? ORDER BY p4_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2143
2143
3
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2143 AND p4_ . category_super_id = 2143 AND s2_ . id = 3 ORDER BY p4_ . sequence ASC , p0_ . sequence ASC ;
Copy
16
0.41 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = 2128 ;
Copy
17
0.88 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = ? AND p0_ . id > = ? AND p0_ . id < > ? AND p4_ . category_super_id = ? AND s2_ . id = ? ORDER BY p4_ . sequence ASC , p0_ . sequence ASC
Parameters :
[
1
2
2128
2128
5
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , u1_ . id AS id_18 , u1_ . name AS name_19 , u1_ . extension AS extension_20 , u1_ . mime AS mime_21 , u1_ . title AS title_22 , u1_ . short_description AS short_description_23 , u1_ . description AS description_24 , u1_ . created AS created_25 , u1_ . path AS path_26 , u1_ . original_name AS original_name_27 , u1_ . width AS width_28 , u1_ . height AS height_29 , u1_ . sequence AS sequence_30 , u1_ . restriction AS restriction_31 , p0_ . category_type_id AS category_type_id_32 , p0_ . upload_id AS upload_id_33 , u1_ . upload_group_id AS upload_group_id_34 , u1_ . upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_ . upload_id = u1_ . id LEFT JOIN category_sub_menu_type c3_ ON p0_ . id = c3_ . category_id LEFT JOIN sub_menu_type s2_ ON s2_ . id = c3_ . sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_ . id = p4_ . category_sub_id WHERE p0_ . is_active = 1 AND p0_ . id > = 2 AND p0_ . id < > 2128 AND p4_ . category_super_id = 2128 AND s2_ . id = 5 ORDER BY p4_ . sequence ASC , p0_ . sequence ASC ;
Copy
18
0.38 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . template AS template_3 , t0 . controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0 . id = category_sub_menu_type . sub_menu_type_id WHERE category_sub_menu_type . category_id = 2129 ;
Copy
19
0.37 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id WHERE p0_ . is_active = ? AND p1_ . category_super_id = ? ORDER BY p1_ . sequence ASC
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id WHERE p0_ . is_active = 1 AND p1_ . category_super_id = 3835 ORDER BY p1_ . sequence ASC ;
Copy
20
0.31 ms
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_super_id = ? ORDER BY t0 . sequence ASC
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_menu_item AS is_menu_item_3 , t0 . category_super_id AS category_super_id_4 , t0 . category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0 . category_super_id = 3835 ORDER BY t0 . sequence ASC ;
Copy
21
0.60 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . title AS title_4 , p0_ . slug AS slug_5 , p0_ . is_active AS is_active_6 , p0_ . is_visible AS is_visible_7 , p0_ . sequence AS sequence_8 , p0_ . javascript AS javascript_9 , p0_ . text_general AS text_general_10 , p0_ . state AS state_11 , p0_ . external_id AS external_id_12 , p0_ . is_indexable AS is_indexable_13 , p0_ . meta_description AS meta_description_14 , p0_ . has_variant_picture AS has_variant_picture_15 , p0_ . sold_amount AS sold_amount_16 , p0_ . producer_id AS producer_id_17 , p0_ . upload_id AS upload_id_18 , p0_ . product_type_id AS product_type_id_19 , p0_ . product_view_type_id AS product_view_type_id_20 FROM product p0_ INNER JOIN category_product c1_ ON p0_ . id = c1_ . product_id WHERE (p0_ . is_active = ? AND c1_ . category_id IN (? )) AND (p0_ . is_active = true ) ORDER BY p0_ . sequence ASC
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . title AS title_4 , p0_ . slug AS slug_5 , p0_ . is_active AS is_active_6 , p0_ . is_visible AS is_visible_7 , p0_ . sequence AS sequence_8 , p0_ . javascript AS javascript_9 , p0_ . text_general AS text_general_10 , p0_ . state AS state_11 , p0_ . external_id AS external_id_12 , p0_ . is_indexable AS is_indexable_13 , p0_ . meta_description AS meta_description_14 , p0_ . has_variant_picture AS has_variant_picture_15 , p0_ . sold_amount AS sold_amount_16 , p0_ . producer_id AS producer_id_17 , p0_ . upload_id AS upload_id_18 , p0_ . product_type_id AS product_type_id_19 , p0_ . product_view_type_id AS product_view_type_id_20 FROM product p0_ INNER JOIN category_product c1_ ON p0_ . id = c1_ . product_id WHERE (p0_ . is_active = 1 AND c1_ . category_id IN (3835 )) AND (p0_ . is_active = true ) ORDER BY p0_ . sequence ASC ;
Copy
22
0.71 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN p_category_category p2_ ON p0_ . id = p2_ . category_super_id WHERE (p1_ . category_super_id = ? OR p2_ . category_sub_id = ? ) AND p0_ . category_type_id = ? AND p0_ . is_active = 1
Parameters :
[
3835
3835
11
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . menu_name AS menu_name_2 , p0_ . description AS description_3 , p0_ . html AS html_4 , p0_ . title AS title_5 , p0_ . is_active AS is_active_6 , p0_ . slug AS slug_7 , p0_ . javascript AS javascript_8 , p0_ . sequence AS sequence_9 , p0_ . is_menu AS is_menu_10 , p0_ . latitude AS latitude_11 , p0_ . longitude AS longitude_12 , p0_ . state AS state_13 , p0_ . has_comments AS has_comments_14 , p0_ . is_indexable AS is_indexable_15 , p0_ . created_at AS created_at_16 , p0_ . published_at AS published_at_17 , p0_ . category_type_id AS category_type_id_18 , p0_ . upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_ . id = p1_ . category_sub_id LEFT JOIN p_category_category p2_ ON p0_ . id = p2_ . category_super_id WHERE (p1_ . category_super_id = 3835 OR p2_ . category_sub_id = 3835 ) AND p0_ . category_type_id = 11 AND p0_ . is_active = 1 ;
Copy
23
0.36 ms
SELECT i0_ . id AS id_0 , i0_ . name AS name_1 , i0_ . title AS title_2 , i0_ . text AS text_3 , i0_ . is_active AS is_active_4 , i0_ . state AS state_5 , i0_ . is_reusable AS is_reusable_6 , i0_ . information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_ . information_block_type_id = i1_ . id LEFT JOIN category_information_block c2_ ON i0_ . id = c2_ . information_block_id WHERE i0_ . is_active = ? AND i1_ . id = ? AND c2_ . category_id = ? ORDER BY c2_ . sequence ASC
SELECT i0_ . id AS id_0 , i0_ . name AS name_1 , i0_ . title AS title_2 , i0_ . text AS text_3 , i0_ . is_active AS is_active_4 , i0_ . state AS state_5 , i0_ . is_reusable AS is_reusable_6 , i0_ . information_block_type_id AS information_block_type_id_7 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_ . information_block_type_id = i1_ . id LEFT JOIN category_information_block c2_ ON i0_ . id = c2_ . information_block_id WHERE i0_ . is_active = 1 AND i1_ . id = 5 AND c2_ . category_id = 3835 ORDER BY c2_ . sequence ASC ;
Copy
24
0.34 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . html AS html_5 , t0 . title AS title_6 , t0 . is_active AS is_active_7 , t0 . slug AS slug_8 , t0 . javascript AS javascript_9 , t0 . sequence AS sequence_10 , t0 . is_menu AS is_menu_11 , t0 . latitude AS latitude_12 , t0 . longitude AS longitude_13 , t0 . state AS state_14 , t0 . has_comments AS has_comments_15 , t0 . is_indexable AS is_indexable_16 , t0 . created_at AS created_at_17 , t0 . published_at AS published_at_18 , t0 . category_type_id AS category_type_id_19 , t0 . upload_id AS upload_id_20 FROM p_category t0 WHERE t0 . id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . menu_name AS menu_name_3 , t0 . description AS description_4 , t0 . html AS html_5 , t0 . title AS title_6 , t0 . is_active AS is_active_7 , t0 . slug AS slug_8 , t0 . javascript AS javascript_9 , t0 . sequence AS sequence_10 , t0 . is_menu AS is_menu_11 , t0 . latitude AS latitude_12 , t0 . longitude AS longitude_13 , t0 . state AS state_14 , t0 . has_comments AS has_comments_15 , t0 . is_indexable AS is_indexable_16 , t0 . created_at AS created_at_17 , t0 . published_at AS published_at_18 , t0 . category_type_id AS category_type_id_19 , t0 . upload_id AS upload_id_20 FROM p_category t0 WHERE t0 . id = '3835' LIMIT 1 ;
Copy
25
0.33 ms
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_manager AS is_manager_3 , t0 . category_id AS category_id_4 , t0 . person_id AS person_id_5 FROM category_person t0 WHERE t0 . category_id = ? ORDER BY t0 . sequence ASC
SELECT t0 . id AS id_1 , t0 . sequence AS sequence_2 , t0 . is_manager AS is_manager_3 , t0 . category_id AS category_id_4 , t0 . person_id AS person_id_5 FROM category_person t0 WHERE t0 . category_id = 3835 ORDER BY t0 . sequence ASC ;
Copy