Employee ID

Make a Great Impression with Your Hospital Employee ID Badges

Every healthcare provider must have employee ID cards in place but are you using your employee badges to also help your branding, training, and compliance efforts? PDC offers a range of employee ID solutions to help your organization make a great impression and increase patient satisfaction.

  • Comply with Joint Commission requirements for identification of persons entering your facility
  • All products can be customized to reinforce branding, special events, and campaigns
  • Protect employee ID badges with badge holders
  • Secure employee ID badges and keep them forward facing with badge reels or lanyards
  • Communicate provider roles and need-to-know information with Badge Buddies

Filter
© 2021 PDC Healthcare. All Rights Reserved.
Time
[Total Time: 0.94663166999817 secs]
SQL [Total: 160 queries]Query Params
46.69msconnect[]
0.78msSET NAMES utf8[]
7.27msSELECT `main_table`.* FROM `core_config_data` AS `main_table`[]
93.56msSHOW TABLE STATUS LIKE 'store_website'[]
0.59msSELECT `store_website`.* FROM `store_website`[]
1.37msSHOW TABLE STATUS LIKE 'store_group'[]
0.51msSELECT `store_group`.* FROM `store_group`[]
0.88msSHOW TABLE STATUS LIKE 'store'[]
0.47msSELECT `store`.* FROM `store`[]
1.58msSHOW TABLE STATUS LIKE 'store'[]
1.17msSELECT `store`.* FROM `store`[]
1.46msSHOW TABLE STATUS LIKE 'store_website'[]
0.81msSELECT `store_website`.* FROM `store_website`[]
1.03msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='staging')[]
1.47msSELECT `main_table`.* FROM `eav_entity_type` AS `main_table`[]
1.48msSHOW TABLE STATUS LIKE 'setup_module'[]
0.78msSELECT `setup_module`.* FROM `setup_module`[]
0.84msSELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')[]
141.30msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('employee-id', 'employee-id/')) AND (`store_id` IN ('1'))[]
0.92msSELECT `theme`.* FROM `theme` WHERE (`theme`.`theme_id`='5')[]
0.94msSELECT `theme`.* FROM `theme` WHERE (`theme`.`theme_id`='4')[]
0.80msSELECT `theme`.* FROM `theme` WHERE (`theme`.`theme_id`='2')[]
0.76msSELECT `theme`.* FROM `theme` WHERE (`theme`.`theme_id`='1')[]
0.73msSELECT `main_table`.* FROM `theme` AS `main_table` WHERE (`area` = 'frontend') AND (`theme_path` = 'Magento/blank')[]
0.84msSELECT `main_table`.* FROM `theme` AS `main_table` WHERE (`area` = 'frontend') AND (`theme_path` = 'Magento/luma')[]
1.04msSELECT `main_table`.* FROM `theme` AS `main_table` WHERE (`area` = 'frontend') AND (`theme_path` = 'Pearl/weltpixel')[]
0.71msSELECT `main_table`.* FROM `theme` AS `main_table` WHERE (`area` = 'frontend') AND (`theme_path` = 'Pdchealthcare/pdc')[]
0.86msSELECT `translation`.`string`, `translation`.`translate`, `translation`.`store_id`, `translation`.`locale` FROM `translation` ORDER BY `store_id` ASC []
1.22msSELECT `translation`.`string`, `translation`.`translate` FROM `translation` WHERE (store_id IN (0 , :store_id)) AND (locale = :locale) ORDER BY `store_id` ASC {":locale":"en_US",":store_id":"1"}
0.72msSELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL){":store_id":1,":required_date":"2021-06-13"}
0.91msSELECT `main_table`.* FROM `store` AS `main_table` WHERE (`main_table`.`group_id` IN('1')) AND (`main_table`.`store_id` > 0) ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC []
139.17msSELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/1248', 'catalog/category/view/id/1248/')) AND (`store_id` IN ('1'))[]
135.93msSELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/category/view/id/1248', 'catalog/category/view/id/1248/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)[]
1.16msSELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE ((entity_id =1248)) AND (catalog_category_entity.created_in <= 1) AND (catalog_category_entity.updated_in > 1)[]
1.59msSELECT `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.85msSHOW INDEX FROM `catalog_category_entity`[]
0.64msSELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE ((entity_id = 1248)) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
2.04msSELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (row_id = '1248') 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 = '1248') 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 = '1248') 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 = '1248') 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 = '1248') AND (attribute_id IN ('70')) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC []
0.60msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1248'))[]
0.83msSELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE ((entity_id = '1248')) AND (catalog_category_entity.created_in <= 1) AND (catalog_category_entity.updated_in > 1) LIMIT 1[]
1.16msSELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`row_id` = `e`.`row_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`row_id` = `e`.`row_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE ((`e`.`entity_id` IN('1248', '1234', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0)) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `e`.`level` DESC []
1.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 (1248, 1234)) AND (t_d.attribute_id IN ('58', '61', '373')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_datetime` 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 (1248, 1234)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.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 (1248, 1234)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.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 (1248, 1234)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.55msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1248', '1', '1234'))[]
1.44msSELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.row_id = m.row_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.row_id = m.row_id WHERE ((m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)) AND (m.created_in <= 1) AND (m.updated_in > 1){":attribute_id":42,":store_id":"1",":active_flag":true,":c_path":"1\/1234\/1248\/%"}
1.18msSELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.row_id = m.row_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.row_id = m.row_id WHERE ((m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)) AND (m.created_in <= 1) AND (m.updated_in > 1){":attribute_id":42,":store_id":"1",":active_flag":true,":c_path":"1\/1234\/1248\/%"}
0.56msSELECT `main_table`.* FROM `amasty_finder_finder` AS `main_table` WHERE (((`categories` LIKE '%,1248,%') OR (`categories` LIKE '%,0,%')))[]
1.10msSELECT `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"}
0.96msSELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`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) WHERE ((`e`.`entity_id` IN('1248')) 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)[]
0.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 (1248)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
0.68msSELECT `main_table`.* FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '1234', '1248'))[]
0.85msDESCRIBE `eav_attribute`[]
1.26msSELECT `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`.*, 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 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`.`is_filterable` > 0) ORDER BY position ASC []
0.81msSELECT `main_table`.* FROM `mageworx_seobase_custom_canonical` AS `main_table` WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '1248') AND (`source_store_id` IN(0, '1')) ORDER BY source_store_id DESC []
1.02msSELECT `e`.* FROM `pr_cookie_entity` AS `e`[]
1.47msSELECT `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.88msSELECT COUNT(*) FROM `pr_cookie_entity` AS `e`[]
0.97msSELECT `e`.* FROM `pr_cookie_category_entity` AS `e` WHERE ((`e`.`status` = 1)) AND ((`e`.`is_essential` = 1))[]
1.29msSELECT `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.55msSELECT COUNT(*) FROM `pr_cookie_category_entity` AS `e` WHERE ((`e`.`status` = 1)) AND ((`e`.`is_essential` = 1))[]
0.70msSELECT `main_table`.`name` FROM `pr_cookie_entity` AS `main_table` WHERE (name LIKE '%*%')[]
1.04msSELECT `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) != ''))[]
0.88msSELECT 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) != ''))[]
1.43msSELECT `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.30msSELECT `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.16msSELECT 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))[]
1.26msSELECT `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.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_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.06msSELECT 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))[]
1.18msSELECT `e`.* FROM `pr_cookie_entity` AS `e` WHERE ((`e`.`category_key` IN('necessary', 'preferences', 'statistics', 'marketing')))[]
1.95msSELECT `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.94msSELECT COUNT(*) FROM `pr_cookie_entity` AS `e` WHERE ((`e`.`category_key` IN('necessary', 'preferences', 'statistics', 'marketing')))[]
1.59msSELECT `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 []
29.22msSELECT `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.63msSELECT `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.91msSELECT `magento_versionscms_hierarchy_node`.* FROM `magento_versionscms_hierarchy_node` WHERE (scope = 'store') AND (scope_id = '1') AND (`level` = 0) LIMIT 1[]
0.55msSELECT `magento_versionscms_hierarchy_node`.* FROM `magento_versionscms_hierarchy_node` WHERE (scope = 'website') AND (scope_id = '1') AND (`level` = 0) LIMIT 1[]
0.86msSELECT `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.16msSHOW INDEX FROM `cms_block`[]
1.46msSELECT `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.52msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '189')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
0.61msSELECT `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}
30.20msSELECT `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.15msSELECT `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'))[]
27.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))[]
1.79msSELECT `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'))[]
1.21msSELECT `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`.`block_id`='194') 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.82msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '194')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
1.00msSELECT `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":194}
2.43msSELECT `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)[]
1.69msDESCRIBE `catalog_product_entity`[]
1.08msSELECT `main_table`.*, `additional_table`.*, IF(al.value IS NULL, main_table.frontend_label, al.value) 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_for_sort_by = 1)[]
1.84msSELECT `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.96msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '181')) AND (t.created_in <= 1) AND (t.updated_in > 1)[]
0.72msSELECT `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}
1.34msSELECT `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[]
1.00msSELECT `t`.* FROM `cms_block` AS `t` WHERE ((block_id = '192')) 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":192}
26.02msSELECT `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.93msSELECT `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.10msSELECT `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.74msSELECT `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.66msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.87msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.91msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
1.70msSELECT `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`.* 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 = 4) AND ((`is_searchable` = '1') OR (`is_visible_in_advanced_search` = '1') OR (((`is_filterable` = '1') OR (`is_filterable` = '2'))) OR (`is_filterable_in_search` = '1'))[]
2.48msSELECT `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`.* 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 = 4) AND ((`is_searchable` = '1') OR (`is_visible_in_advanced_search` = '1') OR (((`is_filterable` = '1') OR (`is_filterable` = '2'))) OR (`is_filterable_in_search` = '1'))[]
1.42msSELECT `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`.* 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 = 4) AND ((`is_searchable` = '1') OR (`is_visible_in_advanced_search` = '1') OR (((`is_filterable` = '1') OR (`is_filterable` = '2'))) OR (`is_filterable_in_search` = '1'))[]
1.41msSELECT `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`.* 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 = 4) AND ((`is_searchable` = '1') OR (`is_visible_in_advanced_search` = '1') OR (((`is_filterable` = '1') OR (`is_filterable` = '2'))) OR (`is_filterable_in_search` = '1'))[]
1.99msSELECT `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`.* 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 = 4) AND (`attribute_code` IN('category_ids', 'country_of_manufacture', 'created_at', 'custom_design', 'custom_design_from', 'custom_design_to', 'custom_layout', 'custom_layout_update', 'description', 'gallery', 'has_options', 'image', 'image_label', 'media_gallery', 'meta_description', 'meta_keyword', 'meta_title', 'minimal_price', 'name', 'news_from_date', 'news_to_date', 'old_id', 'options_container', 'page_layout', 'price', 'quantity_and_stock_status', 'required_options', 'short_description', 'sku', 'small_image', 'small_image_label', 'special_from_date', 'special_price', 'special_to_date', 'status', 'thumbnail', 'thumbnail_label', 'tier_price', 'updated_at', 'visibility', 'weight', 'price_type', 'price_view', 'shipment_type', 'sku_type', 'weight_type', 'url_key', 'url_path', 'msrp', 'msrp_display_actual_price_type', 'links_exist', 'links_purchased_separately', 'links_title', 'samples_title', 'allow_message', 'allow_open_amount', 'email_template', 'giftcard_amounts', 'giftcard_type', 'lifetime', 'open_amount_max', 'open_amount_min', 'use_config_allow_message', 'use_config_email_template', 'is_redeemable', 'use_config_is_redeemable', 'use_config_lifetime', 'related_tgtr_position_behavior', 'related_tgtr_position_limit', 'upsell_tgtr_position_behavior', 'upsell_tgtr_position_limit', 'tax_class_id', 'gift_message_available', 'gift_wrapping_available', 'gift_wrapping_price', 'is_returnable', 'swatch_image'))[]
0.92msSELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base')[]
0.56msSELECT `inventory_stock`.* FROM `inventory_stock` WHERE (`inventory_stock`.`stock_id`=1)[]
0.53msSELECT `inventory_stock_sales_channel`.* FROM `inventory_stock_sales_channel` WHERE (stock_id = 1)[]
0.66msSELECT `main_table`.* FROM `cataloginventory_stock` AS `main_table`[]
2.68msCREATE TEMPORARY TABLE `search_tmp_60c5c88824c3b2_54744153` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='search_tmp_60c5c88824c3b2_54744153' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci[]
1.21msINSERT INTO `search_tmp_60c5c88824c3b2_54744153` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (category_ids_index.category_id in ('1248'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000[]
0.51msSELECT `search_tmp_60c5c88824c3b2_54744153`.`entity_id`, `search_tmp_60c5c88824c3b2_54744153`.`score` FROM `search_tmp_60c5c88824c3b2_54744153`[]
1.02msSELECT `e`.`attribute_set_id` FROM `catalog_product_entity` AS `e` WHERE ((entity_id IN (106093, 106089, 106080, 106074, 106070, 106067, 106066, 22156, 22143, 20655, 14775, 14774, 14773, 14772, 14771, 14770, 14769, 14767, 14765, 14763, 14762, 14761, 14760, 14759, 14758, 14757, 14756, 14754))) AND (e.created_in <= 1) AND (e.updated_in > 1) GROUP BY `attribute_set_id`[]
1.85msSELECT `main_table`.`attribute_code` 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 WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN('10')) GROUP BY `main_table`.`attribute_id`[]
0.87msSELECT count(main_table.entity_id) AS `count`, MAX(min_price) AS `max`, MIN(min_price) AS `min`, STDDEV_SAMP(min_price) AS `std` FROM `catalog_product_index_price` AS `main_table` WHERE (main_table.entity_id in (select entity_id from search_tmp_60c5c88824c3b2_54744153)) AND (customer_group_id = 0) AND (main_table.website_id = '1')[]
0.71msSELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `catalog_product_index_price` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC []
0.85msSELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `catalog_product_index_price` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC []
0.99msSELECT `main_table`.*, count(main_table.value) AS `count` FROM (SELECT `main_table`.`category_id` AS `value` FROM `catalog_category_product_index_store1` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.product_id = entities.entity_id INNER JOIN `catalog_category_entity` AS `category` ON main_table.category_id = category.entity_id AND (category.created_in <= 1 AND category.updated_in > 1) WHERE (main_table.store_id = '1') AND (`category`.`path` LIKE '1/1234/1248%') AND (`category`.`level` > '2')) AS `main_table` GROUP BY `value`[]
0.88msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 74) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.87msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='sku_value') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
0.78msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 0) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.56msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
0.41msSELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id){":entity_type_id":"4"}
0.65msSELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id){":attribute_id":"81"}
0.73msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 81) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.73msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 179) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.60msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 180) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.65msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 181) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.81msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 182) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.47msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
0.63msSELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id){":attribute_id":"183"}
1.18msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 183) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.96msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 184) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.77msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 187) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.63msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 259) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
0.90msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 264) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
1.17msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 266) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
1.14msSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table` INNER JOIN `search_tmp_60c5c88824c3b2_54744153` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 296) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`[]
1.50msSELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (category_ids_index.category_id in ('1248'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`[]
2.57msCREATE TEMPORARY TABLE `search_tmp_60c5c8882e6338_51262010` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='search_tmp_60c5c8882e6338_51262010' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci[]
0.48msINSERT INTO `search_tmp_60c5c8882e6338_51262010` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?){"1":"106093","2":"0.0000000000000000","3":"106089","4":"0.0000000000000000","5":"106080","6":"0.0000000000000000","7":"106074","8":"0.0000000000000000","9":"106070","10":"0.0000000000000000","11":"106067","12":"0.0000000000000000","13":"106066","14":"0.0000000000000000","15":"22156","16":"0.0000000000000000","17":"22143","18":"0.0000000000000000","19":"20655","20":"0.0000000000000000","21":"14775","22":"0.0000000000000000","23":"14774","24":"0.0000000000000000","25":"14773","26":"0.0000000000000000","27":"14772","28":"0.0000000000000000","29":"14771","30":"0.0000000000000000","31":"14770","32":"0.0000000000000000","33":"14769","34":"0.0000000000000000","35":"14767","36":"0.0000000000000000","37":"14765","38":"0.0000000000000000","39":"14763","40":"0.0000000000000000","41":"14762","42":"0.0000000000000000","43":"14761","44":"0.0000000000000000","45":"14760","46":"0.0000000000000000","47":"14759","48":"0.0000000000000000","49":"14758","50":"0.0000000000000000","51":"14757","52":"0.0000000000000000","53":"14756","54":"0.0000000000000000","55":"14754","56":"0.0000000000000000"}
1.37msSELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id){":entity_type_id":"4"}
1.01msSELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=1248 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 `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `search_tmp_60c5c8882e6338_51262010` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (e.created_in <= 1) AND (e.updated_in > 1)[]
2.40msSELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `at_ranking`.`value` AS `ranking` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=1248 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 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `search_tmp_60c5c8882e6338_51262010` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_ranking` ON (`at_ranking`.`row_id` = `e`.`row_id`) AND (`at_ranking`.`attribute_id` = '338') AND (`at_ranking`.`store_id` = 0) WHERE (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `cat_index`.`position` ASC, `ranking` ASC, `e`.`entity_id` ASC LIMIT 16[]
9.07msSELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_product_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 (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066)) AND (t_d.attribute_id IN ('71', '85', '86', '87', '97', '112', '113', '114', '119', '276', '377', '393')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_product_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 (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066)) AND (t_d.attribute_id IN ('73')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_product_entity_decimal` 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 (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066)) AND (t_d.attribute_id IN ('76', '120', '135', '137', '138')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_product_entity_datetime` 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 (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_product_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 (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066)) AND (t_d.attribute_id IN ('96', '122', '124', '126', '127', '128', '129', '132', '134', '136', '179', '180', '181', '182', '184', '186', '187', '193', '194', '198', '199', '259', '264', '266', '286', '296', '318', '325', '342')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))[]
2.21msSELECT `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 ('14754', '14772', '14756', '14757', '14769', '14758', '14770', '14771', '14759', '14760', '14773', '14761', '106067', '106070', '106074', '106066')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)[]
0.94msSELECT `catalog_category_product`.`product_id`, `catalog_category_product`.`category_id` FROM `catalog_category_product` WHERE (product_id IN (14754, 14772, 14756, 14757, 14769, 14758, 14770, 14771, 14759, 14760, 14773, 14761, 106067, 106070, 106074, 106066))[]
5.18msSELECT `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 []
1.14msSELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=1248 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 `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id INNER JOIN `search_tmp_60c5c8882e6338_51262010` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (e.created_in <= 1) AND (e.updated_in > 1)[]
19.69msSELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`row_id` = `e`.`row_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`row_id` = `e`.`row_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1) INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`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 `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE ((`e`.`path` LIKE '1/1234/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC []
26.81msSELECT `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.50msSELECT `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'))[]
25.86msSELECT `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.18msSELECT `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'))[]
1.00msSELECT `main_table`.`name` FROM `pr_cookie_entity` AS `main_table` WHERE (name LIKE '%*%')[]
0.43msSELECT `pr_cookie_entity`.`category_key` FROM `pr_cookie_entity` WHERE (name = :name){":name":"X-Magento-Vary"}