Assortiment vapeur

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

• config: 47ms
• constructor: 0ms
• init: 28ms
• checkAccess: 0ms
• setMedia: 12ms
• postProcess: 0ms
• initHeader: 0ms
• initContent: 1.42s
• initFooter: 69ms
• display: 489ms

Hook processing: 1.454s / 4.92 Mb

• displayTop: 850ms / 1.75 Mb
• displayHeader: 393ms / 2.48 Mb
• actionProductListOverride: 135ms / 0.29 Mb
• displayFooter: 69ms / 0.25 Mb
• moduleRoutes: 5ms / 0.15 Mb
• displayLeftColumn: 2ms / 0 Mb
• actionObjectAddBefore: 0ms / 0 Mb
• DisplayOverrideTemplate: 0ms / 0 Mb
• actionObjectConnectionAddBefore: 0ms / 0 Mb
• actionObjectAddAfter: 0ms / 0 Mb
• actionDispatcher: 0ms / 0 Mb
• actionFrontControllerSetMedia: 0ms / 0 Mb
• actionObjectGuestAddAfter: 0ms / 0 Mb
• actionObjectConnectionAddAfter: 0ms / 0 Mb
• displayRightColumn: 0ms / 0 Mb
• actionObjectGuestAddBefore: 0ms / 0 Mb

Memory peak usage: 7.8 Mb

• config: 1.4 Mb (1.5 Mb)
• constructor: 0 Mb (1.5 Mb)
• init: 0.55 Mb (2 Mb)
• checkAccess: 0 Mb (2 Mb)
• setMedia: 0.03 Mb (2.1 Mb)
• postProcess: 0 Mb (2.1 Mb)
• initHeader: 0 Mb (2.1 Mb)
• initContent: 4.68 Mb (6.7 Mb)
• initFooter: 0.25 Mb (7 Mb)
• display: 0.46 Mb (7.8 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 350 queries
Time spent querying: 522ms

Included files: 269
Size of included files: 3.16 Mb

Globals (> 1 Ko only): 560 Ko

• _MODULES ≈ 394.2 Ko
• _LANG ≈ 103.2 Ko
• context ≈ 46.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

Stopwatch (with SQL_NO_CACHE) (total = 350)

---

11.006 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

---

9.19 ms SELECT SQL_NO_CACHE ctg.`id_group` FROM king_category_group ctg WHERE ctg.`id_category` = 18 AND ctg.`id_group` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1066
1 row browsed

---

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

---

5.636 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

---

5.584 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

---

5.505 ms SELECT SQL_NO_CACHE p.*, product_shop.*, product_shop.id_category_default, pl.*, MAX(image_shop.`id_image`) id_image, il.legend, m.name manufacturer_name, MAX(pa.id_product_attribute) id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity FROM `king_category_product` cp LEFT JOIN king_category c ON (c.id_category = cp.id_category) 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_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) LEFT JOIN king_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 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) LEFT JOIN king_product_attribute pa ON (p.id_product = pa.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND c.nleft >= 48 AND c.nright <= 49 AND c.active = 1 AND p.id_product IN (140,290,291,292,325,326,327) GROUP BY product_shop.id_product ORDER BY p.price asc LIMIT 0,50
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1992
USING FILESORT - 21 rows browsed

---

5.502 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

---

5.401 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

---

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

---

4.871 ms SELECT SQL_NO_CACHE name FROM `king_feature_lang` fl LEFT JOIN `king_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2637
25 rows browsed

---

4.157 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.062 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

---

3.816 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `king_configuration` c LEFT JOIN `king_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /home/cinquantl/www/kingsushi/classes/Configuration.php:116
427 rows browsed

---

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

---

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

---

3.43 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

---

3.422 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

---

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

---

3.307 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 <= 48 AND c.nright >= 49 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

---

3.264 ms SELECT SQL_NO_CACHE p.`id_product` id_product FROM `king_product` p INNER JOIN king_category_product cp ON p.id_product = cp.id_product INNER JOIN king_category c ON (c.id_category = cp.id_category AND c.nleft >= 48 AND c.nright <= 49 AND c.active = 1) RIGHT JOIN king_layered_category lc ON (lc.id_category = 18 AND lc.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 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2003
USING FILESORT - 64 rows browsed
Useless GROUP BY need to be removed

---

3.25 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

---

3.219 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

---

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

---

3.135 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

---

3.104 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

---

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

---

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

---

2.961 ms SELECT SQL_NO_CACHE p.`id_product` id_product FROM `king_product` p INNER JOIN king_category_product cp ON p.id_product = cp.id_product INNER JOIN king_category c ON (c.id_category = cp.id_category AND c.nleft >= 48 AND c.nright <= 49 AND c.active = 1) RIGHT JOIN king_layered_category lc ON (lc.id_category = 18 AND lc.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 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2003
USING FILESORT - 64 rows browsed
Useless GROUP BY need to be removed

---

2.828 ms SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 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) WHERE cp.id_category = c.id_category AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog") ) count_products FROM king_category c LEFT JOIN king_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 1) RIGHT JOIN king_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 48 AND c.nright < 49 AND c.level_depth <= 4 AND c.active = 1 GROUP BY c.id_category ORDER BY c.nleft, c.position
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2284
USING FILESORT - 164 rows browsed

---

2.724 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` = 18 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Category.php:855
1 row browsed

---

2.69 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 50) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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

---

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

---

2.496 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

---

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

---

2.44 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

---

2.44 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` = 18 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

---

2.438 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

---

2.351 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

---

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

---

2.327 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

---

2.319 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

---

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

---

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

---

2.203 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

---

2.175 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

---

2.171 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 140) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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

---

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

---

2.09 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

---

2.077 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

---

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

---

2.013 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

---

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

---

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

---

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

---

1.94 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

---

1.931 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

---

1.93 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.903 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 268) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

1.89 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 325) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.884 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 = 325 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

---

1.86 ms SELECT SQL_NO_CACHE `slide_id`, `shop_id`, `lang_id`, `is_active`, `position`,`url`, `caption`, `image` FROM king_autumn_slider WHERE `shop_id` = 1 AND `lang_id` = 1 ORDER BY `position` ASC
in /home/cinquantl/www/kingsushi/modules/autumnslider/autumnslider.php:812
USING FILESORT - 6 rows browsed

---

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

---

1.849 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 291) 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.838 ms SELECT SQL_NO_CACHE * FROM king_layered_category WHERE id_category = 18 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2032
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

---

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

---

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

---

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

---

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

---

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

---

1.767 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = 'bbf85f0345b6d40ecdf140ed9d4d1741' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

1.76 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.752 ms SELECT SQL_NO_CACHE * FROM `king_social_links` WHERE `id_shop` = 1
in /home/cinquantl/www/kingsushi/modules/autumnsocial/autumnsocial.php:436
1 row browsed

---

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

---

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

---

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

---

1.719 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

---

1.718 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

---

1.708 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.681 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

---

1.665 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 292) 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.652 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `king_image_type` WHERE `name` LIKE 'm_scene_Autumn' LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ImageType.php:141
2 rows browsed

---

1.648 ms INSERT INTO `king_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('30152', '86', '65405310', '', '1', '1', '2020-10-29 23:40:44')
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:455

---

1.626 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = 'bbf85f0345b6d40ecdf140ed9d4d1741' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

1.614 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

---

1.598 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 290) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.591 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 = 291) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

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

---

1.573 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 326) 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.567 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 = 327) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

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

---

1.512 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 140) 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.509 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.509 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

---

1.508 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 326) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.497 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

---

1.465 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

---

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

---

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

---

1.401 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

---

1.396 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.393 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 265) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

1.38 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.372 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 248) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

1.359 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

---

1.354 ms SELECT SQL_NO_CACHE s.* FROM `king_scene_category` sc LEFT JOIN `king_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN king_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `king_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 18 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
in /home/cinquantl/www/kingsushi/classes/Scene.php:214
USING FILESORT - 1 row browsed

---

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

---

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

---

1.321 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

---

1.318 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

---

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

---

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

---

1.29 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

---

1.286 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 291) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.281 ms SELECT SQL_NO_CACHE * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

1.279 ms SELECT SQL_NO_CACHE `id_guest` FROM `king_connections` WHERE `id_guest` = 30152 AND `date_add` > '2020-10-29 23:10: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.277 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

---

1.276 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

---

1.272 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

---

1.265 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.264 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed

---

1.251 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.249 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

---

1.243 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.24 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

---

1.236 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = '655fc1166c861658e118ddae51df67d0' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

1.234 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

---

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

---

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

---

1.226 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.224 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 327) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.216 ms SELECT SQL_NO_CACHE * FROM `king_category` a LEFT JOIN `king_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `king_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 20) AND (b.id_shop = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

1.212 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

---

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

---

1.21 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

---

1.207 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

---

1.206 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

---

1.198 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = 'bbf85f0345b6d40ecdf140ed9d4d1741' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

1.196 ms SELECT SQL_NO_CACHE public_name FROM `king_attribute_group_lang` agl LEFT JOIN `king_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:2627
1 row browsed

---

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

---

1.188 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

---

1.177 ms SELECT SQL_NO_CACHE COUNT(*) FROM king_layered_category WHERE id_category = 18 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:638
1 row browsed

---

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

---

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

---

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

---

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

---

1.147 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

---

1.144 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

---

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

---

1.134 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

---

1.133 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

---

1.129 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module_shop` WHERE `id_module` = 77 AND `id_shop` = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1635
1 row browsed

---

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

---

1.121 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

---

1.12 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

---

1.119 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

---

1.11 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

---

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

---

1.107 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.105 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.103 ms SELECT SQL_NO_CACHE `id_module` FROM `king_module` WHERE `name` = "paypal" LIMIT 1
in /home/cinquantl/www/kingsushi/classes/module/Module.php:1888
1 row browsed

---

1.095 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

---

1.083 ms SELECT SQL_NO_CACHE *, ( IF ('2020-10-29 23:40:44' >= `from` AND '2020-10-29 23:40:44' <= `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, 292) 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 '2020-10-29 23:40:44' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-10-29 23:40:44' <= `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.076 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.073 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

---

1.072 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

---

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

---

1.063 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

---

1.061 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

---

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

---

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

---

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

---

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

---

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

---

1.055 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

---

1.052 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

---

1.051 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

---

1.05 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

---

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

---

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

---

1.047 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 2 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
1 row browsed

---

1.038 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

---

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

---

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

---

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

---

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

---

1.022 ms SELECT SQL_NO_CACHE * FROM `king_category_lang` WHERE `id_category` = 18 AND `id_shop` = 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed

---

1.02 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

---

1.02 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 290) 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.015 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

---

1.015 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

---

1.013 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

---

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

---

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

---

0.978 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.977 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.975 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.971 ms SELECT SQL_NO_CACHE * FROM `king_hook_alias`
in /home/cinquantl/www/kingsushi/classes/Hook.php:182
86 rows browsed

---

0.97 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.968 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.964 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.963 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.96 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = '655fc1166c861658e118ddae51df67d0' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

0.956 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.952 ms SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite` FROM `king_category_lang` AS c LEFT JOIN `king_lang` AS l ON c.`id_lang` = l.`id_lang` WHERE c.`id_category` = 18 AND l.`active` = 1
in /home/cinquantl/www/kingsushi/classes/Category.php:1209
1 row browsed

---

0.95 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.949 ms SELECT SQL_NO_CACHE * FROM `king_group` a LEFT JOIN `king_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

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

---

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

---

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` = 27 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

---

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

---

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

---

0.914 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.913 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.909 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 = 291 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

---

0.909 ms SELECT SQL_NO_CACHE * FROM `king_tax` a WHERE (a.id_tax = 2) LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:212
1 row browsed

---

0.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` = 13 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /home/cinquantl/www/kingsushi/classes/Category.php:727
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

---

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

---

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

---

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

---

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

---

0.888 ms SELECT SQL_NO_CACHE `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.884 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.883 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = 'bbf85f0345b6d40ecdf140ed9d4d1741' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

0.878 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.866 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.863 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.862 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.858 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.857 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.856 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `king_category` c LEFT JOIN `king_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN king_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 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.856 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 = 50 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

---

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

---

0.844 ms SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `king_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 18 AND cl.id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Meta.php:284
1 row browsed

---

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

---

0.837 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.834 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.833 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.833 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.83 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.824 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 = 327 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:662
1 row browsed

---

0.822 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.821 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `king_stock_available` WHERE (id_product = 50) 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.821 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.819 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 = 326 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

---

0.817 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.816 ms SELECT SQL_NO_CACHE id_shop FROM `king_category_shop` WHERE `id_category` = 18 AND id_shop = 1 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:1244
1 row browsed

---

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

---

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

---

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

---

0.809 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.805 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.802 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.8 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 = 292 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

---

0.796 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.795 ms SELECT SQL_NO_CACHE * FROM `king_tax_lang` WHERE `id_tax` = 2
in /home/cinquantl/www/kingsushi/classes/ObjectModel.php:219
1 row browsed

---

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

---

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

---

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

---

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

---

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

---

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

---

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

---

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

---

0.764 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.762 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.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` = 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.755 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 = 292 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

---

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

---

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

---

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

---

0.737 ms SELECT SQL_NO_CACHE pa.id_product_attribute FROM king_product_attribute pa INNER JOIN king_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 50 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:652
1 row browsed

---

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

---

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

---

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

---

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

---

0.71 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.709 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.707 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.701 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.7 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.699 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 = 327 LIMIT 1
in /home/cinquantl/www/kingsushi/classes/Product.php:671
1 row browsed

---

0.696 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.693 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.693 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.683 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.675 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = '655fc1166c861658e118ddae51df67d0' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

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

---

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

---

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

---

0.619 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.615 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.609 ms SELECT SQL_NO_CACHE data FROM `king_layered_friendly_url` WHERE `url_key` = '655fc1166c861658e118ddae51df67d0' LIMIT 1
in /home/cinquantl/www/kingsushi/modules/blocklayered/blocklayered.php:1708
1 row browsed

---

0.6 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.599 ms SELECT SQL_NO_CACHE `id_menu` FROM `king_megamenu_menus_context` WHERE `id_menu` = 9 LIMIT 1
in /home/cinquantl/www/kingsushi/modules/autumnmegamenu/autumnmegamenu.php:998
0 rows browsed

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

---

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

---

16 SELECT * FROM `king_product` a LEFT JOIN `king_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `king_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX

---

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

---

8 SELECT 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

---

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

---

8 SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `king_image` i INNER JOIN king_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `king_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`

---

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

---

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

---

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

---

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

---

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

---

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

---

8 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

---

8 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

---

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

---

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

---

4 SELECT data FROM `king_layered_friendly_url` WHERE `url_key` = 'bbfXXfXXbXXdXXecdfXXedXXdXXdXX' LIMIT XX

---

4 SELECT data FROM `king_layered_friendly_url` WHERE `url_key` = 'XXfcXXcXXeXXddaeXXdfXXdXX' LIMIT XX

---

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

---

3 SELECT s.*, sl.`description` FROM `king_supplier` s LEFT JOIN `king_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 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 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 nleft, nright, level_depth FROM king_category WHERE id_category = XX LIMIT XX

---

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 p.`id_product` id_product FROM `king_product` p INNER JOIN king_category_product cp ON p.id_product = cp.id_product INNER JOIN king_category c ON (c.id_category = cp.id_category AND c.nleft >= XX AND c.nright <= XX AND c.active = XX) RIGHT JOIN king_layered_category lc ON (lc.id_category = XX AND lc.id_shop = XX) INNER JOIN king_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE XX AND product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product

---

2 SELECT ctg.`id_group` FROM king_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX

Tables stress

---

99 category_lang

---

94 category

---

88 category_shop

---

43 category_group

---

42 product_attribute

---

41 product_attribute_shop

---

37 product_shop

---

29 product

---

18 product_lang

---

13 megamenu_menus_context

---

12 image_type

---

10 image

---

10 image_lang

---

10 image_shop

---

10 stock_available

---

8 specific_price

---

8 megamenu_menus

---

8 layered_friendly_url

---

8 specific_price_priority

---

8 product_group_reduction_cache

---

6 hook

---

6 module

---

5 category_product

---

4 manufacturer

---

4 shop

---

4 shop_url

---

4 layered_category

---

4 lang_shop

---

4 hook_module

---

4 currency_shop

---

4 lang

---

3 supplier_lang

---

3 supplier

---

3 module_shop

---

3 country

---

3 supplier_shop

---

3 currency

---

2 hook_alias

---

2 meta

---

2 country_lang

---

2 tax_rule

---

2 country_shop

---

2 shop_group

---

2 meta_lang

---

2 manufacturer_lang

---

2 manufacturer_shop

---

2 group

---

1 scene_category

---

1 connections

---

1 scene_lang

---

1 scene

---

1 page

---

1 tax_lang

---

1 scene_shop

---

1 required_field

---

1 page_type

---

1 layered_indexable_feature

---

1 group_lang

---

1 configuration

---

1 group_shop

---

1 configuration_lang

---

1 module_group

---

1 hook_module_exceptions

---

1 autumn_slider

---

1 social_links

---

1 theme

---

1 feature_lang

---

1 layered_indexable_attribute_group

---

1 attribute_group_lang

---

1 tax

ObjectModel instances

---

72 Category

---

16 Product

---

2 Address

---

2 Language

---

2 Country

---

1 Tax

---

1 Connection

---

1 Guest

---

1 Currency

---

1 ShopGroup

---

1 Customer

---

1 Shop

---

1 Cart

---

1 Group

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