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

Duo de Sushi Gambas (x2)

4,90 € TTC

Référence : S6

En savoir plus
Commentaires

Duo de Sushi aux gambas sur un lit de riz.

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

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

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

config: 52ms
constructor: 0ms
init: 68ms
checkAccess: 0ms
setMedia: 5ms
postProcess: 0ms
initHeader: 0ms
initContent: 1.288s
initFooter: 41ms
display: 554ms

Hook processing: 1.309s / 4.11 Mb

displayTop: 607ms / 1.05 Mb
displayHeader: 296ms / 2.36 Mb
displayFooterProduct: 124ms / 0.04 Mb
displayProductTabContent: 79ms / 0.09 Mb
actionProductOutOfStock: 66ms / 0.09 Mb
displayFooter: 41ms / 0.24 Mb
displayLeftColumnProduct: 38ms / 0.03 Mb
displayProductTab: 26ms / 0.02 Mb
displayProductButtons: 22ms / 0.02 Mb
moduleRoutes: 9ms / 0.15 Mb
displayLeftColumn: 0ms / 0 Mb
actionFrontControllerSetMedia: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
displayRightColumnProduct: 0ms / 0 Mb
actionObjectAddBefore: 0ms / 0 Mb
actionObjectAddAfter: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
actionObjectGuestAddAfter: 0ms / 0 Mb
actionObjectConnectionAddAfter: 0ms / 0 Mb
actionObjectConnectionAddBefore: 0ms / 0 Mb
displayRightColumn: 0ms / 0 Mb
actionObjectGuestAddBefore: 0ms / 0 Mb

Memory peak usage: 8.4 Mb

config: 1.41 Mb (1.5 Mb)
constructor: 0 Mb (1.5 Mb)
init: 1.44 Mb (2.9 Mb)
checkAccess: 0 Mb (2.9 Mb)
setMedia: 0.03 Mb (3 Mb)
postProcess: 0 Mb (3 Mb)
initHeader: 0 Mb (3 Mb)
initContent: 4.07 Mb (7 Mb)
initFooter: 0.25 Mb (7.3 Mb)
display: 0.67 Mb (8.4 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 288 queries
Time spent querying: 276ms

Included files: 286
Size of included files: 3.32 Mb

Globals (> 1 Ko only): 573 Ko

_MODULES ≈ 394.7 Ko
_LANG ≈ 103.1 Ko
context ≈ 58.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
7.135	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
6.965	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
5.919	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
4.678	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` = 26 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	/classes/Product.php:3189	Yes
4.47	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
4.452	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
4.141	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
3.934	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
3.213	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`=26	/classes/Tag.php:161
3.128	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
3.09	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.731	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` = 26 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC	/classes/Product.php:3100	Yes	Yes
2.517	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.106	1	INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('80049', '217', '66019267', '', '1', '1', '2021-09-16 13:08:03')	/classes/ObjectModel.php:455
1.954	1	SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM king_shop_url su LEFT JOIN king_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.wok-king-sushi.fr' OR su.domain_ssl = 'www.wok-king-sushi.fr') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	/classes/shop/Shop.php:320	Yes
1.791	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` = 32 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.657	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` = 26) 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 = 26) 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.625	1	SELECT COUNT(DISTINCT c.id_currency) FROM `king_currency` c LEFT JOIN king_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1	/classes/Currency.php:445
1.613	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` = 26 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC	/modules/productcomments/ProductComment.php:114	Yes
1.568	33	SELECT *, ( IF ('2021-09-16 13:08:02' >= `from` AND '2021-09-16 13:08:02' <= `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, 26) 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-09-16 13:08:02' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:02' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1	/classes/SpecificPrice.php:243	Yes
1.566	93	SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `king_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `king_module` m	/classes/module/Module.php:171
1.555	1	SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM king_shop s LEFT JOIN king_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN king_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1	/classes/shop/Shop.php:199
1.551	26	SELECT m.page, ml.url_rewrite, ml.id_lang FROM `king_meta` m LEFT JOIN `king_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	/classes/Dispatcher.php:426	Yes
1.52	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
1.513	1	SELECT * FROM `king_tax_rule` WHERE `id_country` = 8 AND `id_tax_rules_group` = 2 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC	/classes/tax/TaxRulesTaxManager.php:90	Yes
1.479	1	SELECT * FROM `king_country` a LEFT JOIN `king_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `king_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1	/classes/ObjectModel.php:212
1.459	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 = 26 AND product_shop.active = 1 LIMIT 1	/classes/Meta.php:252
1.444	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.438	5	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 12 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
1.416	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` = 26 AND pccl.`id_lang` = 1 AND pc.`validate` = 1	/modules/productcomments/ProductComment.php:168
1.381	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` = 26 AND l.`active` = 1	/classes/Product.php:4417
1.354	33	SELECT *, ( IF ('2021-09-16 13:08:03' >= `from` AND '2021-09-16 13:08:03' <= `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, 26) 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-09-16 13:08:03' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:03' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC	/classes/SpecificPrice.php:306	Yes
1.316	7	SELECT king_megamenu_menus.id_menu, king_megamenu_menus.active, king_megamenu_menus.position, king_megamenu_menus_lan.id_menu, king_megamenu_menus_lan.id_lang, king_megamenu_menus_lan.name FROM `king_megamenu_menus`, `king_megamenu_menus_lan` WHERE king_megamenu_menus.id_shop = 1 AND king_megamenu_menus.id_menu = king_megamenu_menus_lan.id_menu ORDER BY king_megamenu_menus.position ASC	/modules/autumnmegamenu/autumnmegamenu.php:1158	Yes
1.273	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
1.271	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 = 26 LIMIT 1	/classes/Product.php:642
1.27	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
1.26	12	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
1.258	1	SELECT * FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1	/modules/productcomments/ProductComment.php:137	Yes
1.257	1	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 268 ORDER BY `position`	/classes/Product.php:2431	Yes
1.239	1	SELECT COUNT(DISTINCT l.id_lang) FROM `king_lang` l JOIN king_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1	/classes/Language.php:805
1.2	1	SELECT `id_guest` FROM `king_connections` WHERE `id_guest` = 80049 AND `date_add` > '2021-09-16 12:38:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1	/classes/Connection.php:134	Yes
1.2	1	SELECT l.*, ls.`id_shop` FROM `king_lang` l LEFT JOIN `king_lang_shop` ls ON (l.id_lang = ls.id_lang)	/classes/Language.php:698
1.199	1	SELECT * FROM `king_tax_lang` WHERE `id_tax` = 2	/classes/ObjectModel.php:219
1.175	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
1.168	2	SELECT id_page_type FROM king_page_type WHERE name = 'product' LIMIT 1	/classes/Page.php:96
1.167	12	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
1.15	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
1.136	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
1.136	2	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` = 26 AND ctg.`id_group` = 1 LIMIT 1	/classes/Product.php:4324
1.134	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` = 26	/classes/Product.php:5005
1.134	33	SELECT *, ( IF ('2021-09-16 13:08:03' >= `from` AND '2021-09-16 13:08:03' <= `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, 4) 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-09-16 13:08:03' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:03' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1	/classes/SpecificPrice.php:243	Yes
1.122	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'large_Autumn' LIMIT 1	/classes/ImageType.php:141
1.099	1	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 13 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
1.096	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` = 26	/classes/Product.php:5067
1.09	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 = 4) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
1.079	1	SELECT * FROM king_meta m LEFT JOIN king_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1	/classes/Meta.php:144
1.079	1	SELECT * FROM `king_currency` a LEFT JOIN `king_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1	/classes/ObjectModel.php:212
1.071	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
1.059	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
1.049	1	SELECT id_required_field, object_name, field_name FROM king_required_field	/classes/ObjectModel.php:1187
1.034	1	SELECT * FROM `king_tax` a WHERE (a.id_tax = 2) LIMIT 1	/classes/ObjectModel.php:212
1.032	1	SELECT * FROM `king_currency` c INNER JOIN king_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASC	/classes/Currency.php:219	Yes	Yes
1.027	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
1.018	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
1.016	86	SELECT * FROM `king_hook_alias`	/classes/Hook.php:182
1.005	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
1.005	1	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 18 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
1.005	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
1.003	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
1.003	2	SELECT `id_page` FROM `king_page` WHERE `id_page_type` = 5 AND `id_object` = 26 LIMIT 1	/classes/Page.php:78
0.99	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.984	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.976	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.974	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.974	1	SELECT * FROM `king_hook_module_exceptions` WHERE `id_shop` IN (1)	/classes/module/Module.php:1571
0.97	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.951	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.948	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.947	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.946	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.937	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.935	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.935	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.934	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.933	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.933	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.932	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.929	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.921	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.92	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` = 26 ORDER BY `position`	/classes/Product.php:2431	Yes
0.916	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.913	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.908	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.907	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.907	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 = 26) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.898	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.898	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.895	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.894	1	SELECT * FROM `king_product_lang` WHERE `id_product` = 26 AND `id_shop` = 1	/classes/ObjectModel.php:219
0.887	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.875	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 = 26 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0	/classes/Product.php:1131
0.874	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.873	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockwishlist" LIMIT 1	/classes/module/Module.php:1888
0.871	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.868	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.868	1	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 65 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
0.861	1	SELECT * FROM `king_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.859	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.856	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.85	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.843	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.84	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.836	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 = 26) LIMIT 1	/classes/ObjectModel.php:212
0.836	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.835	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.827	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.826	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.82	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.82	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.818	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.815	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` = 26)	/classes/Product.php:2673
0.814	1	SELECT * FROM `king_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1	/classes/ObjectModel.php:212
0.805	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.805	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.804	0	SELECT `name` FROM `king_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1 LIMIT 1	/classes/Manufacturer.php:241
0.802	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.799	1	SELECT * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 34) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.79	1	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 26 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/classes/Category.php:727	Yes	Yes
0.788	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.779	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.774	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 26 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
0.774	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.769	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.763	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.76	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.76	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.756	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.755	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.754	0	SELECT `name` FROM `king_supplier` WHERE `id_supplier` = 0 LIMIT 1	/classes/Supplier.php:177
0.751	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
0.751	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.75	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.748	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.745	1	SELECT * FROM `king_group_lang` WHERE `id_group` = 1	/classes/ObjectModel.php:219
0.741	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.739	1	SELECT * FROM `king_shop` a WHERE (a.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.735	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 = 4 LIMIT 1	/classes/Product.php:642
0.733	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 26 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.73	1	SELECT * FROM `king_social_links` WHERE `id_shop` = 1	/modules/autumnsocial/autumnsocial.php:436
0.729	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.726	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.725	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` = 4)	/classes/Product.php:2673
0.723	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
0.714	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.713	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.712	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.712	1	SELECT `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1	/classes/module/Module.php:1888
0.711	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.708	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 15	/classes/Category.php:1032
0.703	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.703	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.702	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 14	/classes/Category.php:1032
0.7	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 13	/classes/Category.php:1032
0.7	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` = 26 AND image_shop.`cover` = 1 LIMIT 1	/classes/Product.php:2451
0.699	1	SELECT COUNT(pc.`id_product`) AS nbr FROM `king_product_comment` pc WHERE `id_product` = 26 AND `validate` = 1 AND `grade` > 0 LIMIT 1	/modules/productcomments/ProductComment.php:244
0.696	1	SELECT * FROM `king_country_lang` WHERE `id_country` = 8	/classes/ObjectModel.php:219
0.693	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.69	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 19	/classes/Category.php:1032
0.69	1	SELECT `id_country` FROM `king_country` WHERE `iso_code` = 'FR' LIMIT 1	/classes/Country.php:167
0.684	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.682	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.676	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.673	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.672	1	SELECT * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 62) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.668	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 = 4 LIMIT 1	/classes/Product.php:671
0.666	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 35	/classes/Category.php:1032
0.664	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.664	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.661	1	SELECT domain, domain_ssl FROM king_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	/classes/shop/ShopUrl.php:154
0.658	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 40	/classes/Category.php:1032
0.657	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.657	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 = 26 LIMIT 1	/classes/Product.php:662
0.657	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.656	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.656	1	SELECT version FROM `king_module` WHERE name = 'paypal' LIMIT 1	/modules/paypal/paypal.php:281
0.652	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.651	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.649	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.649	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.648	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 = 26 LIMIT 1	/classes/Product.php:671
0.645	1	SELECT depends_on_stock FROM `king_stock_available` WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:642
0.644	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.643	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 34	/classes/Category.php:1032
0.629	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.628	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 12	/classes/Category.php:1032
0.622	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	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 44	/classes/Category.php:1032
0.619	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.616	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 45	/classes/Category.php:1032
0.611	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.604	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 64	/classes/Category.php:1032
0.602	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:180
0.6	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.595	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.592	1	SELECT out_of_stock FROM `king_stock_available` WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:665
0.591	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 33	/classes/Category.php:1032
0.591	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 = 26 LIMIT 1	/classes/Product.php:652
0.591	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 65	/classes/Category.php:1032
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 = 60) AND (b.id_shop = 1) LIMIT 1	/classes/ObjectModel.php:212
0.585	1	SELECT SUM(quantity) FROM `king_stock_available` WHERE (id_product = 4) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/classes/stock/StockAvailable.php:362
0.583	1	SELECT `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 4 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/classes/SpecificPrice.php:190
0.58	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blocklayered" LIMIT 1	/classes/module/Module.php:1888
0.576	1	SELECT COUNT(`id_product_comment`) AS "nbr" FROM `king_product_comment` pc WHERE `id_product` = 26 AND `validate` = 1 LIMIT 1	/modules/productcomments/ProductComment.php:223
0.574	1	SELECT `id_module` FROM `king_module` WHERE `name` = "blockcategories" LIMIT 1	/classes/module/Module.php:1888
0.568	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 = 4 LIMIT 1	/classes/Product.php:662
0.565	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 3	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.561	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'large_default' LIMIT 1	/classes/Image.php:377
0.56	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 26	/classes/Category.php:1032
0.56	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 43	/classes/Category.php:1032
0.559	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.556	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 20	/classes/Category.php:1032
0.554	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 32	/classes/Category.php:1032
0.55	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 18	/classes/Category.php:1032
0.548	4	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 2	/classes/Category.php:1032
0.545	1	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
0.544	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 = 4 LIMIT 1	/classes/Product.php:652
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.541	0	SELECT cl.`link_rewrite` FROM `king_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 32 LIMIT 1	/classes/Category.php:855
0.54	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 10	/classes/Category.php:1032
0.538	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 7	/classes/Category.php:1032
0.538	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.538	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 27	/classes/Category.php:1032
0.536	1	SELECT id_shop FROM `king_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.535	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.534	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.533	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 4	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.532	1	SELECT id_shop FROM `king_product_shop` WHERE `id_product` = 26 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.528	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 63	/classes/Category.php:1032
0.527	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 8 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.522	1	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 1	/classes/Category.php:1032
0.52	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 42	/classes/Category.php:1032
0.519	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 41	/classes/Category.php:1032
0.519	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 16	/classes/Category.php:1032
0.518	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.517	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 25	/classes/Category.php:1032
0.513	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.511	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 <= 50 AND c.nright >= 51 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.51	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'medium_default' LIMIT 1	/classes/Image.php:377
0.51	1	SELECT `width`, `height` FROM king_image_type WHERE `name` = 'home_default' LIMIT 1	/classes/Image.php:377
0.509	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 21	/classes/Category.php:1032
0.508	1	SELECT id_shop FROM `king_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.507	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 9	/classes/Category.php:1032
0.503	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 26 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.503	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 6	/classes/Category.php:1032
0.501	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 11	/classes/Category.php:1032
0.501	0	SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1	/classes/module/Module.php:1635
0.495	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.49	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.489	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 61	/classes/Category.php:1032
0.489	1	SELECT `reduction` FROM `king_group` WHERE `id_group` = 1 LIMIT 1	/classes/Group.php:132
0.488	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.487	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 31	/classes/Category.php:1032
0.481	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.481	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 1 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.478	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 7 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.476	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 36	/classes/Category.php:1032
0.474	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.471	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 62	/classes/Category.php:1032
0.47	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.469	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 2 LIMIT 1	/classes/Category.php:1227
0.462	1	SELECT `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 4 AND id_shop=1 LIMIT 1	/classes/Product.php:4435
0.461	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 3 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.457	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 38	/classes/Category.php:1032
0.456	0	SELECT `reduction` FROM `king_product_group_reduction_cache` WHERE `id_product` = 4 AND `id_group` = 1 LIMIT 1	/classes/GroupReduction.php:139
0.45	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.449	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 28	/classes/Category.php:1032
0.445	3	SELECT cg.`id_group` FROM king_category_group cg WHERE cg.`id_category` = 60	/classes/Category.php:1032
0.441	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 4 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.431	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.42	0	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 9 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.419	1	SELECT * FROM `king_megamenu_menus_context` WHERE `id_menu` = 2	/modules/autumnmegamenu/autumnmegamenu.php:1076
0.403	1	SELECT `link` FROM king_megamenu_menus WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:1191
0.396	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.396	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.39	1	SELECT `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1	/modules/autumnmegamenu/autumnmegamenu.php:998
0.356	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.334	1	SELECT id_shop FROM `king_category_shop` WHERE `id_category` = 32 AND id_shop = 1 LIMIT 1	/classes/ObjectModel.php:1244
0.331	1	SELECT nleft, nright, level_depth FROM king_category WHERE id_category = 32 LIMIT 1	/classes/Category.php:1227

Stopwatch (with SQL_NO_CACHE) (total = 288)

7.135 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

6.965 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

5.919 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

4.678 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` = 26 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

4.47 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

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

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

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

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

3.128 ms SELECT SQL_NO_CACHE `id_hook`, `name` FROM `king_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `king_hook_alias` ha INNER JOIN `king_hook` h ON ha.name = h.name
in /home/cinquantl/www/kingsushi/classes/Hook.php:130
0 rows browsed

3.09 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.731 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` = 26 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
in /home/cinquantl/www/kingsushi/classes/Product.php:3100
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

2.517 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.106 ms INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('80049', '217', '66019267', '', '1', '1', '2021-09-16 13:08:03')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455

1.954 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM king_shop_url su LEFT JOIN king_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.wok-king-sushi.fr' OR su.domain_ssl = 'www.wok-king-sushi.fr') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /home/cinquantl/www/kingsushi/classes/shop/Shop.php:320
USING FILESORT - 1 row browsed

1.791 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` = 32 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.657 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` = 26) 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 = 26) 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.625 ms SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `king_currency` c LEFT JOIN king_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Currency.php:445
1 row browsed

1.613 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` = 26 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

1.568 ms SELECT SQL_NO_CACHE *, ( IF ('2021-09-16 13:08:02' >= `from` AND '2021-09-16 13:08:02' <= `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, 26) 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-09-16 13:08:02' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:02' <= `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

1.566 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `king_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `king_module` m
in /home/cinquantl/www/kingsushi/classes/module/Module.php:171
93 rows browsed

1.555 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM king_shop s LEFT JOIN king_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN king_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/shop/Shop.php:199
1 row browsed

1.551 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `king_meta` m LEFT JOIN `king_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC
in /home/cinquantl/www/kingsushi/classes/Dispatcher.php:426
USING FILESORT - 26 rows browsed

1.52 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

1.513 ms SELECT SQL_NO_CACHE * FROM `king_tax_rule` WHERE `id_country` = 8 AND `id_tax_rules_group` = 2 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /home/cinquantl/www/kingsushi/classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed

1.479 ms SELECT SQL_NO_CACHE * FROM `king_country` a LEFT JOIN `king_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `king_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

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

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

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

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

1.354 ms SELECT SQL_NO_CACHE *, ( IF ('2021-09-16 13:08:03' >= `from` AND '2021-09-16 13:08:03' <= `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, 26) 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-09-16 13:08:03' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:03' <= `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.316 ms SELECT SQL_NO_CACHE king_megamenu_menus.id_menu, king_megamenu_menus.active, king_megamenu_menus.position, king_megamenu_menus_lan.id_menu, king_megamenu_menus_lan.id_lang, king_megamenu_menus_lan.name FROM `king_megamenu_menus`, `king_megamenu_menus_lan` WHERE king_megamenu_menus.id_shop = 1 AND king_megamenu_menus.id_menu = king_megamenu_menus_lan.id_menu ORDER BY king_megamenu_menus.position ASC
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:1158
USING FILESORT - 7 rows browsed

1.273 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

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

1.27 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

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

1.258 ms SELECT SQL_NO_CACHE * FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:137
USING FILESORT - 1 row browsed

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

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

1.2 ms SELECT SQL_NO_CACHE `id_guest` FROM `king_connections` WHERE `id_guest` = 80049 AND `date_add` > '2021-09-16 12:38:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Connection.php:134
USING FILESORT - 1 row browsed

1.2 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `king_lang` l LEFT JOIN `king_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /home/cinquantl/www/kingsushi/classes/Language.php:698
1 row browsed

1.199 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

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

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

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

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

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

1.136 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` = 26 AND ctg.`id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4324
2 rows browsed

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

1.134 ms SELECT SQL_NO_CACHE *, ( IF ('2021-09-16 13:08:03' >= `from` AND '2021-09-16 13:08:03' <= `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, 4) 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-09-16 13:08:03' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-09-16 13:08:03' <= `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

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

1.099 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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

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

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

1.079 ms SELECT SQL_NO_CACHE * FROM king_meta m LEFT JOIN king_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:144
1 row browsed

1.079 ms SELECT SQL_NO_CACHE * FROM `king_currency` a LEFT JOIN `king_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

1.071 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

1.059 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

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

1.034 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

1.032 ms SELECT SQL_NO_CACHE * FROM `king_currency` c INNER JOIN king_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASC
in /home/cinquantl/www/kingsushi/classes/Currency.php:219
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

1.027 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 26) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/stock/StockAvailable.php:362
1 row browsed

1.018 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

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

1.005 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

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

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

1.003 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

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

0.99 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.984 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.976 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.974 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.974 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.97 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.951 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.948 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.947 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.946 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.937 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.935 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.935 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.934 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.933 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.933 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.932 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.929 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.921 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.92 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` = 26 ORDER BY `position`
in /home/cinquantl/www/kingsushi/classes/Product.php:2431
USING FILESORT - 1 row browsed

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

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

0.887 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.875 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 = 26 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

0.874 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.873 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.871 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.868 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.868 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.861 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 45) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.859 ms SELECT SQL_NO_CACHE * 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.856 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.85 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.843 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.84 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.836 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 = 26) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.836 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.835 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.827 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

0.826 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.82 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.82 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.818 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.815 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` = 26)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed

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

0.79 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.788 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.779 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.774 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 26 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed

0.774 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.769 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.763 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.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` = 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.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` = 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.756 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.755 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.754 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.751 ms SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:180
1 row browsed

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

0.748 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.745 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.741 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.739 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.735 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 = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:642
1 row browsed

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

0.73 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.729 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.726 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.725 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` = 4)
in /home/cinquantl/www/kingsushi/classes/Product.php:2673
1 row browsed

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

0.714 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.713 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.712 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.712 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.711 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.708 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.703 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.703 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.702 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.7 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.7 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` = 26 AND image_shop.`cover` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:2451
1 row browsed

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

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

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

0.666 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.664 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.664 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.661 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.658 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.657 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.657 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 = 26 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed

0.657 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.656 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.656 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.652 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.651 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.649 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.649 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.648 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 = 26 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

0.645 ms SELECT SQL_NO_CACHE depends_on_stock FROM `king_stock_available` WHERE (id_product = 26) 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.644 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.643 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.629 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.628 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.622 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 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.619 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.616 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.611 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.604 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.602 ms SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `king_product_comment` pc WHERE pc.`id_product` = 26 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:180
1 row browsed

0.6 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.595 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.592 ms SELECT SQL_NO_CACHE out_of_stock FROM `king_stock_available` WHERE (id_product = 26) 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.591 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.591 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 = 26 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

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

0.585 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 4) 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.583 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `king_specific_price_priority` WHERE `id_product` = 4 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /home/cinquantl/www/kingsushi/classes/SpecificPrice.php:190
1 row browsed

0.58 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.576 ms SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr" FROM `king_product_comment` pc WHERE `id_product` = 26 AND `validate` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/productcomments/ProductComment.php:223
1 row browsed

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

0.565 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.561 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.56 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.56 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.559 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.556 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.554 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.55 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.548 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.545 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.544 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 = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
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.541 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` = 32 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
0 rows browsed

0.54 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.538 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.538 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.538 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.536 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.535 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.534 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.533 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.532 ms SELECT SQL_NO_CACHE id_shop FROM `king_product_shop` WHERE `id_product` = 26 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

0.528 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.527 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.522 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.52 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.519 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.519 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.518 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.517 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.513 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.511 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 <= 50 AND c.nright >= 51 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.51 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.51 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.509 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.508 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.507 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.503 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 26 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed

0.503 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.501 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.501 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.495 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.49 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.489 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.489 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.488 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.487 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.481 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.481 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.478 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.476 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.474 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.471 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.47 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 4 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed

0.469 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.462 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `king_product_shop` WHERE `id_product` = 4 AND id_shop=1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:4435
1 row browsed

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

0.45 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.449 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.445 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.441 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.431 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.42 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.419 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.403 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.396 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.396 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.39 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.356 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.334 ms SELECT SQL_NO_CACHE id_shop FROM `king_category_shop` WHERE `id_category` = 32 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

0.331 ms SELECT SQL_NO_CACHE nleft, nright, level_depth FROM king_category WHERE id_category = 32 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1227
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`

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

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

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

2 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `king_specific_price` WHERE `id_product` IN (XX, XX) AND `id_product_attribute` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_customer` IN (XX, XX) AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND id_cart IN (XX, XX) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= IF(id_product_attribute=XX,XX ,XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT XX

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

2 SELECT pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX

2 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `king_product` p INNER JOIN `king_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `king_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `king_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)

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

2 SELECT `id_module` FROM `king_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX

2 SELECT m.*, ml.`description`, ml.`short_description` FROM `king_manufacturer` m LEFT JOIN `king_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX ) INNER JOIN king_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) WHERE m.`active` = XX GROUP BY m.id_manufacturer ORDER BY m.`name` ASC

2 SELECT COUNT(*) FROM `king_hook_module` hm LEFT JOIN `king_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'displayHeader' AND hm.`id_module` = XX LIMIT XX

2 SELECT s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = XX INNER JOIN king_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = XX) WHERE (s.`active` = XX) GROUP BY s.id_supplier ORDER BY s.`name` ASC

2 SELECT * FROM `king_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC

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

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

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

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

Tables stress

97 category_lang

89 category

87 category_shop

42 category_group

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

Duo de Sushi Gambas (x2)

Donner votre avis

14 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 = 288)

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

Tables stress

ObjectModel instances

Included files