Retirer ce produit de mes favoris
Ajouter ce produit à mes favoris

BMC3 - Big Maki Cali Thon, Avocat, Mangue...(x8)

24,90 € TTC

Référence : BMC3

Création du chef !

Big Californien aux Thon, Avocat, Mangue, Daikon, Tomate,

Fromage & Confiture de figue.

(huit pièces et trois fois plus gros qu'un Cali classique)

En savoir plus
Commentaires

Big Cali Maki aux Thon, Avocat, Mangue, Daikon, Tomate, Fromage & Confiture de figue.

Aucun commentaire n'a été publié pour le moment.

10 autres produits dans la même catégorie :

Les clients qui ont acheté ce produit ont également acheté...

Load time: 1.816s
You'd better run your shop on a toaster

config: 48ms
constructor: 0ms
init: 62ms
checkAccess: 0ms
setMedia: 5ms
postProcess: 0ms
initHeader: 0ms
initContent: 974ms
initFooter: 35ms
display: 691ms

Hook processing: 981ms / 4.26 Mb

displayTop: 583ms / 1.06 Mb
displayHeader: 208ms / 2.5 Mb
displayProductTabContent: 53ms / 0.1 Mb
displayFooter: 35ms / 0.25 Mb
actionProductOutOfStock: 31ms / 0.09 Mb
displayLeftColumnProduct: 31ms / 0.03 Mb
displayProductButtons: 15ms / 0.02 Mb
displayProductTab: 9ms / 0.02 Mb
moduleRoutes: 8ms / 0.15 Mb
displayFooterProduct: 8ms / 0.04 Mb
displayLeftColumn: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
displayRightColumnProduct: 0ms / 0 Mb
actionFrontControllerSetMedia: 0ms / 0 Mb
actionObjectAddAfter: 0ms / 0 Mb
actionObjectAddBefore: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
actionObjectConnectionAddBefore: 0ms / 0 Mb
actionObjectGuestAddAfter: 0ms / 0 Mb
actionObjectGuestAddBefore: 0ms / 0 Mb
actionObjectConnectionAddAfter: 0ms / 0 Mb
displayRightColumn: 0ms / 0 Mb

Memory peak usage: 8.6 Mb

config: 1.41 Mb (1.5 Mb)
constructor: 0 Mb (1.5 Mb)
init: 1.46 Mb (3 Mb)
checkAccess: 0 Mb (3 Mb)
setMedia: 0.03 Mb (3 Mb)
postProcess: 0 Mb (3 Mb)
initHeader: 0 Mb (3 Mb)
initContent: 4.22 Mb (7.3 Mb)
initFooter: 0.26 Mb (7.7 Mb)
display: 0.67 Mb (8.6 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 286 queries
Time spent querying: 316ms

Included files: 286
Size of included files: 3.31 Mb

Globals (> 1 Ko only): 574 Ko

_MODULES ≈ 394.5 Ko
_LANG ≈ 103.5 Ko
context ≈ 58.7 Ko
_SERVER ≈ 6.2 Ko
_ENV ≈ 6.2 Ko
_MODULE ≈ 2.7 Ko

Go to Stopwatch
Go to Doubles
Go to Tables
Go to ObjectModels
Display queries table

Time (ms)	Rows	Query	Location	Filesort	Group By
7.856	11	SELECT 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	/classes/Category.php:659	Yes
5.887	1	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 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, cl.`name` AS category_default, DATEDIFF( p.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0 AS new FROM `king_accessory` LEFT JOIN `king_product` p ON p.`id_product` = `id_product_2` 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_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.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_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 (p.`id_manufacturer`= m.`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 `id_product_1` = 80 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	/classes/Product.php:3189	Yes
5.831	558	SELECT 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`	/classes/Hook.php:339	Yes
5.021	427	SELECT 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)	/classes/Configuration.php:116
3.986	233	SELECT 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	/classes/Hook.php:227
3.603	1	SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type` 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) LEFT JOIN king_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `king_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `king_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `king_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `king_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN king_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 80 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC	/classes/Product.php:3100	Yes	Yes
2.918	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 21	/classes/Category.php:1032
2.822	1	SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `king_attribute` a LEFT JOIN `king_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `king_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `king_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) INNER JOIN king_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 80	/classes/Product.php:5067
2.821	1	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')	/classes/ObjectModel.php:455
2.749	0	SELECT `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	/classes/Hook.php:130
2.666	1	SELECT * 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	/classes/ObjectModel.php:212
2.606	1	SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `king_product_comment_criterion` pcc LEFT JOIN `king_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `king_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 80) LEFT JOIN `king_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `king_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = 80) WHERE pccl.`id_lang` = 1 AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1 ) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion	/modules/productcomments/ProductCommentCriterion.php:185		Yes
2.59	3	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` = 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	/classes/Manufacturer.php:179	Yes	Yes
2.282	1	SELECT * 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	/classes/ObjectModel.php:212
2.257	1	SELECT * 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	/classes/ObjectModel.php:212
2.22	15	SELECT *, ( IF ('2022-12-08 23:46:43' >= `from` AND '2022-12-08 23:46:43' <= `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, 80) 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 '2022-12-08 23:46:43' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:43' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC	/classes/SpecificPrice.php:306	Yes
2.082	1	SELECT * FROM `king_product` a LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80) LIMIT 1	/classes/ObjectModel.php:212
2.008	1	SELECT pc.`id_product_comment`, (SELECT count() FROM `king_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful, (SELECT count() FROM `king_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `king_product_comment` pc LEFT JOIN `king_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = 80 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC	/modules/productcomments/ProductComment.php:114	Yes
2.002	1	SELECT * 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	/classes/ObjectModel.php:212
1.992	1	SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `king_product_comment` pc LEFT JOIN `king_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `king_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `king_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 80 AND pccl.`id_lang` = 1 AND pc.`validate` = 1	/modules/productcomments/ProductComment.php:168
1.99	1	SELECT pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite FROM `king_product` p LEFT JOIN `king_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 ) INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_lang` l ON (pl.`id_lang` = l.`id_lang`) LEFT JOIN `king_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 ) WHERE p.`id_product` = 80 AND l.`active` = 1	/classes/Product.php:4417
1.99	1	INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('93557', '170', '586128112', '', '1', '1', '2022-12-08 23:46:43')	/classes/ObjectModel.php:455
1.96	1	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 = 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` = 80)	/classes/Product.php:2673
1.959	1	SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `king_attribute` a LEFT JOIN `king_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) LEFT JOIN `king_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 80	/classes/Product.php:5005
1.913	1	SELECT * 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	/classes/ObjectModel.php:212
1.894	7	SELECT 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	/modules/autumnmegamenu/autumnmegamenu.php:1158	Yes
1.861	1	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 = 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` = 6)	/classes/Product.php:2673
1.852	93	SELECT 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	/classes/module/Module.php:171
1.835	15	SELECT *, ( IF ('2022-12-08 23:46:42' >= `from` AND '2022-12-08 23:46:42' <= `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, 80) 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 '2022-12-08 23:46:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:42' <= `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	/classes/SpecificPrice.php:243	Yes
1.833	1	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 = 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`	/classes/Product.php:2431	Yes
1.821	1	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 = 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`	/classes/Product.php:2431	Yes
1.82	1	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 = 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`	/classes/Product.php:2431	Yes
1.759	1	SELECT * 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	/classes/ObjectModel.php:212
1.725	1	SELECT * FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1	/modules/productcomments/ProductComment.php:137	Yes
1.707	1	SELECT 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	/classes/shop/Shop.php:622	Yes
1.685	1	SELECT * 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	/classes/ObjectModel.php:212
1.668	1	SELECT image_shop.`id_image` 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) WHERE i.`id_product` = 80 AND image_shop.`cover` = 1 LIMIT 1	/classes/Product.php:2451
1.643	3	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` = 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	/classes/Manufacturer.php:179	Yes	Yes
1.63	1	SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `king_category` c INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `king_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	/classes/Category.php:537	Yes	Yes
1.617	1	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 = 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`	/classes/Product.php:2431	Yes
1.609	1	SELECT * 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	/classes/Meta.php:144
1.606	1	SELECT 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	/classes/shop/Shop.php:320	Yes
1.582	26	SELECT 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	/classes/Dispatcher.php:426	Yes
1.5	1	SELECT * 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 = 6) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
1.5	1	SELECT `id_guest` FROM `king_connections` WHERE `id_guest` = 93557 AND `date_add` > '2022-12-08 23:16:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1	/classes/Connection.php:134	Yes
1.496	1	SELECT * 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	/classes/ObjectModel.php:212
1.483	1	SELECT * 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	/classes/ObjectModel.php:212
1.475	1	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` = 72 LIMIT 1	/classes/module/Module.php:1651
1.469	3	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` = 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	/classes/Supplier.php:122	Yes	Yes
1.454	1	SELECT * 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	/classes/ObjectModel.php:212
1.446	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
1.436	12	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 = 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	/classes/Category.php:727	Yes	Yes
1.434	1	SELECT * 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	/classes/ObjectModel.php:212
1.433	15	SELECT *, ( IF ('2022-12-08 23:46:42' >= `from` AND '2022-12-08 23:46:42' <= `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, 6) 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 '2022-12-08 23:46:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:42' <= `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	/classes/SpecificPrice.php:243	Yes
1.408	1	SELECT * 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	/classes/ObjectModel.php:212
1.378	1	SELECT * 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	/classes/tax/TaxRulesTaxManager.php:90	Yes
1.378	1	SELECT ctg.`id_group` FROM `king_category_product` cp INNER JOIN `king_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = 80 AND ctg.`id_group` = 1 LIMIT 1	/classes/Product.php:4324
1.375	1	SELECT * 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	/classes/Currency.php:219	Yes	Yes
1.373	1	SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `king_product` p LEFT JOIN `king_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 ) INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 1 AND pl.id_product = 80 AND product_shop.active = 1 LIMIT 1	/classes/Meta.php:252
1.351	1	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 = 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`	/classes/Product.php:2431	Yes
1.347	1	SELECT l.*, ls.`id_shop` FROM `king_lang` l LEFT JOIN `king_lang_shop` ls ON (l.id_lang = ls.id_lang)	/classes/Language.php:698
1.336	3	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` = 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	/classes/Supplier.php:122	Yes	Yes
1.318	6	SELECT `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	/modules/autumnslider/autumnslider.php:812	Yes
1.312	0	SELECT 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_product = 80 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0	/classes/Product.php:1131
1.302	1	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` = 72 LIMIT 1	/classes/module/Module.php:1651
1.282	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'large_Autumn' LIMIT 1	/classes/ImageType.php:141
1.278	1	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 = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 80 LIMIT 1	/classes/Product.php:642
1.273	1	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
1.265	1	SELECT * 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	/classes/ObjectModel.php:212
1.251	1	SELECT id_required_field, object_name, field_name FROM king_required_field	/classes/ObjectModel.php:1187
1.244	1	SELECT 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	/classes/Currency.php:445
1.206	1	SELECT * FROM `king_social_links` WHERE `id_shop` = 1	/modules/autumnsocial/autumnsocial.php:436
1.197	1	SELECT * FROM `king_product_lang` WHERE `id_product` = 80 AND `id_shop` = 1	/classes/ObjectModel.php:219
1.192	1	SELECT * 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	/classes/ObjectModel.php:212
1.189	5	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 = 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	/classes/Category.php:727	Yes	Yes
1.174	12	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 = 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	/classes/Category.php:727	Yes	Yes
1.172	1	SELECT 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	/classes/shop/Shop.php:199
1.16	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
1.155	86	SELECT * FROM `king_hook_alias`	/classes/Hook.php:182
1.153	1	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 = 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`	/classes/Product.php:2431	Yes
1.145	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 16	/classes/Category.php:1032
1.143	1	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 = 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`	/classes/Product.php:2431	Yes
1.136	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 32 LIMIT 1	/classes/Category.php:855
1.127	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockwishlist" LIMIT 1	/classes/module/Module.php:1888
1.125	2	SELECT id_page_type FROM king_page_type WHERE name = 'product' LIMIT 1	/classes/Page.php:96
1.118	1	SELECT * 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	/classes/ObjectModel.php:212
1.099	1	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 = 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	/classes/Category.php:727	Yes	Yes
1.094	1	SELECT COUNT(`id_product_comment`) AS "nbr" FROM `king_product_comment` pc WHERE `id_product` = 80 AND `validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:223
1.092	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blocklayered" LIMIT 1	/classes/module/Module.php:1888
1.092	1	SELECT * 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	/classes/ObjectModel.php:212
1.09	1	SELECT 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	/classes/Language.php:805
1.088	0	SELECT `name` FROM `king_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1 LIMIT 1	/classes/Manufacturer.php:241
1.076	1	SELECT * 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	/classes/ObjectModel.php:212
1.076	1	SELECT t.`id_lang`, t.`name` FROM king_tag t LEFT JOIN king_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=80	/classes/Tag.php:161
1.069	1	SELECT domain, domain_ssl FROM king_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	/classes/shop/ShopUrl.php:154
1.043	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 45 LIMIT 1	/classes/Category.php:855
1.042	41	SELECT c.id_category, cl.name, cl.link_rewrite FROM king_category c LEFT JOIN king_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) WHERE c.nleft <= 56 AND c.nright >= 57 AND c.nleft >= 2 AND c.nright <= 81 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC	/classes/Tools.php:982	Yes
1.036	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
1.027	1	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 = 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	/classes/Category.php:727	Yes	Yes
1.022	1	SELECT `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1	/classes/module/Module.php:1888
1.021	1	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 = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 6 LIMIT 1	/classes/Product.php:642
1.019	1	SELECT `id_page` FROM `king_page` WHERE `id_page_type` = 5 AND `id_object` = 80 LIMIT 1	/classes/Page.php:78
1.016	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 80 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
1.011	1	SELECT * 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	/classes/ObjectModel.php:212
1.008	1	SELECT * 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	/classes/ObjectModel.php:212
1.006	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
1.003	1	SELECT * 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	/classes/ObjectModel.php:212
1	1	SELECT * 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	/classes/ObjectModel.php:212
0.985	1	SELECT * FROM `king_country_lang` WHERE `id_country` = 8	/classes/ObjectModel.php:219
0.983	1	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 = 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`	/classes/Product.php:2431	Yes
0.974	0	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1	/classes/Category.php:855
0.97	4	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 = 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	/classes/Category.php:727	Yes	Yes
0.957	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1	/classes/Category.php:855
0.956	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.954	8	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 = 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	/classes/Category.php:727	Yes	Yes
0.948	1	SELECT * FROM `king_hook_module_exceptions` WHERE `id_shop` IN (1)	/classes/module/Module.php:1571
0.946	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 16 LIMIT 1	/classes/Category.php:855
0.944	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 61	/classes/Category.php:1032
0.942	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.929	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.928	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
0.928	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockcategories" LIMIT 1	/classes/module/Module.php:1888
0.923	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.918	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.917	1	SELECT * 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	/classes/ObjectModel.php:212
0.911	1	SELECT * 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	/classes/ObjectModel.php:212
0.907	1	SELECT * FROM `king_tax` a WHERE (a.id_tax = 2) LIMIT 1	/classes/ObjectModel.php:212
0.907	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.906	1	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 = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 80 LIMIT 1	/classes/Product.php:662
0.905	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.899	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.897	1	SELECT * 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	/classes/tax/TaxRulesTaxManager.php:90	Yes
0.896	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.896	1	SELECT * 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	/classes/ObjectModel.php:212
0.893	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 41 LIMIT 1	/classes/Category.php:855
0.892	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.889	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.888	1	SELECT * 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	/classes/ObjectModel.php:212
0.888	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.883	1	SELECT * 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	/classes/ObjectModel.php:212
0.883	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.881	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.879	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 2 LIMIT 1	/classes/Category.php:1227
0.875	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.869	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.868	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.861	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.861	1	SELECT * FROM `king_tax_lang` WHERE `id_tax` = 2	/classes/ObjectModel.php:219
0.861	1	SELECT * 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	/classes/ObjectModel.php:212
0.861	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.86	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.86	1	SELECT * 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	/classes/ObjectModel.php:212
0.86	1	SELECT * 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	/classes/ObjectModel.php:212
0.859	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.857	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.856	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.852	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1	/classes/Category.php:855
0.851	1	SELECT * 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	/classes/ObjectModel.php:212
0.841	1	SELECT * 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	/classes/ObjectModel.php:212
0.835	8	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 = 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	/classes/Category.php:727	Yes	Yes
0.827	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 6 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
0.827	1	SELECT * 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	/classes/ObjectModel.php:212
0.825	1	SELECT * 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	/classes/ObjectModel.php:212
0.815	0	SELECT `name` FROM `king_supplier` WHERE `id_supplier` = 0 LIMIT 1	/classes/Supplier.php:177
0.813	7	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 = 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	/classes/Category.php:727	Yes	Yes
0.812	0	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
0.808	1	SELECT * 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	/classes/ObjectModel.php:212
0.804	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.803	1	SELECT * FROM `king_shop` a WHERE (a.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.802	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 6) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
0.801	1	SELECT * 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	/classes/ObjectModel.php:212
0.799	1	SELECT * 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	/classes/ObjectModel.php:212
0.799	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 12	/classes/Category.php:1032
0.798	1	SELECT id_shop FROM `king_product_shop` WHERE `id_product` = 80 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.796	1	SELECT * FROM `king_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1	/classes/ObjectModel.php:212
0.791	3	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 = 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	/classes/Category.php:727	Yes	Yes
0.791	1	SELECT * 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	/classes/ObjectModel.php:212
0.79	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.788	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.782	1	SELECT * 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	/classes/ObjectModel.php:212
0.782	1	SELECT * 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	/classes/ObjectModel.php:212
0.78	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_large' LIMIT 1	/classes/ImageType.php:141
0.778	1	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 = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 6 LIMIT 1	/classes/Product.php:662
0.778	1	SELECT * 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	/classes/ObjectModel.php:212
0.77	1	SELECT * 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	/classes/ObjectModel.php:212
0.77	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.77	1	SELECT id_shop FROM `king_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.764	1	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 = 1) WHERE pa.id_product = 80 LIMIT 1	/classes/Product.php:652
0.764	1	SELECT * 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	/classes/ObjectModel.php:212
0.761	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 80 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.756	1	SELECT COUNT(pc.`id_product`) AS nbr FROM `king_product_comment` pc WHERE `id_product` = 80 AND `validate` = 1 AND `grade` > 0 LIMIT 1	/modules/productcomments/ProductComment.php:244
0.751	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 62	/classes/Category.php:1032
0.748	1	SELECT * FROM `king_group_lang` WHERE `id_group` = 1	/classes/ObjectModel.php:219
0.747	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 11	/classes/Category.php:1032
0.74	1	SELECT * 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	/classes/ObjectModel.php:212
0.738	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.737	1	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 = 1) WHERE pa.id_product = 80 LIMIT 1	/classes/Product.php:671
0.735	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.73	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.729	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.727	1	SELECT `reduction` FROM `king_group` WHERE `id_group` = 1 LIMIT 1	/classes/Group.php:132
0.721	1	SELECT * 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	/classes/ObjectModel.php:212
0.72	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.716	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.711	1	SELECT `id_country` FROM `king_country` WHERE `iso_code` = 'FR' LIMIT 1	/classes/Country.php:167
0.709	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.704	1	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 1	/classes/Category.php:1032
0.703	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.691	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.688	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 40	/classes/Category.php:1032
0.684	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 41	/classes/Category.php:1032
0.68	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.673	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 6	/classes/Category.php:1032
0.672	1	SELECT * 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	/classes/ObjectModel.php:212
0.672	1	SELECT id_shop FROM `king_category_shop` WHERE `id_category` = 9 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.672	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 80 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.666	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 9	/classes/Category.php:1032
0.665	1	SELECT * 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	/classes/ObjectModel.php:212
0.662	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 63	/classes/Category.php:1032
0.659	1	SELECT * 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	/classes/ObjectModel.php:212
0.658	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 10	/classes/Category.php:1032
0.657	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.657	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.656	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.654	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 33	/classes/Category.php:1032
0.654	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 20	/classes/Category.php:1032
0.653	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.651	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'home_default' LIMIT 1	/classes/Image.php:377
0.649	1	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 = 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	/classes/Category.php:727	Yes	Yes
0.646	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 31	/classes/Category.php:1032
0.644	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 7	/classes/Category.php:1032
0.635	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.635	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'home_Autumn' LIMIT 1	/classes/ImageType.php:141
0.634	1	SELECT * 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	/classes/ObjectModel.php:212
0.631	1	SELECT * 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	/classes/ObjectModel.php:212
0.63	1	SELECT version FROM `king_module` WHERE name = 'paypal' LIMIT 1	/modules/paypal/paypal.php:281
0.626	1	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 = 1) WHERE pa.id_product = 6 LIMIT 1	/classes/Product.php:671
0.625	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 65	/classes/Category.php:1032
0.624	1	SELECT * 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	/classes/ObjectModel.php:212
0.623	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 9 LIMIT 1	/classes/Category.php:1227
0.622	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 26	/classes/Category.php:1032
0.621	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'large_default' LIMIT 1	/classes/Image.php:377
0.62	1	SELECT * 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	/classes/ObjectModel.php:212
0.617	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'medium_Autumn' LIMIT 1	/classes/ImageType.php:141
0.614	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 25	/classes/Category.php:1032
0.614	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 13	/classes/Category.php:1032
0.61	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 18	/classes/Category.php:1032
0.605	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_home' LIMIT 1	/classes/ImageType.php:141
0.605	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'medium_default' LIMIT 1	/classes/Image.php:377
0.602	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 15	/classes/Category.php:1032
0.601	1	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 = 1) WHERE pa.id_product = 6 LIMIT 1	/classes/Product.php:652
0.599	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 27	/classes/Category.php:1032
0.588	1	SELECT * 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	/classes/ObjectModel.php:212
0.587	1	SELECT depends_on_stock FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:642
0.586	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 19	/classes/Category.php:1032
0.58	1	SELECT out_of_stock FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:665
0.578	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_medium' LIMIT 1	/classes/ImageType.php:141
0.578	1	SELECT ctg.`id_group` FROM king_category_group ctg WHERE ctg.`id_category` = 2 AND ctg.`id_group` = 1 LIMIT 1	/classes/Category.php:1066
0.577	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 14	/classes/Category.php:1032
0.576	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 32	/classes/Category.php:1032
0.573	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.572	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.564	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.557	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 64	/classes/Category.php:1032
0.556	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 2	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.546	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 6 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.536	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 35	/classes/Category.php:1032
0.535	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 4	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.526	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 36	/classes/Category.php:1032
0.508	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 45	/classes/Category.php:1032
0.502	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 34	/classes/Category.php:1032
0.502	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.498	4	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 2	/classes/Category.php:1032
0.496	1	SELECT id_shop FROM `king_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.494	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 60	/classes/Category.php:1032
0.49	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 42	/classes/Category.php:1032
0.484	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 38	/classes/Category.php:1032
0.475	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.465	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 28	/classes/Category.php:1032
0.457	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.456	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 44	/classes/Category.php:1032
0.452	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 43	/classes/Category.php:1032
0.443	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.429	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.406	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 3	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.402	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191

Stopwatch (with SQL_NO_CACHE) (total = 286)

7.856 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 - 11 rows browsed

5.887 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 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, cl.`name` AS category_default, DATEDIFF( p.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0 AS new FROM `king_accessory` LEFT JOIN `king_product` p ON p.`id_product` = `id_product_2` 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_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.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_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 (p.`id_manufacturer`= m.`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 `id_product_1` = 80 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product
in /home/cinquantl/www/kingsushi/classes/Product.php:3189
USING FILESORT - 1 row browsed

5.831 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 - 558 rows browsed

5.021 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.986 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
233 rows browsed

3.603 ms SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type` 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) LEFT JOIN king_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `king_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `king_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `king_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `king_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN king_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 80 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Product.php:3100
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

2.918 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

2.822 ms SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `king_attribute` a LEFT JOIN `king_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `king_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `king_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) INNER JOIN king_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 80
in /home/cinquantl/www/kingsushi/classes/Product.php:5067
1 row browsed

2.821 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.749 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

2.666 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

2.606 ms SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name` FROM `king_product_comment_criterion` pcc LEFT JOIN `king_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `king_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 80) LEFT JOIN `king_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `king_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = 80) WHERE pccl.`id_lang` = 1 AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1 ) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductCommentCriterion.php:185
1 row browsed
Useless GROUP BY need to be removed

2.59 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 - 3 rows browsed
Useless GROUP BY need to be removed

2.282 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

2.257 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

2.22 ms SELECT SQL_NO_CACHE *, ( IF ('2022-12-08 23:46:43' >= `from` AND '2022-12-08 23:46:43' <= `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, 80) 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 '2022-12-08 23:46:43' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:43' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:306
USING FILESORT - 15 rows browsed

2.082 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

2.008 ms SELECT SQL_NO_CACHE pc.`id_product_comment`, (SELECT count(*) FROM `king_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful, (SELECT count(*) FROM `king_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `king_product_comment` pc LEFT JOIN `king_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = 80 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:114
USING FILESORT - 1 row browsed

2.002 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

1.992 ms SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `king_product_comment` pc LEFT JOIN `king_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `king_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `king_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 80 AND pccl.`id_lang` = 1 AND pc.`validate` = 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:168
1 row browsed

1.99 ms SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite FROM `king_product` p LEFT JOIN `king_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 ) INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_lang` l ON (pl.`id_lang` = l.`id_lang`) LEFT JOIN `king_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 ) WHERE p.`id_product` = 80 AND l.`active` = 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4417
1 row browsed

1.99 ms INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('93557', '170', '586128112', '', '1', '1', '2022-12-08 23:46:43')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455

1.96 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` = 80)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed

1.959 ms SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `king_attribute` a LEFT JOIN `king_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `king_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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) LEFT JOIN `king_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 80
in /home/cinquantl/www/kingsushi/classes/Product.php:5005
1 row browsed

1.913 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

1.894 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.861 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` = 6)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed

1.852 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.835 ms SELECT SQL_NO_CACHE *, ( IF ('2022-12-08 23:46:42' >= `from` AND '2022-12-08 23:46:42' <= `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, 80) 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 '2022-12-08 23:46:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:42' <= `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 - 15 rows browsed

1.833 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

1.821 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.82 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

1.759 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.725 ms SELECT SQL_NO_CACHE * FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:137
USING FILESORT - 1 row browsed

1.707 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.685 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.668 ms SELECT SQL_NO_CACHE image_shop.`id_image` 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) WHERE i.`id_product` = 80 AND image_shop.`cover` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:2451
1 row browsed

1.643 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 - 3 rows browsed
Useless GROUP BY need to be removed

1.63 ms SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `king_category` c INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `king_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 9 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:537
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

1.617 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

1.609 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.606 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.582 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.5 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 = 6) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

1.5 ms SELECT SQL_NO_CACHE `id_guest` FROM `king_connections` WHERE `id_guest` = 93557 AND `date_add` > '2022-12-08 23:16: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

1.496 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

1.483 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.475 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.469 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 - 3 rows browsed
Useless GROUP BY need to be removed

1.454 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

1.446 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

1.436 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.434 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.433 ms SELECT SQL_NO_CACHE *, ( IF ('2022-12-08 23:46:42' >= `from` AND '2022-12-08 23:46:42' <= `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, 6) 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 '2022-12-08 23:46:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-12-08 23:46:42' <= `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 - 15 rows browsed

1.408 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.378 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.378 ms SELECT SQL_NO_CACHE ctg.`id_group` FROM `king_category_product` cp INNER JOIN `king_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = 80 AND ctg.`id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4324
1 row browsed

1.375 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.373 ms SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `king_product` p LEFT JOIN `king_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 ) INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 1 AND pl.id_product = 80 AND product_shop.active = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:252
1 row browsed

1.351 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

1.347 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.336 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 - 3 rows browsed
Useless GROUP BY need to be removed

1.318 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.312 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_product = 80 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /home/cinquantl/www/kingsushi/classes/Product.php:1131
0 rows browsed

1.302 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.282 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'large_Autumn' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

1.278 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 = 80 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed

1.273 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

1.265 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.251 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

1.244 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.206 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

1.197 ms SELECT SQL_NO_CACHE * FROM `king_product_lang` WHERE `id_product` = 80 AND `id_shop` = 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed

1.192 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

1.189 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

1.174 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.172 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.16 ms SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:180
1 row browsed

1.155 ms SELECT SQL_NO_CACHE * FROM `king_hook_alias`
in /home/cinquantl/www/kingsushi/classes/Hook.php:182
86 rows browsed

1.153 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

1.145 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

1.143 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

1.136 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

1.127 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

1.125 ms SELECT SQL_NO_CACHE id_page_type FROM king_page_type WHERE name = 'product' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Page.php:96
2 rows browsed

1.118 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

1.099 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

1.094 ms SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr" FROM `king_product_comment` pc WHERE `id_product` = 80 AND `validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:223
1 row browsed

1.092 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "blocklayered" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed

1.092 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

1.09 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

1.088 ms SELECT SQL_NO_CACHE `name` FROM `king_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:241
0 rows browsed

1.076 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

1.076 ms SELECT SQL_NO_CACHE t.`id_lang`, t.`name` FROM king_tag t LEFT JOIN king_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=80
in /home/cinquantl/www/kingsushi/classes/Tag.php:161
1 row browsed

1.069 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

1.043 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

1.042 ms SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite FROM king_category c LEFT JOIN king_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) WHERE c.nleft <= 56 AND c.nright >= 57 AND c.nleft >= 2 AND c.nright <= 81 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
in /home/cinquantl/www/kingsushi/classes/Tools.php:982
USING FILESORT - 41 rows browsed

1.036 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

1.027 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

1.022 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

1.021 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 = 6 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed

1.019 ms SELECT SQL_NO_CACHE `id_page` FROM `king_page` WHERE `id_page_type` = 5 AND `id_object` = 80 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Page.php:78
1 row browsed

1.016 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 80 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed

1.011 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

1.008 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.006 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:362
1 row browsed

1.003 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 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.985 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.983 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.974 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
0 rows browsed

0.97 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.957 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.956 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.954 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.948 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.946 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.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 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.929 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.928 ms SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 80 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:180
1 row browsed

0.928 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "blockcategories" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed

0.923 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.918 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.917 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.911 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.907 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.907 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.906 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 = 80 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed

0.905 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.899 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.897 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.896 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.896 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.893 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.892 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.889 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.888 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.888 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

0.883 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.883 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.881 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.879 ms SELECT SQL_NO_CACHE nleft, nright, level_depth FROM king_category WHERE id_category = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1227
1 row browsed

0.875 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.869 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.868 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.861 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.861 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.861 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.861 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.86 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.86 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.86 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.859 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.857 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.856 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.852 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.851 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.841 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.835 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.827 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 6 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed

0.827 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.825 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.815 ms SELECT SQL_NO_CACHE `name` FROM `king_supplier` WHERE `id_supplier` = 0 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Supplier.php:177
0 rows browsed

0.813 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

0.812 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1635
0 rows browsed

0.808 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.804 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

0.803 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.802 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 6) 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.801 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.799 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.799 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.798 ms SELECT SQL_NO_CACHE id_shop FROM `king_product_shop` WHERE `id_product` = 80 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

0.796 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 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.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 = 10) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.79 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.788 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.782 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.782 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.78 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_large' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

0.778 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 = 6 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed

0.778 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.77 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.77 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.77 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.764 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 = 80 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

0.764 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.761 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 80 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed

0.756 ms SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr FROM `king_product_comment` pc WHERE `id_product` = 80 AND `validate` = 1 AND `grade` > 0 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:244
1 row browsed

0.751 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.748 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.747 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.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 = 61) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.738 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.737 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 = 80 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

0.735 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.73 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.729 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.727 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.721 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.72 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.716 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.711 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.709 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.704 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.703 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.691 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed

0.688 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.684 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.68 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.673 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.672 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.672 ms SELECT SQL_NO_CACHE id_shop FROM `king_category_shop` WHERE `id_category` = 9 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

0.672 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 80 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed

0.666 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.665 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.662 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.659 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.658 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.657 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.657 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.656 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.654 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.654 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.653 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.651 ms SELECT SQL_NO_CACHE `width`, `height` FROM king_image_type WHERE `name` = 'home_default' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Image.php:377
1 row browsed

0.649 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.646 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.644 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.635 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.635 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'home_Autumn' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

0.634 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.631 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.63 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.626 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 = 6 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

0.625 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.624 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.623 ms SELECT SQL_NO_CACHE nleft, nright, level_depth FROM king_category WHERE id_category = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1227
1 row browsed

0.622 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.621 ms SELECT SQL_NO_CACHE `width`, `height` FROM king_image_type WHERE `name` = 'large_default' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Image.php:377
1 row browsed

0.62 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.617 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'medium_Autumn' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

0.614 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.614 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.61 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.605 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_home' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

0.605 ms SELECT SQL_NO_CACHE `width`, `height` FROM king_image_type WHERE `name` = 'medium_default' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Image.php:377
1 row browsed

0.602 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.601 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 = 6 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

0.599 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.588 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.587 ms SELECT SQL_NO_CACHE depends_on_stock FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:642
1 row browsed

0.586 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.58 ms SELECT SQL_NO_CACHE out_of_stock FROM `king_stock_available` WHERE (id_product = 80) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:665
1 row browsed

0.578 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'Autumn_medium' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
1 row browsed

0.578 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.577 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.576 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.573 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.572 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.564 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.557 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.556 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.546 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 6 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed

0.536 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.535 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.526 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.508 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.502 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.502 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.498 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.496 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.494 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.49 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.484 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.475 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.465 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.457 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

0.456 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.452 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.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.429 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.406 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.402 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

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

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

10 SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = XX LIMIT XX

9 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

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 `link` FROM king_megamenu_menus WHERE `id_menu` = XX LIMIT XX

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

3 SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = XX

2 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

2 SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX

2 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

2 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)

2 SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX

2 SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 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

2 SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX

2 SELECT nleft, nright, level_depth FROM king_category WHERE id_category = XX LIMIT XX

2 SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX

2 SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX

Tables stress

97 category_lang

89 category

87 category_shop

42 category_group

21 product_shop

17 product

14 product_lang

14 product_attribute

14 product_attribute_shop

13 megamenu_menus_context

11 image_shop

11 image

10 image_lang

9 image_type

8 module

8 megamenu_menus

7 stock_available

7 product_comment

6 hook

5 manufacturer

4 shop_url

4 currency_shop

4 lang_shop

4 hook_module

4 module_shop

4 lang

4 shop

3 country

3 specific_price

3 product_attribute_combination

3 attribute

3 supplier

3 currency

2 attribute_group_lang

2 attribute_shop

2 manufacturer_lang

2 attribute_lang

2 product_comment_criterion_lang

2 supplier_lang

2 product_comment_criterion

2 manufacturer_shop

2 supplier_shop

2 product_comment_usefulness

2 meta

2 category_product

2 hook_alias

2 shop_group

2 country_lang

2 country_shop

2 group

2 meta_lang

2 product_group_reduction_cache

2 tax_rule

2 specific_price_priority

1 accessory

1 connections

1 page_type

1 page

1 product_comment_criterion_product

1 customer

1 product_comment_criterion_category

1 required_field

1 product_comment_grade

1 layered_indexable_attribute_lang_value

1 tag

1 module_group

1 group_shop

1 configuration_lang

1 configuration

1 theme

1 group_lang

1 tax

1 autumn_slider

1 social_links

1 hook_module_exceptions

1 product_tag

1 tax_lang

1 attribute_group

ObjectModel instances

69 Category

13 Product

9 Address

2 Language

2 Country

1 Tax

1 Guest

1 Group

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/ProductController.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/Category.php
57 classes/Manufacturer.php
58 classes/Supplier.php
59 classes/Address.php
60 classes/tax/TaxManagerFactory.php
61 classes/module/Module.php
62 modules/vatnumber/vatnumber.php
63 classes/tax/TaxManagerModule.php
64 classes/Translate.php
65 themes/autumn/modules/vatnumber/translations/fr.php
66 modules/vatnumber/translations/fr.php
67 modules/vatnumber/VATNumberTaxManager.php
68 classes/tax/TaxManagerInterface.php
69 classes/tax/TaxRulesTaxManager.php
70 classes/tax/Tax.php
71 classes/tax/TaxCalculator.php
72 classes/Combination.php
73 classes/SpecificPrice.php
74 classes/GroupReduction.php
75 classes/Tag.php
76 classes/stock/StockAvailable.php
77 classes/Media.php
78 modules/blockpaymentlogo/blockpaymentlogo.php
79 themes/autumn/modules/blockpaymentlogo/translations/fr.php
80 modules/blockpaymentlogo/translations/fr.php
81 modules/blockcart/blockcart.php
82 themes/autumn/modules/blockcart/translations/fr.php
83 modules/blockcart/translations/fr.php
84 modules/autumnsearchblock/autumnsearchblock.php
85 themes/autumn/modules/autumnsearchblock/translations/fr.php
86 modules/autumnsearchblock/translations/fr.php
87 modules/blocksocial/blocksocial.php
88 themes/autumn/modules/blocksocial/translations/fr.php
89 modules/blocksocial/translations/fr.php
90 modules/blockmyaccount/blockmyaccount.php
91 themes/autumn/modules/blockmyaccount/translations/fr.php
92 modules/blockmyaccount/translations/fr.php
93 modules/blockcontact/blockcontact.php
94 themes/autumn/modules/blockcontact/translations/fr.php
95 modules/blockcontact/translations/fr.php
96 modules/blockspecials/blockspecials.php
97 themes/autumn/modules/blockspecials/translations/fr.php
98 modules/blockspecials/translations/fr.php
99 modules/blockcurrencies/blockcurrencies.php
100 themes/autumn/modules/blockcurrencies/translations/fr.php
101 modules/blockcurrencies/translations/fr.php
102 modules/blocknewproducts/blocknewproducts.php
103 themes/autumn/modules/blocknewproducts/translations/fr.php
104 modules/blocknewproducts/translations/fr.php
105 modules/blockmyaccountfooter/blockmyaccountfooter.php
106 themes/autumn/modules/blockmyaccountfooter/translations/fr.php
107 modules/blockmyaccountfooter/translations/fr.php
108 modules/blocklanguages/blocklanguages.php
109 themes/autumn/modules/blocklanguages/translations/fr.php
110 modules/blocklanguages/translations/fr.php
111 modules/blockmanufacturer/blockmanufacturer.php
112 themes/autumn/modules/blockmanufacturer/translations/fr.php
113 modules/blockmanufacturer/translations/fr.php
114 modules/blockcms/blockcms.php
115 modules/blockcms/BlockCMSModel.php
116 themes/autumn/modules/blockcms/translations/fr.php
117 modules/blockcms/translations/fr.php
118 modules/blocktags/blocktags.php
119 themes/autumn/modules/blocktags/translations/fr.php
120 modules/blocktags/translations/fr.php
121 modules/blockstore/blockstore.php
122 themes/autumn/modules/blockstore/translations/fr.php
123 modules/blockstore/translations/fr.php
124 modules/blockcontactinfos/blockcontactinfos.php
125 themes/autumn/modules/blockcontactinfos/translations/fr.php
126 modules/blockcontactinfos/translations/fr.php
127 modules/favoriteproducts/favoriteproducts.php
128 themes/autumn/modules/favoriteproducts/translations/fr.php
129 modules/favoriteproducts/translations/fr.php
130 tools/smarty/sysplugins/smarty_internal_smartytemplatecompiler.php
131 tools/smarty/sysplugins/smarty_internal_parsetree.php
132 tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php
133 tools/smarty/sysplugins/smarty_internal_templatelexer.php
134 tools/smarty/sysplugins/smarty_internal_templateparser.php
135 tools/smarty/sysplugins/smarty_internal_compile_private_print_expression.php
136 tools/smarty/sysplugins/smarty_internal_compilebase.php
137 tools/smarty/sysplugins/smarty_internal_compile_private_modifier.php
138 tools/smarty/sysplugins/smarty_internal_compile_private_special_variable.php
139 tools/smarty/sysplugins/smarty_internal_compile_if.php
140 tools/smarty/sysplugins/smarty_internal_write_file.php
141 cache/smarty/compile/2f/3a/f2/2f3af2a480eb0128149f5b839b39690e8c6fd0b2.file.favoriteproducts-header.tpl.php
142 tools/smarty/sysplugins/smarty_internal_filter_handler.php
143 tools/minify_html/minify_html.class.php
144 tools/js_minify/jsmin.php
145 modules/feeder/feeder.php
146 themes/autumn/modules/feeder/translations/fr.php
147 modules/feeder/translations/fr.php
148 tools/smarty/plugins/modifiercompiler.escape.php
149 tools/smarty/plugins/shared.literal_compiler_param.php
150 cache/smarty/compile/74/1d/23/741d238345960da9cf1b6def1060a9768582de8f.file.feederHeader.tpl.php
151 tools/smarty/plugins/modifier.escape.php
152 modules/blocklink/blocklink.php
153 themes/autumn/modules/blocklink/translations/fr.php
154 modules/blocklink/translations/fr.php
155 modules/productcomments/productcomments.php
156 themes/autumn/modules/productcomments/translations/fr.php
157 modules/productcomments/translations/fr.php
158 modules/sendtoafriend/sendtoafriend.php
159 themes/autumn/modules/sendtoafriend/translations/fr.php
160 modules/sendtoafriend/translations/fr.php
161 modules/productscategory/productscategory.php
162 themes/autumn/modules/productscategory/translations/fr.php
163 modules/productscategory/translations/fr.php
164 modules/autumnnewsletterblock/autumnnewsletterblock.php
165 themes/autumn/modules/autumnnewsletterblock/translations/fr.php
166 modules/autumnnewsletterblock/translations/fr.php
167 modules/autumnslider/autumnslider.php
168 themes/autumn/modules/autumnslider/translations/fr.php
169 modules/autumnslider/translations/fr.php
170 cache/smarty/compile/97/2f/22/972f22bf893aa0f16299ba7b2c128176e9789a4e.file.autumnslider.tpl.php
171 modules/crossselling/crossselling.php
172 themes/autumn/modules/crossselling/translations/fr.php
173 modules/crossselling/translations/fr.php
174 modules/blocklayered/blocklayered.php
175 themes/autumn/modules/blocklayered/translations/fr.php
176 modules/blocklayered/translations/fr.php
177 modules/blockuserinfo/blockuserinfo.php
178 themes/autumn/modules/blockuserinfo/translations/fr.php
179 modules/blockuserinfo/translations/fr.php
180 modules/autumnsocial/autumnsocial.php
181 themes/autumn/modules/autumnsocial/translations/fr.php
182 modules/autumnsocial/translations/fr.php
183 modules/blockcustomerprivacy/blockcustomerprivacy.php
184 themes/autumn/modules/blockcustomerprivacy/translations/fr.php
185 modules/blockcustomerprivacy/translations/fr.php
186 modules/blockwishlist/blockwishlist.php
187 themes/autumn/modules/blockwishlist/translations/fr.php
188 modules/blockwishlist/translations/fr.php
189 modules/mailalerts/mailalerts.php
190 modules/mailalerts/MailAlert.php
191 themes/autumn/modules/mailalerts/translations/fr.php
192 modules/mailalerts/translations/fr.php
193 modules/autumntheme/autumntheme.php
194 themes/autumn/modules/autumntheme/translations/fr.php
195 modules/autumntheme/translations/fr.php
196 modules/blockwishlist/WishList.php
197 modules/paypal/paypal.php
198 modules/paypal/api/paypal_lib.php
199 modules/paypal/api/paypal_connect.php
200 modules/paypal/api/CallApiPaypalPlus.php
201 modules/paypal/api/ApiPaypalPlus.php
202 modules/paypal/paypal_logos.php
203 modules/paypal/paypal_orders.php
204 modules/paypal/paypal_tools.php
205 modules/paypal/paypal_login/paypal_login.php
206 modules/paypal/paypal_login/PayPalLoginUser.php
207 modules/paypal/classes/PaypalCapture.php
208 modules/paypal/classes/AuthenticatePaymentMethods.php
209 modules/paypal/classes/PaypalPlusPui.php
210 classes/PaymentModule.php
211 themes/autumn/modules/paypal/translations/fr.php
212 modules/paypal/fr.php
213 cache/smarty/compile/ff/e0/a9/ffe0a9863534a7360b913ee44419bb4892ecc9e6.file.paypal.js.php
214 modules/ganalytics/ganalytics.php
215 modules/ganalytics/fr.php
216 modules/ganalytics/backward_compatibility/backward.php
217 modules/ganalytics/backward_compatibility/Display.php
218 tools/smarty/sysplugins/smarty_internal_compile_foreach.php
219 cache/smarty/compile/64/f9/a8/64f9a86987e60551de2d5032ed5dd5a7ed426e5a.file.header.tpl.php
220 modules/eicaptcha/eicaptcha.php
221 modules/eicaptcha/fr.php
222 tools/smarty/sysplugins/smarty_internal_compile_assign.php
223 tools/smarty/plugins/modifiercompiler.upper.php
224 cache/smarty/compile/64/73/08/647308aa914c6b51656592126c239c0406f8d828.file.blocklanguages.tpl.php
225 tools/smarty/sysplugins/smarty_internal_compile_private_registered_function.php
226 cache/smarty/compile/99/f2/8c/99f28c5e6321614bbeb130e4fdd9adae4e093ae7.file.blockuserinfo.tpl.php
227 tools/smarty/sysplugins/smarty_internal_compile_include.php
228 cache/smarty/compile/a4/a7/eb/a4a7eb09ff573253aa846210f079a8b1956f5f80.file.autumnsearchblock-top.tpl.php
229 cache/smarty/compile/c6/5d/96/c65d96bea6018012aac88af7e8ae772dfaef729e.file.autumnsearchblock-instantsearch.tpl.php
230 classes/Customization.php
231 tools/smarty/plugins/modifier.replace.php
232 tools/smarty/plugins/modifiercompiler.cat.php
233 cache/smarty/compile/65/c3/c3/65c3c3234273f45446ca8872b3c8b4489dd72d34.file.blockcart.tpl.php
234 modules/pagesnotfound/pagesnotfound.php
235 themes/autumn/modules/pagesnotfound/translations/fr.php
236 modules/pagesnotfound/translations/fr.php
237 modules/sekeywords/sekeywords.php
238 classes/module/ModuleGraph.php
239 themes/autumn/modules/sekeywords/translations/fr.php
240 modules/sekeywords/translations/fr.php
241 modules/autumnmegamenu/autumnmegamenu.php
242 themes/autumn/modules/autumnmegamenu/translations/fr.php
243 modules/autumnmegamenu/translations/fr.php
244 classes/Feature.php
245 cache/smarty/compile/9c/f9/3c/9cf93c284034e1e0502dcc878660242ecd8af503.file.autumnmegamenu.tpl.php
246 classes/Pack.php
247 classes/ProductDownload.php
248 cache/smarty/cache/productscategory/80/9/1/1/8/6b/1a/c4/6b1ac4149a2d2f1722dad9932a635554b91ba1c1.productscategory.tpl.php
249 cache/smarty/cache/crossselling/productfooter/80/1/1/8/f7/22/c2/f722c2dbc51f88893952ec4b5f29476157628d59.crossselling.tpl.php
250 classes/Image.php
251 classes/ImageType.php
252 modules/favoriteproducts/FavoriteProduct.php
253 cache/smarty/compile/ff/4a/f1/ff4af1b9c12ef4736bd9ac2e164c67ac228d616c.file.favoriteproducts-extra.tpl.php
254 modules/productcomments/ProductComment.php
255 modules/productcomments/ProductCommentCriterion.php
256 tools/smarty/sysplugins/smarty_internal_compile_section.php
257 cache/smarty/compile/44/a3/e2/44a3e25b561aaf73b4c617d5831daead5f71a7b9.file.productcomments-extra.tpl.php
258 cache/smarty/compile/3f/07/9c/3f079c6a9e57c116952a69c4586f9b0debc15960.file.blockwishlist-extra.tpl.php
259 cache/smarty/compile/a9/dd/ce/a9ddcea780046f44b44e95e46a83334de54f2209.file.tab.tpl.php
260 cache/smarty/compile/77/a8/e5/77a8e5108f84b334649960ba9d8d1d5d533acff7.file.productcomments.tpl.php
261 cache/smarty/cache/blockmyaccountfooter/1/1/8/61/9c/e8/619ce8da16923ad9cd240ed261c30f189abd2c69.blockmyaccountfooter.tpl.php
262 cache/smarty/cache/blockcms/2/1/1/8/03/35/2a/03352aa35363acc0eaa236e55d06ce14550a3754.blockcms.tpl.php
263 cache/smarty/cache/blockcontactinfos/1/1/8/36/6e/0f/366e0fc369355feb44a05413816994e55bd78fbf.blockcontactinfos.tpl.php
264 modules/statsdata/statsdata.php
265 themes/autumn/modules/statsdata/translations/fr.php
266 modules/statsdata/translations/fr.php
267 classes/Guest.php
268 classes/Connection.php
269 classes/Page.php
270 classes/ConnectionsSource.php
271 cache/smarty/compile/77/f1/9c/77f19c03ab85b3b550a9ab5cfbed374fb4fa81b9.file.autumnnewsletterblock_footer.tpl.php
272 tools/smarty/plugins/modifiercompiler.default.php
273 tools/smarty/plugins/modifier.date_format.php
274 tools/smarty/sysplugins/smarty_internal_compile_ldelim.php
275 tools/smarty/sysplugins/smarty_internal_compile_rdelim.php
276 tools/smarty/plugins/function.math.php
277 tools/smarty/sysplugins/smarty_internal_compile_private_function_plugin.php
278 tools/smarty/plugins/function.counter.php
279 cache/smarty/compile/e8/a3/04/e8a304c463b9d88519d69cde800c1b1bc7c022c8.file.product.tpl.php
280 cache/smarty/compile/ce/1d/59/ce1d599fd302f4b4de2585b0c582a743e0b30e72.file.errors.tpl.php
281 tools/smarty/plugins/shared.make_timestamp.php
282 cache/smarty/compile/c3/a7/00/c3a7006efaf5a5f09e828b3a979645469d5bbc06.file.breadcrumb.tpl.php
283 cache/smarty/compile/b0/f2/81/b0f28185d9cd84211615bfe3c53f16be4075cbcd.file.layout.tpl.php
284 cache/smarty/compile/f4/a5/3c/f4a53cc40d6c333b1b64baa0b11c7330ada8094b.file.header.tpl.php
285 tools/smarty/plugins/modifier.capitalize.php
286 cache/smarty/compile/b6/13/2e/b6132e9064a6ca774d7e0647cdb6c5d5a391e077.file.footer.tpl.php

Panier

BMC3 - Big Maki Cali Thon, Avocat, Mangue...(x8)

Création du chef !

Big Californien aux Thon, Avocat, Mangue, Daikon, Tomate,

Fromage & Confiture de figue.

(huit pièces et trois fois plus gros qu'un Cali classique)

Donner votre avis

Création du chef !

Big Californien aux Thon, Avocat, Mangue, Daikon, Tomate,

Fromage & Confiture de figue.

(huit pièces et trois fois plus gros qu'un Cali classique)

10 autres produits dans la même catégorie :

Les clients qui ont acheté ce produit ont également acheté...

Mon compte

Information

Contactez-nous

Newsletter

Stopwatch (with SQL_NO_CACHE) (total = 286)

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

Tables stress

ObjectModel instances

Included files