| 0 | connect | 0.47ms |
| 1 | SET NAMES utf8 | 0.16ms |
| 2 | SELECT `store_website`.*
FROM `store_website` | 0.23ms |
| 3 | SELECT `store_group`.*
FROM `store_group` | 0.20ms |
| 4 | SELECT `store`.*
FROM `store` | 0.20ms |
| 5 | SELECT `flag`.*
FROM `flag`
WHERE (`flag`.`flag_code`='config_hash') | 0.20ms |
| 6 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('clothing-trolley-xl-2019', 'clothing-trolley-xl-2019/')) AND (`store_id` IN ('2')) | 0.21ms |
| 7 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`request_path` IN ('catalog/product/view/id/4922', 'catalog/product/view/id/4922/')) AND (`store_id` IN ('2')) | 0.33ms |
| 8 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.request_path IN ('catalog/product/view/id/4922', 'catalog/product/view/id/4922/')) AND (url_rewrite.store_id IN ('2')) AND (relation.category_id IS NULL) | 0.28ms |
| 9 | SELECT `catalog_product_entity`.*
FROM `catalog_product_entity`
WHERE (entity_id =4922) | 0.22ms |
| 10 | SELECT `t`.*
FROM `catalog_product_entity` AS `t`
WHERE (entity_id = 4922) | 0.21ms |
| 11 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_int` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('97', '127', '245', '256', '250', '234', '181', '251', '124', '236', '187', '91', '204', '156', '123', '157', '133', '126', '240', '186', '115', '184', '185', '125', '99', '172', '136', '174', '177', '296', '180', '297', '165', '232', '229', '243', '255', '195', '293', '193', '294', '194', '192', '258', '200', '265', '201', '218', '202', '290', '244', '261', '262', '266', '269', '128', '131')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_text` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('75', '76', '103', '85', '235', '242', '264', '273', '291', '292')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_varchar` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('87', '119', '104', '134', '233', '73', '88', '84', '106', '89', '274', '100', '178', '132', '86', '116', '211', '183', '96', '214', '212', '122', '213', '209', '241', '120', '160', '159', '161', '135', '162', '173', '109', '110', '111', '114', '190', '191', '276', '279', '277', '280', '278', '281', '188', '295', '284', '285', '129', '130')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_decimal` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('78', '81', '77', '92', '237', '121', '238', '239', '98', '82', '206', '207', '208')) AND (`store_id` IN ('2', 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_datetime` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN ('2', 0))) ) AS `u`
ORDER BY `store_id` ASC | 2.62ms |
| 12 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type`
FROM `catalog_product_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 2
LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 2
WHERE (`cpe`.`entity_id` = '4922') AND (default_option_title.store_id = 0)
ORDER BY sort_order ASC, title ASC | 0.45ms |
| 13 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default`
FROM `catalog_product_entity_media_gallery` AS `main`
INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 2 AND value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id
WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '4922')
ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.88ms |
| 14 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.32ms |
| 15 | SELECT `catalog_product_website`.`website_id`
FROM `catalog_product_website`
WHERE (product_id = 4922) | 0.20ms |
| 16 | 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`
FROM `catalog_product_entity_tier_price`
WHERE (website_id = 0) AND (entity_id = '4922')
ORDER BY `qty` ASC | 0.40ms |
| 17 | SELECT `main_table`.*, `cp_table`.`type_id`
FROM `cataloginventory_stock_item` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
WHERE (`main_table`.`product_id` IN('4922')) | 0.52ms |
| 18 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.21ms |
| 19 | SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id`
FROM `cataloginventory_stock_status` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id
WHERE (`main_table`.`product_id` IN('4922')) AND (`main_table`.`website_id` = '0') | 0.27ms |
| 20 | SELECT `catalog_product_website`.`website_id`
FROM `catalog_product_website`
WHERE (product_id = 4922) | 0.20ms |
| 21 | SELECT `catalog_category_product_index_store2`.`product_id`
FROM `catalog_category_product_index_store2`
WHERE (product_id = 4922) AND (category_id = 0) | 0.24ms |
| 22 | SELECT `main_table`.*
FROM `mageplaza_seorule_meta` AS `main_table`
WHERE (`product_id` = '4922') AND (`entity_type` = 'product') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`))))
ORDER BY sort_order ASC | 0.26ms |
| 23 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='4') | 0.20ms |
| 24 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '4') | 0.20ms |
| 25 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.71ms |
| 26 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 27 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='4') | 0.10ms |
| 28 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '4') | 0.10ms |
| 29 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.65ms |
| 30 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 31 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='4') | 0.10ms |
| 32 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '4') | 0.10ms |
| 33 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.63ms |
| 34 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 35 | 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 | 8.43ms |
| 36 | SELECT COUNT(*)
FROM `review` AS `main_table`
INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id
INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id
INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id
WHERE (store.store_id IN('2')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='4922') | 0.47ms |
| 37 | SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price`
FROM `catalogrule_product_price`
WHERE (rule_date = '2023-04-01') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('4922')) | 0.30ms |
| 38 | SELECT `customer_group`.*
FROM `customer_group`
WHERE (`customer_group`.`customer_group_id`=0) | 0.23ms |
| 39 | SELECT `tax_class`.*
FROM `tax_class`
WHERE (`tax_class`.`class_id`='5') | 0.22ms |
| 40 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.48ms |
| 41 | SELECT `customer_group`.*
FROM `customer_group`
WHERE (`customer_group`.`customer_group_id`='1') | 0.11ms |
| 42 | SELECT `tax_class`.*
FROM `tax_class`
WHERE (`tax_class`.`class_id`='5') | 0.10ms |
| 43 | (
SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '90034', '90034*', '9003*', '900*', '90*', '9*'))) UNION (
SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NOT NULL) AND ('90034' BETWEEN rate.zip_from AND rate.zip_to))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.55ms |
| 44 | SELECT `e`.*, `at_product_id`.`product_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id)
WHERE (at_product_id.product_id = '4922') | 0.26ms |
| 45 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (4, 61, 70, 58, 97, 123)) AND (t_d.attribute_id IN ('45')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.31ms |
| 46 | SELECT `catalog_product_entity`.*
FROM `catalog_product_entity`
WHERE (entity_id ='4922') | 0.31ms |
| 47 | SELECT `t`.*
FROM `catalog_product_entity` AS `t`
WHERE (entity_id = '4922') | 0.21ms |
| 48 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_int` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('97', '127', '245', '256', '250', '234', '181', '251', '124', '236', '187', '91', '204', '156', '123', '157', '133', '126', '240', '186', '115', '184', '185', '125', '99', '172', '136', '174', '177', '296', '180', '297', '165', '232', '229', '243', '255', '195', '293', '193', '294', '194', '192', '258', '200', '265', '201', '218', '202', '290', '244', '261', '262', '266', '269', '128', '131')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_text` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('75', '76', '103', '85', '235', '242', '264', '273', '291', '292')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_varchar` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('87', '119', '104', '134', '233', '73', '88', '84', '106', '89', '274', '100', '178', '132', '86', '116', '211', '183', '96', '214', '212', '122', '213', '209', '241', '120', '160', '159', '161', '135', '162', '173', '109', '110', '111', '114', '190', '191', '276', '279', '277', '280', '278', '281', '188', '295', '284', '285', '129', '130')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_decimal` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('78', '81', '77', '92', '237', '121', '238', '239', '98', '82', '206', '207', '208')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_datetime` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 2.08ms |
| 49 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type`
FROM `catalog_product_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 2
LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 2
WHERE (`cpe`.`entity_id` = '4922') AND (default_option_title.store_id = 0)
ORDER BY sort_order ASC, title ASC | 0.40ms |
| 50 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default`
FROM `catalog_product_entity_media_gallery` AS `main`
INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 2 AND value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id
WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '4922')
ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.59ms |
| 51 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.23ms |
| 52 | SELECT `catalog_product_website`.`website_id`
FROM `catalog_product_website`
WHERE (product_id = 4922) | 0.21ms |
| 53 | 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`
FROM `catalog_product_entity_tier_price`
WHERE (website_id = 0) AND (entity_id = '4922')
ORDER BY `qty` ASC | 0.25ms |
| 54 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.22ms |
| 55 | SELECT `eav_attribute`.*
FROM `eav_attribute`
WHERE (`eav_attribute`.`attribute_code`='') AND (entity_type_id = :entity_type_id) | 0.22ms |
| 56 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_id IN ('4922')) AND (url_rewrite.entity_type IN ('product')) AND (url_rewrite.store_id IN (2)) AND (relation.category_id IS NULL) | 0.41ms |
| 57 | SELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code`
FROM `review` AS `main_table`
INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id
INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id
WHERE (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='4922')
ORDER BY main_table.created_at DESC | 0.28ms |
| 58 | SELECT `review_entity_summary`.*
FROM `review_entity_summary`
WHERE (`review_entity_summary`.`entity_pk_value`='4922') AND (store_id = 2) | 0.25ms |
| 59 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`target_path` IN ('catalog/product/view/id/4922')) AND (`store_id` IN ('2')) | 0.20ms |
| 60 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_type` IN ('product')) AND (`entity_id` IN ('4922')) AND (`store_id` IN ('2')) AND (`is_autogenerated` IN (1)) | 0.27ms |
| 61 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_type` IN ('product')) AND (`entity_id` IN ('4922')) AND (`store_id` IN ('1')) AND (`is_autogenerated` IN (1)) | 0.23ms |
| 62 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('4922')) AND (url_rewrite.store_id IN ('1')) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.26ms |
| 63 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = :entity_id) | 0.25ms |
| 64 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.18ms |
| 65 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2)
ORDER BY `catalog_category_entity`.`position` ASC | 0.29ms |
| 66 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.58ms |
| 67 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') | 0.94ms |
| 68 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (3, 4, 8, 14, 15, 48, 61, 62, 63, 64, 107, 128, 129)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.55ms |
| 69 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = :entity_id) | 0.19ms |
| 70 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`entity_id` = '2') | 0.14ms |
| 71 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (`catalog_category_entity`.`path` LIKE '1/2/%') AND (`catalog_category_entity`.`level` <= 2)
ORDER BY `catalog_category_entity`.`position` ASC | 0.25ms |
| 72 | SELECT `e`.`entity_id`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `d` ON e.entity_id = d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond) | 0.55ms |
| 73 | SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 2)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 2 AND url_rewrite.entity_type = 'category')
WHERE (`e`.`entity_id` IN('3', '4', '7', '62', '63', '8', '61', '13', '14', '15', '48', '105', '107', '128', '64', '129', '123', '106', '121', '52', '49', '55', '114', '118', '119')) AND (`e`.`entity_id` NOT IN('7', '13', '105', '123', '106', '121', '49', '118')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
ORDER BY `name` ASC | 0.88ms |
| 74 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (62, 14, 8, 3, 4, 61, 15, 63, 128, 48, 64, 129, 107)) AND (t_d.attribute_id IN ('117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.37ms |
| 75 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='porto_custom_menu_before') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.31ms |
| 76 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='3') | 0.14ms |
| 77 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '3') | 0.14ms |
| 78 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '3') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.74ms |
| 79 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '3') LIMIT 1 | 0.13ms |
| 80 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='4') | 0.13ms |
| 81 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '4') | 0.14ms |
| 82 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '4') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.67ms |
| 83 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '4') LIMIT 1 | 0.10ms |
| 84 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='62') | 0.11ms |
| 85 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '62') | 0.11ms |
| 86 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '62') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.66ms |
| 87 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '62') LIMIT 1 | 0.10ms |
| 88 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='63') | 0.10ms |
| 89 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '63') | 0.11ms |
| 90 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '63') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.68ms |
| 91 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '63') LIMIT 1 | 0.10ms |
| 92 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='8') | 0.10ms |
| 93 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '8') | 0.10ms |
| 94 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '8') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.67ms |
| 95 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '8') LIMIT 1 | 0.19ms |
| 96 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='61') | 0.20ms |
| 97 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '61') | 0.20ms |
| 98 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '61') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.69ms |
| 99 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '61') LIMIT 1 | 0.19ms |
| 100 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('61')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.20ms |
| 101 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='14') | 0.20ms |
| 102 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '14') | 0.10ms |
| 103 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '14') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.64ms |
| 104 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '14') LIMIT 1 | 0.10ms |
| 105 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='15') | 0.11ms |
| 106 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '15') | 0.10ms |
| 107 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '15') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.64ms |
| 108 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '15') LIMIT 1 | 0.19ms |
| 109 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='48') | 0.20ms |
| 110 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '48') | 0.20ms |
| 111 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '48') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.64ms |
| 112 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '48') LIMIT 1 | 0.19ms |
| 113 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='107') | 0.14ms |
| 114 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '107') | 0.20ms |
| 115 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '107') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.65ms |
| 116 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '107') LIMIT 1 | 0.10ms |
| 117 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='128') | 0.11ms |
| 118 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '128') | 0.11ms |
| 119 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '128') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.60ms |
| 120 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '128') LIMIT 1 | 0.19ms |
| 121 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='64') | 0.20ms |
| 122 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '64') | 0.20ms |
| 123 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '64') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.61ms |
| 124 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '64') LIMIT 1 | 0.19ms |
| 125 | SELECT `catalog_category_entity`.*
FROM `catalog_category_entity`
WHERE (entity_id ='129') | 0.20ms |
| 126 | SELECT `t`.*
FROM `catalog_category_entity` AS `t`
WHERE (entity_id = '129') | 0.20ms |
| 127 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_varchar` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('45', '117', '48', '215', '49', '52', '60', '118', '138', '152', '139', '153', '140', '154', '63', '68', '141', '275', '142', '143', '144', '146', '148')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_int` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('46', '70', '71', '69', '137', '151', '196', '53', '197', '54', '210')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_text` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('47', '50', '51', '57', '58', '59', '67', '155', '64', '145', '257', '147', '149', '150')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_datetime` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('61', '62')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_category_entity_decimal` AS `t`
WHERE (entity_id = '129') AND (attribute_id IN ('72')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 0.61ms |
| 128 | SELECT `catalog_category_entity`.`entity_id`
FROM `catalog_category_entity`
WHERE (entity_id = '129') LIMIT 1 | 0.10ms |
| 129 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='porto_custom_menu') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.24ms |
| 130 | SELECT `main_table`.*
FROM `tax_class` AS `main_table`
WHERE (`main_table`.`class_type` = 'PRODUCT') | 0.25ms |
| 131 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('2')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.50ms |
| 132 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('3')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.44ms |
| 133 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('4')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.43ms |
| 134 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('8')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.40ms |
| 135 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('9')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.39ms |
| 136 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('10')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.39ms |
| 137 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('11')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.38ms |
| 138 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('12')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.37ms |
| 139 | SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title`
FROM `tax_calculation` AS `main_table`
INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '2'
WHERE (customer_tax_class_id = 5) AND (product_tax_class_id IN ('13')) AND (rate.tax_country_id = 'US') AND (rate.tax_region_id IN(0, 64)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', 'w226s8100', 'w226s8100*', 'w226s810*', 'w226s81*', 'w226s8*', 'w226s*', 'w226*', 'w22*', 'w2*', 'w*'))
ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC | 0.30ms |
| 140 | SELECT COUNT(*)
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id)
WHERE (at_product_id.product_id = '4922') AND (`e`.`path` LIKE '1/2/%') | 0.25ms |
| 141 | SELECT `e`.*, `at_product_id`.`product_id`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id)
WHERE (at_product_id.product_id = '4922') AND (`e`.`path` LIKE '1/2/%')
ORDER BY `e`.`level` DESC LIMIT 1 | 0.26ms |
| 142 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (70)) AND (t_d.attribute_id IN ('45')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.29ms |
| 143 | SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`
FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 2)
WHERE (`e`.`entity_id` IN('4', '70')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') | 0.30ms |
| 144 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (4, 70)) AND (t_d.attribute_id IN ('45', '117')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 0.31ms |
| 145 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.23ms |
| 146 | SELECT `url_rewrite`.*
FROM `url_rewrite`
WHERE (`entity_id` IN ('70')) AND (`entity_type` IN ('category')) AND (`store_id` IN (2)) | 0.23ms |
| 147 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (`main_table`.`option_id` IN('29')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.32ms |
| 148 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (`main_table`.`option_id` IN('7')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.30ms |
| 149 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '156') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.57ms |
| 150 | Select *
FROM eav_attribute_option_swatch where option_id = 140 | 0.21ms |
| 151 | Select *
FROM eav_attribute_option_swatch where option_id = 144 | 0.20ms |
| 152 | Select *
FROM eav_attribute_option_swatch where option_id = 149 | 0.20ms |
| 153 | Select *
FROM eav_attribute_option_swatch where option_id = 178 | 0.11ms |
| 154 | Select *
FROM eav_attribute_option_swatch where option_id = 181 | 0.11ms |
| 155 | Select *
FROM eav_attribute_option_swatch where option_id = 154 | 0.11ms |
| 156 | Select *
FROM eav_attribute_option_swatch where option_id = 183 | 0.11ms |
| 157 | Select *
FROM eav_attribute_option_swatch where option_id = 139 | 0.06ms |
| 158 | Select *
FROM eav_attribute_option_swatch where option_id = 153 | 0.11ms |
| 159 | Select *
FROM eav_attribute_option_swatch where option_id = 159 | 0.06ms |
| 160 | Select *
FROM eav_attribute_option_swatch where option_id = 141 | 0.06ms |
| 161 | Select *
FROM eav_attribute_option_swatch where option_id = 145 | 0.09ms |
| 162 | Select *
FROM eav_attribute_option_swatch where option_id = 138 | 0.09ms |
| 163 | Select *
FROM eav_attribute_option_swatch where option_id = 182 | 0.06ms |
| 164 | Select *
FROM eav_attribute_option_swatch where option_id = 5 | 0.06ms |
| 165 | Select *
FROM eav_attribute_option_swatch where option_id = 4 | 0.05ms |
| 166 | Select *
FROM eav_attribute_option_swatch where option_id = 25 | 0.05ms |
| 167 | Select *
FROM eav_attribute_option_swatch where option_id = 24 | 0.05ms |
| 168 | Select *
FROM eav_attribute_option_swatch where option_id = 26 | 0.05ms |
| 169 | Select *
FROM eav_attribute_option_swatch where option_id = 27 | 0.05ms |
| 170 | Select *
FROM eav_attribute_option_swatch where option_id = 28 | 0.05ms |
| 171 | Select *
FROM eav_attribute_option_swatch where option_id = 29 | 0.05ms |
| 172 | Select *
FROM eav_attribute_option_swatch where option_id = 30 | 0.05ms |
| 173 | Select *
FROM eav_attribute_option_swatch where option_id = 34 | 0.05ms |
| 174 | Select *
FROM eav_attribute_option_swatch where option_id = 79 | 0.05ms |
| 175 | Select *
FROM eav_attribute_option_swatch where option_id = 80 | 0.05ms |
| 176 | Select *
FROM eav_attribute_option_swatch where option_id = 300 | 0.05ms |
| 177 | Select *
FROM eav_attribute_option_swatch where option_id = 309 | 0.05ms |
| 178 | Select *
FROM eav_attribute_option_swatch where option_id = 310 | 0.05ms |
| 179 | Select *
FROM eav_attribute_option_swatch where option_id = 360 | 0.05ms |
| 180 | Select *
FROM eav_attribute_option_swatch where option_id = 361 | 0.05ms |
| 181 | Select *
FROM eav_attribute_option_swatch where option_id = 362 | 0.05ms |
| 182 | Select *
FROM eav_attribute_option_swatch where option_id = 186 | 0.05ms |
| 183 | Select *
FROM eav_attribute_option_swatch where option_id = 406 | 0.05ms |
| 184 | Select *
FROM eav_attribute_option_swatch where option_id = 470 | 0.05ms |
| 185 | Select *
FROM eav_attribute_option_swatch where option_id = 471 | 0.05ms |
| 186 | Select *
FROM eav_attribute_option_swatch where option_id = 472 | 0.05ms |
| 187 | Select *
FROM eav_attribute_option_swatch where option_id = 473 | 0.05ms |
| 188 | Select *
FROM eav_attribute_option_swatch where option_id = 474 | 0.05ms |
| 189 | Select *
FROM eav_attribute_option_swatch where option_id = 475 | 0.05ms |
| 190 | Select *
FROM eav_attribute_option_swatch where option_id = 476 | 0.05ms |
| 191 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '157') AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.24ms |
| 192 | Select *
FROM eav_attribute_option_swatch where option_id = 157 | 0.07ms |
| 193 | Select *
FROM eav_attribute_option_swatch where option_id = 172 | 0.11ms |
| 194 | Select *
FROM eav_attribute_option_swatch where option_id = 179 | 0.11ms |
| 195 | Select *
FROM eav_attribute_option_swatch where option_id = 7 | 0.18ms |
| 196 | Select *
FROM eav_attribute_option_swatch where option_id = 151 | 0.18ms |
| 197 | Select *
FROM eav_attribute_option_swatch where option_id = 184 | 0.16ms |
| 198 | Select *
FROM eav_attribute_option_swatch where option_id = 163 | 0.09ms |
| 199 | Select *
FROM eav_attribute_option_swatch where option_id = 176 | 0.08ms |
| 200 | Select *
FROM eav_attribute_option_swatch where option_id = 155 | 0.08ms |
| 201 | Select *
FROM eav_attribute_option_swatch where option_id = 6 | 0.06ms |
| 202 | Select *
FROM eav_attribute_option_swatch where option_id = 168 | 0.06ms |
| 203 | Select *
FROM eav_attribute_option_swatch where option_id = 170 | 0.05ms |
| 204 | Select *
FROM eav_attribute_option_swatch where option_id = 174 | 0.05ms |
| 205 | Select *
FROM eav_attribute_option_swatch where option_id = 31 | 0.06ms |
| 206 | Select *
FROM eav_attribute_option_swatch where option_id = 32 | 0.05ms |
| 207 | Select *
FROM eav_attribute_option_swatch where option_id = 33 | 0.05ms |
| 208 | Select *
FROM eav_attribute_option_swatch where option_id = 89 | 0.05ms |
| 209 | Select *
FROM eav_attribute_option_swatch where option_id = 90 | 0.05ms |
| 210 | Select *
FROM eav_attribute_option_swatch where option_id = 418 | 0.05ms |
| 211 | SELECT `e`.`entity_id`
FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id
WHERE (l.product_id IN('4922')) | 0.23ms |
| 212 | SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required`
FROM `catalog_product_bundle_selection` AS `tbl_selection`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0
INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id
INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id
WHERE (parent.entity_id = :parent_id) | 0.46ms |
| 213 | SELECT `main_table`.*
FROM `mageplaza_seocrosslinks_term` AS `main_table`
WHERE (`status` = '1') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`)))) AND (FIND_IN_SET(0, `apply_for`))
ORDER BY sort_order ASC | 0.31ms |
| 214 | SELECT `main_table`.*
FROM `mageplaza_seocrosslinks_term` AS `main_table`
WHERE (`status` = '1') AND (((FIND_IN_SET(0, `stores`)) OR (FIND_IN_SET('2', `stores`)))) AND (FIND_IN_SET(0, `apply_for`))
ORDER BY sort_order ASC | 0.22ms |
| 215 | SELECT `catalog_product_entity`.*
FROM `catalog_product_entity`
WHERE (entity_id ='4922') | 0.17ms |
| 216 | SELECT `t`.*
FROM `catalog_product_entity` AS `t`
WHERE (entity_id = '4922') | 0.19ms |
| 217 | SELECT `u`.*
FROM ( (
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_int` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('97', '127', '245', '256', '250', '234', '181', '251', '124', '236', '187', '91', '204', '156', '123', '157', '133', '126', '240', '186', '115', '184', '185', '125', '99', '172', '136', '174', '177', '296', '180', '297', '165', '232', '229', '243', '255', '195', '293', '193', '294', '194', '192', '258', '200', '265', '201', '218', '202', '290', '244', '261', '262', '266', '269', '128', '131')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_text` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('75', '76', '103', '85', '235', '242', '264', '273', '291', '292')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_varchar` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('87', '119', '104', '134', '233', '73', '88', '84', '106', '89', '274', '100', '178', '132', '86', '116', '211', '183', '96', '214', '212', '122', '213', '209', '241', '120', '160', '159', '161', '135', '162', '173', '109', '110', '111', '114', '190', '191', '276', '279', '277', '280', '278', '281', '188', '295', '284', '285', '129', '130')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_decimal` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('78', '81', '77', '92', '237', '121', '238', '239', '98', '82', '206', '207', '208')) AND (`store_id` IN (2, 0)))
UNION ALL(
SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id`
FROM `catalog_product_entity_datetime` AS `t`
WHERE (entity_id = '4922') AND (attribute_id IN ('101', '79', '102', '80', '94', '95')) AND (`store_id` IN (2, 0))) ) AS `u`
ORDER BY `store_id` ASC | 1.81ms |
| 218 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type`
FROM `catalog_product_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 2
LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 2
WHERE (`cpe`.`entity_id` = '4922') AND (default_option_title.store_id = 0)
ORDER BY sort_order ASC, title ASC | 0.28ms |
| 219 | SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`entity_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default`, IFNULL(`value_video`.`provider`, `default_value_video`.`provider`) AS `video_provider`, IFNULL(`value_video`.`url`, `default_value_video`.`url`) AS `video_url`, IFNULL(`value_video`.`title`, `default_value_video`.`title`) AS `video_title`, IFNULL(`value_video`.`description`, `default_value_video`.`description`) AS `video_description`, IFNULL(`value_video`.`metadata`, `default_value_video`.`metadata`) AS `video_metadata`, `default_value_video`.`provider` AS `video_provider_default`, `default_value_video`.`url` AS `video_url_default`, `default_value_video`.`title` AS `video_title_default`, `default_value_video`.`description` AS `video_description_default`, `default_value_video`.`metadata` AS `video_metadata_default`
FROM `catalog_product_entity_media_gallery` AS `main`
INNER JOIN `catalog_product_entity_media_gallery_value_to_entity` AS `entity` ON main.value_id = entity.value_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 2 AND value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 AND default_value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `value_video` ON value.value_id = value_video.value_id AND value.store_id = value_video.store_id
LEFT JOIN `catalog_product_entity_media_gallery_value_video` AS `default_value_video` ON default_value.value_id = default_value_video.value_id AND default_value.store_id = default_value_video.store_id
WHERE (main.attribute_id = '90') AND (main.disabled = 0) AND (entity.entity_id = '4922')
ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC | 0.53ms |
| 220 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.21ms |
| 221 | SELECT `catalog_product_website`.`website_id`
FROM `catalog_product_website`
WHERE (product_id = 4922) | 0.20ms |
| 222 | 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`
FROM `catalog_product_entity_tier_price`
WHERE (website_id = 0) AND (entity_id = '4922')
ORDER BY `qty` ASC | 0.22ms |
| 223 | SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position`
FROM `catalog_category_product`
WHERE (product_id = 4922) | 0.19ms |
| 224 | SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value`
FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2'
WHERE (`main_table`.`attribute_id` = '183') AND (`main_table`.`option_id` IN('95')) AND (tdv.store_id = 0)
ORDER BY main_table.sort_order ASC, value ASC | 0.29ms |
| 225 | SELECT `cms_block`.`block_id`
FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id
WHERE (`cms_block`.`identifier`='material_D') AND (is_active = 1) AND (cbs.store_id in (2, 0))
ORDER BY `store_id` DESC LIMIT 1 | 0.33ms |
| 226 | SELECT `t`.*
FROM `cms_block` AS `t`
WHERE (block_id = '164') | 0.18ms |
| 227 | 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.23ms |
| 228 | SELECT `main_table`.*, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id`, `review_entity`.`entity_code`
FROM `review` AS `main_table`
INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id
INNER JOIN `review_store` AS `store` ON main_table.review_id=store.review_id
INNER JOIN `review_entity` ON main_table.entity_id=review_entity.entity_id
WHERE (store.store_id IN('2')) AND (main_table.status_id=1) AND (review_entity.entity_code='product') AND (main_table.entity_pk_value='4922')
ORDER BY main_table.created_at DESC | 0.30ms |
| 229 | SELECT `review_entity_summary`.*
FROM `review_entity_summary`
WHERE (`review_entity_summary`.`entity_pk_value`='4922') AND (store_id = 2) | 0.21ms |
| 230 | SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type`
FROM `catalog_product_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 2
LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 2
WHERE (`product_id` = '4922') AND (default_option_title.store_id = 0)
ORDER BY sort_order ASC, title ASC | 0.35ms |
| 231 | SELECT COUNT(*)
FROM `catalog_product_option` AS `main_table`
INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = main_table.product_id
INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id
LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = 2
LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0
LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = 2
WHERE (`product_id` = '4922') AND (default_option_title.store_id = 0) | 0.26ms |
| 232 | SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type`
FROM `catalog_product_link_attribute`
WHERE (link_type_id = 4) | 0.25ms |
| 233 | 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`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4
LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '2'
INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id
WHERE (links.product_id in ('4922')) AND (`e`.`entity_id` != '4922')
ORDER BY `position` ASC | 0.70ms |
| 234 | SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5343)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '132', '135', '159', '160', '161', '162', '173', '176', '209', '233', '241', '284', '285')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5343)) AND (t_d.attribute_id IN ('76', '235', '242', '273')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5343)) AND (t_d.attribute_id IN ('78', '121', '237', '238', '239')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5343)) AND (t_d.attribute_id IN ('79', '80', '94', '95')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
UNION ALL
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2
WHERE (e.entity_id IN (5343)) AND (t_d.attribute_id IN ('97', '123', '125', '126', '127', '128', '131', '133', '136', '156', '157', '165', '174', '177', '180', '186', '187', '202', '204', '218', '234', '236', '240', '250', '256', '259', '262', '266', '290')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 2.75ms |
| 235 | SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id`
FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id
WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('5343')) AND (url_rewrite.store_id IN (2)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL) | 0.29ms |
| 236 | SELECT DISTINCT `e`.`entity_id` AS `parent_product_id`
FROM `catalog_product_bundle_selection`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = catalog_product_bundle_selection.parent_product_id
WHERE (catalog_product_bundle_selection.product_id IN('4922')) | 0.23ms |
| 237 | SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type`
FROM `catalog_product_link_attribute`
WHERE (link_type_id = 1) | 0.21ms |
| 238 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position`
FROM `catalog_product_entity` AS `e`
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1
LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1'
INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id
WHERE (links.product_id in (4922)) AND (`e`.`entity_id` != 4922) | 0.30ms |
| 239 | SELECT `catalog_product_link_attribute`.`product_link_attribute_id` AS `id`, `catalog_product_link_attribute`.`product_link_attribute_code` AS `code`, `catalog_product_link_attribute`.`data_type` AS `type`
FROM `catalog_product_link_attribute`
WHERE (link_type_id = 5) | 0.20ms |
| 240 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position`
FROM `catalog_product_entity` AS `e`
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 5
LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '3'
INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id
WHERE (links.product_id in (4922)) AND (`e`.`entity_id` != 4922) | 0.28ms |
| 241 | SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id`, `links`.`product_id` AS `_linked_to_product_id`, `link_attribute_position_int`.`value` AS `position`
FROM `catalog_product_entity` AS `e`
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4
LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '2'
INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id
WHERE (links.product_id in (4922)) AND (`e`.`entity_id` != 4922) | 0.34ms |
Info 
Design 
Profile 
Queries 
Logs 
Actions 
