Accueil 24h Avant [-30%]

Réservez votre commande ! 24h Avant [-30%]

Reservez votre commande avant midi pour le soir ou pour le lendemain et recevez des réductions.

En reservant votre comande, optenez jusqu'a -50% de réduction sur une selection de menus à déguster à deux ou entre amis !

Plus

View:
2 items


Load time: 1.517s
You'd better run your shop on a toaster
Hook processing: 825ms / 5.16 Mb
Memory peak usage: 8.3 Mb

Total cache size (in Cache class): 0 Mb
DB type: DbPDO
SQL Queries: 260 queries
Time spent querying: 226ms
Included files: 270
Size of included files: 3.13 Mb
Globals (> 1 Ko only): 563 Ko

Stopwatch (with SQL_NO_CACHE) (total = 260)

10.138 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 61) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
7.986 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.`id_product_attribute`) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0 AS new FROM `king_product` p INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN `king_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `king_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `king_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN king_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE p.`id_manufacturer` = 5 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN ( SELECT cp.`id_product` FROM `king_category_group` cg LEFT JOIN `king_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `king_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1 WHERE cg.`id_group` = 1 ) GROUP BY product_shop.id_product ORDER BY product_shop.`price` asc LIMIT 0,50
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:369
USING FILESORT - 4 rows browsed
5.161 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `king_module` m INNER JOIN `king_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `king_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `king_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM king_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /home/cinquantl/www/kingsushi/classes/Hook.php:339
USING FILESORT - 93 rows browsed
5.028 ms SELECT SQL_NO_CACHE s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Supplier.php:122
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed
4.535 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `king_category_product` cp LEFT JOIN `king_product` p ON p.`id_product` = cp.`id_product` INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN king_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `king_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `king_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `king_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `king_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `king_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY RAND() LIMIT 0, 1
in /home/cinquantl/www/kingsushi/classes/Category.php:659
USING FILESORT - 33 rows browsed
4.293 ms SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1 ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE m.`active` = 1 GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:179
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed
4.276 ms SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1 ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE m.`active` = 1 GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:179
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed
3.924 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `king_configuration` c LEFT JOIN `king_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /home/cinquantl/www/kingsushi/classes/Configuration.php:116
427 rows browsed
3.447 ms SELECT SQL_NO_CACHE `id_hook`, `name` FROM `king_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `king_hook_alias` ha INNER JOIN `king_hook` h ON ha.name = h.name
in /home/cinquantl/www/kingsushi/classes/Hook.php:130
0 rows browsed
3.298 ms SELECT SQL_NO_CACHE s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Supplier.php:122
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed
3.191 ms SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `king_hook` h INNER JOIN `king_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `king_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
in /home/cinquantl/www/kingsushi/classes/Hook.php:227
USING FILESORT - 93 rows browsed
2.248 ms INSERT INTO `king_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455
2.228 ms SELECT SQL_NO_CACHE p.`id_product` FROM `king_product` p INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_manufacturer = 5 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN ( SELECT cp.`id_product` FROM `king_category_group` cg LEFT JOIN `king_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `king_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1 WHERE cg.`id_group` = 1 )
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:307
4 rows browsed
2.071 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 268) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.894 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM king_shop_url su LEFT JOIN king_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.wok-king-sushi.fr' OR su.domain_ssl = 'www.wok-king-sushi.fr') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /home/cinquantl/www/kingsushi/classes/shop/Shop.php:320
USING FILESORT - 1 row browsed
1.757 ms INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('120646', '69', '584050364', '', '1', '1', '2021-11-29 04:18:20')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455
1.742 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `king_meta` m LEFT JOIN `king_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC
in /home/cinquantl/www/kingsushi/classes/Dispatcher.php:426
USING FILESORT - 26 rows browsed
1.595 ms SELECT SQL_NO_CACHE king_megamenu_menus.id_menu, king_megamenu_menus.active, king_megamenu_menus.position, king_megamenu_menus_lan.id_menu, king_megamenu_menus_lan.id_lang, king_megamenu_menus_lan.name FROM `king_megamenu_menus`, `king_megamenu_menus_lan` WHERE king_megamenu_menus.id_shop = 1 AND king_megamenu_menus.id_menu = king_megamenu_menus_lan.id_menu ORDER BY king_megamenu_menus.position ASC
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1158
USING FILESORT - 7 rows browsed
1.59 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 268 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
1.588 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM king_shop_group gs LEFT JOIN king_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN king_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
in /home/cinquantl/www/kingsushi/classes/shop/Shop.php:622
USING FILESORT - 1 row browsed
1.471 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `king_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `king_module` m
in /home/cinquantl/www/kingsushi/classes/module/Module.php:171
93 rows browsed
1.459 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 11 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 8 rows browsed
Useless GROUP BY need to be removed
1.338 ms SELECT SQL_NO_CACHE * FROM `king_currency` c INNER JOIN king_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASC
in /home/cinquantl/www/kingsushi/classes/Currency.php:219
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
1.334 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 11) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.334 ms SELECT SQL_NO_CACHE * FROM `king_country` a LEFT JOIN `king_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `king_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.289 ms SELECT SQL_NO_CACHE * FROM `king_currency` a LEFT JOIN `king_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.28 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 248) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.251 ms SELECT SQL_NO_CACHE * FROM `king_hook_alias`
in /home/cinquantl/www/kingsushi/classes/Hook.php:182
86 rows browsed
1.213 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 1 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
1.211 ms SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `king_currency` c LEFT JOIN king_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Currency.php:445
1 row browsed
1.196 ms SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords` FROM `king_manufacturer_lang` ml LEFT JOIN `king_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`) WHERE ml.id_lang = 1 AND ml.id_manufacturer = 5 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:324
1 row browsed
1.186 ms SELECT SQL_NO_CACHE `slide_id`, `shop_id`, `lang_id`, `is_active`, `position`,`url`, `caption`, `image` FROM king_autumn_slider WHERE `shop_id` = 1 AND `lang_id` = 1 ORDER BY `position` ASC
in /home/cinquantl/www/kingsushi/modules/autumnslider/autumnslider.php:812
USING FILESORT - 6 rows browsed
1.18 ms SELECT SQL_NO_CACHE * FROM `king_tax_rule` WHERE `id_country` = 8 AND `id_tax_rules_group` = 2 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /home/cinquantl/www/kingsushi/classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed
1.161 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 7 rows browsed
Useless GROUP BY need to be removed
1.152 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `king_lang` l LEFT JOIN `king_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /home/cinquantl/www/kingsushi/classes/Language.php:698
1 row browsed
1.152 ms SELECT SQL_NO_CACHE * FROM `king_manufacturer` a LEFT JOIN `king_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 1 LEFT JOIN `king_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 5) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.15 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM king_shop s LEFT JOIN king_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN king_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/shop/Shop.php:199
1 row browsed
1.143 ms SELECT SQL_NO_CACHE * FROM king_meta m LEFT JOIN king_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:144
1 row browsed
1.142 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 54) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.134 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 12 rows browsed
Useless GROUP BY need to be removed
1.06 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.054 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
0 rows browsed
1.028 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 162) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.022 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 323) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.018 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 265) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.009 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 256) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
1.008 ms SELECT SQL_NO_CACHE COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = 72 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1651
1 row browsed
1.003 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `king_lang` l JOIN king_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Language.php:805
1 row browsed
0.974 ms SELECT SQL_NO_CACHE * FROM `king_group` a LEFT JOIN `king_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.968 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 45 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.948 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 11 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 8 rows browsed
Useless GROUP BY need to be removed
0.944 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 61
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.942 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `king_product` p INNER JOIN `king_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `king_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 209)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed
0.942 ms SELECT SQL_NO_CACHE *, ( IF ('2021-11-29 04:18:20' >= `from` AND '2021-11-29 04:18:20' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `king_specific_price` WHERE `id_product` IN (0, 209) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:20' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:20' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:243
USING FILESORT - 33 rows browsed
0.935 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 63) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.923 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 11
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.91 ms SELECT SQL_NO_CACHE * FROM `king_hook_module_exceptions` WHERE `id_shop` IN (1)
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1571
1 row browsed
0.897 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 54 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.891 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 265 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.88 ms SELECT SQL_NO_CACHE COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = 72 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1651
1 row browsed
0.872 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 248 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.856 ms SELECT SQL_NO_CACHE * FROM `king_tax_rule` WHERE `id_country` = 8 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /home/cinquantl/www/kingsushi/classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed
0.853 ms SELECT SQL_NO_CACHE * FROM `king_social_links` WHERE `id_shop` = 1
in /home/cinquantl/www/kingsushi/modules/autumnsocial/autumnsocial.php:436
1 row browsed
0.839 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 27 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed
0.832 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 62) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.827 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 209) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.824 ms SELECT SQL_NO_CACHE * FROM `king_group_lang` WHERE `id_group` = 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed
0.823 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 80 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.823 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 323 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.821 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 209 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed
0.804 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 210 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed
0.797 ms SELECT SQL_NO_CACHE *, ( IF ('2021-11-29 04:18:19' >= `from` AND '2021-11-29 04:18:19' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `king_specific_price` WHERE `id_product` IN (0, 27) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:19' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:19' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:243
USING FILESORT - 33 rows browsed
0.797 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 256 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.793 ms SELECT SQL_NO_CACHE * FROM `king_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.791 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 36) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.787 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 64 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.781 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 210) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.779 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 162 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed
0.777 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 38) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.768 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 28 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed
0.767 ms SELECT SQL_NO_CACHE * FROM `king_tax_lang` WHERE `id_tax` = 2
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed
0.766 ms SELECT SQL_NO_CACHE * FROM `king_tax` a WHERE (a.id_tax = 2) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.763 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 34 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.75 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed
0.75 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 28) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.74 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 15) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.74 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 12 rows browsed
Useless GROUP BY need to be removed
0.739 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 65 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.736 ms SELECT SQL_NO_CACHE * FROM `king_country` a LEFT JOIN `king_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.733 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM king_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/shop/ShopUrl.php:154
1 row browsed
0.728 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.726 ms SELECT SQL_NO_CACHE `id_country` FROM `king_country` WHERE `iso_code` = 'FR' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Country.php:167
1 row browsed
0.726 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 12 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 5 rows browsed
Useless GROUP BY need to be removed
0.725 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 27) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:362
1 row browsed
0.72 ms SELECT SQL_NO_CACHE id_shop FROM `king_manufacturer_shop` WHERE `id_manufacturer` = 5 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed
0.718 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 41) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.716 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 31) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.715 ms SELECT SQL_NO_CACHE `id_guest` FROM `king_connections` WHERE `id_guest` = 120646 AND `date_add` > '2021-11-29 03:48:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Connection.php:134
USING FILESORT - 1 row browsed
0.713 ms SELECT SQL_NO_CACHE *, ( IF ('2021-11-29 04:18:20' >= `from` AND '2021-11-29 04:18:20' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `king_specific_price` WHERE `id_product` IN (0, 210) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:20' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-11-29 04:18:20' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:243
USING FILESORT - 33 rows browsed
0.713 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 41 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.711 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 60) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.701 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 65) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.698 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 209 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed
0.696 ms SELECT SQL_NO_CACHE `id_page` FROM `king_page` WHERE `id_page_type` = 8 AND `id_object` = 5 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Page.php:78
1 row browsed
0.692 ms SELECT SQL_NO_CACHE * FROM `king_country_lang` WHERE `id_country` = 8
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed
0.687 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 1) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.675 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "blockwishlist" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed
0.654 ms SELECT SQL_NO_CACHE id_shop FROM `king_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed
0.654 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 62
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.652 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 64
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.643 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 40 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 4 rows browsed
Useless GROUP BY need to be removed
0.642 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 42 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.64 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 44) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.64 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 209 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed
0.636 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 42) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.621 ms SELECT SQL_NO_CACHE * FROM `king_lang` a LEFT JOIN `king_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.619 ms SELECT SQL_NO_CACHE id_page_type FROM king_page_type WHERE name = 'manufacturer' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Page.php:96
1 row browsed
0.617 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.617 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 43) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.616 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM king_required_field
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1187
1 row browsed
0.615 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 34) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.615 ms SELECT SQL_NO_CACHE * FROM `king_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.614 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 44 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.609 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 33 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.608 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 209 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed
0.606 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 43 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.603 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 13 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.595 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 27) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.594 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 60 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.586 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 209 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed
0.586 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 41
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.585 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 62 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.583 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.578 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 35 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.576 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 38
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.572 ms SELECT SQL_NO_CACHE version FROM `king_module` WHERE name = 'paypal' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/paypal/paypal.php:281
1 row browsed
0.571 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 60
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.569 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1635
1 row browsed
0.568 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 41 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.562 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 15 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.562 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 61 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.56 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 14) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.555 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 27 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.554 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 45 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.55 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 6) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.548 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 20) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.548 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 13) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.546 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.546 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 36 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.545 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.544 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 28
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.542 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 9) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.538 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 21) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.538 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 36
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.534 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 38 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.527 ms SELECT SQL_NO_CACHE id_shop FROM `king_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed
0.525 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 8 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
0 rows browsed
0.525 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 27) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.524 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 40) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.522 ms SELECT SQL_NO_CACHE * FROM `king_megamenu_menus_context` WHERE `id_menu` = 3
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1076
1 row browsed
0.513 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 33) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.513 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 44 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.512 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 10) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.512 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 18) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.511 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 16 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.51 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 26) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.509 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 45) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.507 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.505 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 65
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.504 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 43 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.499 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.498 ms SELECT SQL_NO_CACHE * FROM `king_megamenu_menus_context` WHERE `id_menu` = 2
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1076
1 row browsed
0.494 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 42 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.494 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 32) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.494 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 19) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.492 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 21 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.491 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 209 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed
0.49 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 19 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.489 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `king_product` p INNER JOIN `king_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `king_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 210)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed
0.488 ms SELECT SQL_NO_CACHE * FROM `king_megamenu_menus_context` WHERE `id_menu` = 4
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1076
1 row browsed
0.483 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 26 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.482 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 7 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.481 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 15
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.481 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 7) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.48 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 63
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.479 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 35) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.478 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 18 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.478 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 35
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.478 ms SELECT SQL_NO_CACHE `reduction` FROM `king_group` WHERE `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Group.php:132
1 row browsed
0.477 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 210 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed
0.474 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 10 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.47 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.465 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 210 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed
0.465 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 9 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.465 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.463 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 6 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.462 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 63 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.461 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 12) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.46 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 45 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.459 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 14 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.458 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 32 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.457 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 2) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.456 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 31
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.456 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 27 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed
0.454 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 18
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.453 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
1 row browsed
0.453 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 16) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.45 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `king_product` p INNER JOIN `king_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `king_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 27)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed
0.445 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 210) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:362
1 row browsed
0.443 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.439 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 20 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.433 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 13
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.432 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 25) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.431 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 33
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.43 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 64) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed
0.428 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 25 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.428 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 41 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.427 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed
0.426 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 210 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed
0.424 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 42
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.424 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 16 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.42 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 3 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.418 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 16
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.408 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 209) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:362
1 row browsed
0.408 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 27 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed
0.406 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 2
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
4 rows browsed
0.404 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 26
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.401 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 27 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed
0.397 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 21
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.396 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 43
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.395 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 209 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed
0.393 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 27
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.39 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 45
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.39 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 210 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed
0.386 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 14
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.386 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 40
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.385 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 27 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed
0.381 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 34
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.38 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 7
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.379 ms SELECT SQL_NO_CACHE ctg.`id_group` FROM king_category_group ctg WHERE ctg.`id_category` = 2 AND ctg.`id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1066
1 row browsed
0.377 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 33 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.374 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 27 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed
0.367 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 6
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.366 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 8 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.362 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 7 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.362 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 7 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
0 rows browsed
0.361 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 32 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed
0.36 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 44
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.357 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 10
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.35 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 32
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.345 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 210 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed
0.343 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 12
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.341 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 19
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.339 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 9
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.338 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 210 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed
0.335 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed
0.33 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 25
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.329 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 20
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed
0.319 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 27 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed
0.308 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
0 rows browsed

Doubles (IDs replaced by "XX") (total = 23)

46 SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
39 SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = XX
39 SELECT * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XX WHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX
11 SELECT * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX
10 SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = XX LIMIT XX
8 SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
7 SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
7 SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = XX LIMIT XX
3 SELECT pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
3 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `king_specific_price` WHERE `id_product` IN (XX, XX) AND `id_product_attribute` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_customer` IN (XX, XX) AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND id_cart IN (XX, XX) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= IF(id_product_attribute=XX,XX ,XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT XX
3 SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
3 SELECT pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.`default_on` = XX AND pa.id_product = XX LIMIT XX
3 SELECT pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
3 SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3 SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = XX
3 SELECT pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
3 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `king_product` p INNER JOIN `king_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `king_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `king_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
3 SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX
2 SELECT m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) WHERE m.`active` = XX GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
2 SELECT COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = XX LIMIT XX
2 SELECT s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = XX INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE (s.`active` = XX) GROUP BY s.id_supplier ORDER BY s.`name` ASC
2 SELECT * FROM `king_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC

Tables stress

93 category_lang
87 category
85 category_shop
42 category_group
20 product_shop
17 product
17 product_attribute_shop
17 product_attribute
13 megamenu_menus_context
13 product_lang
10 image
10 image_shop
10 image_lang
8 megamenu_menus
6 hook
6 manufacturer
6 module
5 stock_available
4 manufacturer_shop
4 shop_url
4 manufacturer_lang
4 lang_shop
4 shop
4 currency_shop
4 hook_module
3 category_product
3 lang
3 country
3 module_shop
3 specific_price_priority
3 currency
3 specific_price
3 product_group_reduction_cache
2 supplier_shop
2 supplier_lang
2 tax_rule
2 country_lang
2 country_shop
2 meta_lang
2 meta
2 supplier
2 group
2 shop_group
2 hook_alias
1 page_type
1 connections
1 required_field
1 tax_lang
1 page
1 social_links
1 configuration_lang
1 configuration
1 theme
1 module_group
1 group_shop
1 autumn_slider
1 hook_module_exceptions
1 group_lang
1 tax

ObjectModel instances

66 Category
11 Product
2 Language
2 Manufacturer
2 Country
2 Address
1 Guest
1 Connection
1 Tax
1 Group
1 ShopGroup
1 Customer
1 Currency
1 Cart
1 Shop

Included files

1 ./index.php
2 config/config.inc.php
3 config/defines.inc.php
4 config/settings.inc.php
5 config/autoload.php
6 config/alias.php
7 classes/Autoload.php
8 cache/class_index.php
9 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 classes/db/Db.php
17 tools/profiling/Tools.php
18 classes/Tools.php
19 classes/Context.php
20 classes/shop/Shop.php
21 classes/db/DbPDO.php
22 classes/cache/Cache.php
23 classes/Validate.php
24 classes/db/DbQuery.php
25 config/defines_uri.inc.php
26 classes/Configuration.php
27 classes/Language.php
28 classes/Country.php
29 classes/Collection.php
30 classes/shop/ShopGroup.php
31 classes/Cookie.php
32 classes/Rijndael.php
33 classes/Customer.php
34 classes/Group.php
35 classes/Link.php
36 classes/shop/ShopUrl.php
37 config/smarty.config.inc.php
38 tools/smarty/Smarty.class.php
39 tools/smarty/sysplugins/smarty_internal_data.php
40 tools/smarty/sysplugins/smarty_internal_templatebase.php
41 tools/smarty/sysplugins/smarty_internal_template.php
42 tools/smarty/sysplugins/smarty_resource.php
43 tools/smarty/sysplugins/smarty_internal_resource_file.php
44 tools/smarty/sysplugins/smarty_cacheresource.php
45 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
46 config/smartyfront.config.inc.php
47 classes/Dispatcher.php
48 controllers/front/ManufacturerController.php
49 classes/controller/FrontController.php
50 themes/autumn/lang/fr.php
51 classes/Currency.php
52 classes/Cart.php
53 classes/CartRule.php
54 classes/Meta.php
55 classes/Product.php
56 classes/Manufacturer.php
57 classes/Media.php
58 classes/module/Module.php
59 modules/blockpaymentlogo/blockpaymentlogo.php
60 classes/Translate.php
61 themes/autumn/modules/blockpaymentlogo/translations/fr.php
62 modules/blockpaymentlogo/translations/fr.php
63 modules/blockcart/blockcart.php
64 themes/autumn/modules/blockcart/translations/fr.php
65 modules/blockcart/translations/fr.php
66 modules/autumnsearchblock/autumnsearchblock.php
67 themes/autumn/modules/autumnsearchblock/translations/fr.php
68 modules/autumnsearchblock/translations/fr.php
69 modules/blocksocial/blocksocial.php
70 themes/autumn/modules/blocksocial/translations/fr.php
71 modules/blocksocial/translations/fr.php
72 modules/blockmyaccount/blockmyaccount.php
73 themes/autumn/modules/blockmyaccount/translations/fr.php
74 modules/blockmyaccount/translations/fr.php
75 modules/blockcontact/blockcontact.php
76 themes/autumn/modules/blockcontact/translations/fr.php
77 modules/blockcontact/translations/fr.php
78 modules/blockspecials/blockspecials.php
79 themes/autumn/modules/blockspecials/translations/fr.php
80 modules/blockspecials/translations/fr.php
81 modules/blockcurrencies/blockcurrencies.php
82 themes/autumn/modules/blockcurrencies/translations/fr.php
83 modules/blockcurrencies/translations/fr.php
84 modules/blocknewproducts/blocknewproducts.php
85 themes/autumn/modules/blocknewproducts/translations/fr.php
86 modules/blocknewproducts/translations/fr.php
87 modules/blockmyaccountfooter/blockmyaccountfooter.php
88 themes/autumn/modules/blockmyaccountfooter/translations/fr.php
89 modules/blockmyaccountfooter/translations/fr.php
90 modules/blocklanguages/blocklanguages.php
91 themes/autumn/modules/blocklanguages/translations/fr.php
92 modules/blocklanguages/translations/fr.php
93 modules/blockmanufacturer/blockmanufacturer.php
94 themes/autumn/modules/blockmanufacturer/translations/fr.php
95 modules/blockmanufacturer/translations/fr.php
96 modules/blockcms/blockcms.php
97 modules/blockcms/BlockCMSModel.php
98 themes/autumn/modules/blockcms/translations/fr.php
99 modules/blockcms/translations/fr.php
100 modules/blocktags/blocktags.php
101 themes/autumn/modules/blocktags/translations/fr.php
102 modules/blocktags/translations/fr.php
103 modules/blockstore/blockstore.php
104 themes/autumn/modules/blockstore/translations/fr.php
105 modules/blockstore/translations/fr.php
106 modules/blockcontactinfos/blockcontactinfos.php
107 themes/autumn/modules/blockcontactinfos/translations/fr.php
108 modules/blockcontactinfos/translations/fr.php
109 modules/favoriteproducts/favoriteproducts.php
110 themes/autumn/modules/favoriteproducts/translations/fr.php
111 modules/favoriteproducts/translations/fr.php
112 tools/smarty/sysplugins/smarty_internal_smartytemplatecompiler.php
113 tools/smarty/sysplugins/smarty_internal_parsetree.php
114 tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php
115 tools/smarty/sysplugins/smarty_internal_templatelexer.php
116 tools/smarty/sysplugins/smarty_internal_templateparser.php
117 tools/smarty/sysplugins/smarty_internal_compile_private_print_expression.php
118 tools/smarty/sysplugins/smarty_internal_compilebase.php
119 tools/smarty/sysplugins/smarty_internal_compile_private_modifier.php
120 tools/smarty/sysplugins/smarty_internal_compile_private_special_variable.php
121 tools/smarty/sysplugins/smarty_internal_compile_if.php
122 tools/smarty/sysplugins/smarty_internal_write_file.php
123 cache/smarty/compile/2f/3a/f2/2f3af2a480eb0128149f5b839b39690e8c6fd0b2.file.favoriteproducts-header.tpl.php
124 tools/smarty/sysplugins/smarty_internal_filter_handler.php
125 tools/minify_html/minify_html.class.php
126 tools/js_minify/jsmin.php
127 modules/feeder/feeder.php
128 themes/autumn/modules/feeder/translations/fr.php
129 modules/feeder/translations/fr.php
130 tools/smarty/plugins/modifiercompiler.escape.php
131 tools/smarty/plugins/shared.literal_compiler_param.php
132 cache/smarty/compile/74/1d/23/741d238345960da9cf1b6def1060a9768582de8f.file.feederHeader.tpl.php
133 tools/smarty/plugins/modifier.escape.php
134 modules/blocklink/blocklink.php
135 themes/autumn/modules/blocklink/translations/fr.php
136 modules/blocklink/translations/fr.php
137 modules/productcomments/productcomments.php
138 themes/autumn/modules/productcomments/translations/fr.php
139 modules/productcomments/translations/fr.php
140 modules/sendtoafriend/sendtoafriend.php
141 themes/autumn/modules/sendtoafriend/translations/fr.php
142 modules/sendtoafriend/translations/fr.php
143 modules/productscategory/productscategory.php
144 themes/autumn/modules/productscategory/translations/fr.php
145 modules/productscategory/translations/fr.php
146 modules/autumnnewsletterblock/autumnnewsletterblock.php
147 themes/autumn/modules/autumnnewsletterblock/translations/fr.php
148 modules/autumnnewsletterblock/translations/fr.php
149 modules/autumnslider/autumnslider.php
150 themes/autumn/modules/autumnslider/translations/fr.php
151 modules/autumnslider/translations/fr.php
152 cache/smarty/compile/97/2f/22/972f22bf893aa0f16299ba7b2c128176e9789a4e.file.autumnslider.tpl.php
153 modules/crossselling/crossselling.php
154 themes/autumn/modules/crossselling/translations/fr.php
155 modules/crossselling/translations/fr.php
156 modules/blocklayered/blocklayered.php
157 themes/autumn/modules/blocklayered/translations/fr.php
158 modules/blocklayered/translations/fr.php
159 modules/blockuserinfo/blockuserinfo.php
160 themes/autumn/modules/blockuserinfo/translations/fr.php
161 modules/blockuserinfo/translations/fr.php
162 modules/autumnsocial/autumnsocial.php
163 themes/autumn/modules/autumnsocial/translations/fr.php
164 modules/autumnsocial/translations/fr.php
165 modules/blockcustomerprivacy/blockcustomerprivacy.php
166 themes/autumn/modules/blockcustomerprivacy/translations/fr.php
167 modules/blockcustomerprivacy/translations/fr.php
168 modules/blockwishlist/blockwishlist.php
169 themes/autumn/modules/blockwishlist/translations/fr.php
170 modules/blockwishlist/translations/fr.php
171 modules/mailalerts/mailalerts.php
172 modules/mailalerts/MailAlert.php
173 themes/autumn/modules/mailalerts/translations/fr.php
174 modules/mailalerts/translations/fr.php
175 modules/autumntheme/autumntheme.php
176 themes/autumn/modules/autumntheme/translations/fr.php
177 modules/autumntheme/translations/fr.php
178 modules/blockwishlist/WishList.php
179 modules/paypal/paypal.php
180 modules/paypal/api/paypal_lib.php
181 modules/paypal/api/paypal_connect.php
182 modules/paypal/api/CallApiPaypalPlus.php
183 modules/paypal/api/ApiPaypalPlus.php
184 modules/paypal/paypal_logos.php
185 modules/paypal/paypal_orders.php
186 modules/paypal/paypal_tools.php
187 modules/paypal/paypal_login/paypal_login.php
188 modules/paypal/paypal_login/PayPalLoginUser.php
189 modules/paypal/classes/PaypalCapture.php
190 modules/paypal/classes/AuthenticatePaymentMethods.php
191 modules/paypal/classes/PaypalPlusPui.php
192 classes/PaymentModule.php
193 themes/autumn/modules/paypal/translations/fr.php
194 modules/paypal/fr.php
195 cache/smarty/compile/ff/e0/a9/ffe0a9863534a7360b913ee44419bb4892ecc9e6.file.paypal.js.php
196 modules/ganalytics/ganalytics.php
197 modules/ganalytics/fr.php
198 modules/ganalytics/backward_compatibility/backward.php
199 modules/ganalytics/backward_compatibility/Display.php
200 tools/smarty/sysplugins/smarty_internal_compile_foreach.php
201 cache/smarty/compile/64/f9/a8/64f9a86987e60551de2d5032ed5dd5a7ed426e5a.file.header.tpl.php
202 modules/eicaptcha/eicaptcha.php
203 modules/eicaptcha/fr.php
204 tools/smarty/sysplugins/smarty_internal_compile_assign.php
205 tools/smarty/plugins/modifiercompiler.upper.php
206 cache/smarty/compile/64/73/08/647308aa914c6b51656592126c239c0406f8d828.file.blocklanguages.tpl.php
207 tools/smarty/sysplugins/smarty_internal_compile_private_registered_function.php
208 cache/smarty/compile/99/f2/8c/99f28c5e6321614bbeb130e4fdd9adae4e093ae7.file.blockuserinfo.tpl.php
209 tools/smarty/sysplugins/smarty_internal_compile_include.php
210 cache/smarty/compile/a4/a7/eb/a4a7eb09ff573253aa846210f079a8b1956f5f80.file.autumnsearchblock-top.tpl.php
211 cache/smarty/compile/c6/5d/96/c65d96bea6018012aac88af7e8ae772dfaef729e.file.autumnsearchblock-instantsearch.tpl.php
212 classes/Customization.php
213 tools/smarty/plugins/modifier.replace.php
214 tools/smarty/plugins/modifiercompiler.cat.php
215 cache/smarty/compile/65/c3/c3/65c3c3234273f45446ca8872b3c8b4489dd72d34.file.blockcart.tpl.php
216 modules/pagesnotfound/pagesnotfound.php
217 themes/autumn/modules/pagesnotfound/translations/fr.php
218 modules/pagesnotfound/translations/fr.php
219 modules/sekeywords/sekeywords.php
220 classes/module/ModuleGraph.php
221 themes/autumn/modules/sekeywords/translations/fr.php
222 modules/sekeywords/translations/fr.php
223 modules/autumnmegamenu/autumnmegamenu.php
224 themes/autumn/modules/autumnmegamenu/translations/fr.php
225 modules/autumnmegamenu/translations/fr.php
226 classes/Category.php
227 classes/Combination.php
228 classes/stock/StockAvailable.php
229 classes/tax/Tax.php
230 classes/Address.php
231 classes/SpecificPrice.php
232 classes/tax/TaxManagerFactory.php
233 modules/vatnumber/vatnumber.php
234 classes/tax/TaxManagerModule.php
235 themes/autumn/modules/vatnumber/translations/fr.php
236 modules/vatnumber/translations/fr.php
237 modules/vatnumber/VATNumberTaxManager.php
238 classes/tax/TaxManagerInterface.php
239 classes/tax/TaxRulesTaxManager.php
240 classes/tax/TaxCalculator.php
241 classes/GroupReduction.php
242 classes/Feature.php
243 classes/Supplier.php
244 cache/smarty/compile/9c/f9/3c/9cf93c284034e1e0502dcc878660242ecd8af503.file.autumnmegamenu.tpl.php
245 cache/smarty/cache/blockmyaccountfooter/1/1/8/61/9c/e8/619ce8da16923ad9cd240ed261c30f189abd2c69.blockmyaccountfooter.tpl.php
246 cache/smarty/cache/blockcms/2/1/1/8/03/35/2a/03352aa35363acc0eaa236e55d06ce14550a3754.blockcms.tpl.php
247 cache/smarty/cache/blockcontactinfos/1/1/8/36/6e/0f/366e0fc369355feb44a05413816994e55bd78fbf.blockcontactinfos.tpl.php
248 modules/statsdata/statsdata.php
249 themes/autumn/modules/statsdata/translations/fr.php
250 modules/statsdata/translations/fr.php
251 classes/Guest.php
252 classes/Connection.php
253 classes/Page.php
254 classes/ConnectionsSource.php
255 cache/smarty/compile/77/f1/9c/77f19c03ab85b3b550a9ab5cfbed374fb4fa81b9.file.autumnnewsletterblock_footer.tpl.php
256 cache/smarty/compile/32/3a/e1/323ae17c6ffaf7b387cc14ec82c19b4e04f54be2.file.manufacturer.tpl.php
257 cache/smarty/compile/c3/a7/00/c3a7006efaf5a5f09e828b3a979645469d5bbc06.file.breadcrumb.tpl.php
258 cache/smarty/compile/ce/1d/59/ce1d599fd302f4b4de2585b0c582a743e0b30e72.file.errors.tpl.php
259 cache/smarty/compile/51/2b/71/512b712b5b6287ba577727fb28bb1983f5dc8438.file.product-compare.tpl.php
260 cache/smarty/compile/07/35/28/073528ea9352e37f9dbf2122f1d94941a534eb48.file.product-sort.tpl.php
261 cache/smarty/compile/21/e1/1b/21e11be9f8ef63ae64e6be85c855fe347e8369e8.file.nbr-product-page.tpl.php
262 cache/smarty/compile/b8/9e/85/b89e8528e42ac73074182dfd633b0a177e04e1f7.file.product-view.tpl.php
263 tools/smarty/plugins/modifiercompiler.strip_tags.php
264 cache/smarty/compile/9c/b1/1f/9cb11f5b36ff191dd84240692d2f299cbeaa3d4c.file.product-list.tpl.php
265 tools/smarty/sysplugins/smarty_internal_compile_section.php
266 cache/smarty/compile/63/8b/0e/638b0ea7d5307d0d3942465314a4003147843c0d.file.pagination.tpl.php
267 cache/smarty/compile/b0/f2/81/b0f28185d9cd84211615bfe3c53f16be4075cbcd.file.layout.tpl.php
268 cache/smarty/compile/f4/a5/3c/f4a53cc40d6c333b1b64baa0b11c7330ada8094b.file.header.tpl.php
269 tools/smarty/plugins/modifier.capitalize.php
270 cache/smarty/compile/b6/13/2e/b6132e9064a6ca774d7e0647cdb6c5d5a391e077.file.footer.tpl.php