FreshWipes™ Mammography Patient Wipe Pre-moistened Cleansing Towelette Individually Packaged for Use Before Patient Exam - 500 per Case

Part #
MAMWIPE

500/Case

$75.02
FreshWipes™ Mammography Patient Wipe Pre-moistened Cleansing Towelette Individually Packaged for Use Before Patient Exam - 500 per Case is available to buy in increments of 1

FreshWipes™ Mammography Patient Wipe

  • Pre-moistened towelette removes residual oils, powder and deodorant
  • Dries in seconds with no remaining residue
  • Leaves patient's skin feeling clean
More Information
Brand FRESHWIPES™
Units 500
Product Type Mammography Patient Wipe
Unit of Measurement Case
Superceded Message PWM500 item is now superseded with MAMWIPE. All items associated to PWM500 will refer to MAMWIPE.
© 2021 PDC Healthcare. All Rights Reserved.
Time
[Total Time: 0.69241094589233 secs]
SQL [Total: 148 queries]Query Params
46.42msconnect[]
0.94msSET NAMES utf8[]
1.51msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='staging')[]
1.89msSHOW TABLE STATUS LIKE 'store_website'[]
0.91msSELECT `store_website`.* FROM `store_website`[]
1.94msSHOW TABLE STATUS LIKE 'store_group'[]
1.45msSELECT `store_group`.* FROM `store_group`[]
1.70msSHOW TABLE STATUS LIKE 'store'[]
0.88msSELECT `store`.* FROM `store`[]
1.49msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')[]
136.23msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('freshwipestm-mammography-patient-wipe-pre-moistened-cleansing-towelette-individually-packaged-for-use-before-patient-exam-500-per-case', 'freshwipestm-mammography-patient-wipe-pre-moistened-cleansing-towelette-individually-packaged-for-use-before-patient-exam-500-per-case/')) AND (`store_id` IN ('1'))[]
134.91msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/product/view/id/26064', 'catalog/product/view/id/26064/')) AND (`store_id` IN ('1'))[]
136.75msSELECT `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/product/view/id/26064', 'catalog/product/view/id/26064/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)[]
1.49msSHOW INDEX FROM `catalog_product_entity`[]
0.83msSELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE ((entity_id =26064)) AND (catalog_product_entity.created_in <= 1) AND (catalog_product_entity.updated_in > 1)[]
1.11msDESCRIBE `eav_attribute`[]
4.03msSELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` = '10') ORDER BY entity_attribute.sort_order ASC []
1.14msSELECT `t`.* FROM `catalog_product_entity` AS `t` WHERE ((entity_id = 26064)) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
6.07msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_varchar` AS `t` WHERE (row_id = '26064') AND (attribute_id IN ('393', '85', '345', '107', '123', '310', '86', '97', '109', '148', '276', '309', '329', '71', '87', '82', '372', '103', '303', '330', '432', '377', '371', '308', '331', '84', '307', '332', '95', '304', '333', '305', '334', '524', '119', '306', '302', '351', '300', '98', '299', '301', '197', '274', '257', '112', '278', '113', '144', '288', '114', '277', '117', '171', '326', '280', '292', '291', '289', '290', '261', '260', '316', '262', '317', '242', '321', '243', '322', '250', '323', '254', '392', '248', '253', '252', '249', '251', '255', '244', '245', '246', '130', '131')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_text` AS `t` WHERE (row_id = '26064') AND (attribute_id IN ('72', '315', '320', '73', '343', '83', '106', '327', '177', '191')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_int` AS `t` WHERE (row_id = '26064') AND (attribute_id IN ('128', '179', '198', '344', '328', '383', '430', '96', '199', '180', '269', '348', '181', '268', '353', '187', '196', '356', '89', '125', '521', '127', '182', '256', '523', '325', '272', '124', '183', '239', '139', '525', '184', '265', '186', '266', '136', '527', '264', '205', '222', '140', '232', '141', '122', '211', '142', '370', '209', '143', '225', '126', '200', '145', '102', '234', '146', '279', '235', '147', '285', '217', '284', '227', '282', '213', '236', '204', '281', '219', '293', '216', '362', '295', '229', '296', '201', '121', '228', '361', '224', '134', '297', '212', '195', '294', '230', '298', '233', '193', '214', '223', '194', '231', '203', '178', '206', '286', '210', '207', '318', '240', '208', '259', '215', '342', '226', '221', '202', '218', '220', '273', '287', '129', '132', '172', '173', '174', '175')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_decimal` AS `t` WHERE (row_id = '26064') AND (attribute_id IN ('76', '149', '79', '91', '75', '120', '99', '135', '137', '138', '80', '338', '314', '341')) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_product_entity_datetime` AS `t` WHERE (row_id = '26064') AND (attribute_id IN ('104', '77', '105', '78', '93', '94')) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC []
1.30msSELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.row_id = main_table.product_id AND (cpe.created_in <= 1 AND cpe.updated_in > 1) INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 1 LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 1 WHERE (`cpe`.`entity_id` = '26064') AND (default_option_title.store_id = 0) ORDER BY sort_order ASC, title ASC []
2.38msSELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`row_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default` FROM `catalog_product_entity_media_gallery` AS `main` INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1 AND value.row_id = entity.row_id LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.row_id = entity.row_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id WHERE (main.attribute_id = '88') AND (main.disabled = 0) AND (entity.row_id = '26064') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC []
0.99msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 26064)[]
1.01msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 26064)[]
1.27msSELECT `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` FROM `catalog_product_entity_tier_price` WHERE (website_id = 0) AND (row_id = '26064') ORDER BY `qty` ASC []
1.71msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id AND (cp_table.created_in <= 1 AND cp_table.updated_in > 1) WHERE (`main_table`.`product_id` IN('26064'))[]
1.10msSELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 26064)[]
1.47msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE ((sku IN ('MAMWIPE'))) AND (catalog_product_entity.created_in <= 1) AND (catalog_product_entity.updated_in > 1)[]
0.69msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.44msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.49msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.51msSELECT `catalog_product_entity`.`sku`, `catalog_product_entity`.`type_id` FROM `catalog_product_entity` WHERE ((sku IN ('MAMWIPE'))) AND (catalog_product_entity.created_in <= 1) AND (catalog_product_entity.updated_in > 1)[]
0.74msSELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id AND (cp_table.created_in <= 1 AND cp_table.updated_in > 1) WHERE (product_id='26064') AND (stock_id=1) LIMIT 1[]
1.49msSELECT `main_table`.* FROM `mageworx_seocrosslinks_crosslink` AS `main_table` INNER JOIN `mageworx_seocrosslinks_crosslink_store` AS `store_table` ON main_table.crosslink_id = store_table.crosslink_id WHERE (main_table.in_product = 1) AND (main_table.is_active = 1) AND (store_table.store_id IN('1', 0)) GROUP BY `main_table`.`crosslink_id` ORDER BY priority DESC []
0.47msSELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id = 26064)[]
1.06msSELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 26064) AND (category_id = 0)[]
1.39msSHOW INDEX FROM `catalog_category_entity`[]
1.64msSELECT `main_table`.*, `additional_table`.* FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id=3) AND (`attribute_code` IN('all_children', 'available_sort_by', 'children', 'children_count', 'custom_apply_to_products', 'custom_design', 'custom_design_from', 'custom_design_to', 'custom_layout_update', 'custom_use_parent_settings', 'default_sort_by', 'description', 'display_mode', 'filter_price_range', 'image', 'include_in_menu', 'is_active', 'is_anchor', 'landing_page', 'level', 'meta_description', 'meta_keywords', 'meta_title', 'name', 'page_layout', 'path', 'path_in_store', 'position', 'url_key', 'url_path'))[]
3.43msSELECT `e`.`entity_id`, `e`.`level`, `e`.`path`, `event`.`event_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`row_id` = `e`.`row_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`.`row_id` = `e`.`row_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) LEFT JOIN `magento_catalogevent_event` AS `event` ON event.category_id = e.entity_id WHERE ((IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (e.path LIKE '1/1234%')) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `e`.`level` ASC []
0.66msSELECT `customer_entity`.* FROM `customer_entity` WHERE (entity_id ='')[]
0.72msSELECT `main_table`.* FROM `magento_customersegment_segment` AS `main_table` INNER JOIN `magento_customersegment_event` AS `evt` ON main_table.segment_id = evt.segment_id INNER JOIN (SELECT DISTINCT `magento_customersegment_website`.`segment_id` FROM `magento_customersegment_website` WHERE (website_id IN (1))) AS `website` ON main_table.segment_id = website.segment_id WHERE (evt.event = 'catalog_controller_product_view') AND (`is_active` = '1')[]
1.08msSELECT `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 {":theme_id":"5",":store_id":"1"}
1.48msSELECT `main_table`.* FROM `mst_blog_post` AS `main_table` WHERE (`status` = '2') AND (`type` = 'post') AND (`created_at` <= '2021-06-13T08:56:13+00:00') AND ((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET(1, `store_ids`))) AND (FIND_IN_SET('26064', `product_ids`)) ORDER BY created_at DESC []
1.01msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='breadcrumbs_priority') AND (entity_type_id = :entity_type_id){":entity_type_id":"3"}
0.64msSELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id){":entity_type_id":"3"}
0.60msSELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id){":attribute_id":"347"}
1.88msSELECT `e`.*, `at_product_id`.`product_id`, `at_breadcrumbs_priority`.`value` AS `breadcrumbs_priority` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id) LEFT JOIN `catalog_category_entity_text` AS `at_breadcrumbs_priority` ON (`at_breadcrumbs_priority`.`row_id` = `e`.`row_id`) AND (`at_breadcrumbs_priority`.`attribute_id` = '347') AND (`at_breadcrumbs_priority`.`store_id` = 0) WHERE ((at_product_id.product_id = '26064')) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `e`.`level` ASC []
2.52msSELECT `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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1856, 126, 211, 547, 1074, 1663, 1666, 1765, 723, 995, 865, 1023)) AND (t_d.attribute_id IN ('41', '43')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1856, 126, 211, 547, 1074, 1663, 1666, 1765, 723, 995, 865, 1023)) AND (t_d.attribute_id IN ('42')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.59msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1856', '1', '137', '122', '126', '1', '137', '122', '126', '211', '1', '137', '122', '126', '547', '1', '137', '677', '709', '1074', '1', '1234', '1252', '1262', '1663', '1', '1234', '1252', '1262', '1666', '1', '1234', '1250', '1284', '1765', '1', '137', '677', '709', '1074', '723', '1', '137', '677', '678', '992', '995', '1', '137', '677', '678', '681', '739', '862', '865', '1', '137', '677', '678', '992', '995', '1015', '1023'))[]
1.71msSELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `at_breadcrumbs_priority`.`value` AS `breadcrumbs_priority` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`row_id` = `e`.`row_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`.`row_id` = `e`.`row_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) LEFT JOIN `catalog_category_entity_text` AS `at_breadcrumbs_priority` ON (`at_breadcrumbs_priority`.`row_id` = `e`.`row_id`) AND (`at_breadcrumbs_priority`.`attribute_id` = '347') AND (`at_breadcrumbs_priority`.`store_id` = 0) WHERE ((`e`.`entity_id` IN('122', '137', '1', '709', '677', '1262', '1252', '1284', '1250', '992', '678', '862', '739', '681', '1015')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')) AND (e.created_in <= 1) AND (e.updated_in > 1)[]
1.00msSELECT `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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (122, 137, 677, 678, 681, 709, 739, 862, 992, 1015, 1250, 1252, 1262, 1284)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.97msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '137', '122', '1', '137', '1', '137', '677', '1', '137', '677', '678', '1', '137', '677', '678', '681', '1', '137', '677', '709', '1', '137', '677', '678', '681', '739', '1', '137', '677', '678', '681', '739', '862', '1', '137', '677', '678', '992', '1', '137', '677', '678', '992', '995', '1015', '1', '1234', '1250', '1', '1234', '1252', '1', '1234', '1252', '1262', '1', '1234', '1250', '1284'))[]
0.49msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('1856')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))[]
0.82msSELECT `main_table`.* FROM `mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'product') AND (`source_entity_id` = '26064') AND (`source_store_id` IN(0, 1)) ORDER BY source_store_id DESC []
0.95msSELECT `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_id IN ('26064')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (1)) AND (relation.category_id IS NULL)[]
0.97msSELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-06-13') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('26064'))[]
0.89msSELECT `main_table`.* FROM `review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('26064')) AND (entity_type = 1) AND (store_id = 1)[]
0.80msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '74') AND (`main_table`.`option_id` IN('MAMWIPE')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.60msSELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='26064') AND (store_id = 1)[]
0.94msSELECT `main_table`.* FROM `store_group` AS `main_table` WHERE (`main_table`.`website_id` IN('1')) ORDER BY main_table.name ASC []
0.73msSHOW INDEX FROM `pr_cookie_entity`[]
1.42msSELECT `main_table`.*, `additional_table`.* FROM `eav_attribute` AS `main_table` INNER JOIN `plumrocket_eav_attribute_additional` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id=11)[]
0.87msSELECT `e`.* FROM `pr_cookie_entity` AS `e`[]
1.92msSELECT `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 `pr_cookie_entity_text` AS `t_d` INNER JOIN `pr_cookie_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (t_d.attribute_id IN ('453')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.96msSELECT COUNT(*) FROM `pr_cookie_entity` AS `e`[]
1.07msSELECT `e`.* FROM `pr_cookie_category_entity` AS `e` WHERE ((`e`.`status` = 1)) AND ((`e`.`is_essential` = 1))[]
0.97msSELECT `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 `pr_cookie_category_entity_text` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1)) AND (t_d.attribute_id IN ('445', '448', '447', '443')) 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 `pr_cookie_category_entity_int` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1)) AND (t_d.attribute_id IN ('455', '446')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.76msSELECT COUNT(*) FROM `pr_cookie_category_entity` AS `e` WHERE ((`e`.`status` = 1)) AND ((`e`.`is_essential` = 1))[]
0.73msSELECT `main_table`.`name` FROM `pr_cookie_entity` AS `main_table` WHERE (name LIKE '%*%')[]
0.98msSELECT `e`.*, IF(at_head_scripts.value_id > 0, at_head_scripts.value, at_head_scripts_default.value) AS `head_scripts`, IF(at_footer_miscellaneous_html.value_id > 0, at_footer_miscellaneous_html.value, at_footer_miscellaneous_html_default.value) AS `footer_miscellaneous_html` FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_text` AS `at_head_scripts_default` ON (`at_head_scripts_default`.`entity_id` = `e`.`entity_id`) AND (`at_head_scripts_default`.`attribute_id` = '447') AND `at_head_scripts_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_text` AS `at_head_scripts` ON (`at_head_scripts`.`entity_id` = `e`.`entity_id`) AND (`at_head_scripts`.`attribute_id` = '447') AND (`at_head_scripts`.`store_id` = 1) LEFT JOIN `pr_cookie_category_entity_text` AS `at_footer_miscellaneous_html_default` ON (`at_footer_miscellaneous_html_default`.`entity_id` = `e`.`entity_id`) AND (`at_footer_miscellaneous_html_default`.`attribute_id` = '448') AND `at_footer_miscellaneous_html_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_text` AS `at_footer_miscellaneous_html` ON (`at_footer_miscellaneous_html`.`entity_id` = `e`.`entity_id`) AND (`at_footer_miscellaneous_html`.`attribute_id` = '448') AND (`at_footer_miscellaneous_html`.`store_id` = 1) WHERE ((`e`.`status` = 1)) AND ((IF(at_head_scripts.value_id > 0, at_head_scripts.value, at_head_scripts_default.value) != '') OR (IF(at_footer_miscellaneous_html.value_id > 0, at_footer_miscellaneous_html.value, at_footer_miscellaneous_html_default.value) != ''))[]
1.30msSELECT COUNT(*) FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_text` AS `at_head_scripts_default` ON (`at_head_scripts_default`.`entity_id` = `e`.`entity_id`) AND (`at_head_scripts_default`.`attribute_id` = '447') AND `at_head_scripts_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_text` AS `at_head_scripts` ON (`at_head_scripts`.`entity_id` = `e`.`entity_id`) AND (`at_head_scripts`.`attribute_id` = '447') AND (`at_head_scripts`.`store_id` = 1) LEFT JOIN `pr_cookie_category_entity_text` AS `at_footer_miscellaneous_html_default` ON (`at_footer_miscellaneous_html_default`.`entity_id` = `e`.`entity_id`) AND (`at_footer_miscellaneous_html_default`.`attribute_id` = '448') AND `at_footer_miscellaneous_html_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_text` AS `at_footer_miscellaneous_html` ON (`at_footer_miscellaneous_html`.`entity_id` = `e`.`entity_id`) AND (`at_footer_miscellaneous_html`.`attribute_id` = '448') AND (`at_footer_miscellaneous_html`.`store_id` = 1) WHERE ((`e`.`status` = 1)) AND ((IF(at_head_scripts.value_id > 0, at_head_scripts.value, at_head_scripts_default.value) != '') OR (IF(at_footer_miscellaneous_html.value_id > 0, at_footer_miscellaneous_html.value, at_footer_miscellaneous_html_default.value) != ''))[]
0.94msSELECT `e`.*, IF(at_sort_order.value_id > 0, at_sort_order.value, at_sort_order_default.value) AS `sort_order` FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order_default` ON (`at_sort_order_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order_default`.`attribute_id` = '446') AND `at_sort_order_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order` ON (`at_sort_order`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order`.`attribute_id` = '446') AND (`at_sort_order`.`store_id` = 1) WHERE ((`e`.`status` = 1)) ORDER BY `sort_order` ASC, `e`.`created_at` ASC, `e`.`entity_id` ASC []
1.13msSELECT `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 `pr_cookie_category_entity_text` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4)) AND (t_d.attribute_id IN ('445', '448', '447', '443')) 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 `pr_cookie_category_entity_int` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4)) AND (t_d.attribute_id IN ('455')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
1.09msSELECT COUNT(*) FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order_default` ON (`at_sort_order_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order_default`.`attribute_id` = '446') AND `at_sort_order_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order` ON (`at_sort_order`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order`.`attribute_id` = '446') AND (`at_sort_order`.`store_id` = 1) WHERE ((`e`.`status` = 1))[]
0.73msSELECT `e`.*, IF(at_sort_order.value_id > 0, at_sort_order.value, at_sort_order_default.value) AS `sort_order` FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order_default` ON (`at_sort_order_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order_default`.`attribute_id` = '446') AND `at_sort_order_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order` ON (`at_sort_order`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order`.`attribute_id` = '446') AND (`at_sort_order`.`store_id` = 1) WHERE ((`e`.`status` = 1)) ORDER BY `sort_order` ASC, `e`.`created_at` ASC, `e`.`entity_id` ASC []
0.88msSELECT `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 `pr_cookie_category_entity_text` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4)) AND (t_d.attribute_id IN ('445', '448', '447', '443')) 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 `pr_cookie_category_entity_int` AS `t_d` INNER JOIN `pr_cookie_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4)) AND (t_d.attribute_id IN ('455')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.62msSELECT COUNT(*) FROM `pr_cookie_category_entity` AS `e` LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order_default` ON (`at_sort_order_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order_default`.`attribute_id` = '446') AND `at_sort_order_default`.`store_id` = 0 LEFT JOIN `pr_cookie_category_entity_int` AS `at_sort_order` ON (`at_sort_order`.`entity_id` = `e`.`entity_id`) AND (`at_sort_order`.`attribute_id` = '446') AND (`at_sort_order`.`store_id` = 1) WHERE ((`e`.`status` = 1))[]
0.83msSELECT `e`.* FROM `pr_cookie_entity` AS `e` WHERE ((`e`.`category_key` IN('necessary', 'preferences', 'statistics', 'marketing')))[]
1.23msSELECT `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 `pr_cookie_entity_text` AS `t_d` INNER JOIN `pr_cookie_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `pr_cookie_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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (t_d.attribute_id IN ('453')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.61msSELECT COUNT(*) FROM `pr_cookie_entity` AS `e` WHERE ((`e`.`category_key` IN('necessary', 'preferences', 'statistics', 'marketing')))[]
1.15msSELECT `main_table`.* FROM `store` AS `main_table` WHERE (`main_table`.`website_id` IN('1')) ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC []
1.18msSELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE ((entity_id ='1234')) AND (catalog_category_entity.created_in <= 1) AND (catalog_category_entity.updated_in > 1)[]
2.16msSELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id=3) AND (`entity_attribute`.`attribute_set_id` = '3') ORDER BY entity_attribute.sort_order ASC []
0.69msSELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE ((entity_id = '1234')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
1.44msSELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 0 WHERE (main_table.entity_type_id=3) AND (`entity_attribute`.`attribute_set_id` = '3') ORDER BY entity_attribute.sort_order ASC []
2.60msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (row_id = '1234') AND (attribute_id IN ('384', '385', '391', '386', '387', '394', '388', '397', '389', '398', '44', '390', '399', '400', '401', '47', '402', '48', '347', '350', '54', '55', '56', '412', '413', '416', '65', '62')) AND (`store_id` IN (1, 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (row_id = '1234') AND (attribute_id IN ('41', '396', '43', '45', '46', '352', '403', '404', '346', '49', '58', '374', '405', '417', '406', '407', '419', '420', '408', '409', '410', '57', '422', '426', '431', '61', '66', '373')) 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 (row_id = '1234') AND (attribute_id IN ('42', '395', '427', '428', '68', '69', '526', '522', '67', '429', '528', '418', '421', '411', '50', '423', '414', '424', '415', '425', '51')) 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 (row_id = '1234') 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 (row_id = '1234') AND (attribute_id IN ('70')) AND (`store_id` IN (1, 0))) ) AS `u` ORDER BY `store_id` ASC []
0.77msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234'))[]
1.01msSELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE ((entity_id = '1234')) AND (catalog_category_entity.created_in <= 1) AND (catalog_category_entity.updated_in > 1) LIMIT 1[]
26.82msSELECT `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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('41', '396', '403', '404', '405', '406', '407', '408', '409', '410', '426', '422')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('394', '397', '398', '399', '400', '401', '402', '412', '413', '416')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('395', '411', '414', '415', '425', '424', '423')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
1.89msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1238', '1', '1234', '1247', '1', '1234', '1250', '1', '1234', '1248', '1', '1234', '1249', '1', '1234', '1251', '1', '1234', '1253', '1', '1234', '1252', '1', '1234', '1238', '1270', '1', '1234', '1247', '1287', '1', '1234', '1248', '1268', '1', '1234', '1249', '1298', '1', '1234', '1250', '1281', '1', '1234', '1252', '1408', '1', '1234', '1253', '1302', '1', '1234', '1238', '1271', '1', '1234', '1247', '1288', '1', '1234', '1248', '1269', '1', '1234', '1249', '1299', '1', '1234', '1250', '1282', '1', '1234', '1253', '1303', '1', '1234', '1238', '1272', '1', '1234', '1247', '1289', '1', '1234', '1248', '1307', '1', '1234', '1249', '1300', '1', '1234', '1250', '1283', '1', '1234', '1253', '1304', '1', '1234', '1238', '1273', '1', '1234', '1247', '1290', '1', '1234', '1249', '1301', '1', '1234', '1250', '1284', '1', '1234', '1252', '1256', '1', '1234', '1253', '1305', '1', '1234', '1238', '1274', '1', '1234', '1247', '1291', '1', '1234', '1250', '1285', '1', '1234', '1252', '1257', '1', '1234', '1253', '1306', '1', '1234', '1238', '1275', '1', '1234', '1247', '1292', '1', '1234', '1250', '1286', '1', '1234', '1252', '1258', '1', '1234', '1238', '1276', '1', '1234', '1247', '1293', '1', '1234', '1252', '1259', '1', '1234', '1253', '1838', '1', '1234', '1238', '1277', '1', '1234', '1247', '1294', '1', '1234', '1252', '1260', '1', '1234', '1253', '1847', '1', '1234', '1238', '1278', '1', '1234', '1247', '1295', '1', '1234', '1253', '1854', '1', '1234', '1238', '1279', '1', '1234', '1247', '1296', '1', '1234', '1252', '1262', '1', '1234', '1253', '1855', '1', '1234', '1238', '1280', '1', '1234', '1252', '1263', '1', '1234', '1238', '1849', '1', '1234', '1252', '1264', '1', '1234', '1252', '1265', '1', '1234', '1252', '1266', '1', '1234', '1252', '1267', '1', '1234', '1816', '1823', '1', '1234', '1816', '1822', '1', '1234', '1816', '1821', '1', '1234', '1816', '1820', '1', '1234', '1816', '1819', '1', '1234', '1816', '1818', '1', '1234', '1238', '1270', '1700', '1', '1234', '1238', '1271', '1705', '1', '1234', '1238', '1272', '1710', '1', '1234', '1238', '1273', '1730', '1', '1234', '1238', '1274', '1735', '1', '1234', '1238', '1275', '1739', '1', '1234', '1238', '1276', '1741', '1', '1234', '1238', '1277', '1744', '1', '1234', '1238', '1278', '1748', '1', '1234', '1250', '1281', '1751', '1', '1234', '1250', '1282', '1759', '1', '1234', '1250', '1283', '1763', '1', '1234', '1250', '1284', '1765', '1', '1234', '1250', '1285', '1769', '1', '1234', '1247', '1287', '1773', '1', '1234', '1247', '1288', '1776', '1', '1234', '1247', '1290', '1782', '1', '1234', '1247', '1293', '1786', '1', '1234', '1247', '1294', '1793', '1', '1234', '1247', '1295', '1796', '1', '1234', '1253', '1302', '1800', '1', '1234', '1253', '1303', '1807', '1', '1234', '1253', '1305', '1812', '1', '1234', '1253', '1306', '1840', '1', '1234', '1253', '1838', '1850', '1', '1234', '1238', '1270', '1701', '1', '1234', '1238', '1271', '1706', '1', '1234', '1238', '1272', '1711', '1', '1234', '1238', '1273', '1731', '1', '1234', '1238', '1274', '1736', '1', '1234', '1238', '1275', '1740', '1', '1234', '1238', '1276', '1742', '1', '1234', '1238', '1277', '1745', '1', '1234', '1238', '1278', '1749', '1', '1234', '1250', '1281', '1752', '1', '1234', '1250', '1282', '1760', '1', '1234', '1250', '1283', '1764', '1', '1234', '1250', '1284', '1766', '1', '1234', '1250', '1285', '1770', '1', '1234', '1247', '1287', '1774', '1', '1234', '1247', '1288', '1777', '1', '1234', '1247', '1290', '1783', '1', '1234', '1247', '1293', '1787', '1', '1234', '1247', '1294', '1794', '1', '1234', '1247', '1295', '1797', '1', '1234', '1253', '1302', '1801', '1', '1234', '1253', '1303', '1808', '1', '1234', '1253', '1305', '1813', '1', '1234', '1253', '1306', '1841', '1', '1234', '1253', '1838', '1851', '1', '1234', '1238', '1270', '1702', '1', '1234', '1238', '1271', '1707', '1', '1234', '1238', '1273', '1732', '1', '1234', '1238', '1274', '1737', '1', '1234', '1238', '1276', '1743', '1', '1234', '1238', '1278', '1750', '1', '1234', '1250', '1281', '1753', '1', '1234', '1250', '1282', '1761', '1', '1234', '1250', '1284', '1767', '1', '1234', '1250', '1285', '1771', '1', '1234', '1247', '1287', '1775', '1', '1234', '1247', '1288', '1778', '1', '1234', '1247', '1293', '1788', '1', '1234', '1247', '1294', '1795', '1', '1234', '1247', '1295', '1798', '1', '1234', '1253', '1302', '1802', '1', '1234', '1253', '1303', '1809', '1', '1234', '1253', '1305', '1814', '1', '1234', '1253', '1306', '1842', '1', '1234', '1253', '1838', '1853', '1', '1234', '1238', '1270', '1703', '1', '1234', '1238', '1271', '1708', '1', '1234', '1238', '1272', '1713', '1', '1234', '1250', '1281', '1754', '1', '1234', '1250', '1282', '1762', '1', '1234', '1250', '1284', '1768', '1', '1234', '1250', '1285', '1772', '1', '1234', '1247', '1288', '1779', '1', '1234', '1247', '1293', '1789', '1', '1234', '1253', '1303', '1810', '1', '1234', '1253', '1306', '1843', '1', '1234', '1238', '1270', '1704', '1', '1234', '1238', '1271', '1709', '1', '1234', '1238', '1272', '1714', '1', '1234', '1250', '1281', '1755', '1', '1234', '1247', '1288', '1780', '1', '1234', '1247', '1293', '1790', '1', '1234', '1253', '1302', '1804', '1', '1234', '1253', '1303', '1811', '1', '1234', '1238', '1270', '1852', '1', '1234', '1238', '1272', '1715', '1', '1234', '1250', '1281', '1756', '1', '1234', '1247', '1288', '1781', '1', '1234', '1247', '1293', '1791', '1', '1234', '1253', '1302', '1805', '1', '1234', '1253', '1306', '1846', '1', '1234', '1238', '1271', '1848', '1', '1234', '1238', '1272', '1716', '1', '1234', '1250', '1281', '1757', '1', '1234', '1247', '1293', '1792', '1', '1234', '1253', '1302', '1806', '1', '1234', '1238', '1272', '1717', '1', '1234', '1250', '1281', '1758', '1', '1234', '1238', '1272', '1718', '1', '1234', '1238', '1272', '1719', '1', '1234', '1238', '1272', '1720', '1', '1234', '1238', '1272', '1722', '1', '1234', '1238', '1272', '1723', '1', '1234', '1238', '1272', '1724', '1', '1234', '1238', '1272', '1725', '1', '1234', '1238', '1272', '1726', '1', '1234', '1238', '1272', '1728', '1', '1234', '1238', '1272', '1729'))[]
0.63msSELECT `magento_versionscms_hierarchy_node`.* FROM `magento_versionscms_hierarchy_node` WHERE (scope = 'store') AND (scope_id = '1') AND (`level` = 0) LIMIT 1[]
0.78msSELECT `magento_versionscms_hierarchy_node`.* FROM `magento_versionscms_hierarchy_node` WHERE (scope = 'website') AND (scope_id = '1') AND (`level` = 0) LIMIT 1[]
0.92msSHOW INDEX FROM `cms_page`[]
1.22msSELECT `main_table`.*, `page_table`.`title` AS `page_title`, `page_table`.`identifier` AS `page_identifier`, (SELECT GROUP_CONCAT(store_id SEPARATOR ',') AS `store_id` FROM `cms_page_store` AS `cps` WHERE (cps.row_id = main_table.page_id)) AS `page_in_stores`, `metadata_table`.`meta_first_last`, `metadata_table`.`meta_next_previous`, `metadata_table`.`meta_chapter`, `metadata_table`.`meta_section`, `metadata_table`.`meta_cs_enabled`, `metadata_table`.`pager_visibility`, `metadata_table`.`pager_frame`, `metadata_table`.`pager_jump`, `metadata_table`.`menu_visibility`, `metadata_table`.`menu_layout`, `metadata_table`.`menu_brief`, `metadata_table`.`menu_excluded`, `metadata_table`.`menu_levels_down`, `metadata_table`.`menu_ordered`, `metadata_table`.`menu_list_type`, `metadata_table`.`top_menu_visibility`, `metadata_table`.`top_menu_excluded` FROM `magento_versionscms_hierarchy_node` AS `main_table` LEFT JOIN `cms_page` AS `page_table` ON main_table.page_id = page_table.page_id AND (page_table.created_in <= 1 AND page_table.updated_in > 1) LEFT JOIN `magento_versionscms_hierarchy_metadata` AS `metadata_table` ON main_table.node_id = metadata_table.node_id WHERE (main_table.scope = 'default') AND (main_table.scope_id = 0) ORDER BY `main_table`.`level` ASC, `main_table`.`sort_order` ASC []
1.13msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.row_id = cbs.row_id WHERE ((`cms_block`.`identifier`='after-menu') AND (is_active = 1) AND (cbs.store_id in (1, 0))) AND (cms_block.created_in <= 1) AND (cms_block.updated_in > 1) ORDER BY `store_id` DESC LIMIT 1[]
0.67msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '189')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
0.65msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.row_id = cb.row_id AND (cb.created_in <= 1 AND cb.updated_in > 1) WHERE (cb.block_id = :block_id){":block_id":189}
25.74msSELECT `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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('41', '396', '403', '404', '405', '406', '407', '408', '409', '410', '426', '422')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('394', '397', '398', '399', '400', '401', '402', '412', '413', '416')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('395', '411', '414', '415', '425', '424', '423')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
2.05msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1238', '1', '1234', '1247', '1', '1234', '1250', '1', '1234', '1248', '1', '1234', '1249', '1', '1234', '1251', '1', '1234', '1253', '1', '1234', '1252', '1', '1234', '1238', '1270', '1', '1234', '1247', '1287', '1', '1234', '1248', '1268', '1', '1234', '1249', '1298', '1', '1234', '1250', '1281', '1', '1234', '1252', '1408', '1', '1234', '1253', '1302', '1', '1234', '1238', '1271', '1', '1234', '1247', '1288', '1', '1234', '1248', '1269', '1', '1234', '1249', '1299', '1', '1234', '1250', '1282', '1', '1234', '1253', '1303', '1', '1234', '1238', '1272', '1', '1234', '1247', '1289', '1', '1234', '1248', '1307', '1', '1234', '1249', '1300', '1', '1234', '1250', '1283', '1', '1234', '1253', '1304', '1', '1234', '1238', '1273', '1', '1234', '1247', '1290', '1', '1234', '1249', '1301', '1', '1234', '1250', '1284', '1', '1234', '1252', '1256', '1', '1234', '1253', '1305', '1', '1234', '1238', '1274', '1', '1234', '1247', '1291', '1', '1234', '1250', '1285', '1', '1234', '1252', '1257', '1', '1234', '1253', '1306', '1', '1234', '1238', '1275', '1', '1234', '1247', '1292', '1', '1234', '1250', '1286', '1', '1234', '1252', '1258', '1', '1234', '1238', '1276', '1', '1234', '1247', '1293', '1', '1234', '1252', '1259', '1', '1234', '1253', '1838', '1', '1234', '1238', '1277', '1', '1234', '1247', '1294', '1', '1234', '1252', '1260', '1', '1234', '1253', '1847', '1', '1234', '1238', '1278', '1', '1234', '1247', '1295', '1', '1234', '1253', '1854', '1', '1234', '1238', '1279', '1', '1234', '1247', '1296', '1', '1234', '1252', '1262', '1', '1234', '1253', '1855', '1', '1234', '1238', '1280', '1', '1234', '1252', '1263', '1', '1234', '1238', '1849', '1', '1234', '1252', '1264', '1', '1234', '1252', '1265', '1', '1234', '1252', '1266', '1', '1234', '1252', '1267', '1', '1234', '1816', '1823', '1', '1234', '1816', '1822', '1', '1234', '1816', '1821', '1', '1234', '1816', '1820', '1', '1234', '1816', '1819', '1', '1234', '1816', '1818', '1', '1234', '1238', '1270', '1700', '1', '1234', '1238', '1271', '1705', '1', '1234', '1238', '1272', '1710', '1', '1234', '1238', '1273', '1730', '1', '1234', '1238', '1274', '1735', '1', '1234', '1238', '1275', '1739', '1', '1234', '1238', '1276', '1741', '1', '1234', '1238', '1277', '1744', '1', '1234', '1238', '1278', '1748', '1', '1234', '1250', '1281', '1751', '1', '1234', '1250', '1282', '1759', '1', '1234', '1250', '1283', '1763', '1', '1234', '1250', '1284', '1765', '1', '1234', '1250', '1285', '1769', '1', '1234', '1247', '1287', '1773', '1', '1234', '1247', '1288', '1776', '1', '1234', '1247', '1290', '1782', '1', '1234', '1247', '1293', '1786', '1', '1234', '1247', '1294', '1793', '1', '1234', '1247', '1295', '1796', '1', '1234', '1253', '1302', '1800', '1', '1234', '1253', '1303', '1807', '1', '1234', '1253', '1305', '1812', '1', '1234', '1253', '1306', '1840', '1', '1234', '1253', '1838', '1850', '1', '1234', '1238', '1270', '1701', '1', '1234', '1238', '1271', '1706', '1', '1234', '1238', '1272', '1711', '1', '1234', '1238', '1273', '1731', '1', '1234', '1238', '1274', '1736', '1', '1234', '1238', '1275', '1740', '1', '1234', '1238', '1276', '1742', '1', '1234', '1238', '1277', '1745', '1', '1234', '1238', '1278', '1749', '1', '1234', '1250', '1281', '1752', '1', '1234', '1250', '1282', '1760', '1', '1234', '1250', '1283', '1764', '1', '1234', '1250', '1284', '1766', '1', '1234', '1250', '1285', '1770', '1', '1234', '1247', '1287', '1774', '1', '1234', '1247', '1288', '1777', '1', '1234', '1247', '1290', '1783', '1', '1234', '1247', '1293', '1787', '1', '1234', '1247', '1294', '1794', '1', '1234', '1247', '1295', '1797', '1', '1234', '1253', '1302', '1801', '1', '1234', '1253', '1303', '1808', '1', '1234', '1253', '1305', '1813', '1', '1234', '1253', '1306', '1841', '1', '1234', '1253', '1838', '1851', '1', '1234', '1238', '1270', '1702', '1', '1234', '1238', '1271', '1707', '1', '1234', '1238', '1273', '1732', '1', '1234', '1238', '1274', '1737', '1', '1234', '1238', '1276', '1743', '1', '1234', '1238', '1278', '1750', '1', '1234', '1250', '1281', '1753', '1', '1234', '1250', '1282', '1761', '1', '1234', '1250', '1284', '1767', '1', '1234', '1250', '1285', '1771', '1', '1234', '1247', '1287', '1775', '1', '1234', '1247', '1288', '1778', '1', '1234', '1247', '1293', '1788', '1', '1234', '1247', '1294', '1795', '1', '1234', '1247', '1295', '1798', '1', '1234', '1253', '1302', '1802', '1', '1234', '1253', '1303', '1809', '1', '1234', '1253', '1305', '1814', '1', '1234', '1253', '1306', '1842', '1', '1234', '1253', '1838', '1853', '1', '1234', '1238', '1270', '1703', '1', '1234', '1238', '1271', '1708', '1', '1234', '1238', '1272', '1713', '1', '1234', '1250', '1281', '1754', '1', '1234', '1250', '1282', '1762', '1', '1234', '1250', '1284', '1768', '1', '1234', '1250', '1285', '1772', '1', '1234', '1247', '1288', '1779', '1', '1234', '1247', '1293', '1789', '1', '1234', '1253', '1303', '1810', '1', '1234', '1253', '1306', '1843', '1', '1234', '1238', '1270', '1704', '1', '1234', '1238', '1271', '1709', '1', '1234', '1238', '1272', '1714', '1', '1234', '1250', '1281', '1755', '1', '1234', '1247', '1288', '1780', '1', '1234', '1247', '1293', '1790', '1', '1234', '1253', '1302', '1804', '1', '1234', '1253', '1303', '1811', '1', '1234', '1238', '1270', '1852', '1', '1234', '1238', '1272', '1715', '1', '1234', '1250', '1281', '1756', '1', '1234', '1247', '1288', '1781', '1', '1234', '1247', '1293', '1791', '1', '1234', '1253', '1302', '1805', '1', '1234', '1253', '1306', '1846', '1', '1234', '1238', '1271', '1848', '1', '1234', '1238', '1272', '1716', '1', '1234', '1250', '1281', '1757', '1', '1234', '1247', '1293', '1792', '1', '1234', '1253', '1302', '1806', '1', '1234', '1238', '1272', '1717', '1', '1234', '1250', '1281', '1758', '1', '1234', '1238', '1272', '1718', '1', '1234', '1238', '1272', '1719', '1', '1234', '1238', '1272', '1720', '1', '1234', '1238', '1272', '1722', '1', '1234', '1238', '1272', '1723', '1', '1234', '1238', '1272', '1724', '1', '1234', '1238', '1272', '1725', '1', '1234', '1238', '1272', '1726', '1', '1234', '1238', '1272', '1728', '1', '1234', '1238', '1272', '1729'))[]
26.40msSELECT `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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('41', '396', '403', '404', '405', '406', '407', '408', '409', '410', '426', '422')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('394', '397', '398', '399', '400', '401', '402', '412', '413', '416')) 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.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1238, 1247, 1250, 1248, 1249, 1251, 1253, 1252, 1270, 1287, 1268, 1298, 1281, 1408, 1302, 1271, 1288, 1269, 1299, 1282, 1303, 1272, 1289, 1307, 1300, 1283, 1304, 1273, 1290, 1301, 1284, 1256, 1305, 1274, 1291, 1285, 1257, 1306, 1275, 1292, 1286, 1258, 1276, 1293, 1259, 1838, 1277, 1294, 1260, 1847, 1278, 1295, 1854, 1279, 1296, 1262, 1855, 1280, 1263, 1849, 1264, 1265, 1266, 1267, 1823, 1822, 1821, 1820, 1819, 1818, 1700, 1705, 1710, 1730, 1735, 1739, 1741, 1744, 1748, 1751, 1759, 1763, 1765, 1769, 1773, 1776, 1782, 1786, 1793, 1796, 1800, 1807, 1812, 1840, 1850, 1701, 1706, 1711, 1731, 1736, 1740, 1742, 1745, 1749, 1752, 1760, 1764, 1766, 1770, 1774, 1777, 1783, 1787, 1794, 1797, 1801, 1808, 1813, 1841, 1851, 1702, 1707, 1732, 1737, 1743, 1750, 1753, 1761, 1767, 1771, 1775, 1778, 1788, 1795, 1798, 1802, 1809, 1814, 1842, 1853, 1703, 1708, 1713, 1754, 1762, 1768, 1772, 1779, 1789, 1810, 1843, 1704, 1709, 1714, 1755, 1780, 1790, 1804, 1811, 1852, 1715, 1756, 1781, 1791, 1805, 1846, 1848, 1716, 1757, 1792, 1806, 1717, 1758, 1718, 1719, 1720, 1722, 1723, 1724, 1725, 1726, 1728, 1729)) AND (t_d.attribute_id IN ('395', '411', '414', '415', '425', '424', '423')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
1.28msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1238', '1', '1234', '1247', '1', '1234', '1250', '1', '1234', '1248', '1', '1234', '1249', '1', '1234', '1251', '1', '1234', '1253', '1', '1234', '1252', '1', '1234', '1238', '1270', '1', '1234', '1247', '1287', '1', '1234', '1248', '1268', '1', '1234', '1249', '1298', '1', '1234', '1250', '1281', '1', '1234', '1252', '1408', '1', '1234', '1253', '1302', '1', '1234', '1238', '1271', '1', '1234', '1247', '1288', '1', '1234', '1248', '1269', '1', '1234', '1249', '1299', '1', '1234', '1250', '1282', '1', '1234', '1253', '1303', '1', '1234', '1238', '1272', '1', '1234', '1247', '1289', '1', '1234', '1248', '1307', '1', '1234', '1249', '1300', '1', '1234', '1250', '1283', '1', '1234', '1253', '1304', '1', '1234', '1238', '1273', '1', '1234', '1247', '1290', '1', '1234', '1249', '1301', '1', '1234', '1250', '1284', '1', '1234', '1252', '1256', '1', '1234', '1253', '1305', '1', '1234', '1238', '1274', '1', '1234', '1247', '1291', '1', '1234', '1250', '1285', '1', '1234', '1252', '1257', '1', '1234', '1253', '1306', '1', '1234', '1238', '1275', '1', '1234', '1247', '1292', '1', '1234', '1250', '1286', '1', '1234', '1252', '1258', '1', '1234', '1238', '1276', '1', '1234', '1247', '1293', '1', '1234', '1252', '1259', '1', '1234', '1253', '1838', '1', '1234', '1238', '1277', '1', '1234', '1247', '1294', '1', '1234', '1252', '1260', '1', '1234', '1253', '1847', '1', '1234', '1238', '1278', '1', '1234', '1247', '1295', '1', '1234', '1253', '1854', '1', '1234', '1238', '1279', '1', '1234', '1247', '1296', '1', '1234', '1252', '1262', '1', '1234', '1253', '1855', '1', '1234', '1238', '1280', '1', '1234', '1252', '1263', '1', '1234', '1238', '1849', '1', '1234', '1252', '1264', '1', '1234', '1252', '1265', '1', '1234', '1252', '1266', '1', '1234', '1252', '1267', '1', '1234', '1816', '1823', '1', '1234', '1816', '1822', '1', '1234', '1816', '1821', '1', '1234', '1816', '1820', '1', '1234', '1816', '1819', '1', '1234', '1816', '1818', '1', '1234', '1238', '1270', '1700', '1', '1234', '1238', '1271', '1705', '1', '1234', '1238', '1272', '1710', '1', '1234', '1238', '1273', '1730', '1', '1234', '1238', '1274', '1735', '1', '1234', '1238', '1275', '1739', '1', '1234', '1238', '1276', '1741', '1', '1234', '1238', '1277', '1744', '1', '1234', '1238', '1278', '1748', '1', '1234', '1250', '1281', '1751', '1', '1234', '1250', '1282', '1759', '1', '1234', '1250', '1283', '1763', '1', '1234', '1250', '1284', '1765', '1', '1234', '1250', '1285', '1769', '1', '1234', '1247', '1287', '1773', '1', '1234', '1247', '1288', '1776', '1', '1234', '1247', '1290', '1782', '1', '1234', '1247', '1293', '1786', '1', '1234', '1247', '1294', '1793', '1', '1234', '1247', '1295', '1796', '1', '1234', '1253', '1302', '1800', '1', '1234', '1253', '1303', '1807', '1', '1234', '1253', '1305', '1812', '1', '1234', '1253', '1306', '1840', '1', '1234', '1253', '1838', '1850', '1', '1234', '1238', '1270', '1701', '1', '1234', '1238', '1271', '1706', '1', '1234', '1238', '1272', '1711', '1', '1234', '1238', '1273', '1731', '1', '1234', '1238', '1274', '1736', '1', '1234', '1238', '1275', '1740', '1', '1234', '1238', '1276', '1742', '1', '1234', '1238', '1277', '1745', '1', '1234', '1238', '1278', '1749', '1', '1234', '1250', '1281', '1752', '1', '1234', '1250', '1282', '1760', '1', '1234', '1250', '1283', '1764', '1', '1234', '1250', '1284', '1766', '1', '1234', '1250', '1285', '1770', '1', '1234', '1247', '1287', '1774', '1', '1234', '1247', '1288', '1777', '1', '1234', '1247', '1290', '1783', '1', '1234', '1247', '1293', '1787', '1', '1234', '1247', '1294', '1794', '1', '1234', '1247', '1295', '1797', '1', '1234', '1253', '1302', '1801', '1', '1234', '1253', '1303', '1808', '1', '1234', '1253', '1305', '1813', '1', '1234', '1253', '1306', '1841', '1', '1234', '1253', '1838', '1851', '1', '1234', '1238', '1270', '1702', '1', '1234', '1238', '1271', '1707', '1', '1234', '1238', '1273', '1732', '1', '1234', '1238', '1274', '1737', '1', '1234', '1238', '1276', '1743', '1', '1234', '1238', '1278', '1750', '1', '1234', '1250', '1281', '1753', '1', '1234', '1250', '1282', '1761', '1', '1234', '1250', '1284', '1767', '1', '1234', '1250', '1285', '1771', '1', '1234', '1247', '1287', '1775', '1', '1234', '1247', '1288', '1778', '1', '1234', '1247', '1293', '1788', '1', '1234', '1247', '1294', '1795', '1', '1234', '1247', '1295', '1798', '1', '1234', '1253', '1302', '1802', '1', '1234', '1253', '1303', '1809', '1', '1234', '1253', '1305', '1814', '1', '1234', '1253', '1306', '1842', '1', '1234', '1253', '1838', '1853', '1', '1234', '1238', '1270', '1703', '1', '1234', '1238', '1271', '1708', '1', '1234', '1238', '1272', '1713', '1', '1234', '1250', '1281', '1754', '1', '1234', '1250', '1282', '1762', '1', '1234', '1250', '1284', '1768', '1', '1234', '1250', '1285', '1772', '1', '1234', '1247', '1288', '1779', '1', '1234', '1247', '1293', '1789', '1', '1234', '1253', '1303', '1810', '1', '1234', '1253', '1306', '1843', '1', '1234', '1238', '1270', '1704', '1', '1234', '1238', '1271', '1709', '1', '1234', '1238', '1272', '1714', '1', '1234', '1250', '1281', '1755', '1', '1234', '1247', '1288', '1780', '1', '1234', '1247', '1293', '1790', '1', '1234', '1253', '1302', '1804', '1', '1234', '1253', '1303', '1811', '1', '1234', '1238', '1270', '1852', '1', '1234', '1238', '1272', '1715', '1', '1234', '1250', '1281', '1756', '1', '1234', '1247', '1288', '1781', '1', '1234', '1247', '1293', '1791', '1', '1234', '1253', '1302', '1805', '1', '1234', '1253', '1306', '1846', '1', '1234', '1238', '1271', '1848', '1', '1234', '1238', '1272', '1716', '1', '1234', '1250', '1281', '1757', '1', '1234', '1247', '1293', '1792', '1', '1234', '1253', '1302', '1806', '1', '1234', '1238', '1272', '1717', '1', '1234', '1250', '1281', '1758', '1', '1234', '1238', '1272', '1718', '1', '1234', '1238', '1272', '1719', '1', '1234', '1238', '1272', '1720', '1', '1234', '1238', '1272', '1722', '1', '1234', '1238', '1272', '1723', '1', '1234', '1238', '1272', '1724', '1', '1234', '1238', '1272', '1725', '1', '1234', '1238', '1272', '1726', '1', '1234', '1238', '1272', '1728', '1', '1234', '1238', '1272', '1729'))[]
0.84msSELECT `main_table`.* FROM `review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('26064')) AND (entity_type = 1) AND (store_id = 1)[]
0.95msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.row_id = l.parent_id AND (p.created_in <= 1 AND p.updated_in > 1) INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 AND (e.created_in <= 1 AND e.updated_in > 1) WHERE (p.entity_id IN ('26064'))[]
0.86msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 AND (e.created_in <= 1 AND e.updated_in > 1) INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.row_id AND (parent.created_in <= 1 AND parent.updated_in > 1) INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"26064"}
1.20msSELECT `l`.`product_id`, `l`.`parent_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity` AS `p` ON p.row_id = l.parent_id AND (p.created_in <= 1 AND p.updated_in > 1) INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 AND (e.created_in <= 1 AND e.updated_in > 1) WHERE (p.entity_id IN ('26064'))[]
0.95msSELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 AND (e.created_in <= 1 AND e.updated_in > 1) INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.row_id AND (parent.created_in <= 1 AND parent.updated_in > 1) INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id){":parent_id":"26064"}
2.00msSELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `attribute_group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity` LEFT JOIN `eav_attribute_group` AS `attribute_group` ON entity.attribute_group_id = attribute_group.attribute_group_id WHERE (entity.attribute_set_id = :attribute_set_id){":attribute_set_id":"10"}
1.12msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '286') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.87msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '179') AND (`main_table`.`option_id` IN('12670')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.89msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '180') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.90msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '187') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.90msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '182') AND (`main_table`.`option_id` IN('1481')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.68msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '325') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.56msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '183') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
1.06msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '184') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.99msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '186') AND (`main_table`.`option_id` IN('883')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
1.04msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '264') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.65msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '296') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.88msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '259') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
0.95msSELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '266') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC []
1.61msSELECT `main_table`.* FROM `mst_blog_post` AS `main_table` WHERE (`status` = '2') AND (`type` = 'post') AND (`created_at` <= '2021-06-13T08:56:13+00:00') AND ((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET(1, `store_ids`))) AND (FIND_IN_SET('26064', `product_ids`)) ORDER BY created_at DESC []
1.10msSELECT `main_table`.* FROM `review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('26064')) AND (entity_type = 1) AND (store_id = 1)[]
0.88msDESCRIBE `catalog_product_entity`[]
2.44msSELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)[]
0.94msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.58msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.49msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.52msSELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 1)[]
1.32msSELECT COUNT(DISTINCT e.entity_id) 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.website_id = '1' AND price_index.customer_group_id = 0 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.visibility IN(2, 4) AND cat_index.category_id=1234 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.row_id AND (product_entity_table.created_in <= 1 AND product_entity_table.updated_in > 1) WHERE ((`e`.`entity_id` NOT IN('26064')) AND (links.product_id in ('26064')) AND (`e`.`row_id` != '26064')) AND (e.created_in <= 1) AND (e.updated_in > 1)[]
1.48msSELECT `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`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position` 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.website_id = '1' AND price_index.customer_group_id = 0 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.visibility IN(2, 4) AND cat_index.category_id=1234 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.row_id AND (product_entity_table.created_in <= 1 AND product_entity_table.updated_in > 1) WHERE ((`e`.`entity_id` NOT IN('26064')) AND (links.product_id in ('26064')) AND (`e`.`row_id` != '26064')) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY RAND() LIMIT 20[]
0.76msSELECT `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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)[]
1.03msSELECT `main_table`.* FROM `magento_targetrule` AS `main_table` INNER JOIN `magento_targetrule_product` AS `product_idx` ON product_idx.rule_id = main_table.rule_id LEFT JOIN `magento_targetrule_customersegment` AS `segement_idx` ON segement_idx.rule_id = main_table.rule_id WHERE (`apply_to` = '1') AND (product_idx.product_id = '26064') AND (`is_active` = '1') AND (segement_idx.segment_id IS NULL) ORDER BY sort_order ASC []
0.81msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.46msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.59msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.48msSELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type` FROM `catalog_product_link_attribute` WHERE (link_type_id = 4)[]
1.28msSELECT COUNT(DISTINCT e.entity_id) 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.website_id = '1' AND price_index.customer_group_id = 0 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.visibility IN(2, 4) AND cat_index.category_id=1234 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.row_id AND (product_entity_table.created_in <= 1 AND product_entity_table.updated_in > 1) WHERE ((`e`.`entity_id` NOT IN('26064')) AND (links.product_id in ('26064')) AND (`e`.`row_id` != '26064')) AND (e.created_in <= 1) AND (e.updated_in > 1)[]
1.33msSELECT `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`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position` 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.website_id = '1' AND price_index.customer_group_id = 0 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.visibility IN(2, 4) AND cat_index.category_id=1234 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '4' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.row_id AND (product_entity_table.created_in <= 1 AND product_entity_table.updated_in > 1) WHERE ((`e`.`entity_id` NOT IN('26064')) AND (links.product_id in ('26064')) AND (`e`.`row_id` != '26064')) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY RAND() LIMIT 20[]
0.94msSELECT `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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)[]
0.72msSELECT DISTINCT `e`.`entity_id` AS `parent_product_id` FROM `catalog_product_bundle_selection` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = catalog_product_bundle_selection.parent_product_id AND (e.created_in <= 1 AND e.updated_in > 1) WHERE (catalog_product_bundle_selection.product_id IN('26064'))[]
0.96msSELECT `main_table`.* FROM `magento_targetrule` AS `main_table` INNER JOIN `magento_targetrule_product` AS `product_idx` ON product_idx.rule_id = main_table.rule_id LEFT JOIN `magento_targetrule_customersegment` AS `segement_idx` ON segement_idx.rule_id = main_table.rule_id WHERE (`apply_to` = '2') AND (product_idx.product_id = '26064') AND (`is_active` = '1') AND (segement_idx.segment_id IS NULL) ORDER BY sort_order ASC []
1.07msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.row_id = cbs.row_id WHERE ((`cms_block`.`identifier`='weltpixel_footer_v3') AND (is_active = 1) AND (cbs.store_id in (1, 0))) AND (cms_block.created_in <= 1) AND (cms_block.updated_in > 1) ORDER BY `store_id` DESC LIMIT 1[]
0.86msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '181')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
0.58msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.row_id = cb.row_id AND (cb.created_in <= 1 AND cb.updated_in > 1) WHERE (cb.block_id = :block_id){":block_id":181}
0.99msSELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.row_id = cbs.row_id WHERE ((`cms_block`.`identifier`='browser-restriction') AND (is_active = 1) AND (cbs.store_id in (1, 0))) AND (cms_block.created_in <= 1) AND (cms_block.updated_in > 1) ORDER BY `store_id` DESC LIMIT 1[]
0.52msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '192')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
0.47msSELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.row_id = cb.row_id AND (cb.created_in <= 1 AND cb.updated_in > 1) WHERE (cb.block_id = :block_id){":block_id":192}
0.84msSELECT `main_table`.`name` FROM `pr_cookie_entity` AS `main_table` WHERE (name LIKE '%*%')[]
0.47msSELECT `pr_cookie_entity`.`category_key` FROM `pr_cookie_entity` WHERE (name = :name){":name":"X-Magento-Vary"}