string(45) "SELECT `store_website`.* FROM `store_website`"
string(41) "SELECT `store_group`.* FROM `store_group`"
string(29) "SELECT `store`.* FROM `store`"
string(68) "SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`='config_hash')"
string(249) "SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('mini-mechanical-parts/mini-cooling-and-heating/classic-mini-radiator.html', 'mini-mechanical-parts/mini-cooling-and-heating/classic-mini-radiator.html/')) AND (`store_id` IN ('1'))"
string(157) "SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('catalog/category/view/id/94', 'catalog/category/view/id/94/')) AND (`store_id` IN ('1'))"
string(383) "SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `url_rewrite`
LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('catalog/category/view/id/94', 'catalog/category/view/id/94/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)"
string(87) "SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id =94)"
string(73) "SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = 94)"
string(1093) "SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (41, 43, 45, 46, 132, 49, 58, 57, 61, 66, 271)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (42, 68, 69, 67, 50, 51)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (59, 60)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (70)) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC
"
string(108) "SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '94') LIMIT 1"
string(1144) "SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `catalog_category_entity` AS `e`
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '68') AND `at_custom_use_parent_settings_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '68') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('94', '10', '56', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC
"
string(2258) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (94, 10, 56, 2)) AND (t_d.attribute_id IN (58, 61, 271)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (94, 10, 56, 2)) AND (t_d.attribute_id IN (59, 60)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (94, 10, 56, 2)) AND (t_d.attribute_id IN (62)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (94, 10, 56, 2)) AND (t_d.attribute_id IN (69)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(419) "SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)"
string(419) "SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)"
string(310) "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
"
string(122) "SELECT `main_table`.* FROM `swissup_easybanner_placeholder` AS `main_table` WHERE (`status` = '1') AND (`container` != '')"
string(928) "SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY position ASC
"
string(144) "SELECT `swissup_navigationpro_menu`.* FROM `swissup_navigationpro_menu` WHERE (`swissup_navigationpro_menu`.`identifier`='shop-all-departments')"
string(199) "SELECT `main_table`.* FROM `swissup_navigationpro_item` AS `main_table` WHERE (`menu_id` = '3') AND (`is_active` = '1') AND (`level` < 6) ORDER BY level ASC, position ASC, parent_id ASC, item_id ASC
"
string(374) "SELECT `e`.*, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (`e`.`path` LIKE '1/2/%') ORDER BY `e`.`level` ASC, `e`.`position` ASC, `e`.`parent_id` ASC, `e`.`entity_id` ASC
"
string(685) "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` = '42') 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` = '42') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('56', '10', '94')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1')"
string(557) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d`
INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10, 56, 94)) AND (t_d.attribute_id IN (41, 43)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(131) "SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('56')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))"
string(131) "SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))"
string(131) "SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`entity_id` IN ('94')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))"
string(928) "SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY position ASC
"
string(431) "SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
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'"
string(639) "SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price ) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price ) * 1, 2)) AS `std` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
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' WHERE (price_index.min_price IS NOT NULL)"
string(197) "SELECT `l`.`attribute_id`, `l`.`store_id`, `l`.`value`, `eav`.`attribute_code` FROM `swissup_seourls_attribute_label` AS `l`
LEFT JOIN `eav_attribute` AS `eav` ON eav.attribute_id = l.attribute_id"
string(203) "SELECT `v`.* FROM `swissup_seourls_attribute_value` AS `v` WHERE (attribute_id IN ('75', '76', '81', '260', '261', '273', '277', '195')) ORDER BY `attribute_id` ASC, `original_value` ASC, `store_id` ASC
"
string(139) "SELECT `a`.* FROM `swissup_seourls_attribute_advanced` AS `a` WHERE (attribute_id IN ('75', '76', '81', '260', '261', '273', '277', '195'))"
string(89) "SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='94')"
string(75) "SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '94')"
string(1093) "SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (41, 43, 45, 46, 132, 49, 58, 57, 61, 66, 271)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (42, 68, 69, 67, 50, 51)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (59, 60)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (70)) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC
"
string(108) "SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '94') LIMIT 1"
string(89) "SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id ='94')"
string(75) "SELECT `t`.* FROM `catalog_category_entity` AS `t` WHERE (entity_id = '94')"
string(1093) "SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (41, 43, 45, 46, 132, 49, 58, 57, 61, 66, 271)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_int` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (42, 68, 69, 67, 50, 51)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_text` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (44, 47, 48, 54, 55, 56, 65, 62)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_datetime` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (59, 60)) AND (`store_id` IN ('1', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_decimal` AS `t` WHERE (entity_id = '94') AND (attribute_id IN (70)) AND (`store_id` IN ('1', 0))) ) AS `u` ORDER BY `store_id` ASC
"
string(108) "SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '94') LIMIT 1"
string(257) "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`='header_cms_links') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(242) "SELECT `cms_block`.`block_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`='146') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(242) "SELECT `cms_block`.`block_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`='147') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(61) "SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '147')"
string(149) "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)"
string(14) "SET NAMES utf8"
string(19) "SET NAMES 'utf8mb4'"
string(91) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='template') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(101) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='fishpig-theme-hash') LIMIT 1"
string(87) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='home') LIMIT 1"
string(102) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='permalink_structure') LIMIT 1"
string(90) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='siteurl') LIMIT 1"
string(102) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='permalink_structure') LIMIT 1"
string(97) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='active_plugins') LIMIT 1"
string(130) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='elementor_experiment-e_optimized_assets_loading') LIMIT 1"
string(106) "SELECT `wp_options`.`option_value` FROM `wp_options` WHERE (option_name='_fp_rp_magento_base_url') LIMIT 1"
string(94) "SELECT `wp_related_categories`.`post_id` FROM `wp_related_categories` WHERE (category_id='94')"
string(254) "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`='brands_slider') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(61) "SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '144')"
string(149) "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)"
string(256) "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`='footer_contacts') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(61) "SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '255')"
string(149) "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)"
string(259) "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`='footer_cms_content') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(61) "SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '135')"
string(149) "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)"
string(256) "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`='footer_payments') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(61) "SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = '136')"
string(149) "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)"
string(258) "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`='argento_scroll_up') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC
LIMIT 1"
string(70) "SELECT `main_table`.* FROM `swissup_gdpr_cookie_group` AS `main_table`"
string(64) "SELECT `main_table`.* FROM `swissup_gdpr_cookie` AS `main_table`"
string(4000) "SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) AS `special_from_date`, IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) AS `special_to_date`, IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) AS `special_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '77') AND `at_special_from_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '77') AND (`at_special_from_date`.`store_id` = 1)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date_default` ON (`at_special_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date_default`.`attribute_id` = '78') AND `at_special_to_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '78') AND (`at_special_to_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_decimal` AS `at_special_price_default` ON (`at_special_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_price_default`.`attribute_id` = '76') AND `at_special_price_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 1)
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
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 WHERE (((((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) <= '2023-06-08 23:59:59') OR (IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS NULL))))) AND (((((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2023-06-08 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NULL))))) AND ((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS NOT NULL) OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NOT NULL)) AND (IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) > 0) ORDER BY RAND(), `e`.`entity_id` DESC
LIMIT 8"
string(3118) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6073, 6605, 4424, 10253, 11270, 6067, 6049, 1762)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6073, 6605, 4424, 10253, 11270, 6067, 6049, 1762)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6073, 6605, 4424, 10253, 11270, 6067, 6049, 1762)) AND (t_d.attribute_id IN (79, 120, 138, 141, 142, 155)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6073, 6605, 4424, 10253, 11270, 6067, 6049, 1762)) AND (t_d.attribute_id IN (93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6073, 6605, 4424, 10253, 11270, 6067, 6049, 1762)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(468) "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 ('6073', '6605', '4424', '10253', '11270', '6067', '6049', '1762')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(2284) "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 = 1 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 = '88') AND (main.disabled = 0) AND (entity.entity_id in ('6073', '6605', '4424', '10253', '11270', '6067', '6049', '1762')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
"
string(729) "SELECT `i`.`entity_id`, `l`.`sort_order`, `l`.`category_position` AS `position`, `l`.`category_text` AS `text`, `l`.`category_custom_style` AS `custom`, `l`.`category_custom_url` AS `custom_url`, `l`.`category_round_method` AS `round_method`, `l`.`category_round_value` AS `round_value`, `l`.`category_image` AS `image`, `l`.`category_target_element` AS `target_element`, `l`.`category_insert_method` AS `insert_method` FROM `swissup_prolabels_index` AS `i`
LEFT JOIN `swissup_prolabels_label` AS `l` ON l.label_id = i.label_id WHERE (entity_id IN ('6073', '6605', '4424', '10253', '11270', '6067', '6049', '1762')) AND (status = '1') AND (store_id LIKE '%\"0\"%' OR store_id LIKE '%\"1\"%') AND (customer_groups LIKE '%\"0\"%')"
Cooling Radiators for all Classic Mini models Mini Sport
string(192) "SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to IN('GBP', 'EUR', 'USD'))"
string(192) "SELECT `directory_currency_rate`.`currency_to`, `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to IN('GBP', 'EUR', 'USD'))"
string(151) "SELECT `swissup_easybanner_placeholder`.* FROM `swissup_easybanner_placeholder` WHERE (`swissup_easybanner_placeholder`.`name`='minisport_content_top')"
string(149) "SELECT `swissup_easybanner_placeholder_offset`.* FROM `swissup_easybanner_placeholder_offset` WHERE (placeholder_id='12') ORDER BY `id` DESC
LIMIT 1"
string(270) "SELECT `main_table`.*, `placeholder`.* FROM `swissup_easybanner_banner` AS `main_table`
INNER JOIN `swissup_easybanner_banner_placeholder` AS `placeholder` ON placeholder.banner_id=main_table.banner_id and placeholder.placeholder_id=12 WHERE (status = 1) AND (type = 1)"
string(121) "SELECT `banner_store`.* FROM `swissup_easybanner_banner_store` AS `banner_store` WHERE (banner_store.banner_id IN ('87'))"
string(145) "SELECT `banner_placeholder`.* FROM `swissup_easybanner_banner_placeholder` AS `banner_placeholder` WHERE (banner_placeholder.banner_id IN ('87'))"
string(203) "SELECT `bs`.`banner_id`, SUM(`display_count`) AS `display_count`, SUM(`clicks_count`) AS `clicks_count` FROM `swissup_easybanner_banner_statistic` AS `bs` WHERE (banner_id IN ('87')) GROUP BY `banner_id`"
Here at Mini Sport, we stock a selection of Classic Mini Radiators suitable for all Classic Mini models from 1959 - 2001 for road, race, rally and auto-test applications. Our range of covers standard radiators for all carburetor, SPi and MPi Mini’s, 2 core and 4 core high-flow uprated radiators and high efficiency aluminium radiators for the ultimate in cooling performance. Whatever your Mini's cooling system needs Mini Sport has the answer.
For more information and advice get in touch with a member of our experienced team on 01282 778731 or contact us by e-mail sales@minisport.com
string(975) "SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') 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` = '42') AND (`at_is_active`.`store_id` = 1)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (e.path LIKE '1/2/56/10/94/%') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`level` '4') ORDER BY `e`.`level` ASC, `e`.`position` ASC
"
string(136) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='position') AND (entity_type_id = :entity_type_id)"
string(140) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)"
string(117) "SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(135) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='lhd_rhd') AND (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(150) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='hydrolastic_suspension') AND (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(139) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='clutch_type') AND (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(139) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='body_panels') AND (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(150) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='swissup_rating_summary') AND (entity_type_id = :entity_type_id)"
string(98) "SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)"
string(142) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='swissup_is_new') AND (entity_type_id = :entity_type_id)"
string(143) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='swissup_on-sale') AND (entity_type_id = :entity_type_id)"
string(141) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='swissup_stock') AND (entity_type_id = :entity_type_id)"
string(611) "SELECT `e`.`entity_id`, `stockItem`.`stock_status` AS `is_salable`, `cat_index`.`position` FROM `catalog_product_entity` AS `e`
INNER JOIN `cataloginventory_stock_status` AS `stockItem` ON stockItem.product_id = e.entity_id AND stockItem.website_id = 0 AND stockItem.stock_id = 1
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id = e.entity_id AND cat_index.category_id = 94 AND cat_index.store_id = 1 WHERE (e.entity_id IN('5392', '1209', '1485', '1486', '1487', '1488', '6350', '2470', '2471', '9324')) ORDER BY is_salable DESC, position ASC, entity_id DESC
LIMIT 12"
string(1302) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
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 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) ORDER BY FIELD(e.entity_id,6350,5392,2471,2470,1488,1487,1486,1485,1209,9324)
"
string(3180) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) AND (t_d.attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6350, 5392, 2471, 2470, 1488, 1487, 1486, 1485, 1209, 9324)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(482) "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 ('6350', '5392', '2471', '2470', '1488', '1487', '1486', '1485', '1209', '9324')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(2298) "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 = 1 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 = '88') AND (main.disabled = 0) AND (entity.entity_id in ('6350', '5392', '2471', '2470', '1488', '1487', '1486', '1485', '1209', '9324')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
"
string(101) "SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (frontend_input = :frontend_input)"
string(743) "SELECT `i`.`entity_id`, `l`.`sort_order`, `l`.`category_position` AS `position`, `l`.`category_text` AS `text`, `l`.`category_custom_style` AS `custom`, `l`.`category_custom_url` AS `custom_url`, `l`.`category_round_method` AS `round_method`, `l`.`category_round_value` AS `round_value`, `l`.`category_image` AS `image`, `l`.`category_target_element` AS `target_element`, `l`.`category_insert_method` AS `insert_method` FROM `swissup_prolabels_index` AS `i`
LEFT JOIN `swissup_prolabels_label` AS `l` ON l.label_id = i.label_id WHERE (entity_id IN ('6350', '5392', '2471', '2470', '1488', '1487', '1486', '1485', '1209', '9324')) AND (status = '1') AND (store_id LIKE '%\"0\"%' OR store_id LIKE '%\"1\"%') AND (customer_groups LIKE '%\"0\"%')"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6350') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6350))"
string(94) "SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=0)"
string(72) "SELECT `tax_class`.* FROM `tax_class` WHERE (`tax_class`.`class_id`='3')"
string(139) "SELECT `customer_group_excluded_website`.`website_id` FROM `customer_group_excluded_website` WHERE (customer_group_id = :customer_group_id)"
string(1180) "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 = '1' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('5')) AND (rate.tax_country_id = 'GB') AND (rate.tax_region_id IN(0, 0)) AND (rate.zip_is_range IS NULL) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC
"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '5392') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(5392))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2471') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(2471))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2470') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(2470))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1488') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1488))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1487') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1487))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1486') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1486))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1485') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1485))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1209') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1209))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '9324') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(9324))"
string(155) "SELECT `swissup_easybanner_placeholder`.* FROM `swissup_easybanner_placeholder` WHERE (`swissup_easybanner_placeholder`.`name`='minisport_category_banner')"
string(149) "SELECT `swissup_easybanner_placeholder_offset`.* FROM `swissup_easybanner_placeholder_offset` WHERE (placeholder_id='16') ORDER BY `id` DESC
LIMIT 1"
string(270) "SELECT `main_table`.*, `placeholder`.* FROM `swissup_easybanner_banner` AS `main_table`
INNER JOIN `swissup_easybanner_banner_placeholder` AS `placeholder` ON placeholder.banner_id=main_table.banner_id and placeholder.placeholder_id=16 WHERE (status = 1) AND (type = 1)"
string(120) "SELECT `banner_store`.* FROM `swissup_easybanner_banner_store` AS `banner_store` WHERE (banner_store.banner_id IN ('6'))"
string(144) "SELECT `banner_placeholder`.* FROM `swissup_easybanner_banner_placeholder` AS `banner_placeholder` WHERE (banner_placeholder.banner_id IN ('6'))"
string(202) "SELECT `bs`.`banner_id`, SUM(`display_count`) AS `display_count`, SUM(`clicks_count`) AS `clicks_count` FROM `swissup_easybanner_banner_statistic` AS `bs` WHERE (banner_id IN ('6')) GROUP BY `banner_id`"
Extra Special
string(137) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id)"
string(4000) "SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) AS `special_from_date`, IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) AS `special_to_date`, IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) AS `special_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '77') AND `at_special_from_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '77') AND (`at_special_from_date`.`store_id` = 1)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date_default` ON (`at_special_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date_default`.`attribute_id` = '78') AND `at_special_to_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '78') AND (`at_special_to_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_decimal` AS `at_special_price_default` ON (`at_special_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_price_default`.`attribute_id` = '76') AND `at_special_price_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 1)
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
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 WHERE (((((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) 0, at_special_from_date.value, at_special_from_date_default.value) IS NULL))))) AND (((((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2023-06-08 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NULL))))) AND ((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS NOT NULL) OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NOT NULL)) AND (IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) > 0) ORDER BY RAND(), `e`.`entity_id` DESC
LIMIT 8"
string(3108) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6049, 6073, 6605, 1762, 6036, 11725, 562, 2593)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6049, 6073, 6605, 1762, 6036, 11725, 562, 2593)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6049, 6073, 6605, 1762, 6036, 11725, 562, 2593)) AND (t_d.attribute_id IN (79, 120, 138, 141, 142, 155)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6049, 6073, 6605, 1762, 6036, 11725, 562, 2593)) AND (t_d.attribute_id IN (93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (6049, 6073, 6605, 1762, 6036, 11725, 562, 2593)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(466) "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 ('6049', '6073', '6605', '1762', '6036', '11725', '562', '2593')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(2282) "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 = 1 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 = '88') AND (main.disabled = 0) AND (entity.entity_id in ('6049', '6073', '6605', '1762', '6036', '11725', '562', '2593')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
"
string(727) "SELECT `i`.`entity_id`, `l`.`sort_order`, `l`.`category_position` AS `position`, `l`.`category_text` AS `text`, `l`.`category_custom_style` AS `custom`, `l`.`category_custom_url` AS `custom_url`, `l`.`category_round_method` AS `round_method`, `l`.`category_round_value` AS `round_value`, `l`.`category_image` AS `image`, `l`.`category_target_element` AS `target_element`, `l`.`category_insert_method` AS `insert_method` FROM `swissup_prolabels_index` AS `i`
LEFT JOIN `swissup_prolabels_label` AS `l` ON l.label_id = i.label_id WHERE (entity_id IN ('6049', '6073', '6605', '1762', '6036', '11725', '562', '2593')) AND (status = '1') AND (store_id LIKE '%\"0\"%' OR store_id LIKE '%\"1\"%') AND (customer_groups LIKE '%\"0\"%')"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6049') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6049))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6073') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6073))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6605') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6605))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '1762') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(1762))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '6036') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(6036))"
string(592) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '11725') ORDER BY `qty` ASC
"
string(233) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(11725))"
string(590) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '562') ORDER BY `qty` ASC
"
string(231) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(562))"
string(591) "SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`percentage_value`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (website_id IN(0, '1')) AND (entity_id = '2593') ORDER BY `qty` ASC
"
string(232) "SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2023-06-08') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN(2593))"
string(2652) "SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '77') AND `at_special_from_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '77') AND (`at_special_from_date`.`store_id` = 1)
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date_default` ON (`at_special_to_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date_default`.`attribute_id` = '78') AND `at_special_to_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '78') AND (`at_special_to_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_decimal` AS `at_special_price_default` ON (`at_special_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_price_default`.`attribute_id` = '76') AND `at_special_price_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 1) WHERE (((((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) 0, at_special_from_date.value, at_special_from_date_default.value) IS NULL))))) AND (((((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2023-06-08 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NULL))))) AND ((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS NOT NULL) OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS NOT NULL)) AND (IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) > 0)"
per page
string(436) "SELECT `m`.`entity_id` FROM `catalog_category_entity` AS `m`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (IF(c.value_id > 0, c.value, d.value) = :scope) AND (`path` LIKE :c_path) AND (`level`
string(905) "SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') 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` = '42') AND (`at_is_active`.`store_id` = 1)
LEFT JOIN `url_rewrite` ON (url_rewrite.entity_id =e.entity_id) AND (url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = 1 AND url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('')) ORDER BY `e`.`position` ASC
"
Shop By
Shopping Options
Price
—
string(128) "SELECT `eav_attribute`.`attribute_id` FROM `eav_attribute` WHERE (entity_type_id = 3) AND (attribute_code = 'is_anchor') LIMIT 1"
string(352) "SELECT `cce`.`entity_id`, `cce`.`entity_id`, `cce`.`parent_id`, `cce`.`path`, `cce_int`.`value` AS `is_anchor` FROM `catalog_category_entity` AS `cce`
INNER JOIN `catalog_category_entity_int` AS `cce_int` ON cce.entity_id = cce_int.entity_id WHERE (cce_int.attribute_id = '51') AND (cce.path LIKE '%/94' OR cce.path LIKE '%/94/%') ORDER BY `path` ASC
"
string(137) "SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='entity_id') AND (entity_type_id = :entity_type_id)"
string(1546) "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`, MIN(cat_pro.position) AS `cat_index_position`, `at_minimal_price`.`value` AS `minimal_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
LEFT JOIN `catalog_product_entity_decimal` AS `at_minimal_price` ON (`at_minimal_price`.`entity_id` = `e`.`entity_id`) AND (`at_minimal_price`.`attribute_id` = '99') AND (`at_minimal_price`.`store_id` = 0)
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 WHERE (price_index.final_price
string(3180) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1218) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(1751) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (73)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (77, 78, 93, 94)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (store_id = 0)"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (0)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=1209) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=1485) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=1486) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=1487) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=1488) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=2470) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=2471) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=5392) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=6350) AND (store_id = 1)"
string(135) "SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`=9324) AND (store_id = 1)"
string(1249) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 WHERE (e.entity_id IN (NULL)) GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(408) "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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1218) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(1751) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (73)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (77, 78, 93, 94)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (store_id = 0)"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (0)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1249) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 WHERE (e.entity_id IN (NULL)) GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(408) "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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1218) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(1751) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (73)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (77, 78, 93, 94)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (store_id = 0)"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (0)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1249) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 WHERE (e.entity_id IN (NULL)) GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(408) "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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1218) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(1751) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (73)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (77, 78, 93, 94)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (store_id = 0)"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (0)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1249) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 WHERE (e.entity_id IN (NULL)) GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(408) "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 (NULL)) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1218) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(1751) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (73)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (77, 78, 93, 94)) AND (store_id = 0) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (store_id = 0)"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (0)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"
string(1303) "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`, MIN(cat_pro.position) AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=94
INNER JOIN `catalog_category_product` AS `cat_pro` ON cat_pro.product_id = e.entity_id AND cat_pro.category_id IN(94)
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 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) GROUP BY `e`.`entity_id` ORDER BY `e`.`entity_id` asc
"
string(3180) "SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 229, 274)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (76, 79, 120, 138, 141, 142, 155)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1209, 1485, 1486, 1487, 1488, 2470, 2471, 5392, 6350, 9324)) AND (t_d.attribute_id IN (96, 121, 123, 125, 126, 127, 128, 131, 136, 137, 151, 184, 185, 186, 187, 221)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))"
string(482) "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 ('1209', '1485', '1486', '1487', '1488', '2470', '2471', '5392', '6350', '9324')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)"