Profile all queries0SELECT `name`, `data_type`, `data` FROM system_setting1SELECT domain_url, name FROM core_domain_handler_domain JOIN core_domain_handler_alias ON core_domain_handler_alias_id = * FROM `core_domain_handler_alias` WHERE `core_domain_handler_alias`.`name` = 'default' LIMIT 13SELECT * FROM `core_language` WHERE ((1 = 1)) 4SELECT * FROM `currency` WHERE `currency`.`id` = '1' LIMIT 15SELECT `core_module`.* FROM `core_module` WHERE ((1 = 1)) 6SELECT `code` FROM `core_language` WHERE `code` = 'en'7SELECT * FROM `nice_url` WHERE ((`nice_url`.`url_hash` IN ( '709cb646aa814e6eaa33fd7caf00b325' ) AND `nice_url`.`alias` = 'default' AND `nice_url`.`lang_code` = 'en') AND ((1 = 1))) ORDER BY CHAR_LENGTH( url ) desc LIMIT 1 OFFSET 08SELECT * FROM `product` WHERE ((`product`.`id` = '134056') AND ((1 = 1))) LIMIT 1 OFFSET 09SELECT * FROM `snippet` WHERE ((1 = 1)) 10SELECT * FROM `country` WHERE `country`.`id` = '2' LIMIT 111SELECT * FROM `currency` WHERE `currency`.`code` = 'PLN' LIMIT 112SELECT * FROM `plugin_metadata` WHERE ((1 = 1)) ORDER BY name 13 SELECT product.*, AS producer_name FROM product LEFT JOIN producer p ON = WHERE = :id 14SELECT * FROM `product_capability` WHERE ((`product_capability`.`product_id` = '134056') AND ((1 = 1))) 15SELECT * FROM `core_domain_handler_alias` WHERE ((1 = 1)) 16 SELECT COUNT(id) FROM dropshipping_product WHERE = '134056' 17SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '134056') AND ((1 = 1))) LIMIT 1 OFFSET 018SELECT * FROM `unavailability_option` WHERE `unavailability_option`.`id` = '1' LIMIT 119SELECT c.*, count( as count FROM category c LEFT JOIN product_in_category pic ON = LEFT JOIN category_connection cc ON = WHERE = '134056' AND IS TRUE AND NOT IN (SELECT from_id FROM category_connection WHERE = 2592) GROUP BY ORDER BY count DESC LIMIT 120 SELECT c.* FROM category c JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = :alias 21 SELECT category.* FROM category JOIN category_connection cc ON = AND > 0 WHERE = '1120' AND ((1 = 1)) ORDER BY DESC 22 SELECT as domain_alias FROM category c JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = '1120' 23SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '479' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 24SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1120' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 25SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '134056' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 26 SELECT * FROM product_picture WHERE ordering = (SELECT MIN(ordering) FROM product_picture pp WHERE = GROUP BY ) AND (`product_picture`.`product_id` = '134056' AND ((1 = 1))) 27 SELECT id, product_id, warehouse_symbol FROM product_variant WHERE warehouse_symbol IS NOT NULL AND warehouse_symbol != '' AND (`product_variant`.`product_id` IN ( '134056' ) AND ((1 = 1))) GROUP BY product_id 28SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '134056' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 029SELECT * FROM `producer` WHERE `producer`.`id` = '290' LIMIT 130 SELECT product_field.*, `ppf`.`name__pl` AS field_name__pl, `ppf`.`name__en` AS field_name__en FROM ( SELECT * FROM `product_field` WHERE `product_id` = '134056' ORDER BY `id` DESC ) as product_field JOIN`product_profile_field` `ppf` ON `ppf`.`id` = `product_field`.`profile_field_id` JOIN`product_profile_to_field` `pptf` ON `ppf`.`id`=`pptf`.`product_profile_field_id` WHERE (`product_field`.`profile_field_id` IN ( '1', '68' ) AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC31SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 032SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '134056' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 033SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '134056' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 034 SELECT product_field.*, `ppf`.`name__pl` AS field_name__pl, `ppf`.`name__en` AS field_name__en FROM ( SELECT * FROM `product_field` WHERE `product_id` = '134056' ORDER BY `id` DESC ) as product_field JOIN`product_profile_field` `ppf` ON `ppf`.`id` = `product_field`.`profile_field_id` JOIN`product_profile_to_field` `pptf` ON `ppf`.`id`=`pptf`.`product_profile_field_id` WHERE (`product_field`.`profile_field_id` IN ( '1', '68' ) AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC35SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 036SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '134056' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 037SELECT COUNT( * ) AS _record_count FROM `sales_manago` WHERE ((`sales_manago`.`controller_name` = 'product' AND `sales_manago`.`controller_action` = 'show' AND `sales_manago`.`is_active` = '1') AND ((1 = 1)))38SELECT distinct name FROM `seo_type_name`39 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 40SELECT * FROM seo_type_name41SELECT * FROM `seo_suffix` WHERE ((1 = 1)) 42SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 043 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 44 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 45SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 046 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 47 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 48SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 049 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 50 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 51SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 052 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 53 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 54SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 055 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 56 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 57SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 058 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 59 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 60SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 061 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 62 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 63SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 064 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 65 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 66SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 067 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 68 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 69SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 070 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 71 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 72SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 073 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 74 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 75SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 076 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 77 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 78SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 079 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 80 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 81SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 082 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 83 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 84SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 085 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 86 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 87SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 088 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 89 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 90SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 091 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 92 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 93SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 094 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 95 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 96SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 097 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 98 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 99SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0100 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 101 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 102SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0103 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 104 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 105SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0106 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 107 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 108SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0109 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 110 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 111SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0112 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 113 SELECT `seo_type`.* FROM `seo_type` JOIN core_domain_handler_alias cdha ON = `seo_type`.core_domain_handler_alias_id WHERE ( = 'default' AND ((1 = 1))) 114SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0115 SELECT * FROM `seo_rule` WHERE '/inne-3y36d2' LIKE REPLACE( REPLACE( pattern, '?', '_' ), '*', '%' ) AND ( IN ( SELECT FROM `seo_rule_to_core_domain_handler_alias`crtcdha JOIN core_domain_handler_alias cdha ON = WHERE = 3 ) AND ((1 = 1))) ORDER BY priority ASC 116SELECT * FROM `shop_banner_informational` WHERE ((`shop_banner_informational`.`start_date` '1659586675' AND `shop_banner_informational`.`is_active` = '1') AND ((1 = 1))) 117 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'logo' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 118 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'benefit_banners' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 2 OFFSET 0 119SELECT * FROM `currency` WHERE ((1 = 1)) ORDER BY code asc 120SELECT * FROM `flag` WHERE (`flag`.`visible_in_menu` = '1' AND ((1 = 1))) ORDER BY ordering asc 121SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'flag' AND `nice_url`.`object_id` IN ( '2' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 122SELECT * FROM `category` WHERE `category`.`id` = '1' LIMIT 1123 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 124SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '3', '479', '6', '2059', '2356', '2337', '8', '9', '2452' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 125 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'logo' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 126SELECT * FROM `category` WHERE `category`.`id` = '1' LIMIT 1127 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 128 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_3' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 129 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '3' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 130SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1153', '1113', '501', '18', '20', '25', '32', '26', '21', '1727', '19', '22', '1893', '1157', '1852', '27', '23', '24', '34', '30', '29', '28', '1704', '33', '291', '35', '31', '17', '1650' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 131SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '3' AND ((1 = 1))) 132SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1598' AND `nice_url`.`is_redirect` = '0' AND `nice_url`.`lang_code` = 'en') AND ((1 = 1))) LIMIT 1 OFFSET 0133 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_479' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 134 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '479' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 135SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1120', '1116', '482', '487', '492', '488', '484', '483', '485', '502', '1844', '572', '1797', '1762', '486', '494', '490', '1860', '489', '493', '496', '495', '491', '480', '1673' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 136SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '479' AND ((1 = 1))) 137 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_6' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 138 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '6' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 139SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1122', '1118', '117', '123', '124', '119', '118', '120', '1798', '1763', '121', '122', '128', '1863', '125', '127', '287', '129', '126', '116', '1675' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 140SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '6' AND ((1 = 1))) 141 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_2059' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 142 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2059' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 143SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2073', '2074', '2348', '2250', '2064', '2323', '2253', '2062', '2060', '2251', '2350', '2085', '2252', '2352', '2327', '2379', '2334', '2076', '2067', '2065', '2063', '2326', '2159', '2249', '2394' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 144SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '2059' AND ((1 = 1))) 145 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_2356' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 146 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2356' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 147SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2358' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 148 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2358' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 149SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2359', '2360', '2361', '2362', '2363', '2367', '2369', '2370', '2371', '2382', '2385', '2397', '2398', '2399', '2406', '2426', '2435' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 150SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2435' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 151SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2359 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products152SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2360 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products153SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2361 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products154SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2362 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products155SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2363 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products156SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2367 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products157SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2369 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products158SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2370 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products159SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2371 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products160SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2382 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products161SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2385 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products162SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2397 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products163SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2398 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products164SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2399 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products165SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2406 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products166SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2426 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products167SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2435 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products168SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2357' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 169 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2357' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 170SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2364', '2365', '2366', '2395', '2400' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 171SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2364 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products172SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2365 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products173SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2366 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products174SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2395 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products175SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2400 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products176SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2401' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 177 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2401' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 178SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2402', '2403', '2404', '2405' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 179SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2402 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products180SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2403 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products181SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2404 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products182SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2405 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products183SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2368' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 184 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2368' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 185SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2372', '2374', '2375', '2376', '2377', '2381', '2383', '2439' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 186SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2439' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 187SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2372 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products188SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2374 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products189SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2375 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products190SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2376 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products191SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2377 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products192SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2381 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products193SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2383 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products194SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2439 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products195SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2336' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 196 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2336' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 197 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_2337' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 198 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2337' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 199SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2414' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 200 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2414' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 201SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2415', '2416', '2380', '2422', '2424' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 202SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2415 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products203SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2416 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products204SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2380 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products205SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2422 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products206SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2424 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products207SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2448' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 208 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2448' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 209SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2451', '2392' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 210SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2451' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 211SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2451 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products212SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2392 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products213SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1170' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 214 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1170' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 215SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1857', '2407', '2410', '2411', '2412' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 216SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1857 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products217SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2407 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products218SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2410 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products219SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2411 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products220SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2412 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products221SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '2413' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 222 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2413' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 223SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2344', '2345' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 224SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2344 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products225SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 2345 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products226 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_8' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 227 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '8' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 228SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1087' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 229 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1087' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 230SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1082' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 231 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1082' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 232SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1099', '1100', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1114', '1126', '1134', '1166', '1176', '1526', '1527', '1529', '1530', '1561', '1570', '1571', '1572' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 233SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1099 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products234SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1100 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products235SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1102 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products236SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1103 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products237SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1104 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products238SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1105 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products239SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1106 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products240SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1107 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products241SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1108 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products242SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1114 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products243SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1126 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products244SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1134 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products245SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1166 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products246SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1176 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products247SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1526 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products248SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1527 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products249SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1529 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products250SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1530 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products251SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1561 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products252SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1570 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products253SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1571 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products254SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1572 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products255SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1086' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 256 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1086' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 257SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1178', '1180', '1181', '1182', '1183' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 258SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1178 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products259SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1180 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products260SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1181 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products261SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1182 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products262SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1183 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products263SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1081' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 264 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '1081' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 265SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1088', '1089', '1090', '1091', '1092', '1093', '1094', '1095', '1096', '1097', '1098', '1115', '1151', '1164', '1161', '1165', '1169', '1213', '1669', '1859' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 266SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1088 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products267SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1089 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products268SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1090 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products269SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1091 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products270SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1092 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products271SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1093 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products272SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1094 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products273SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1095 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products274SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1096 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products275SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1097 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products276SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1098 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products277SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1115 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products278SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1151 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products279SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1164 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products280SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1161 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products281SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1165 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products282SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1169 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products283SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1213 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products284SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1669 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products285SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1859 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products286 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_9' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 287 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '9' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 288SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '195' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 289 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '195' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 290SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '197', '198', '199', '200', '201', '202', '203', '474', '204', '205', '206', '207', '208', '209', '210', '211', '475', '212', '506', '539' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 291SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 197 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products292SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 198 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products293SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 199 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products294SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 200 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products295SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 201 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products296SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 202 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products297SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 203 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products298SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 474 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products299SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 204 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products300SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 205 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products301SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 206 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products302SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 207 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products303SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 208 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products304SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 209 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products305SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 210 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products306SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 211 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products307SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 475 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products308SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 212 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products309SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 506 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products310SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 539 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products311SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '247' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 312 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '247' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 313SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '248', '249', '250', '251', '252', '253', '504', '254', '255', '256', '257', '258', '513', '514', '1404' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 314SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 248 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products315SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 249 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products316SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 250 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products317SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 251 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products318SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 252 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products319SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 253 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products320SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 504 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products321SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 254 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products322SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 255 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products323SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 256 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products324SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 257 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products325SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 258 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products326SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 513 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products327SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 514 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products328SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1404 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products329SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '213' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 330 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '213' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY asc 331SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '230', '229', '517', '1025' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 332SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 214 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products333SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 215 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products334SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 216 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products335SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 217 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products336SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 218 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products337SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 219 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products338SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 220 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products339SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 221 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products340SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 222 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products341SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 223 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products342SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 224 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products343SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 225 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products344SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 226 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products345SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 227 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products346SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 228 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products347SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 230 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products348SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 229 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products349SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 517 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products350SELECT EXISTS (SELECT * FROM product_in_category pic JOIN category_connection cc ON = JOIN product_capability pc ON = WHERE = 1025 AND = 3 AND = 1 AND = 1 LIMIT 1) as has_products351 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'menubanner_for_2452' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 352 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2452' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 353SELECT * FROM `flag` WHERE (`flag`.`visible_in_menu` = '1' AND ((1 = 1))) ORDER BY ordering asc 354 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '3' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 355 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '479' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 356 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '6' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 357 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2059' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 358 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2356' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 359SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2358', '2357', '2401', '2368', '2336' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 360 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2337' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 361SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '2414', '2448', '1170', '2413' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 362 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '8' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 363SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '1087', '1082', '1086', '1081' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 364 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '9' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 365SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` IN ( '195', '247', '213' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 366 SELECT `category`.* FROM `category` JOIN category_connection cc ON = `category`.id WHERE = '2452' AND = 1 AND ((`category`.`is_visible` = '1' AND `category`.`is_visible_in_menu` = '1') AND ((1 = 1))) ORDER BY IF(FIELD(is_first_in_menu,1)=1,1,0) DESC, IF(FIELD(is_last_in_menu,1)=1,1,0), name__en 367SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = '' AND 1=2 /* ALWAYS FALSE */ AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 368 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'horizontal_banner_en' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc LIMIT 1 OFFSET 0 369 SELECT `product_variant`.*, `po`.`name__pl` AS option_name__pl, `po`.`name__en` AS option_name__en, `ua`.`name__pl` AS unavailability_option_name__pl, `ua`.`name__en` AS unavailability_option_name__en FROM `product_variant` JOIN `warehouse_state` ws ON ws.`variant_id` = `product_variant`.`id` JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 JOIN `product_option` po ON po.`id` = `product_variant`.`option_id` JOIN `product` p ON p.`id` = `product_variant`.`product_id` AND `product_variant`.`is_active` = 1 JOIN `unavailability_option` ua ON ua.`id` = p.`unavailability_option_id` WHERE `product_variant`.`product_id` = '134056' GROUP BY `product_variant`.`id` HAVING COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) > 0 OR MIN(ua.`is_blocking_sell` = 0) ORDER BY po.`ordering` ASC 370SELECT * FROM `product` WHERE `product`.`id` = '134056' LIMIT 1371SELECT * FROM `vat_rate` WHERE `vat_rate`.`id` = '5' LIMIT 1372 SELECT product_variant.*, option_name, `uo`.`name__pl` AS unavailability_option_name__pl, `uo`.`name__en` AS unavailability_option_name__en FROM product_variant LEFT JOIN product_option po ON = RIGHT JOIN product p ON = LEFT JOIN unavailability_option uo ON = WHERE = '134056' AND = 1 ORDER BY ASC 373 SELECT * FROM product_picture WHERE ordering = (SELECT MIN(ordering) FROM product_picture pp WHERE = GROUP BY ) AND (`product_picture`.`product_id` = '134056' AND ((1 = 1))) 374 SELECT id, product_id, warehouse_symbol FROM product_variant WHERE warehouse_symbol IS NOT NULL AND warehouse_symbol != '' AND (`product_variant`.`product_id` IN ( '134056' ) AND ((1 = 1))) GROUP BY product_id 375 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 376 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 377 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 378 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 379 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 380 SELECT COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS `quantity_available` FROM `warehouse_state` ws JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 WHERE ws.`symbol` = '3Y36D2 SAM 1 ' 381SELECT c.*, count( as count FROM category c LEFT JOIN product_in_category pic ON = LEFT JOIN category_connection cc ON = WHERE = '134056' AND IS TRUE AND NOT IN (SELECT from_id FROM category_connection WHERE = 2592) GROUP BY ORDER BY count DESC LIMIT 1382 SELECT category.*, FROM category category LEFT JOIN product_in_category pic ON pic.`category_id` = JOIN category_connection cc ON = JOIN category category2 ON = JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = '134056' AND = 'default' AND ((1 = 1)) ORDER BY asc 383SELECT * FROM `category` WHERE `category`.`id` = '2592' LIMIT 1384 SELECT category.* FROM category JOIN category_connection cc ON = AND > 0 WHERE = '1120' AND ((1 = 1)) ORDER BY DESC 385 SELECT as domain_alias FROM category c JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = '1120' 386 SELECT category.* FROM category JOIN category_connection cc ON = AND > 0 WHERE = '1120' AND ((1 = 1)) ORDER BY DESC 387 SELECT as domain_alias FROM category c JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = '1120' 388SELECT * FROM `product_picture` WHERE ((`product_picture`.`product_id` = '134056' AND `product_picture`.`category_id` = '1') AND ((1 = 1))) ORDER BY ordering asc 389 SELECT product_flag.*, AS symbol FROM product_flag JOIN flag ON = WHERE (`product_flag`.`product_id` IN ( '134056' ) AND ((1 = 1)))390SELECT * FROM `shop_banner_promotional` WHERE ((`shop_banner_promotional`.`start_date` '1659586675' AND `shop_banner_promotional`.`is_active` = '1' AND `shop_banner_promotional`.`flag_id` IS NOT NULL AND `shop_banner_promotional`.`disable_other_flags` = '1') AND ((1 = 1))) ORDER BY flag_id_to_site asc LIMIT 1 OFFSET 0391SELECT `symbol` FROM `product_symbol_extension` WHERE `product_id` = '134056'392SELECT * FROM `product_review` WHERE ((`product_review`.`product_id` = '134056' AND `product_review`.`is_accepted` = '1') AND ((1 = 1))) ORDER BY created_at desc 393 SELECT product_flag.* FROM product_flag JOIN flag ON = WHERE ((`product_flag`.`product_id` = '134056' AND '' AND IS NOT NULL) AND ((1 = 1)))394SELECT * FROM `flag` WHERE (`flag`.`navbar_is_visible` = '1' AND ((1 = 1))) ORDER BY navbar_priority asc 395SELECT * FROM `periodic_transport_promotion` WHERE ((`periodic_transport_promotion`.`start_date` = '2022-08-04 06:17:00') AND ((1 = 1))) LIMIT 1 OFFSET 0396SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'producer' AND `nice_url`.`object_id` = '290' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 397SELECT * FROM `product_variant` WHERE ((`product_variant`.`product_id` = '134056' AND `product_variant`.`warehouse_symbol` IS NOT NULL) AND ((1 = 1))) LIMIT 1 OFFSET 0398 SELECT pv.* FROM product_variant pv LEFT JOIN product p ON = WHERE = '134056' AND = '2'; AND ((1 = 1)) LIMIT 1 OFFSET 0399SELECT * FROM `product_option_group` WHERE `product_option_group`.`id` = '2' LIMIT 1400 SELECT `product_sizetable_generator`.*, `product_sizetable_picture`.filename AS picture_filename FROM `product_sizetable_generator` LEFT JOIN `product_sizetable_picture` ON `product_sizetable_picture`.`id` = `product_sizetable_generator`.`picture_id` WHERE ((`product_sizetable_generator`.`product_id` = '134056') AND ((1 = 1))) LIMIT 1 401SELECT * FROM `product_sizetable_template` WHERE `product_sizetable_template`.`id` = '' LIMIT 1402SELECT * FROM `page` WHERE ((1 = 1)) 403SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'page' AND `nice_url`.`object_id` IN ( '18', '19', '25', '26', '29', '30', '31', '34', '36', '37', '40', '46', '47', '49', '50', '51', '52', '57', '58', '59', '63', '64' ) AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 404 SELECT `product_variant`.*, `po`.`name__pl` AS option_name__pl, `po`.`name__en` AS option_name__en, `ua`.`name__pl` AS unavailability_option_name__pl, `ua`.`name__en` AS unavailability_option_name__en FROM `product_variant` JOIN `warehouse_state` ws ON ws.`variant_id` = `product_variant`.`id` JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 JOIN `product_option` po ON po.`id` = `product_variant`.`option_id` JOIN `product` p ON p.`id` = `product_variant`.`product_id` AND `product_variant`.`is_active` = 1 JOIN `unavailability_option` ua ON ua.`id` = p.`unavailability_option_id` WHERE `product_variant`.`product_id` = '134056' GROUP BY `product_variant`.`id` HAVING COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) > 0 OR MIN(ua.`is_blocking_sell` = 0) ORDER BY po.`ordering` ASC 405 SELECT `product_variant`.`product_id`, COALESCE(GREATEST( SUM(IF (GREATEST(ws.`quantity_stocked`, 0) > 0, GREATEST(ws.`quantity_stocked`, 0), 0)) - SUM(IF (GREATEST(ws.`quantity_booked`, 0) > 0, GREATEST(ws.`quantity_booked`, 0), 0)), 0), 0) AS available_quantity, ua.`is_blocking_sell` FROM `product_variant` JOIN `warehouse_state` ws ON ws.`variant_id` = `product_variant`.`id` JOIN `warehouse` w ON w.`id` = ws.`warehouse_id` AND w.`is_active` = 1 JOIN `product` p ON p.`id` = `product_variant`.`product_id` AND `product_variant`.`is_active` = 1 JOIN `unavailability_option` ua ON ua.`id` = p.`unavailability_option_id` WHERE (`product_variant`.`product_id` IN ( '134056' ) AND ((1 = 1))) GROUP BY `product_variant`.`id` HAVING available_quantity > 0 LIMIT 1 406 SELECT pv.* FROM product_variant pv LEFT JOIN product p ON = WHERE = '134056' AND = '2'; AND ((1 = 1)) LIMIT 1 OFFSET 0407SELECT `point_of_sale_warehouse_state`.`id`, `point_of_sale_warehouse_state`.`point_of_sale_id`, `point_of_sale_warehouse_state`.`symbol`, `point_of_sale_warehouse_state`.`quantity_stocked`, `point_of_sale_warehouse_state`.`updated_at`, `product_variant`.`product_id`, `product_variant`.`id` as `product_variant_id`, `point_of_sale`.`name__pl` as `point_of_sale_name`, `point_of_sale`.`city__pl` as `point_of_sale_city`, `point_of_sale`.`street__pl` as `point_of_sale_street` FROM `point_of_sale_warehouse_state` JOIN `product_variant` ON `product_variant`.id = `point_of_sale_warehouse_state`.`product_variant_id` JOIN `point_of_sale` ON `point_of_sale`.id = `point_of_sale_warehouse_state`.`point_of_sale_id`WHERE `point_of_sale_warehouse_state`.`product_id` = '134056'408SELECT `point_of_sale_warehouse_state`.`id`, `point_of_sale_warehouse_state`.`point_of_sale_id`, `point_of_sale_warehouse_state`.`symbol`, `point_of_sale_warehouse_state`.`quantity_stocked`, `point_of_sale_warehouse_state`.`updated_at`, `product_variant`.`product_id`, `product_variant`.`id` as `product_variant_id`, `point_of_sale`.`name__pl` as `point_of_sale_name`, `point_of_sale`.`city__pl` as `point_of_sale_city`, `point_of_sale`.`street__pl` as `point_of_sale_street` FROM `point_of_sale_warehouse_state` JOIN `product_variant` ON `product_variant`.id = `point_of_sale_warehouse_state`.`product_variant_id` JOIN `point_of_sale` ON `point_of_sale`.id = `point_of_sale_warehouse_state`.`point_of_sale_id`WHERE `point_of_sale_warehouse_state`.`product_id` = '134056'409SELECT * FROM `gratuitous_product_reference` WHERE ((`gratuitous_product_reference`.`root_product_id` = '134056') AND ((1 = 1))) ORDER BY ordering ASC 410SELECT * FROM `gratuitous_product_reference` WHERE ((`gratuitous_product_reference`.`gratuitous_product_id` = '134056') AND ((1 = 1))) 411SELECT * FROM `periodic_transport_promotion` WHERE ((`periodic_transport_promotion`.`start_date` = '2022-08-04 06:17:00') AND ((1 = 1))) LIMIT 1 OFFSET 0412 SELECT tag.*, COUNT(*) as `count` FROM tag JOIN tag_connection tc ON = WHERE IN ( SELECT FROM tag JOIN `tag_connection` ON `tag_connection`.`tag_id` = `tag`.`id` WHERE ((`tag_connection`.`object_model` = 'Product' AND `tag_connection`.`object_id` = '134056' AND `tag_connection`.`is_object_visible` = '1') AND ((1 = 1))) ) GROUP BY `tag`.`name__pl`, `tag`.`name__en` 413SELECT value_ids FROM `product_field` WHERE (`product_field`.`product_id` = '134056' AND `product_field`.`profile_field_id` = '2') LIMIT 1414 SELECT * FROM product_picture WHERE ((ordering = (SELECT MIN(ordering) FROM product_picture pp WHERE = GROUP BY ) AND `product_picture`.`product_id` IS NULL) AND ((1 = 1))) 415 SELECT product_field.*, `ppf`.`name__pl` AS field_name__pl, `ppf`.`name__en` AS field_name__en FROM ( SELECT * FROM `product_field` WHERE `product_id` = '134056' ORDER BY `id` DESC ) as product_field JOIN`product_profile_field` `ppf` ON `ppf`.`id` = `product_field`.`profile_field_id` JOIN`product_profile_to_field` `pptf` ON `ppf`.`id`=`pptf`.`product_profile_field_id` WHERE (`product_field`.`profile_field_id` = '2' AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC416 SELECT category.*, FROM category category LEFT JOIN product_in_category pic ON pic.`category_id` = JOIN category_connection cc ON = JOIN category category2 ON = JOIN category_alias ca ON = JOIN core_domain_handler_alias cdha ON = WHERE = '134056' AND = 'default' AND ((1 = 1)) ORDER BY asc LIMIT 1 417 SELECT product_field.*, `ppf`.`name__pl` AS field_name__pl, `ppf`.`name__en` AS field_name__en FROM ( SELECT * FROM `product_field` WHERE `product_id` = '134056' ORDER BY `id` DESC ) as product_field JOIN`product_profile_field` `ppf` ON `ppf`.`id` = `product_field`.`profile_field_id` JOIN`product_profile_to_field` `pptf` ON `ppf`.`id`=`pptf`.`product_profile_field_id` WHERE (`product_field`.`profile_field_id` = '2' AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC418SELECT * FROM `product_line_banner` WHERE (`product_line_banner`.`product_profile_field_multiple_choice_id` = '' AND ((1 = 1))) LIMIT 1 OFFSET 0419 SELECT `shop_banner`.* FROM `shop_banner` JOIN shop_banner_category_connection ON = `shop_banner`.id JOIN shop_banner_category ON = WHERE is_deleted = 0 AND ((`shop_banner`.`is_deleted` = '0' AND = 'payu_banners' AND (`shop_banner`.`start_date` = '2022-08-04 06:17:55' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc 420SELECT * FROM `product_review` WHERE ((`product_review`.`product_id` = '134056' AND `product_review`.`is_accepted` = '1') AND ((1 = 1))) ORDER BY created_at desc 421 SELECT COUNT( * ) AS review_count, COALESCE( SUM( score ), 0 ) AS total_score FROM product_review WHERE product_id = :product_id AND is_accepted = 1422SELECT * FROM `product_profile` WHERE `product_profile`.`id` = '1' LIMIT 1423 SELECT product_field.*, `ppf`.`name__pl` AS field_name__pl, `ppf`.`name__en` AS field_name__en FROM ( SELECT * FROM `product_field` WHERE `product_id` = '134056' ORDER BY `id` DESC ) as product_field JOIN`product_profile_field` `ppf` ON `ppf`.`id` = `product_field`.`profile_field_id` JOIN`product_profile_to_field` `pptf` ON `ppf`.`id`=`pptf`.`product_profile_field_id` WHERE ( IN ( '1' ) AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC424SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 0425SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '15' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 0426SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '29' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 0427SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '134056' AND `seo_heading`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 0428SELECT * FROM `product_attachment` WHERE ((`product_attachment`.`product_id` = '134056' AND `product_attachment`.`type` = 'standard') AND ((1 = 1))) ORDER BY id asc 429 SELECT product_profile_field.*, as product_profile_id, as pptf_id FROM product_profile_field JOIN product_profile_to_field pptf ON = WHERE ( = '1' AND ((1 = 1))) ORDER BY ASC 430SELECT * FROM `product_field` WHERE (`product_field`.`product_id` = '134056' AND ((1 = 1))) 431SELECT COUNT(id) AS count FROM canonical_url WHERE controller_name = 'product' AND (action_name = 'show' OR action_name IS NULL);432SELECT * FROM `core_domain_handler_domain` WHERE ((`core_domain_handler_domain`.`core_domain_handler_alias_id` = '3' AND `core_domain_handler_domain`.`domain_url` = ' AND ((1 = 1))) LIMIT 1 OFFSET 0433 SELECT COUNT( AS `count` FROM `page_pop_up` JOIN `page_pop_up_callback` puc ON puc.`pop_up_id` = `page_pop_up`.`id` JOIN `page_pop_up_device` pud ON pud.`pop_up_id` = `page_pop_up`.`id` WHERE puc.`controller_name` = 'product' AND puc.`controller_action` = 'show' AND pud.`is_desktop` = 1 AND (`page_pop_up`.`start_date` = '2022-08-04 06:17:55' OR `page_pop_up`.`end_date` IS NULL)434SELECT * FROM `product_field` WHERE ((`product_field`.`product_id` = '134056' AND `product_field`.`profile_field_id` = '1') AND ((1 = 1))) LIMIT 1 OFFSET 0435SELECT * FROM `core_language` WHERE `core_language`.`id` = '1' LIMIT 1436SELECT * FROM `system_setting` WHERE ((1 = 1))