| 0 | connect | 0.30ms |
| 1 | SET NAMES utf8 | 0.07ms |
| 2 | SELECT `store_website`.*
FROM `store_website` | 0.18ms |
| 3 | SELECT `store_group`.*
FROM `store_group` | 0.11ms |
| 4 | SELECT `store`.*
FROM `store` | 0.09ms |
| 5 | SELECT `flag`.*
FROM `flag`
WHERE (`flag`.`flag_code`='config_hash') | 0.28ms |
| 6 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('gear/l/activity:school/features-bags:lightweight/material:rayon/style-bags:tote/test-shipping-filter:b.html', 'gear/l/activity:school/features-bags:lightweight/material:rayon/style-bags:tote/test-shipping-filter:b.html/')) AND (`store_id` IN ('1')) | 0.28ms |
| 7 | SELECT `url_rewrite`.*, `relation`.*
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 ('test-shipping-filter:b.html')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) | 0.23ms |
| 8 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('gear.html', 'gear.html/')) AND (`store_id` IN ('1')) | 0.16ms |
| 9 | 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 = 1
WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0)
ORDER BY `position` ASC | 1.29ms |
| 10 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '245') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.62ms |
| 11 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '250') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.34ms |
| 12 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '258') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 13 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '259') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.63ms |
| 14 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '251') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.39ms |
| 15 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '77') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.28ms |
| 16 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '83') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 17 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '93') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.47ms |
| 18 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '215') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.24ms |
| 19 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '223') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.24ms |
| 20 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '224') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.51ms |
| 21 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '225') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 22 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '226') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.33ms |
| 23 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '227') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 24 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '228') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.28ms |
| 25 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '229') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.28ms |
| 26 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '230') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 27 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '231') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.31ms |
| 28 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '232') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.27ms |
| 29 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '233') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.34ms |
| 30 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '234') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.36ms |
| 31 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '235') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.36ms |
| 32 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '242') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 2.22ms |
| 33 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '243') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.27ms |
| 34 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '244') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.37ms |
| 35 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '246') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.55ms |
| 36 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '247') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.29ms |
| 37 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '248') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.37ms |
| 38 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '249') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.33ms |
| 39 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '257') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.36ms |
| 40 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '260') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.58ms |
| 41 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '261') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.55ms |
| 42 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '262') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.31ms |
| 43 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '263') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.28ms |
| 44 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('catalog/category/view/id/3', 'catalog/category/view/id/3/')) AND (`store_id` IN ('1')) | 0.62ms |
| 45 | SELECT `url_rewrite`.*, `relation`.*
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 ('3')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) | 0.39ms |
| 46 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('catalog/category/view/id/3', 'catalog/category/view/id/3/')) AND (`store_id` IN ('1')) | 0.17ms |
| 47 | SELECT `url_rewrite`.*, `relation`.*
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 ('3')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL) | 0.16ms |
| 48 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id =3) | 0.36ms |
| 49 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = 3) | 0.19ms |
| 50 | 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, 119, 48, 49, 149, 140, 52, 60, 120, 63, 68, 118)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (46, 70, 71, 145, 138, 69, 151, 53, 54)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (47, 50, 51, 143, 147, 57, 58, 59, 67, 64)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (61, 62)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (72)) AND (`store_id` IN ('1', 0))) ) AS `u`
ORDER BY `store_id` ASC | 1.13ms |
| 51 | SELECT COUNT(DISTINCT main_table.crosslink_id)
FROM `mageworx_seocrosslinks_crosslink` AS `main_table`
INNER JOIN `mageworx_seocrosslinks_crosslink_store` AS `store_table` ON main_table.crosslink_id = store_table.crosslink_id
WHERE (main_table.in_category = 1) AND (main_table.is_active = 1) AND (store_table.store_id IN('1', 0)) | 0.49ms |
| 52 | SELECT `main_table`.*, `main_table`.`crosslink_id`, `main_table`.`keyword`
FROM `mageworx_seocrosslinks_crosslink` AS `main_table`
INNER JOIN `mageworx_seocrosslinks_crosslink_store` AS `store_table` ON main_table.crosslink_id = store_table.crosslink_id
WHERE (main_table.in_category = 1) AND (main_table.is_active = 1) AND (store_table.store_id IN('1', 0))
GROUP BY `main_table`.`crosslink_id` | 0.40ms |
| 53 | SELECT `main_table`.*
FROM `mageworx_seocrosslinks_crosslink` AS `main_table`
INNER JOIN `mageworx_seocrosslinks_crosslink_store` AS `store_table` ON main_table.crosslink_id = store_table.crosslink_id
WHERE (main_table.in_category = 1) AND (main_table.is_active = 1) AND (store_table.store_id IN('1', 0)) AND (`main_table`.`crosslink_id` IN(3))
GROUP BY `main_table`.`crosslink_id`
ORDER BY priority DESC | 0.21ms |
| 54 | SELECT `crosslink_entity_store`.*
FROM `mageworx_seocrosslinks_crosslink_store` AS `crosslink_entity_store`
WHERE (crosslink_entity_store.crosslink_id IN ('3')) | 0.13ms |
| 55 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '3') LIMIT 1 | 0.37ms |
| 56 | 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` = 1)
WHERE (`e`.`entity_id` IN('3', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0)
ORDER BY `e`.`level` DESC | 0.52ms |
| 57 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (3, 2)) AND (t_d.attribute_id IN (60, 63, 118)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_datetime` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (3, 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 = 1
WHERE (e.entity_id IN (3, 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 = 1
WHERE (e.entity_id IN (3, 2)) AND (t_d.attribute_id IN (71)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.95ms |
| 58 | 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.39ms |
| 59 | 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.25ms |
| 60 | SELECT `layout_update`.`xml`, `layout_update`.`handle`
FROM `layout_update`
INNER JOIN `layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id
WHERE (link.store_id IN (0, :store_id)) AND (link.theme_id = :theme_id) AND (link.is_temporary = 0)
ORDER BY `layout_update`.`sort_order` ASC | 1.04ms |
| 61 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.55ms |
| 62 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%')
ORDER BY `catalog_category_entity`.`position` ASC | 0.34ms |
| 63 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`
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` = 1)
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` = 1)
WHERE (`e`.`entity_id` IN('3', '50', '32', '4', '23', '5', '9', '19', '21', '41', '49', '53', '58')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
ORDER BY `name` ASC | 1.07ms |
| 64 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (5, 3, 4, 23, 58, 9, 53, 49, 21, 50, 32)) AND (t_d.attribute_id IN (119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_int` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (5, 3, 4, 23, 58, 9, 53, 49, 21, 50, 32)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.58ms |
| 65 | 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` = 1)
WHERE (`e`.`entity_id` IN('3')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') | 0.25ms |
| 66 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (3)) AND (t_d.attribute_id IN (45, 119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.25ms |
| 67 | 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 = 1
WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0)
ORDER BY `position` ASC | 1.28ms |
| 68 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='3') | 0.16ms |
| 69 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '3') | 0.14ms |
| 70 | 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, 119, 48, 49, 149, 140, 52, 60, 120, 63, 68, 118)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (46, 70, 71, 145, 138, 69, 151, 53, 54)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (47, 50, 51, 143, 147, 57, 58, 59, 67, 64)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (61, 62)) AND (`store_id` IN ('1', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN (72)) AND (`store_id` IN ('1', 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.79ms |
| 71 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '3') LIMIT 1 | 0.15ms |
| 72 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id) | 0.17ms |
| 73 | SELECT `eav_entity_type`.`additional_attribute_table`
FROM `eav_entity_type`
WHERE (entity_type_id = :entity_type_id) | 0.14ms |
| 74 | SELECT `catalog_eav_attribute`.*
FROM `catalog_eav_attribute`
WHERE (attribute_id = :attribute_id) | 0.15ms |
| 75 | 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.32ms |
| 76 | 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` = 1)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category')
WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('17', '18', '56', '8'))
ORDER BY `e`.`position` ASC | 0.37ms |
| 77 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) AND (t_d.attribute_id IN (119, 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 = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) 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 = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.59ms |
| 78 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '245') AND (`main_table`.`option_id` IN('76')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.21ms |
| 79 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '215') AND (`main_table`.`option_id` IN('8')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.20ms |
| 80 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '244') AND (`main_table`.`option_id` IN('66')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.18ms |
| 81 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '246') AND (`main_table`.`option_id` IN('85')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.18ms |
| 82 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '248') AND (`main_table`.`option_id` IN('118')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.17ms |
| 83 | SELECT `main_table`.*
FROM `mageworx_seobase_custom_canonical` AS `main_table`
WHERE (`source_entity_type` = 'category') AND (`source_entity_id` = '3') AND (`source_store_id` IN(0, '1'))
ORDER BY source_store_id DESC | 0.27ms |
| 84 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('3')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.18ms |
| 85 | SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate`
FROM `directory_currency_rate`
WHERE (currency_from = :currency_from) AND (currency_to IN('BYN', 'EUR', 'USD')) | 0.58ms |
| 86 | SELECT `main_table`.*
FROM `checkout_agreement` AS `main_table`
INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id
WHERE (store_table_1.store_id IN ('1', 0)) AND ((`is_active` = 1))
GROUP BY `main_table`.`agreement_id` | 0.65ms |
| 87 | SELECT `captcha_log`.`count`
FROM `captcha_log`
WHERE (type = 1) AND (value = '216.73.216.105') | 0.64ms |
| 88 | SELECT `captcha_log`.`count`
FROM `captcha_log`
WHERE (type = 1) AND (value = '216.73.216.105') | 0.15ms |
| 89 | SELECT `e`.*, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '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` = 1)
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '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` = 1)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`path` LIKE '1/2/%') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')
ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC | 1.78ms |
| 90 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (3, 50, 4, 32, 5, 23, 9, 21, 49, 53, 58, 8, 6, 10, 22, 24, 33, 54, 17, 11, 25, 34, 55, 18, 12, 56, 7, 13, 26, 30, 35, 39, 14, 27, 31, 36, 40, 15, 28, 37, 16, 29, 38)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.76ms |
| 91 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('50')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.18ms |
| 92 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('50')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.42ms |
| 93 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('32')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.17ms |
| 94 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('32')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.25ms |
| 95 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.21ms |
| 96 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('23')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 97 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('21')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.19ms |
| 98 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('21')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.38ms |
| 99 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('49')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.17ms |
| 100 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('49')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 101 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('22')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.17ms |
| 102 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('22')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.47ms |
| 103 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('24')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.16ms |
| 104 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('24')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 105 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('33')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.16ms |
| 106 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('33')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 107 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('17')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.22ms |
| 108 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('17')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.23ms |
| 109 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 110 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('25')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 111 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('34')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.17ms |
| 112 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('34')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 113 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.19ms |
| 114 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('18')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 115 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.31ms |
| 116 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('26')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 117 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('30')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.18ms |
| 118 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('30')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 119 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('35')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.19ms |
| 120 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('35')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 121 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('39')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 122 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('39')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 123 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('27')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.33ms |
| 124 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('27')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.20ms |
| 125 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('31')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.18ms |
| 126 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('31')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 127 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('36')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.16ms |
| 128 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('36')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 129 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('40')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 130 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('40')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.16ms |
| 131 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('28')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 132 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('28')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 133 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('37')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 134 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('37')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.17ms |
| 135 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('29')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.15ms |
| 136 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('29')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.16ms |
| 137 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('38')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1)) AND (`redirect_type` IN (0)) | 0.14ms |
| 138 | SELECT `url_rewrite`.*, `relation`.*
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('38')) AND (url_rewrite.entity_type IN ('category')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.redirect_type IN (0)) AND (relation.category_id IS NULL) | 0.18ms |
| 139 | SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate`
FROM `directory_currency_rate`
WHERE (currency_from = :currency_from) AND (currency_to IN('BYN', 'EUR', 'USD')) | 0.38ms |
| 140 | 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`.`block_id`='11') AND (is_active = 1) AND (cbs.store_id in (1, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.28ms |
| 141 | SELECT `t`.*
FROM `cms_block` AS `t`
WHERE (block_id = '11') | 0.14ms |
| 142 | SELECT `cbs`.`store_id`
FROM `cms_block_store` AS `cbs`
INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id
WHERE (cb.block_id = :block_id) | 0.15ms |
| 143 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id) | 0.17ms |
| 144 | SELECT `inventory_stock_sales_channel`.`stock_id`
FROM `inventory_stock_sales_channel`
WHERE (type = 'website') AND (code = 'base') | 0.31ms |
| 145 | SELECT `inventory_stock`.*
FROM `inventory_stock`
WHERE (`inventory_stock`.`stock_id`=1) | 0.14ms |
| 146 | SELECT `inventory_stock_sales_channel`.*
FROM `inventory_stock_sales_channel`
WHERE (stock_id = 1) | 0.16ms |
| 147 | SELECT DISTINCT `e`.`entity_id`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
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=2
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
WHERE (((IFNULL(`e`.`sku`, 0) IN ('24-MB02', '24-WB04', '24-UG06', '24-WG080') OR (FIND_IN_SET ('24-MB02', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WB04', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-UG06', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WG080', `e`.`sku`) > 0)) )) AND (stock_status_index.stock_status = 1) | 1.00ms |
| 148 | SELECT DISTINCT `e`.`entity_id`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
WHERE (((IFNULL(`e`.`sku`, 0) IN ('24-MB02', '24-WB04', '24-UG06', '24-WG080') OR (FIND_IN_SET ('24-MB02', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WB04', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-UG06', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WG080', `e`.`sku`) > 0)) )) | 1.23ms |
| 149 | SELECT `entity_table`.`entity_id`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id
INNER JOIN `catalog_product_entity` AS `entity_table` ON entity_table.entity_id = link_table.parent_id
WHERE (link_table.product_id IN ('70', '78', '79', '109', '70', '79', '78', '109')) | 0.19ms |
| 150 | SELECT DISTINCT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
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=2
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((IFNULL(`e`.`sku`, 0) IN ('24-MB02', '24-WB04', '24-UG06', '24-WG080') OR (FIND_IN_SET ('24-MB02', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WB04', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-UG06', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WG080', `e`.`sku`) > 0)) )) AND (stock_status_index.stock_status = 1)
ORDER BY (FIELD(`e`.`sku`, '24-MB02', '24-WB04', '24-UG06', '24-WG080')) LIMIT 4 | 1.64ms |
| 151 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (70, 78, 79, 109)) AND (t_d.attribute_id IN (251, 93, 97, 125, 128, 129, 131, 132, 133, 136, 215, 241)) 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_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (70, 78, 79, 109)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (70, 78, 79, 109)) AND (t_d.attribute_id IN (76)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (70, 78, 79, 109)) AND (t_d.attribute_id IN (78, 123)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (70, 78, 79, 109)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.26ms |
| 152 | SELECT `url_rewrite`.*, `relation`.*
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 ('70', '78', '79', '109')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.26ms |
| 153 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('70', '78', '79', '109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.32ms |
| 154 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.18ms |
| 155 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.16ms |
| 156 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.33ms |
| 157 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.17ms |
| 158 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.26ms |
| 159 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.21ms |
| 160 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.22ms |
| 161 | SELECT DISTINCT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
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=2
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((IFNULL(`e`.`sku`, 0) IN ('24-MB02', '24-WB04', '24-UG06', '24-WG080') OR (FIND_IN_SET ('24-MB02', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WB04', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-UG06', `e`.`sku`) > 0) OR (FIND_IN_SET ('24-WG080', `e`.`sku`) > 0)) )) AND (stock_status_index.stock_status = 1)
ORDER BY (FIELD(`e`.`sku`, '24-MB02', '24-WB04', '24-UG06', '24-WG080')) LIMIT 4 | 1.51ms |
| 162 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 70) | 0.16ms |
| 163 | SELECT `main_table`.*, `review_entity`.`entity_code`
FROM `review_entity_summary` AS `main_table`
LEFT JOIN `review_entity` ON main_table.entity_type = review_entity.entity_id
WHERE (store_id = 1) AND (entity_pk_value = '70') AND (entity_code = 'product') | 0.21ms |
| 164 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '70')
ORDER BY `qty` ASC | 0.25ms |
| 165 | SELECT `directory_currency_rate`.`rate`
FROM `directory_currency_rate`
WHERE (currency_from = :currency_from) AND (currency_to = :currency_to) | 0.13ms |
| 166 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('70')) | 0.13ms |
| 167 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (70) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('70')) | 0.21ms |
| 168 | SELECT `eav_entity_type`.*
FROM `eav_entity_type`
WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') | 0.18ms |
| 169 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='msrp') AND (entity_type_id = :entity_type_id) | 0.17ms |
| 170 | SELECT `catalog_eav_attribute`.*
FROM `catalog_eav_attribute`
WHERE (attribute_id = :attribute_id) | 0.18ms |
| 171 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 78) | 0.44ms |
| 172 | SELECT `main_table`.*, `review_entity`.`entity_code`
FROM `review_entity_summary` AS `main_table`
LEFT JOIN `review_entity` ON main_table.entity_type = review_entity.entity_id
WHERE (store_id = 1) AND (entity_pk_value = '78') AND (entity_code = 'product') | 0.27ms |
| 173 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '78')
ORDER BY `qty` ASC | 0.23ms |
| 174 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('78')) | 0.14ms |
| 175 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (78) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('78')) | 0.23ms |
| 176 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 79) | 0.16ms |
| 177 | SELECT `main_table`.*, `review_entity`.`entity_code`
FROM `review_entity_summary` AS `main_table`
LEFT JOIN `review_entity` ON main_table.entity_type = review_entity.entity_id
WHERE (store_id = 1) AND (entity_pk_value = '79') AND (entity_code = 'product') | 0.37ms |
| 178 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '79')
ORDER BY `qty` ASC | 0.19ms |
| 179 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('79')) | 0.13ms |
| 180 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (79) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('79')) | 0.19ms |
| 181 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 109) | 0.17ms |
| 182 | SELECT `main_table`.*, `review_entity`.`entity_code`
FROM `review_entity_summary` AS `main_table`
LEFT JOIN `review_entity` ON main_table.entity_type = review_entity.entity_id
WHERE (store_id = 1) AND (entity_pk_value = '109') AND (entity_code = 'product') | 0.19ms |
| 183 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.30ms |
| 184 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.21ms |
| 185 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 186 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '109')
ORDER BY `qty` ASC | 0.19ms |
| 187 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 188 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('109')) | 0.13ms |
| 189 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (109) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('109')) | 0.36ms |
| 190 | SELECT COUNT(*)
FROM `catalog_product_bundle_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 1
WHERE (cpe.entity_id = '109') AND (required=1) | 0.24ms |
| 191 | SELECT `main_table`.*, `option_value_default`.`title` AS `default_title`, IF(option_value.title IS NOT NULL, option_value.title, option_value_default.title) AS `title`
FROM `catalog_product_bundle_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 1
WHERE (cpe.entity_id = '109')
ORDER BY `main_table`.`position` asc, `main_table`.`option_id` asc | 0.25ms |
| 192 | SELECT (MAX(is_salable) = 1 AND MAX(is_required_and_unsalable) = 0)
FROM (
SELECT `bundle_options`.`required`, MAX(IFNULL(child_status_store.value, child_status_global.value) != 2) AS `is_salable`, IF(required = 1 AND MAX(IFNULL(child_status_store.value, child_status_global.value) != 2) = 0, 1, 0) AS `is_required_and_unsalable`
FROM `catalog_product_entity` AS `parent_products`
INNER JOIN `catalog_product_bundle_option` AS `bundle_options` ON bundle_options.parent_id = parent_products.entity_id
INNER JOIN `catalog_product_bundle_selection` AS `bundle_selections` ON bundle_selections.option_id = bundle_options.option_id
INNER JOIN `catalog_product_entity` AS `child_products` ON child_products.entity_id = bundle_selections.product_id
INNER JOIN `catalog_product_entity_int` AS `child_status_global` ON child_status_global.entity_id = child_products.entity_id AND child_status_global.attribute_id = 97 AND child_status_global.store_id = 0
LEFT JOIN `catalog_product_entity_int` AS `child_status_store` ON child_status_store.entity_id = child_products.entity_id AND child_status_store.attribute_id = 97 AND child_status_store.store_id = 1
WHERE (parent_products.entity_id = 109)
GROUP BY `bundle_options`.`parent_id`, `bundle_options`.`option_id`) AS `t` | 0.54ms |
| 193 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.44ms |
| 194 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.71ms |
| 195 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('90')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.22ms |
| 196 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.16ms |
| 197 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.14ms |
| 198 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 0.92ms |
| 199 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.49ms |
| 200 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('85')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.22ms |
| 201 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.17ms |
| 202 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 0.94ms |
| 203 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 0.95ms |
| 204 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (97)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (97)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (97)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.46ms |
| 205 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('97')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.24ms |
| 206 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.34ms |
| 207 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.19ms |
| 208 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.19ms |
| 209 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.48ms |
| 210 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('86')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 211 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.16ms |
| 212 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)ASC LIMIT 1 | 1.11ms |
| 213 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '90')
ORDER BY `qty` ASC | 0.22ms |
| 214 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '85')
ORDER BY `qty` ASC | 0.18ms |
| 215 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '97')
ORDER BY `qty` ASC | 0.19ms |
| 216 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '86')
ORDER BY `qty` ASC | 0.17ms |
| 217 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 1.54ms |
| 218 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (96)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (96)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (96)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.49ms |
| 219 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('96')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.24ms |
| 220 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.23ms |
| 221 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 1.13ms |
| 222 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 0.93ms |
| 223 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (85)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.47ms |
| 224 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 0.92ms |
| 225 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 0.96ms |
| 226 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (99)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (99)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (99)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.45ms |
| 227 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('99')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.23ms |
| 228 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.16ms |
| 229 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 0.93ms |
| 230 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 1.16ms |
| 231 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (79, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (86)) AND (t_d.attribute_id IN (136)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.49ms |
| 232 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `catalog_rule`.`rule_price` AS `catalog_rule_price`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `catalogrule_product_price` AS `catalog_rule` ON catalog_rule.product_id = `selection`.`product_id` AND catalog_rule.website_id = '1' AND catalog_rule.customer_group_id = 0 AND catalog_rule.rule_date = '2026-02-28'
INNER JOIN `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (LEAST(minimal_price, IFNULL(catalog_rule_price, minimal_price)) * selection.selection_qty)DESC LIMIT 1 | 1.01ms |
| 233 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '96')
ORDER BY `qty` ASC | 0.19ms |
| 234 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '85')
ORDER BY `qty` ASC | 0.19ms |
| 235 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '99')
ORDER BY `qty` ASC | 0.20ms |
| 236 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '86')
ORDER BY `qty` ASC | 0.22ms |
| 237 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.27ms |
| 238 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 1.17ms |
| 239 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 0.93ms |
| 240 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 1.01ms |
| 241 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 1.01ms |
| 242 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 0.85ms |
| 243 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 0.87ms |
| 244 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 0.84ms |
| 245 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)DESC LIMIT 1 | 0.93ms |
| 246 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('109')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.48ms |
| 247 | SELECT COUNT(*)
FROM `catalog_product_bundle_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 1
WHERE (cpe.entity_id = '109') AND (required=1) | 0.23ms |
| 248 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.89ms |
| 249 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.78ms |
| 250 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 1.07ms |
| 251 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (2)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.96ms |
| 252 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.84ms |
| 253 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (3)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.85ms |
| 254 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.79ms |
| 255 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `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`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
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 `cataloginventory_stock_item` AS `stock_item` ON selection.product_id = stock_item.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (4)) AND (selection.parent_product_id = '109') AND (IF(stock_item.use_config_manage_stock = 1, 1, stock_item.manage_stock) = 0 OR (stock_item.is_in_stock = 1 AND (IF(stock_item.use_config_backorders = 1, 0, stock_item.backorders) != 0 OR IF(selection.selection_can_change_qty, IF(stock_item.use_config_min_sale_qty = 1, 1, stock_item.min_sale_qty), selection.selection_qty) <= stock_item.qty)))
ORDER BY (price_index.price * selection.selection_qty)ASC LIMIT 1 | 0.81ms |
| 256 | SELECT `main_table`.`option_id`
FROM `catalog_product_bundle_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.parent_id
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value_default` ON main_table.option_id = option_value_default.option_id AND main_table.parent_id = option_value_default.parent_product_id AND option_value_default.store_id = 0
LEFT JOIN `catalog_product_bundle_option_value` AS `option_value` ON main_table.option_id = option_value.option_id AND main_table.parent_id = option_value.parent_product_id AND option_value.store_id = 1
WHERE (cpe.entity_id = '109') | 0.28ms |
| 257 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1, 2, 3, 4)) AND (selection.parent_product_id = '109') AND (stock_status_index.stock_status = 1)
ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 0.84ms |
| 258 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90, 85, 97, 86, 93, 98, 96, 99)) AND (t_d.attribute_id IN (251, 93, 97, 125, 128, 129, 131, 132, 133, 136, 215, 241)) 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_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90, 85, 97, 86, 93, 98, 96, 99)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90, 85, 97, 86, 93, 98, 96, 99)) AND (t_d.attribute_id IN (76)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90, 85, 97, 86, 93, 98, 96, 99)) AND (t_d.attribute_id IN (77, 78, 123)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (90, 85, 97, 86, 93, 98, 96, 99)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.51ms |
| 259 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('90', '85', '97', '86', '93', '98', '96', '99')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.49ms |
| 260 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.18ms |
| 261 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.33ms |
| 262 | SELECT DISTINCT `e`.*, `selection`.*, IF(price.selection_price_type IS NOT NULL, price.selection_price_type, selection.selection_price_type) AS `selection_price_type`, IF(price.selection_price_value IS NOT NULL, price.selection_price_value, selection.selection_price_value) AS `selection_price_value`, `price`.`parent_product_id`, `price`.`website_id` AS `price_scope`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_bundle_selection` AS `selection` ON selection.product_id = e.entity_id
INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1
LEFT JOIN `catalog_product_bundle_selection_price` AS `price` ON selection.selection_id = price.selection_id AND price.website_id = 1 AND selection.parent_product_id = price.parent_product_id
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (((`e`.`required_options` != 1) OR (`e`.`required_options` IS NULL))) AND (selection.option_id IN (1, 2, 3, 4)) AND (selection.parent_product_id = '109') AND (stock_status_index.stock_status = 1)
ORDER BY `selection`.`position` asc, `selection`.`selection_id` asc | 1.02ms |
| 263 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '90')
ORDER BY `qty` ASC | 0.20ms |
| 264 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('90')) | 0.31ms |
| 265 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (90) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('90')) | 0.21ms |
| 266 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '93')
ORDER BY `qty` ASC | 0.20ms |
| 267 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('93')) | 0.13ms |
| 268 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (93) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('93')) | 0.19ms |
| 269 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '96')
ORDER BY `qty` ASC | 0.18ms |
| 270 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('96')) | 0.11ms |
| 271 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (96) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('96')) | 0.16ms |
| 272 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '85')
ORDER BY `qty` ASC | 0.17ms |
| 273 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('85')) | 0.15ms |
| 274 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (85) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('85')) | 0.38ms |
| 275 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '97')
ORDER BY `qty` ASC | 0.25ms |
| 276 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('97')) | 0.31ms |
| 277 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (97) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('97')) | 0.20ms |
| 278 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '98')
ORDER BY `qty` ASC | 0.17ms |
| 279 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('98')) | 0.12ms |
| 280 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (98) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('98')) | 0.21ms |
| 281 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '99')
ORDER BY `qty` ASC | 0.16ms |
| 282 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('99')) | 0.11ms |
| 283 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (99) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('99')) | 0.17ms |
| 284 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '86')
ORDER BY `qty` ASC | 0.37ms |
| 285 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('86')) | 0.12ms |
| 286 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (86) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('86')) | 0.19ms |
| 287 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id) | 0.33ms |
| 288 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (
SELECT `review_entity`.`entity_id`
FROM `review_entity`
WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (73))
ORDER BY FIELD(e.entity_id,73) | 0.72ms |
| 289 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (73)) AND (t_d.attribute_id IN (251, 93, 97, 125, 128, 129, 131, 132, 133, 136, 215, 241, 83)) 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_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (73)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 121, 124, 135)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (73)) AND (t_d.attribute_id IN (76, 75)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (73)) AND (t_d.attribute_id IN (78, 123)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (73)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.08ms |
| 290 | SELECT `url_rewrite`.*, `relation`.*
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 ('73')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.26ms |
| 291 | SELECT `mageworx_catalog_product_entity_decimal_temp`.*
FROM `mageworx_catalog_product_entity_decimal_temp`
WHERE (customer_group_id = 0) AND (store_id IN('0', '1')) AND (entity_id IN('73')) AND (attribute_id IN ('77', '78')) AND (value IS NOT NULL) AND (value > 0)
ORDER BY `entity_id` ASC, `attribute_id` ASC, `store_id` DESC | 0.29ms |
| 292 | SELECT `customerprices`.*, `product`.`entity_id`
FROM `mageworx_customerprices` AS `customerprices`
LEFT JOIN `catalog_product_entity` AS `product` ON product.entity_id = customerprices.product_id
WHERE (customerprices.customer_id = 0) | 0.17ms |
| 293 | SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (
SELECT `review_entity`.`entity_id`
FROM `review_entity`
WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`
WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (73))
ORDER BY FIELD(e.entity_id,73) LIMIT 12 | 0.40ms |
| 294 | SELECT `e`.`entity_id`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (73)) | 0.32ms |
| 295 | SELECT `e`.*, `link`.*, `product_website`.*, `price`.*, `link`.`product_id`, (price.final_price < price.price) AS `hasSpecialPrice`, `e`.`entity_id` AS `identifier`, `e`.`entity_id`
FROM `catalog_product_entity` AS `e`
LEFT JOIN `catalog_product_super_link` AS `link` ON link.parent_id = e.entity_id
LEFT JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = link.product_id
LEFT JOIN `catalog_product_index_price` AS `price` ON price.entity_id = COALESCE(link.product_id, e.entity_id) AND price.website_id = 1 AND price.customer_group_id = 0
WHERE (e.entity_id IN (73)) | 0.29ms |
| 296 | SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id`
FROM `catalog_product_entity_tier_price`
WHERE (website_id IN(0, '1')) AND (entity_id = '73')
ORDER BY `qty` ASC | 0.23ms |
| 297 | SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
WHERE (entity_id IN('73')) | 0.14ms |
| 298 | SELECT `catalogrule_product_price`.`product_id`, IFNULL(mageworx_catalogrule.rule_price, catalogrule_product_price.rule_price) AS `rule_price`
FROM `catalogrule_product_price`
LEFT JOIN `mageworx_catalogrule_product_price` AS `mageworx_catalogrule` ON mageworx_catalogrule.website_id = 1 AND mageworx_catalogrule.customer_group_id = 0 AND mageworx_catalogrule.product_id IN (73) AND mageworx_catalogrule.customer_id = 0 AND mageworx_catalogrule.rule_date = '2026-02-28'
WHERE (catalogrule_product_price.rule_date = '2026-02-28') AND (catalogrule_product_price.website_id = '1') AND (catalogrule_product_price.customer_group_id = 0) AND (catalogrule_product_price.product_id IN('73')) | 0.24ms |
| 299 | SELECT `mageworx_faq_entity_link`.*
FROM `mageworx_faq_entity_link`
WHERE (entity_type = 'category') AND (entity_id = 3) AND (entity_identifier = '') AND (store_id = 1)
ORDER BY `sort_order` ASC, `link_id` ASC | 0.45ms |
| 300 | SELECT `mageworx_faq_entity_link`.*
FROM `mageworx_faq_entity_link`
WHERE (entity_type = 'category') AND (entity_id = 3) AND (entity_identifier = '') AND (store_id = 0)
ORDER BY `sort_order` ASC, `link_id` ASC | 0.25ms |
| 301 | 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.62ms |
| 302 | 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` = 1)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category')
WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('17', '18', '56', '8'))
ORDER BY `e`.`position` ASC | 0.70ms |
| 303 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) AND (t_d.attribute_id IN (119, 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 = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) 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 = 1
WHERE (e.entity_id IN (8, 17, 18, 56)) AND (t_d.attribute_id IN (54)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 1.06ms |
| 304 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '245') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.32ms |
| 305 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '215') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 306 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '244') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.26ms |
| 307 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '246') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.25ms |
| 308 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '248') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.23ms |
| 309 | 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 = '1'
WHERE (`main_table`.`attribute_id` = '93') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, `value` ASC | 0.45ms |
| 310 | SELECT `main_table`.*
FROM `eav_attribute_option_swatch` AS `main_table`
WHERE (`main_table`.`option_id` IN(44)) | 0.36ms |
| 311 | 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`.`block_id`='4') AND (is_active = 1) AND (cbs.store_id in (1, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.58ms |
| 312 | SELECT `t`.*
FROM `cms_block` AS `t`
WHERE (block_id = '4') | 0.17ms |
| 313 | SELECT `cbs`.`store_id`
FROM `cms_block_store` AS `cbs`
INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id
WHERE (cb.block_id = :block_id) | 0.16ms |
| 314 | 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`.`block_id`='1') AND (is_active = 1) AND (cbs.store_id in (1, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.22ms |
| 315 | SELECT `t`.*
FROM `cms_block` AS `t`
WHERE (block_id = '1') | 0.12ms |
| 316 | SELECT `cbs`.`store_id`
FROM `cms_block_store` AS `cbs`
INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id
WHERE (cb.block_id = :block_id) | 0.16ms |
Info 
Design 
Profile 
Queries 
Logs 
Actions 
