SET NAMES utf8
            

              commit
            

              SELECT RELEASE_LOCK(?);
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `store_group`.* FROM `store_group`
            

              connect
            

              SET NAMES utf8
            

              SELECT `store_website`.* FROM `store_website`
            

              SELECT `store_group`.* FROM `store_group`
            

              SELECT `store`.* FROM `store`
            

              SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')
            

              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/13', 'catalog/category/view/id/13/')) AND (`store_id` IN ('1'))
            

              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
 LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/category/view/id/13', 'catalog/category/view/id/13/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)
            

              SELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC

            

              SELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC

            

              SELECT `stripe_account`.* FROM `stripe_account` WHERE (`stripe_account`.`secret_key`='5019875dbc8498db66c046f9ca36113fe18f39ba5c4852a0ac1243ae95ad0c71')
            

              begin
            

              UPDATE `stripe_account` SET `is_valid` = ? WHERE (id=3)
            

              commit
            

              SELECT COUNT(*) FROM `stripe_customers` AS `main_table` WHERE (`session_id` = '1570suhhme8fi8ro1i145oif52') AND ((`pk` = 'pk_live_51SQ4XoEQhpkV25H3GqHUxNYPTPnrp66C8wr6gGvy7fW1OA1hSJdK794pNmEiRY2cgD1FaebjJ6lTihnYeQ1gcNhn00Vx66HU8g') OR (`pk` IS NULL))
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =13)
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 13)
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (59, 60)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (70)) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '13') LIMIT 1
            

              SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('13', '21', '3', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC

            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (13, 21, 3, 2)) AND (t_d.attribute_id IN (58, 61, 313)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (13, 21, 3, 2)) AND (t_d.attribute_id IN (59, 60)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (13, 21, 3, 2)) AND (t_d.attribute_id IN (62)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (13, 21, 3, 2)) AND (t_d.attribute_id IN (69)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
            

              SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)
            

              SELECT `layout_update`.`xml`, `layout_update`.`handle` FROM `layout_update`
 INNER JOIN `layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.theme_id = :theme_id) AND (link.is_temporary = 0) ORDER BY `layout_update`.`sort_order` ASC

            

              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e`
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('3', '21', '13')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (3, 13, 21)) AND (t_d.attribute_id IN (41, 43)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('3')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            

              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            

              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            

              SELECT GET_LOCK(?, ?);
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2')
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '2')
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '2') LIMIT 1
            

              SELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1)
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (`e`.`path` LIKE '1/2/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC

            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (3, 33, 21, 13, 12, 8, 19, 25, 5, 18, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (41, 359)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT `main_table`.`magicmenu_id`, `main_table`.`cat_id`, `main_table`.`cat_col`, `main_table`.`cat_proportion`, `main_table`.`top`, `main_table`.`right`, `main_table`.`right_proportion`, `main_table`.`bottom`, `main_table`.`left`, `main_table`.`left_proportion` FROM `magiccart_magicmenu` AS `main_table` WHERE (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('1', `stores`)))) AND (`status` = '1')
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='top_menu_category') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='top_menu_category') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `cms_block`.`block_id` FROM `cms_block` WHERE (`cms_block`.`identifier`='top_menu_category') LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `main_table`.`magicmenu_id`, `main_table`.`link`, `main_table`.`name`, `main_table`.`cat_col`, `main_table`.`magic_label`, `main_table`.`ext_content`, `main_table`.`order` FROM `magiccart_magicmenu` AS `main_table` WHERE (`extra` = '1') AND (`status` = '1') AND (find_in_set(0, stores) OR find_in_set('1', stores)) ORDER BY `order` ASC

            

              SELECT RELEASE_LOCK(?);
            

              SELECT `main_table`.* FROM `checkout_agreement` AS `main_table`
 INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id WHERE (store_table_1.store_id IN ('1', 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id`
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='page_menu') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='before-category-products') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')
            

              SELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=2)
            

              SELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 2)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
            

              SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='material') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_colors') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='hems_model') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='one_or_two_piece') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='length') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='choose_dress') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='fastening') AND (entity_type_id = :entity_type_id)
            

              SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
            

              SELECT `e`.`entity_id`, `stockItem`.`is_salable`, `cat_index`.`position` FROM `catalog_product_entity` AS `e`
 INNER JOIN `inventory_stock_2` AS `stockItem` ON stockItem.sku = e.sku
 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id = e.entity_id AND cat_index.category_id = 13 AND cat_index.store_id = 1 ORDER BY is_salable DESC, position ASC, entity_id DESC
 LIMIT 12
            

              SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
 LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (35, 299, 302)) ORDER BY FIELD(e.entity_id,35,299,302)

            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (35, 299, 302)) AND (t_d.attribute_id IN (71, 85, 86, 87, 97, 112, 113, 114, 119, 314, 315, 363)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (35, 299, 302)) AND (t_d.attribute_id IN (73, 152, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 362)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (35, 299, 302)) AND (t_d.attribute_id IN (76, 120)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (35, 299, 302)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (35, 299, 302)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 133, 151, 374)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
 LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('35', '299', '302')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id = '13')
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='13')
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '13')
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '13') LIMIT 1
            

              SELECT `main_table`.* FROM `cataloginventory_stock` AS `main_table`
            

              SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=13 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
 LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku
            

              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V001'))
            

              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 35)
            

              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('VA1002'))
            

              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 299)
            

              SELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (sku IN ('V1003'))
            

              SELECT `cataloginventory_stock_status`.`qty` AS `quantity`, `cataloginventory_stock_status`.`stock_status` AS `is_salable` FROM `cataloginventory_stock_status` WHERE (product_id = 302)
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='13')
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '13')
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '13') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '13') LIMIT 1
            

              SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=13 AND cat_index.is_parent=1
 INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
 LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku
            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(35))
            

              SELECT GET_LOCK(?, ?);
            

              SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)
            

              SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FI') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

            

              SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='1')
            

              SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FI') AND (rate.tax_region_id IN(0, 336)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '00100', '00100*', '0010*', '001*', '00*', '0*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table`
 INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
 INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
 LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'FI') AND (rate.tax_region_id IN(0, 336)) AND (rate.zip_is_range IS NOT NULL) AND ('00100' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '35') ORDER BY `qty` ASC

            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(35))
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT RELEASE_LOCK(?);
            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(299))
            

              SELECT GET_LOCK(?, ?);
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '299') ORDER BY `qty` ASC

            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(299))
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT RELEASE_LOCK(?);
            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(302))
            

              SELECT GET_LOCK(?, ?);
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '302') ORDER BY `qty` ASC

            

              SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2026-11-04') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(302))
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)
            

              SELECT RELEASE_LOCK(?);
            

              SELECT GET_LOCK(?, ?);
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='2')
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '2')
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '2') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '2') LIMIT 1
            

              SELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1)
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (`e`.`path` LIKE '1/2/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC

            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (3, 33, 21, 13, 12, 8, 19, 25, 5, 18, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (41, 359)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT `main_table`.`magicmenu_id`, `main_table`.`cat_id`, `main_table`.`cat_col`, `main_table`.`cat_proportion`, `main_table`.`top`, `main_table`.`right`, `main_table`.`right_proportion`, `main_table`.`bottom`, `main_table`.`left`, `main_table`.`left_proportion` FROM `magiccart_magicmenu` AS `main_table` WHERE (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('1', `stores`)))) AND (`status` = '1')
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='top_menu_category') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='top_menu_category') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `cms_block`.`block_id` FROM `cms_block` WHERE (`cms_block`.`identifier`='top_menu_category') LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '60')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT RELEASE_LOCK(?);
            

              SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level)
            

              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('')) ORDER BY `e`.`position` ASC

            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='sidebar-additional-custom') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_top') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='block_footer_bottom') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '51')
            

              SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs`
 INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =33)
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 33)
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '33') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '33') LIMIT 1
            

              SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m`
 LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level)
            

              SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
 INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1)
 LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('10', '11', '12', '19', '20', '22', '4', '5')) ORDER BY `e`.`position` ASC

            

              SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (43, 41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d`
 INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
 LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (12, 19, 5, 11, 10, 20, 22, 4)) AND (t_d.attribute_id IN (51)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
            

              SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =21)
            

              SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 21)
            

              SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (41, 359, 156, 360, 43, 361, 132, 45, 46, 49, 58, 364, 57, 61, 66, 313)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (155, 42, 157, 68, 69, 67, 50, 51)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (59, 60)) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '21') AND (attribute_id IN (70)) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC

            

              SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '21') LIMIT 1
            

              SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='footer_links') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1
            

              SELECT `cms_block`.`block_id` FROM `cms_block`
 INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='payment') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
 LIMIT 1