| 1 |
0.80 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;
|
| 2 |
0.32 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;
|
| 3 |
0.30 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;
|
| 4 |
1.08 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: [
"produkty-laserove-bezpecnosti"
]
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 = 'produkty-laserove-bezpecnosti';
|
| 5 |
0.38 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 = 2;
|
| 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: [
"produkty-laserove-bezpecnosti"
]
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 = 'produkty-laserove-bezpecnosti';
|
| 7 |
0.42 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';
|
| 8 |
0.49 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;
|
| 9 |
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 = '1';
|
| 10 |
0.57 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;
|
| 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;
|
| 12 |
0.95 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;
|
| 13 |
0.87 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;
|
| 14 |
0.46 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;
|
| 15 |
0.99 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;
|
| 16 |
0.44 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 = 3836;
|
| 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
3836
3836
6
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, 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 <> 3836 AND p4_.category_super_id = 3836 AND s2_.id = 6 ORDER BY p4_.sequence ASC, p0_.sequence ASC;
|
| 18 |
5.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_.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_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = ? OR p3_.category_super_id = ?) AND (p0_.is_active = true)
Parameters: [
3836
3836
]
SELECT 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_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id LEFT JOIN p_category p2_ ON c1_.category_id = p2_.id LEFT JOIN p_category_category p3_ ON p2_.id = p3_.category_sub_id WHERE (c1_.category_id = 3836 OR p3_.category_super_id = 3836) AND (p0_.is_active = true);
|
| 19 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = ? AND ((t0.is_active = true))
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = 56001 AND ((t0.is_active = true));
|
| 20 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = 67825;
|
| 21 |
0.48 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;
|