| 0 | connect | 0.46ms |
| 1 | SET NAMES utf8 | 0.16ms |
| 2 | SELECT `store_website`.*
FROM `store_website` | 0.24ms |
| 3 | SELECT `store_group`.*
FROM `store_group` | 0.20ms |
| 4 | SELECT `store`.*
FROM `store` | 0.11ms |
| 5 | SELECT `flag`.*
FROM `flag`
WHERE (`flag`.`flag_code`='config_hash') | 0.21ms |
| 6 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('vacuum-products', 'vacuum-products/')) AND (`store_id` IN ('2')) | 0.20ms |
| 7 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('catalog/category/view/id/107', 'catalog/category/view/id/107/')) AND (`store_id` IN ('2')) | 0.23ms |
| 8 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.request_path IN ('catalog/category/view/id/107', 'catalog/category/view/id/107/')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.28ms |
| 9 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id =107) | 0.22ms |
| 10 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = 107) | 0.21ms |
| 11 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('61', '62')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('72')) AND (`store_id` IN ('2', 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.90ms |
| 12 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '107') LIMIT 1 | 0.20ms |
| 13 | SELECT `main_table`.*
FROM `mageplaza_seorule_meta` AS `main_table`
WHERE (`category_id` = '107') AND (`entity_type` = 'category') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`))))
ORDER BY sort_order ASC | 0.24ms |
| 14 | SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '70') AND `at_custom_use_parent_settings_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '70') AND (`at_custom_use_parent_settings`.`store_id` = 2)
WHERE (`e`.`entity_id` IN('107', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0)
ORDER BY `e`.`level` DESC | 0.36ms |
| 15 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (107, 2)) AND (t_d.attribute_id IN ('60', '63', '275')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_datetime` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (107, 2)) AND (t_d.attribute_id IN ('61', '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_text` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (107, 2)) AND (t_d.attribute_id IN ('64')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_int` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (107, 2)) AND (t_d.attribute_id IN ('71')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.01ms |
| 16 | SELECT COUNT(m.entity_id)
FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id
WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag) | 0.31ms |
| 17 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
WHERE (`e`.`entity_id` IN('107')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') | 0.37ms |
| 18 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (107)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.40ms |
| 19 | SELECT `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 = 2
WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0)
ORDER BY position ASC | 0.53ms |
| 20 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('107')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.27ms |
| 21 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`target_path` IN ('catalog/category/view/id/107')) AND (`store_id` IN ('2')) | 0.38ms |
| 22 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_type` IN ('category')) AND (`entity_id` IN ('107')) AND (`store_id` IN ('2')) AND (`is_autogenerated` IN (1)) | 0.26ms |
| 23 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_type` IN ('category')) AND (`entity_id` IN ('107')) AND (`store_id` IN ('1')) AND (`is_autogenerated` IN (1)) | 0.25ms |
| 24 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_type IN ('category')) AND (url_rewrite.entity_id IN ('107')) AND (url_rewrite.store_id IN ('1')) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.28ms |
| 25 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = :entity_id) | 0.21ms |
| 26 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.21ms |
| 27 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2)
ORDER BY `catalog_category_entity`.`position` ASC | 0.31ms |
| 28 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.48ms |
| 29 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 0.82ms |
| 30 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (3, 4, 8, 14, 15, 48, 61, 62, 63, 64, 107, 128, 129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.59ms |
| 31 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = :entity_id) | 0.24ms |
| 32 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.20ms |
| 33 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2)
ORDER BY `catalog_category_entity`.`position` ASC | 0.30ms |
| 34 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.65ms |
| 35 | SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
ORDER BY `name` ASC | 0.98ms |
| 36 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (62, 14, 8, 3, 4, 61, 15, 63, 128, 48, 64, 129, 107)) AND (t_d.attribute_id IN ('117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.45ms |
| 37 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='porto_custom_menu_before') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.31ms |
| 38 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='3') | 0.20ms |
| 39 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '3') | 0.20ms |
| 40 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.84ms |
| 41 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '3') LIMIT 1 | 0.18ms |
| 42 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='4') | 0.21ms |
| 43 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '4') | 0.11ms |
| 44 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.71ms |
| 45 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 46 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='62') | 0.11ms |
| 47 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '62') | 0.11ms |
| 48 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.69ms |
| 49 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '62') LIMIT 1 | 0.10ms |
| 50 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='63') | 0.11ms |
| 51 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '63') | 0.11ms |
| 52 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.72ms |
| 53 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '63') LIMIT 1 | 0.11ms |
| 54 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='8') | 0.11ms |
| 55 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '8') | 0.11ms |
| 56 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.69ms |
| 57 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '8') LIMIT 1 | 0.10ms |
| 58 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='61') | 0.11ms |
| 59 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '61') | 0.11ms |
| 60 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.79ms |
| 61 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '61') LIMIT 1 | 0.20ms |
| 62 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('61')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.24ms |
| 63 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='14') | 0.20ms |
| 64 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '14') | 0.20ms |
| 65 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.77ms |
| 66 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '14') LIMIT 1 | 0.19ms |
| 67 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='15') | 0.11ms |
| 68 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '15') | 0.11ms |
| 69 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.66ms |
| 70 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '15') LIMIT 1 | 0.10ms |
| 71 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='48') | 0.11ms |
| 72 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '48') | 0.11ms |
| 73 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.67ms |
| 74 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '48') LIMIT 1 | 0.10ms |
| 75 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='107') | 0.11ms |
| 76 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '107') | 0.11ms |
| 77 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.69ms |
| 78 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '107') LIMIT 1 | 0.10ms |
| 79 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='128') | 0.11ms |
| 80 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '128') | 0.11ms |
| 81 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.62ms |
| 82 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '128') LIMIT 1 | 0.10ms |
| 83 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='64') | 0.11ms |
| 84 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '64') | 0.11ms |
| 85 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.65ms |
| 86 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '64') LIMIT 1 | 0.10ms |
| 87 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='129') | 0.11ms |
| 88 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '129') | 0.11ms |
| 89 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.64ms |
| 90 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '129') LIMIT 1 | 0.10ms |
| 91 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='porto_custom_menu') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.25ms |
| 92 | SELECT `main_table`.*
FROM `tax_class` AS `main_table`
WHERE (`main_table`.`class_type` = 'PRODUCT') | 0.21ms |
| 93 | SELECT `customer_group`.*
FROM `customer_group`
WHERE (`customer_group`.`customer_group_id`=0) | 0.20ms |
| 94 | SELECT `tax_class`.*
FROM `tax_class`
WHERE (`tax_class`.`class_id`='5') | 0.12ms |
| 95 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.38ms |
| 96 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.43ms |
| 97 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('3')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.38ms |
| 98 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('4')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.39ms |
| 99 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('8')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.33ms |
| 100 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('9')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.34ms |
| 101 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('10')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.33ms |
| 102 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('11')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.34ms |
| 103 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('12')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.34ms |
| 104 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('13')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.33ms |
| 105 | SELECT `main_table`.*
FROM `mageplaza_seocrosslinks_term` AS `main_table`
WHERE (`status` = '1') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`)))) AND (FIND_IN_SET(1, `apply_for`))
ORDER BY sort_order ASC | 0.22ms |
| 106 | SELECT `main_table`.*
FROM `cataloginventory_stock` AS `main_table` | 0.23ms |
| 107 | CREATE TEMPORARY TABLE `search_tmp_6428bf0d81fc35_61637680` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`)
) COMMENT='search_tmp_6428bf0d81fc35_61637680' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci | 0.37ms |
| 108 | INSERT INTO `search_tmp_6428bf0d81fc35_61637680`
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_store2` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '2'
WHERE (search_index.store_id = '2') AND (category_ids_index.category_id IN (107))) AS `main_select`
GROUP BY `entity_id`
ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.49ms |
| 109 | SELECT `search_tmp_6428bf0d81fc35_61637680`.`entity_id`, `search_tmp_6428bf0d81fc35_61637680`.`score`
FROM `search_tmp_6428bf0d81fc35_61637680` | 0.18ms |
| 110 | SELECT `e`.`attribute_set_id`
FROM `catalog_product_entity` AS `e`
WHERE (entity_id IN (5875, 5754, 5464, 5296))
GROUP BY `attribute_set_id` | 0.23ms |
| 111 | SELECT `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.61ms |
| 112 | SELECT 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_6428bf0d81fc35_61637680)) AND (customer_group_id = 0) AND (main_table.website_id = '1') | 0.24ms |
| 113 | SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix`
FROM `catalog_product_index_price` AS `main_table`
INNER JOIN `search_tmp_6428bf0d81fc35_61637680` 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.28ms |
| 114 | SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix`
FROM `catalog_product_index_price` AS `main_table`
INNER JOIN `search_tmp_6428bf0d81fc35_61637680` 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.24ms |
| 115 | SELECT `main_table`.*, count(main_table.value) AS `count`
FROM (
SELECT `main_table`.`category_id` AS `value`
FROM `catalog_category_product_index_store2` AS `main_table`
INNER JOIN `search_tmp_6428bf0d81fc35_61637680` 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
WHERE (main_table.store_id = '2') AND (`category`.`path` LIKE '1/2/107%') AND (`category`.`level` > '2')) AS `main_table`
GROUP BY `value` | 0.25ms |
| 116 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id) | 0.12ms |
| 117 | SELECT `eav_entity_type`.`additional_attribute_table`
FROM `eav_entity_type`
WHERE (entity_type_id = :entity_type_id) | 0.10ms |
| 118 | SELECT `catalog_eav_attribute`.*
FROM `catalog_eav_attribute`
WHERE (attribute_id = :attribute_id) | 0.12ms |
| 119 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 83) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.18ms |
| 120 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 156) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.19ms |
| 121 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 157) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.17ms |
| 122 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 187) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.25ms |
| 123 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='modulfixierung') AND (entity_type_id = :entity_type_id) | 0.21ms |
| 124 | SELECT `catalog_eav_attribute`.*
FROM `catalog_eav_attribute`
WHERE (attribute_id = :attribute_id) | 0.18ms |
| 125 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 255) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.17ms |
| 126 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 259) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.18ms |
| 127 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 262) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.28ms |
| 128 | SELECT `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_6428bf0d81fc35_61637680` AS `entities` ON main_table.entity_id = entities.entity_id
WHERE (main_table.attribute_id = 266) AND (main_table.store_id = '2' )) AS `main_table`
GROUP BY `value` | 0.18ms |
| 129 | SELECT 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_store2` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '2'
WHERE (search_index.store_id = '2') AND (category_ids_index.category_id IN (107))) AS `main_select`
GROUP BY `entity_id`
ORDER BY `relevance` DESC, `entity_id` DESC) AS `core_select` | 0.27ms |
| 130 | CREATE TEMPORARY TABLE `search_tmp_6428bf0d844343_51715250` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`)
) COMMENT='search_tmp_6428bf0d844343_51715250' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci | 0.19ms |
| 131 | INSERT INTO `search_tmp_6428bf0d844343_51715250` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?) | 0.15ms |
| 132 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id) | 0.19ms |
| 133 | SELECT COUNT(DISTINCT e.entity_id)
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=107
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `search_tmp_6428bf0d844343_51715250` AS `search_result` ON e.entity_id = search_result.entity_id | 0.32ms |
| 134 | SELECT `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`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=107
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = (
SELECT `review_entity`.`entity_id`
FROM `review_entity`
WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `search_tmp_6428bf0d844343_51715250` AS `search_result` ON e.entity_id = search_result.entity_id
ORDER BY `cat_index`.`position` asc, `e`.`entity_id` DESC, `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` DESC LIMIT 12 | 0.49ms |
| 135 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5875, 5754, 5296, 5464)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '132', '135', '159', '160', '161', '162', '173', '176', '209', '233', '241', '284', '285')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5875, 5754, 5296, 5464)) AND (t_d.attribute_id IN ('76', '235', '242', '273')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5875, 5754, 5296, 5464)) AND (t_d.attribute_id IN ('78', '121', '237', '238', '239')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5875, 5754, 5296, 5464)) AND (t_d.attribute_id IN ('79', '80', '94', '95')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5875, 5754, 5296, 5464)) AND (t_d.attribute_id IN ('97', '123', '125', '126', '127', '128', '131', '133', '136', '156', '157', '165', '174', '177', '180', '186', '187', '202', '204', '218', '234', '236', '240', '250', '256', '259', '262', '266', '290')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 3.19ms |
| 136 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('5875', '5754', '5296', '5464')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.31ms |
| 137 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 5875) | 0.21ms |
| 138 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='107') | 0.20ms |
| 139 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '107') | 0.19ms |
| 140 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.78ms |
| 141 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '107') LIMIT 1 | 0.19ms |
| 142 | SELECT `customer_group`.*
FROM `customer_group`
WHERE (`customer_group`.`customer_group_id`='1') | 0.29ms |
| 143 | SELECT `tax_class`.*
FROM `tax_class`
WHERE (`tax_class`.`class_id`='5') | 0.21ms |
| 144 | (
SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '90034', '90034*', '9003*', '900*', '90*', '9*'))) UNION (
SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NOT NULL) AND ('90034' BETWEEN rate.zip_from AND rate.zip_to))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.67ms |
| 145 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (`main_table`.`option_id` IN('29')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.34ms |
| 146 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (`main_table`.`option_id` IN('78')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 147 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 5754) | 0.23ms |
| 148 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (`main_table`.`option_id` IN('30')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 149 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.26ms |
| 150 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 5296) | 0.21ms |
| 151 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (`main_table`.`option_id` IN('30')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 152 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (`main_table`.`option_id` IN('78')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 153 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 5464) | 0.22ms |
| 154 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (`main_table`.`option_id` IN('29')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 155 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (`main_table`.`option_id` IN('78')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.27ms |
| 156 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='bottom_description') AND (entity_type_id = :entity_type_id) | 0.28ms |
| 157 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '107') | 0.22ms |
| 158 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/107/%')
ORDER BY `catalog_category_entity`.`position` ASC | 0.22ms |
| 159 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('111', '112', '113')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.30ms |
| 160 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('111', '112', '113')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 0.46ms |
| 161 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (111, 112, 113)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.35ms |
| 162 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='2') | 0.18ms |
| 163 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '2') | 0.20ms |
| 164 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '2') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '2') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '2') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '2') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '2') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.69ms |
| 165 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '2') LIMIT 1 | 0.17ms |
| 166 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.19ms |
| 167 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%')
ORDER BY `catalog_category_entity`.`position` ASC | 0.22ms |
| 168 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('3', '117', '65', '120', '127', '66', '67', '68', '108', '4', '69', '126', '71', '70', '72', '73', '74', '75', '7', '62', '76', '77', '78', '79', '63', '81', '80', '82', '83', '8', '88', '89', '90', '91', '61', '13', '14', '15', '98', '97', '96', '103', '102', '101', '100', '99', '48', '87', '86', '84', '85', '105', '107', '111', '112', '113', '128', '64', '94', '92', '93', '95', '129', '123', '106', '121', '52', '49', '55', '56', '57', '58', '59', '60', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.65ms |
| 169 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('3', '117', '65', '120', '127', '66', '67', '68', '108', '4', '69', '126', '71', '70', '72', '73', '74', '75', '7', '62', '76', '77', '78', '79', '63', '81', '80', '82', '83', '8', '88', '89', '90', '91', '61', '13', '14', '15', '98', '97', '96', '103', '102', '101', '100', '99', '48', '87', '86', '84', '85', '105', '107', '111', '112', '113', '128', '64', '94', '92', '93', '95', '129', '123', '106', '121', '52', '49', '55', '56', '57', '58', '59', '60', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('72', '74', '7', '78', '81', '83', '13', '102', '101', '100', '99', '105', '94', '123', '106', '121', '49', '60', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 1.40ms |
| 170 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (3, 4, 8, 14, 15, 48, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 73, 75, 76, 77, 79, 80, 82, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 95, 96, 97, 98, 103, 107, 108, 111, 112, 113, 117, 120, 126, 127, 128, 129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.30ms |
| 171 | SELECT `m`.`entity_id`
FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id
WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level` <= :c_level) | 0.30ms |
| 172 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('111', '112', '113'))
ORDER BY `e`.`position` ASC | 0.37ms |
| 173 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (111, 112, 113)) AND (t_d.attribute_id IN ('117', '45')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_text` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (111, 112, 113)) AND (t_d.attribute_id IN ('57')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_int` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (111, 112, 113)) AND (t_d.attribute_id IN ('54')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.57ms |
| 174 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.57ms |
| 175 | SELECT `main_table`.*
FROM `eav_attribute_option_swatch` AS `main_table`
WHERE (`main_table`.`option_id` IN(29, 30)) | 0.21ms |
| 176 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='porto_category_side_custom_block') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.33ms |
Info 
Design 
Profile 
Queries 
Logs 
Actions 
