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

Exquise de Foie Gras & Magret de Canard

20,90 € TTC

Référence : P80

14 pièces

OFFERT : Gingembre + Wasabi + Sauces

Commentaires

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

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

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

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

config: 62ms
constructor: 0ms
init: 58ms
checkAccess: 0ms
setMedia: 5ms
postProcess: 0ms
initHeader: 0ms
initContent: 1.149s
initFooter: 52ms
display: 859ms

Hook processing: 1.185s / 4.56 Mb

displayTop: 617ms / 1.09 Mb
displayHeader: 342ms / 2.72 Mb
displayProductTabContent: 57ms / 0.1 Mb
displayFooter: 52ms / 0.27 Mb
actionProductOutOfStock: 34ms / 0.09 Mb
displayFooterProduct: 32ms / 0.04 Mb
displayProductButtons: 18ms / 0.03 Mb
displayLeftColumnProduct: 17ms / 0.03 Mb
displayProductTab: 8ms / 0.03 Mb
moduleRoutes: 6ms / 0.15 Mb
displayLeftColumn: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
actionFrontControllerSetMedia: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
actionObjectAddBefore: 0ms / 0 Mb
actionObjectAddAfter: 0ms / 0 Mb
displayRightColumnProduct: 0ms / 0 Mb
actionObjectGuestAddBefore: 0ms / 0 Mb
actionObjectConnectionAddAfter: 0ms / 0 Mb
actionObjectGuestAddAfter: 0ms / 0 Mb
actionObjectConnectionAddBefore: 0ms / 0 Mb
displayRightColumn: 0ms / 0 Mb

Memory peak usage: 9.2 Mb

config: 1.53 Mb (1.6 Mb)
constructor: 0 Mb (1.6 Mb)
init: 1.62 Mb (3.2 Mb)
checkAccess: 0 Mb (3.2 Mb)
setMedia: 0.03 Mb (3.2 Mb)
postProcess: 0 Mb (3.2 Mb)
initHeader: 0 Mb (3.2 Mb)
initContent: 4.52 Mb (7.9 Mb)
initFooter: 0.28 Mb (8.4 Mb)
display: 0.68 Mb (9.2 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 289 queries
Time spent querying: 191ms

Included files: 286
Size of included files: 3.31 Mb

Globals (> 1 Ko only): 578 Ko

_MODULES ≈ 394.2 Ko
_LANG ≈ 103.6 Ko
context ≈ 63.3 Ko
_SERVER ≈ 5.8 Ko
_ENV ≈ 5.8 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
4.398	33	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
4.297	93	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	Yes
4.031	93	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
3.314	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
3.078	9	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.989	9	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
2.787	9	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.611	9	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
2.579	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` = 230 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	/classes/Product.php:3189	Yes
2.54	1	SELECT `id_guest` FROM `king_connections` WHERE `id_guest` = 100741 AND `date_add` > '2021-10-21 16:43:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1	/classes/Connection.php:134	Yes
2.432	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.303	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 = 230 LIMIT 1	/classes/Product.php:642
2.059	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.839	1	INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('100741', '298', '598530478', '', '1', '1', '2021-10-21 17:13:53')	/classes/ObjectModel.php:455
1.831	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
1.768	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
1.628	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` = 60 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.608	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` = 230 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
1.607	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 = 230 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0	/classes/Product.php:1131
1.305	33	SELECT *, ( IF ('2021-10-21 17:13:53' >= `from` AND '2021-10-21 17:13:53' <= `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, 230) AND `id_shop` IN(0, 1) AND `id_currency` IN(0, 1) AND `id_country` IN(0, 8) AND `id_group` IN(0, 1) AND `id_customer` IN(0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC	/classes/SpecificPrice.php:306	Yes
1.104	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.096	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` = 230) 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 = 230) 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
1.047	1	SELECT id_required_field, object_name, field_name FROM king_required_field	/classes/ObjectModel.php:1187
0.99	2	SELECT id_page_type FROM king_page_type WHERE name = 'product' LIMIT 1	/classes/Page.php:96
0.979	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
0.971	1	SELECT `id_page` FROM `king_page` WHERE `id_page_type` = 5 AND `id_object` = 230 LIMIT 1	/classes/Page.php:78
0.97	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` = 230 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC	/modules/productcomments/ProductComment.php:114	Yes
0.96	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
0.955	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
0.939	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
0.874	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 = 230 AND product_shop.active = 1 LIMIT 1	/classes/Meta.php:252
0.863	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.858	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
0.824	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
0.821	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.816	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.814	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.802	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
0.798	1	SELECT * FROM `king_product_comment` pc WHERE pc.`id_product` = 230 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1	/modules/productcomments/ProductComment.php:137	Yes
0.77	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
0.76	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
0.759	33	SELECT *, ( IF ('2021-10-21 17:13:53' >= `from` AND '2021-10-21 17:13:53' <= `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, 22) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' <= `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
0.754	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
0.753	33	SELECT *, ( IF ('2021-10-21 17:13:52' >= `from` AND '2021-10-21 17:13:52' <= `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, 230) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:52' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:52' <= `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
0.753	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.751	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` = 230 ORDER BY `position`	/classes/Product.php:2431	Yes
0.75	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` = 230	/classes/Product.php:5005
0.733	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
0.729	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` = 230 AND pccl.`id_lang` = 1 AND pc.`validate` = 1	/modules/productcomments/ProductComment.php:168
0.725	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
0.724	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.716	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
0.697	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
0.687	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
0.684	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
0.683	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
0.683	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
0.681	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
0.671	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.663	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
0.662	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 = 230) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.658	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` = 230	/classes/Product.php:5067
0.658	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
0.657	86	SELECT * FROM `king_hook_alias`	/classes/Hook.php:182
0.657	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 = 22) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.643	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.638	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 = 230) LIMIT 1	/classes/ObjectModel.php:212
0.637	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
0.635	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.624	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
0.623	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.62	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.619	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.616	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.611	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.611	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
0.608	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.605	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.601	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.601	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.593	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.591	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.587	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.584	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.583	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
0.583	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.579	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
0.578	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 27	/classes/Category.php:1032
0.572	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.568	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.568	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.564	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
0.563	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.56	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.559	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.558	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.558	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
0.556	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.553	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`=230	/classes/Tag.php:161
0.553	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.552	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.551	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.55	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 230 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
0.549	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.548	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
0.545	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
0.543	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` = 248 ORDER BY `position`	/classes/Product.php:2431	Yes
0.542	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.541	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
0.539	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.539	0	SELECT `name` FROM `king_supplier` WHERE `id_supplier` = 0 LIMIT 1	/classes/Supplier.php:177
0.537	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` = 22)	/classes/Product.php:2673
0.537	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
0.536	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.536	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.535	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` = 230 AND ctg.`id_group` = 1 LIMIT 1	/classes/Product.php:4324
0.534	1	SELECT * FROM `king_social_links` WHERE `id_shop` = 1	/modules/autumnsocial/autumnsocial.php:436
0.534	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.533	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.533	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
0.533	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.531	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.53	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` = 230 AND l.`active` = 1	/classes/Product.php:4417
0.526	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.526	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.526	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.525	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.523	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.523	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.523	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
0.52	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.519	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 18	/classes/Category.php:1032
0.518	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 15	/classes/Category.php:1032
0.515	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.514	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.513	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.512	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 <= 18 AND c.nright >= 19 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
0.512	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.512	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.512	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.511	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.511	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.506	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.505	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.505	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.504	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
0.504	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
0.504	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
0.503	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.502	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.502	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
0.501	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
0.501	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.5	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'large_default' LIMIT 1	/classes/Image.php:377
0.5	0	SELECT `name` FROM `king_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1 LIMIT 1	/classes/Manufacturer.php:241
0.499	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.494	1	SELECT * FROM `king_tax` a WHERE (a.id_tax = 2) LIMIT 1	/classes/ObjectModel.php:212
0.494	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.493	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.491	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.491	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.49	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
0.49	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` = 230 AND image_shop.`cover` = 1 LIMIT 1	/classes/Product.php:2451
0.489	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
0.488	1	SELECT * FROM `king_group_lang` WHERE `id_group` = 1	/classes/ObjectModel.php:219
0.487	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 7	/classes/Category.php:1032
0.486	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.486	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.486	1	SELECT * FROM `king_tax_lang` WHERE `id_tax` = 2	/classes/ObjectModel.php:219
0.485	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 64	/classes/Category.php:1032
0.484	1	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 60 LIMIT 1	/classes/Category.php:855
0.483	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 2 LIMIT 1	/classes/Category.php:1227
0.483	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.482	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 32	/classes/Category.php:1032
0.482	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 22) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
0.482	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.48	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.478	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.478	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.475	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.473	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.472	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 11	/classes/Category.php:1032
0.472	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 65	/classes/Category.php:1032
0.467	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 230 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
0.465	1	SELECT id_shop FROM `king_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.465	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 230) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
0.464	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
0.463	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 230 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
0.46	1	SELECT * FROM `king_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1	/classes/ObjectModel.php:212
0.458	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 6	/classes/Category.php:1032
0.456	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 33	/classes/Category.php:1032
0.456	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 31	/classes/Category.php:1032
0.454	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 61	/classes/Category.php:1032
0.454	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 = 22 LIMIT 1	/classes/Product.php:652
0.452	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 = 22 LIMIT 1	/classes/Product.php:662
0.451	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` = 230)	/classes/Product.php:2673
0.45	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.45	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.449	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.448	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 62	/classes/Category.php:1032
0.445	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.444	1	SELECT * FROM `king_hook_module_exceptions` WHERE `id_shop` IN (1)	/classes/module/Module.php:1571
0.444	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.443	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 = 22 LIMIT 1	/classes/Product.php:642
0.443	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
0.44	1	SELECT domain, domain_ssl FROM king_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	/classes/shop/ShopUrl.php:154
0.439	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 41	/classes/Category.php:1032
0.437	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 2	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.435	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.433	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.433	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.432	1	SELECT COUNT(pc.`id_product`) AS nbr FROM `king_product_comment` pc WHERE `id_product` = 230 AND `validate` = 1 AND `grade` > 0 LIMIT 1	/modules/productcomments/ProductComment.php:244
0.429	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 35	/classes/Category.php:1032
0.428	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 60	/classes/Category.php:1032
0.422	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 25	/classes/Category.php:1032
0.421	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 19	/classes/Category.php:1032
0.42	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 20	/classes/Category.php:1032
0.42	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.419	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 4	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.418	1	SELECT version FROM `king_module` WHERE name = 'paypal' LIMIT 1	/modules/paypal/paypal.php:281
0.417	1	SELECT `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1	/classes/module/Module.php:1888
0.411	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 40	/classes/Category.php:1032
0.41	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 = 22 LIMIT 1	/classes/Product.php:671
0.408	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.407	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockwishlist" LIMIT 1	/classes/module/Module.php:1888
0.405	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 230 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.403	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.402	4	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 2	/classes/Category.php:1032
0.4	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
0.399	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 44	/classes/Category.php:1032
0.397	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 63	/classes/Category.php:1032
0.397	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 45	/classes/Category.php:1032
0.395	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 42	/classes/Category.php:1032
0.395	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.394	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 43	/classes/Category.php:1032
0.393	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'medium_default' LIMIT 1	/classes/Image.php:377
0.392	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
0.391	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 36	/classes/Category.php:1032
0.389	1	SELECT id_shop FROM `king_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.388	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 = 230 LIMIT 1	/classes/Product.php:652
0.386	1	SELECT COUNT(`id_product_comment`) AS "nbr" FROM `king_product_comment` pc WHERE `id_product` = 230 AND `validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:223
0.381	1	SELECT * FROM `king_shop` a WHERE (a.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.38	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 28	/classes/Category.php:1032
0.38	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 = 230 LIMIT 1	/classes/Product.php:662
0.378	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.377	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 13	/classes/Category.php:1032
0.377	1	SELECT * FROM `king_country_lang` WHERE `id_country` = 8	/classes/ObjectModel.php:219
0.376	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 10	/classes/Category.php:1032
0.376	1	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 1	/classes/Category.php:1032
0.374	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 = 230 LIMIT 1	/classes/Product.php:671
0.373	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 22 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.371	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 16	/classes/Category.php:1032
0.369	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 14	/classes/Category.php:1032
0.369	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'home_default' LIMIT 1	/classes/Image.php:377
0.367	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
0.365	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 12	/classes/Category.php:1032
0.364	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blocklayered" LIMIT 1	/classes/module/Module.php:1888
0.362	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.362	1	SELECT * FROM `king_product_lang` WHERE `id_product` = 230 AND `id_shop` = 1	/classes/ObjectModel.php:219
0.361	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 34	/classes/Category.php:1032
0.361	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.358	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.358	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 38	/classes/Category.php:1032
0.354	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 26	/classes/Category.php:1032
0.349	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.349	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.348	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 230 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.347	1	SELECT `id_country` FROM `king_country` WHERE `iso_code` = 'FR' LIMIT 1	/classes/Country.php:167
0.344	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.344	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 22 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
0.344	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 21	/classes/Category.php:1032
0.344	1	SELECT id_shop FROM `king_category_shop` WHERE `id_category` = 60 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.343	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 9	/classes/Category.php:1032
0.343	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.343	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 3	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.341	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.341	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockcategories" LIMIT 1	/classes/module/Module.php:1888
0.327	1	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
0.327	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.327	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.326	1	SELECT out_of_stock FROM `king_stock_available` WHERE (id_product = 230) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:665
0.32	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 22 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.315	0	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 60 LIMIT 1	/classes/Category.php:855
0.309	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 60 LIMIT 1	/classes/Category.php:1227
0.306	1	SELECT `reduction` FROM `king_group` WHERE `id_group` = 1 LIMIT 1	/classes/Group.php:132
0.303	0	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
0.295	1	SELECT depends_on_stock FROM `king_stock_available` WHERE (id_product = 230) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:642
0.29	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.286	1	SELECT id_shop FROM `king_product_shop` WHERE `id_product` = 230 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244

Stopwatch (with SQL_NO_CACHE) (total = 289)

4.398 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `king_category_product` cp LEFT JOIN `king_product` p ON p.`id_product` = cp.`id_product` INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `king_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN king_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `king_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `king_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `king_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `king_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `king_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY RAND() LIMIT 0, 1
in /home/cinquantl/www/kingsushi/classes/Category.php:659
USING FILESORT - 33 rows browsed

4.297 ms SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `king_hook` h INNER JOIN `king_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `king_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
in /home/cinquantl/www/kingsushi/classes/Hook.php:227
USING FILESORT - 93 rows browsed

4.031 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `king_module` m INNER JOIN `king_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `king_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `king_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM king_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /home/cinquantl/www/kingsushi/classes/Hook.php:339
USING FILESORT - 93 rows browsed

3.314 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

3.078 ms SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1 ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE m.`active` = 1 GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:179
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed

2.989 ms SELECT SQL_NO_CACHE s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Supplier.php:122
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed

2.787 ms SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1 ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE m.`active` = 1 GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Manufacturer.php:179
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed

2.611 ms SELECT SQL_NO_CACHE s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Supplier.php:122
USING FILESORT - 9 rows browsed
Useless GROUP BY need to be removed

2.579 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` = 230 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

2.54 ms SELECT SQL_NO_CACHE `id_guest` FROM `king_connections` WHERE `id_guest` = 100741 AND `date_add` > '2021-10-21 16:43: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

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

2.059 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.839 ms INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('100741', '298', '598530478', '', '1', '1', '2021-10-21 17:13:53')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455

1.831 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

1.768 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

1.628 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` = 60 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.608 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` = 230 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

1.607 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 = 230 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.305 ms SELECT SQL_NO_CACHE *, ( IF ('2021-10-21 17:13:53' >= `from` AND '2021-10-21 17:13:53' <= `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, 230) AND `id_shop` IN(0, 1) AND `id_currency` IN(0, 1) AND `id_country` IN(0, 8) AND `id_group` IN(0, 1) AND `id_customer` IN(0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' <= `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 - 33 rows browsed

1.104 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.096 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` = 230) 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 = 230) 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

1.047 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM king_required_field
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1187
1 row browsed

0.99 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

0.979 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

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

0.97 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` = 230 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

0.96 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

0.955 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

0.939 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 12 rows browsed
Useless GROUP BY need to be removed

0.874 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 = 230 AND product_shop.active = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:252
1 row browsed

0.863 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.858 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

0.824 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 12 rows browsed
Useless GROUP BY need to be removed

0.821 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.816 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.814 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.802 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

0.798 ms SELECT SQL_NO_CACHE * FROM `king_product_comment` pc WHERE pc.`id_product` = 230 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

0.77 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

0.76 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 12 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 5 rows browsed
Useless GROUP BY need to be removed

0.759 ms SELECT SQL_NO_CACHE *, ( IF ('2021-10-21 17:13:53' >= `from` AND '2021-10-21 17:13:53' <= `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, 22) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:53' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:243
USING FILESORT - 33 rows browsed

0.754 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

0.753 ms SELECT SQL_NO_CACHE *, ( IF ('2021-10-21 17:13:52' >= `from` AND '2021-10-21 17:13:52' <= `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, 230) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:52' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-10-21 17:13:52' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:243
USING FILESORT - 33 rows browsed

0.753 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.751 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` = 230 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.75 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` = 230
in /home/cinquantl/www/kingsushi/classes/Product.php:5005
1 row browsed

0.733 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

0.729 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` = 230 AND pccl.`id_lang` = 1 AND pc.`validate` = 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:168
1 row browsed

0.725 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

0.724 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.716 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

0.697 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

0.687 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

0.684 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

0.683 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

0.683 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

0.681 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

0.671 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.663 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

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

0.658 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

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

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

0.643 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.638 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 = 230) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.637 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `king_lang` l JOIN king_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Language.php:805
1 row browsed

0.635 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.624 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

0.623 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.62 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.619 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.616 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.611 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.611 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

0.608 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.605 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.601 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.601 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.593 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.591 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.587 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.584 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.583 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

0.583 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.579 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 18 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

0.578 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.572 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.568 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.568 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.564 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 62) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.563 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.56 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.559 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.558 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.558 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 323 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.556 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.553 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`=230
in /home/cinquantl/www/kingsushi/classes/Tag.php:161
1 row browsed

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

0.549 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.548 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 11) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.545 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

0.543 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 248 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.542 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.541 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 7 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

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

0.537 ms SELECT SQL_NO_CACHE COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = 72 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1651
1 row browsed

0.536 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.536 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.535 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` = 230 AND ctg.`id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4324
1 row browsed

0.534 ms SELECT SQL_NO_CACHE * FROM `king_social_links` WHERE `id_shop` = 1
in /home/cinquantl/www/kingsushi/modules/autumnsocial/autumnsocial.php:436
1 row browsed

0.534 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.533 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.533 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 256 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.533 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.531 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.53 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` = 230 AND l.`active` = 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4417
1 row browsed

0.526 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.526 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.526 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.525 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.523 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.523 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.523 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 265 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.52 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed

0.519 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.518 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.515 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.514 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.513 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.512 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 <= 18 AND c.nright >= 19 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

0.512 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.512 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 10) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.512 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 42) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.511 ms SELECT SQL_NO_CACHE * 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.511 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.506 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.505 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.505 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.504 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 54 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.504 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 9) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.504 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 1) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.503 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.502 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.502 ms SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 162 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

0.501 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 36) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.501 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.5 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.5 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

0.499 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.494 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.494 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.493 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.491 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.491 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.49 ms SELECT SQL_NO_CACHE * FROM `king_country` a LEFT JOIN `king_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.49 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` = 230 AND image_shop.`cover` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:2451
1 row browsed

0.489 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 20) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.488 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.487 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.486 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.486 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.486 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.485 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.484 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` = 60 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed

0.483 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.483 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.482 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.482 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 22) 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.482 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.48 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.478 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.478 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.475 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.473 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.472 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.472 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.467 ms SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 230 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:180
1 row browsed

0.465 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.465 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 230) 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.464 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 16) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

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

0.46 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.458 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.456 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.456 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 31
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed

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

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

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

0.45 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.45 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.449 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.448 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.445 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.444 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.444 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.443 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 = 22 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed

0.443 ms SELECT SQL_NO_CACHE COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = 72 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1651
1 row browsed

0.44 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM king_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/shop/ShopUrl.php:154
1 row browsed

0.439 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.437 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.435 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.433 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.433 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.432 ms SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr FROM `king_product_comment` pc WHERE `id_product` = 230 AND `validate` = 1 AND `grade` > 0 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:244
1 row browsed

0.429 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.428 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.422 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.421 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.42 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.42 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.419 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.418 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.417 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed

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

0.408 ms SELECT SQL_NO_CACHE `link` FROM king_megamenu_menus WHERE `id_menu` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1191
1 row browsed

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

0.405 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 230 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed

0.403 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.402 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.4 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 45 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed

0.399 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.397 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.397 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.395 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.395 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.394 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.393 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.392 ms SELECT SQL_NO_CACHE * FROM `king_lang` a LEFT JOIN `king_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.391 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.389 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.388 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 = 230 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

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

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

0.378 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.377 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.377 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.376 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.376 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.374 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 230 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

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

0.371 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 16
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed

0.369 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.369 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.367 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 32 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed

0.365 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.364 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

0.362 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.362 ms SELECT SQL_NO_CACHE * FROM `king_product_lang` WHERE `id_product` = 230 AND `id_shop` = 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed

0.361 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.361 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.358 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.358 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.354 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.349 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.349 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.348 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 230 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed

0.347 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.344 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.344 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 22 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed

0.344 ms SELECT SQL_NO_CACHE cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 21
in /home/cinquantl/www/kingsushi/classes/Category.php:1032
3 rows browsed

0.344 ms SELECT SQL_NO_CACHE id_shop FROM `king_category_shop` WHERE `id_category` = 60 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

0.343 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.343 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.343 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.341 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.341 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.327 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1635
1 row browsed

0.327 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.327 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.326 ms SELECT SQL_NO_CACHE out_of_stock FROM `king_stock_available` WHERE (id_product = 230) 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.32 ms SELECT SQL_NO_CACHE `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 22 AND `id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/GroupReduction.php:139
0 rows browsed

0.315 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` = 60 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
0 rows browsed

0.309 ms SELECT SQL_NO_CACHE nleft, nright, level_depth FROM king_category WHERE id_category = 60 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1227
1 row browsed

0.306 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.303 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.295 ms SELECT SQL_NO_CACHE depends_on_stock FROM `king_stock_available` WHERE (id_product = 230) 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.29 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.286 ms SELECT SQL_NO_CACHE id_shop FROM `king_product_shop` WHERE `id_product` = 230 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
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 * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX

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

9 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`

8 SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX

7 SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = XX LIMIT XX

3 SELECT * 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

98 category_lang

89 category

87 category_shop

42 category_group

22 product_shop

18 product

15 product_lang

14 product_attribute

14 product_attribute_shop

13 megamenu_menus_context

12 image_shop

12 image

11 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/230/60/1/1/8/6b/1a/c4/6b1ac4149a2d2f1722dad9932a635554b91ba1c1.productscategory.tpl.php
249 cache/smarty/cache/crossselling/productfooter/230/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

Exquise de Foie Gras & Magret de Canard

Donner votre avis

11 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 = 289)

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

Tables stress

ObjectModel instances

Included files