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 ( '9ac751353c8a97fd653d8f13f85780e9' ) 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` = '144376') 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` = '144376') AND ((1 = 1))) 15SELECT * FROM `core_domain_handler_alias` WHERE ((1 = 1)) 16 SELECT COUNT(id) FROM dropshipping_product WHERE = '144376' 17SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '144376') 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 = '144376' 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 = '1089' 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 = '1089' 23SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '8' 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` = '1081' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 25SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'category' AND `nice_url`.`object_id` = '1089' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 26SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '144376' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 27 SELECT * FROM product_picture WHERE ordering = (SELECT MIN(ordering) FROM product_picture pp WHERE = GROUP BY ) AND (`product_picture`.`product_id` = '144376' AND ((1 = 1))) 28 SELECT id, product_id, warehouse_symbol FROM product_variant WHERE warehouse_symbol IS NOT NULL AND warehouse_symbol != '' AND (`product_variant`.`product_id` IN ( '144376' ) AND ((1 = 1))) GROUP BY product_id 29SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '144376' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 030SELECT * FROM `producer` WHERE `producer`.`id` = '116' LIMIT 131 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` = '144376' 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` ASC32SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 033SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '144376' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 034SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '144376' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 035 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` = '144376' 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` ASC36SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 037SELECT * FROM `seo_metadata` WHERE ((`seo_metadata`.`object_id` = '144376' AND `seo_metadata`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 038SELECT 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)))39SELECT distinct name FROM `seo_type_name`40 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))) 41SELECT * FROM seo_type_name42SELECT * FROM `seo_suffix` WHERE ((1 = 1)) 43SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 044 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 45 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))) 46SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 047 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 48 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))) 49SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 050 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 51 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))) 52SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 053 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 54 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))) 55SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 056 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 57 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))) 58SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 059 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 60 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))) 61SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 062 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 63 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))) 64SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 065 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 66 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))) 67SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 068 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 69 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))) 70SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 071 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 72 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))) 73SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 074 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 75 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))) 76SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 077 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 78 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))) 79SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 080 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 81 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))) 82SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 083 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 84 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))) 85SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 086 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 87 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))) 88SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 089 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 90 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))) 91SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 092 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 93 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))) 94SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 095 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 96 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))) 97SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 098 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 99 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))) 100SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0101 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 102 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))) 103SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0104 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 105 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))) 106SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0107 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 108 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))) 109SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0110 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 111 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))) 112SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0113 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 114 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))) 115SELECT * FROM `core_domain_handler_alias` WHERE ((`core_domain_handler_alias`.`name` = 'default') AND ((1 = 1))) LIMIT 1 OFFSET 0116 SELECT * FROM `seo_rule` WHERE '/gry-i-puzzle-3y37bp' 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 117SELECT * FROM `shop_banner_informational` WHERE ((`shop_banner_informational`.`start_date` '1659243987' AND `shop_banner_informational`.`is_active` = '1') AND ((1 = 1))) 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 = 'logo' AND (`shop_banner`.`start_date` = '2022-07-31 07:06:27' 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 119 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-07-31 07:06:27' 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 120SELECT * FROM `currency` WHERE ((1 = 1)) ORDER BY code asc 121SELECT * FROM `flag` WHERE (`flag`.`visible_in_menu` = '1' AND ((1 = 1))) ORDER BY ordering asc 122SELECT * 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 123SELECT * FROM `category` WHERE `category`.`id` = '1' LIMIT 1124 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 125SELECT * 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 126 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-07-31 07:06:27' 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 127SELECT * FROM `category` WHERE `category`.`id` = '1' LIMIT 1128 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 129 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-07-31 07:06:27' 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 130 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 131SELECT * 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 132SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '3' AND ((1 = 1))) 133SELECT * 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 0134 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-07-31 07:06:27' 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 135 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 136SELECT * 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 137SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '479' AND ((1 = 1))) 138 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-07-31 07:06:27' 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 139 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 140SELECT * 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 141SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '6' AND ((1 = 1))) 142 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-07-31 07:06:27' 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 143 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 144SELECT * 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 145SELECT * FROM `category_additional_nav` WHERE (`category_additional_nav`.`category_id` = '2059' AND ((1 = 1))) 146 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-07-31 07:06:27' 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 147 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 148SELECT * 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 149 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 150SELECT * 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 151SELECT * 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 152SELECT 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_products153SELECT 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_products154SELECT 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_products155SELECT 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_products156SELECT 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_products157SELECT 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_products158SELECT 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_products159SELECT 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_products160SELECT 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_products161SELECT 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_products162SELECT 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_products163SELECT 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_products164SELECT 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_products165SELECT 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_products166SELECT 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_products167SELECT 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_products168SELECT 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_products169SELECT * 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 170 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 171SELECT * 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 172SELECT 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_products173SELECT 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_products174SELECT 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_products175SELECT 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_products176SELECT 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_products177SELECT * 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 178 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 179SELECT * 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 180SELECT 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_products181SELECT 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_products182SELECT 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_products183SELECT 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_products184SELECT * 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 185 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 186SELECT * 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 187SELECT * 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 188SELECT 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_products189SELECT 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_products190SELECT 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_products191SELECT 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_products192SELECT 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_products193SELECT 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_products194SELECT 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_products195SELECT 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_products196SELECT * 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 197 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 198 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-07-31 07:06:27' 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 199 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 200SELECT * 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 201 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 202SELECT * 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 203SELECT 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_products204SELECT 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_products205SELECT 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_products206SELECT 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_products207SELECT 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_products208SELECT * 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 209 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 210SELECT * 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 211SELECT * 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 212SELECT 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_products213SELECT 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_products214SELECT * 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 215 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 216SELECT * 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 217SELECT 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_products218SELECT 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_products219SELECT 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_products220SELECT 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_products221SELECT 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_products222SELECT * 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 223 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 224SELECT * 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 225SELECT 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_products226SELECT 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_products227 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-07-31 07:06:27' 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 228 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 229SELECT * 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 230 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 231SELECT * 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 232 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 233SELECT * 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 234SELECT 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_products235SELECT 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_products236SELECT 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_products237SELECT 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_products238SELECT 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_products239SELECT 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_products240SELECT 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_products241SELECT 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_products242SELECT 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_products243SELECT 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_products244SELECT 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_products245SELECT 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_products246SELECT 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_products247SELECT 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_products248SELECT 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_products249SELECT 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_products250SELECT 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_products251SELECT 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_products252SELECT 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_products253SELECT 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_products254SELECT 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_products255SELECT 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_products256SELECT * 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 257 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 258SELECT * 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 259SELECT 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_products260SELECT 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_products261SELECT 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_products262SELECT 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_products263SELECT 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_products264 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-07-31 07:06:27' 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-07-31 07:06:27' 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-07-31 07:06:27' 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` = '144376' 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` = '144376' 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 = '144376' 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` = '144376' 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 ( '144376' ) 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` = '3Y37BP SAM ONE SIZE' 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` = '3Y37BP SAM ONE SIZE' 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` = '3Y37BP SAM ONE SIZE' 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` = '3Y37BP SAM ONE SIZE' 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` = '3Y37BP SAM ONE SIZE' 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` = '3Y37BP SAM ONE SIZE' 381SELECT c.*, count( as count FROM category c LEFT JOIN product_in_category pic ON = LEFT JOIN category_connection cc ON = WHERE = '144376' 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 = '144376' 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 = '1089' 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 = '1089' 386 SELECT category.* FROM category JOIN category_connection cc ON = AND > 0 WHERE = '8' 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 = '8' 388SELECT * FROM `product_picture` WHERE ((`product_picture`.`product_id` = '144376' 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 ( '144376' ) AND ((1 = 1)))390SELECT * FROM `shop_banner_promotional` WHERE ((`shop_banner_promotional`.`start_date` '1659243988' 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` = '144376'392SELECT * FROM `product_review` WHERE ((`product_review`.`product_id` = '144376' 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` = '144376' 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-07-31 07:06:00') AND ((1 = 1))) LIMIT 1 OFFSET 0396SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'producer' AND `nice_url`.`object_id` = '116' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 397SELECT * FROM `product_variant` WHERE ((`product_variant`.`product_id` = '144376' 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 = '144376' 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` = '144376') 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` = '144376' 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 ( '144376' ) 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 = '144376' 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` = '144376'408SELECT point_of_sale_id, store_mpk FROM pec_store409INSERT INTO `system_error` (`id`, `created_at`, `severity`, `code`, `message`) VALUES (NULL, '1659243988', 'high', 'Module\Solar\PointOfSale\WarehouseState\Synchronizer\WarehouseStateSynchronizer', 'SQLSTATE[08006] [7] could not connect to server: Connection refused\n Is the server running on host \" and accepting\n TCP/IP connections on port 5432? | point_of_sale_ids:340 | product_symbols:3Y37BP SAM ONE SIZE')410SELECT `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` = '144376'411SELECT `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` = '144376'412INSERT INTO `system_error` (`id`, `created_at`, `severity`, `code`, `message`) VALUES (NULL, '1659243988', 'high', 'Module\Solar\PointOfSale\WarehouseState\Synchronizer\WarehouseStateSynchronizer', 'SQLSTATE[08006] [7] could not connect to server: Connection refused\n Is the server running on host \" and accepting\n TCP/IP connections on port 5432? | point_of_sale_ids:340 | product_symbols:3Y37BP SAM ONE SIZE')413SELECT `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` = '144376'414SELECT * FROM `gratuitous_product_reference` WHERE ((`gratuitous_product_reference`.`root_product_id` = '144376') AND ((1 = 1))) ORDER BY ordering ASC 415SELECT * FROM `gratuitous_product_reference` WHERE ((`gratuitous_product_reference`.`gratuitous_product_id` = '144376') AND ((1 = 1))) 416SELECT * FROM `periodic_transport_promotion` WHERE ((`periodic_transport_promotion`.`start_date` = '2022-07-31 07:06:00') AND ((1 = 1))) LIMIT 1 OFFSET 0417 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` = '144376' AND `tag_connection`.`is_object_visible` = '1') AND ((1 = 1))) ) GROUP BY `tag`.`name__pl`, `tag`.`name__en` 418SELECT value_ids FROM `product_field` WHERE (`product_field`.`product_id` = '144376' AND `product_field`.`profile_field_id` = '2') LIMIT 1419 SELECT p.* FROM product p JOIN product_field pf ON = AND != '144376' AND = '2' AND = '[585]' JOIN product_capability ON = AND = 1 AND = 1 AND = 1 AND = 1 AND = '3' LIMIT 20 420 SELECT * FROM product_picture WHERE ((ordering = (SELECT MIN(ordering) FROM product_picture pp WHERE = GROUP BY ) AND `product_picture`.`product_id` IN ( '86728', '105417', '106152', '136991', '136492', '136986', '146545', '146544', '146541', '146466', '149756', '145219', '145471', '147652', '147656', '147659' )) AND ((1 = 1))) 421SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '86728' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 422SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '105417' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 423SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '106152' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 424SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '136991' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 425SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '136492' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 426SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '136986' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 427SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '146545' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 428SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '146544' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 429SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '146541' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 430SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '146466' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 431SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '149756' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 432SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '145219' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 433SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '145471' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 434SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '147652' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 435SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '147656' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 436SELECT * FROM `nice_url` WHERE ((`nice_url`.`object_type` = 'product' AND `nice_url`.`object_id` = '147659' AND `nice_url`.`is_redirect` = '0') AND ((1 = 1))) ORDER BY lang_code DESC, alias 437 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 ( '86728', '105417', '106152', '136991', '136492', '136986', '146545', '146544', '146541', '146466', '149756', '145219', '145471', '147652', '147656', '147659' ) AND ((1 = 1))) GROUP BY `product_variant`.`id` HAVING available_quantity > 0 LIMIT 1 438 SELECT id, product_id, warehouse_symbol FROM product_variant WHERE warehouse_symbol IS NOT NULL AND warehouse_symbol != '' AND (`product_variant`.`product_id` IN ( '86728', '105417', '106152', '136991', '136492', '136986', '146545', '146544', '146541', '146466', '149756', '145219', '145471', '147652', '147656', '147659' ) AND ((1 = 1))) GROUP BY product_id 439 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` = '144376' 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` ASC440 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 = '144376' AND = 'default' AND ((1 = 1)) ORDER BY asc LIMIT 1 441 SELECT COUNT(id) FROM dropshipping_product WHERE = '86728' 442SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '86728') AND ((1 = 1))) LIMIT 1 OFFSET 0443 SELECT COUNT(id) FROM dropshipping_product WHERE = '105417' 444SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '105417') AND ((1 = 1))) LIMIT 1 OFFSET 0445 SELECT COUNT(id) FROM dropshipping_product WHERE = '106152' 446SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '106152') AND ((1 = 1))) LIMIT 1 OFFSET 0447 SELECT COUNT(id) FROM dropshipping_product WHERE = '136991' 448SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '136991') AND ((1 = 1))) LIMIT 1 OFFSET 0449 SELECT COUNT(id) FROM dropshipping_product WHERE = '136492' 450SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '136492') AND ((1 = 1))) LIMIT 1 OFFSET 0451 SELECT COUNT(id) FROM dropshipping_product WHERE = '136986' 452SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '136986') AND ((1 = 1))) LIMIT 1 OFFSET 0453 SELECT COUNT(id) FROM dropshipping_product WHERE = '146545' 454SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '146545') AND ((1 = 1))) LIMIT 1 OFFSET 0455 SELECT COUNT(id) FROM dropshipping_product WHERE = '146544' 456SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '146544') AND ((1 = 1))) LIMIT 1 OFFSET 0457 SELECT COUNT(id) FROM dropshipping_product WHERE = '146541' 458SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '146541') AND ((1 = 1))) LIMIT 1 OFFSET 0459 SELECT COUNT(id) FROM dropshipping_product WHERE = '146466' 460SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '146466') AND ((1 = 1))) LIMIT 1 OFFSET 0461 SELECT COUNT(id) FROM dropshipping_product WHERE = '149756' 462SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '149756') AND ((1 = 1))) LIMIT 1 OFFSET 0463 SELECT COUNT(id) FROM dropshipping_product WHERE = '145219' 464SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '145219') AND ((1 = 1))) LIMIT 1 OFFSET 0465 SELECT COUNT(id) FROM dropshipping_product WHERE = '145471' 466SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '145471') AND ((1 = 1))) LIMIT 1 OFFSET 0467 SELECT COUNT(id) FROM dropshipping_product WHERE = '147652' 468SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '147652') AND ((1 = 1))) LIMIT 1 OFFSET 0469 SELECT COUNT(id) FROM dropshipping_product WHERE = '147656' 470SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '147656') AND ((1 = 1))) LIMIT 1 OFFSET 0471 SELECT COUNT(id) FROM dropshipping_product WHERE = '147659' 472SELECT * FROM `product_symbol_extension` WHERE ((`product_symbol_extension`.`product_id` = '147659') AND ((1 = 1))) LIMIT 1 OFFSET 0473 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` = '144376' 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` ASC474SELECT * FROM `product_line_banner` WHERE (`product_line_banner`.`product_profile_field_multiple_choice_id` = '585' AND ((1 = 1))) LIMIT 1 OFFSET 0475 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-07-31 07:06:28' OR `shop_banner`.`end_date` IS NULL) AND `shop_banner`.`is_active` = '1') AND ((1 = 1))) GROUP BY `shop_banner`.id ORDER BY asc 476SELECT * FROM `product_review` WHERE ((`product_review`.`product_id` = '144376' AND `product_review`.`is_accepted` = '1') AND ((1 = 1))) ORDER BY created_at desc 477 SELECT COUNT( * ) AS review_count, COALESCE( SUM( score ), 0 ) AS total_score FROM product_review WHERE product_id = :product_id AND is_accepted = 1478SELECT * FROM `product_profile` WHERE `product_profile`.`id` = '21' LIMIT 1479 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` = '144376' 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 ( '21' ) AND ((1 = 1))) GROUP BY product_field.`profile_field_id` ORDER BY `pptf`.`ordering` ASC480SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '27' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 0481SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '1' AND `seo_heading`.`object_type` = 'product_profile_field') AND ((1 = 1))) LIMIT 1 OFFSET 0482SELECT * FROM `seo_heading` WHERE ((`seo_heading`.`object_id` = '144376' AND `seo_heading`.`object_type` = 'product') AND ((1 = 1))) LIMIT 1 OFFSET 0483SELECT * FROM `product_attachment` WHERE ((`product_attachment`.`product_id` = '144376' AND `product_attachment`.`type` = 'standard') AND ((1 = 1))) ORDER BY id asc 484 SELECT product_profile_field.*, as product_profile_id, as pptf_id FROM product_profile_field JOIN product_profile_to_field pptf ON = WHERE ( = '21' AND ((1 = 1))) ORDER BY ASC 485SELECT * FROM `product_field` WHERE (`product_field`.`product_id` = '144376' AND ((1 = 1))) 486SELECT * FROM `product_profile_field_multiple_choice` WHERE ((`product_profile_field_multiple_choice`.`id` IN ( '585' )) AND ((1 = 1))) 487SELECT COUNT(id) AS count FROM canonical_url WHERE controller_name = 'product' AND (action_name = 'show' OR action_name IS NULL);488SELECT * 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 0489 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-07-31 07:06:28' OR `page_pop_up`.`end_date` IS NULL)490SELECT * FROM `product_field` WHERE ((`product_field`.`product_id` = '144376' AND `product_field`.`profile_field_id` = '1') AND ((1 = 1))) LIMIT 1 OFFSET 0491SELECT * FROM `core_language` WHERE `core_language`.`id` = '1' LIMIT 1492SELECT * FROM `system_setting` WHERE ((1 = 1))