Categories

Manufacturers

Search

Good Morning, Welcome to our demo store


The above "featured slider" has been entirely coded within the theme. It doesn't need any modules installed and would appear as above without the need to install any additional code apart from the "plugins" override. It inserts the required css and javascript into the header using  Tools::AddCss() and Tools::AddJS calls so that the files may be compressed and minimised automatically, if desired.

This page itself has been inserted onto the home page using the {cms id='X'} smarty plugin command by eCartService.net. It supports all the features of the CMS editor to allow you to easiy maintain content, and update without having to worry about complex modules, hooks or additional editors. 

 

Learn more by reading the article 1.4 Plugins Revisited on eCartService.net

 

Now you can even use the plugins system to deploy {less} <-- you'll only understand that comment if you read the blog ;) 

 

 

The "Featured Products" block at the bottom of every page (as below) in this demo store uses the following plugin code:

{plugin module='homefeatured' hook='home'}
 
 

Cart  

No products

Shipping £0.00
Total £0.00

Cart Check out

Specials

All specials

Search



Load time: 514ms
I hope it is a shared hosting
Hook processing: 274ms
Memory peak usage: 14.07 Mb
SQL Queries: 88 queries
Time spent querying: 132ms
Included files: 140
Size of included files: 1.15 Mb
Globals (> 1 Ko only): 412 Ko

Stopwatch (with SQL_NO_CACHE)


49.484 ms SELECT c.`id_guest` FROM `ps_connections` c WHERE c.`id_guest` = 0 AND DATE_ADD(c.`date_add`, INTERVAL 30 MINUTE) > '2012-05-18 04:24:00' ORDER BY c.`date_add` DESC
12.487 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` b ON (a.`id_category` = b.`id_category` AND `id_lang` = 1) WHERE a.`id_category` = 1
9.353 ms INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('0','1','2012-05-18 04:24:50')
5.921 ms SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) AND `level_depth` <= 3 AND cg.`id_group` IN (1) GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC
3.528 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 6) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
3.448 ms SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m LEFT JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` LEFT JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` AND m.`active` = 1 ORDER BY hm.`position`
3.404 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6
3.224 ms SELECT c.`name`, cl.`id_lang`, cl.`value` as cl_value, c.`value` as c_value FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
2.886 ms SELECT p.*, pa.`id_product_attribute`, 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`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = 1 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,4
1.596 ms SELECT `id_product` FROM `ps_specific_price` WHERE `id_shop` IN(0, 1) AND `id_currency` IN(0, 3) AND `id_country` IN(0, 17) AND `id_group` IN(0, 1) AND `from_quantity` = 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) AND `reduction` > 0
1.579 ms SELECT t.name, COUNT(pt.id_tag) AS times FROM `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) WHERE t.`id_lang` = 1 AND p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 0, 10
1.426 ms SELECT cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = 1 AND c.`id_category` = 4
1.419 ms SELECT p.*, pa.`id_product_attribute`, 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`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = 1 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,8
1.34 ms SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = 0 AND ccl.`id_lang` = 1 AND bcl.`id_lang` = 1 ORDER BY `position`
1.222 ms SELECT cl.`id_cms`, cl.`meta_title`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_lang` cl ON (bcp.`id_cms` = cl.`id_cms`) INNER JOIN `ps_cms` c ON (bcp.`id_cms` = c.`id_cms`) WHERE bcp.`id_cms_block` = 1 AND cl.`id_lang` = 1 AND bcp.`is_category` = 0 AND c.`active` = 1 ORDER BY `position`
1.203 ms SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
1.045 ms SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = 1) WHERE p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY sales DESC LIMIT 0, 5
0.881 ms SELECT p.`id_page` FROM `ps_page` p LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type` WHERE pt.`name` = 'index.php'
0.876 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 1
0.778 ms SELECT m.*, ml.`description` FROM `ps_manufacturer` m LEFT JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1) WHERE m.`active` = 1 ORDER BY m.`name` ASC
0.775 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'index' AND ml.id_lang = 1
0.727 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
0.714 ms SELECT * FROM `ps_module`
0.707 ms SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * ((100 + (t.`rate`))/100)) AS orderprice, pa.id_product_attribute FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT OUTER JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND `default_on` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE p.`active` = 1 AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY p.`date_add` DESC LIMIT 0, 5
0.705 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` b ON (a.`id_country` = b.`id_country` AND `id_lang` = 1) WHERE a.`id_country` = 17
0.684 ms SELECT `name` FROM `ps_subdomain`
0.647 ms SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
0.637 ms SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
0.623 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
0.617 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'order' AND ml.id_lang = 1
0.607 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 1
0.567 ms SELECT COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 99
0.561 ms SELECT * FROM `ps_currency` a WHERE a.`id_currency` = 3
0.558 ms SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) WHERE p.id_product = 1
0.545 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 0
0.536 ms SELECT page, url_rewrite FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta) WHERE id_lang = 1
0.519 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.474 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 6 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 6
0.47 ms SELECT bcp.`id_cms`, cl.`name`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_category_lang` cl ON (bcp.`id_cms` = cl.`id_cms_category`) WHERE bcp.`id_cms_block` = 1 AND cl.`id_lang` = 1 AND bcp.`is_category` = 1
0.439 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 6
0.425 ms SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = 1 AND ccl.`id_lang` = 1 AND bcl.`id_lang` = 1 ORDER BY `position`
0.42 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 2
0.403 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1237 AND `id_page` = 1
0.385 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 6
0.379 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1
0.378 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 1
0.372 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1
0.36 ms SELECT * FROM `ps_currency` WHERE `deleted` = 0 AND `active` = 1 ORDER BY `name` ASC
0.36 ms SELECT IF(COUNT(id_product_attribute), SUM(pa.`quantity`), p.`quantity`) as total FROM `ps_product` p LEFT JOIN `ps_product_attribute` AS pa ON pa.`id_product` = p.`id_product` WHERE p.`id_product` = 1 AND `id_product_attribute` = 31 GROUP BY p.`id_product`
0.357 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1
0.353 ms SELECT COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 48
0.344 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 2) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.344 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1 AND `id_group` = 1
0.343 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 9) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.341 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 5) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.334 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 9 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 9
0.317 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` b ON (a.`id_cms` = b.`id_cms` AND `id_lang` = 1) WHERE a.`id_cms` = 6
0.317 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 8 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 8
0.314 ms SELECT *, ( IF ('2012-05-18 04:24:50' >= `from` AND '2012-05-18 04:24:50' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 8) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:24:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.305 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 2 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 2
0.289 ms SELECT * FROM `ps_tax_rule` WHERE `id_country` = 17 AND `id_tax_rules_group` = 2 AND `id_state` IN (0, 0) AND `id_county` IN (0, 0) ORDER BY `id_county` DESC, `id_state` DESC
0.289 ms SELECT IF(COUNT(id_product_attribute), SUM(pa.`quantity`), p.`quantity`) as total FROM `ps_product` p LEFT JOIN `ps_product_attribute` AS pa ON pa.`id_product` = p.`id_product` WHERE p.`id_product` = 2 AND `id_product_attribute` = 8 GROUP BY p.`id_product`
0.287 ms SELECT p.id_product FROM `ps_product` p WHERE 1 AND p.`active` = 1 AND p.`id_product` IN (1) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY RAND()
0.271 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9
0.269 ms SELECT cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = 1 AND c.`id_category` = 2
0.261 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 5 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 5
0.259 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 31
0.248 ms SELECT COUNT(*) FROM `ps_lang` WHERE `active` = 1
0.233 ms SELECT p.`price`, pa.`price` AS attribute_price, p.`ecotax` , pa.`ecotax` AS attribute_ecotax FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON pa.`id_product_attribute` = 31 WHERE p.`id_product` = 1
0.229 ms SELECT p.`price`, pa.`price` AS attribute_price, p.`ecotax` , pa.`ecotax` AS attribute_ecotax FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON pa.`id_product_attribute` = 8 WHERE p.`id_product` = 2
0.21 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2 AND `id_group` = 1
0.198 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
0.198 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5
0.186 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9 AND `id_group` = 1
0.177 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 8
0.176 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 9
0.172 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 8
0.172 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1
0.169 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1
0.167 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 5
0.165 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2
0.164 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 2
0.164 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8
0.157 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 1
0.143 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8 AND `id_group` = 1

Doubles (IDs replaced by "XX")


6 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)) AS `score` FROM `ps_specific_price` WHERE `id_product` 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 `from_quantity` <= 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`) ) ORDER BY `score` DESC, `from_quantity` DESC
6 SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = XX
6 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX
6 SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = XX AND default_on = XX), XX) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = XX
6 SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX
3 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) WHERE pf.id_product = XX
2 SELECT cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = XX AND c.`id_category` = XX
2 SELECT p.*, pa.`id_product_attribute`, 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`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AS new, (p.`price` * IF(t.`rate`,((XX + (t.`rate`))/XX),XX)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = XX) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = XX AND tr.`id_state` = XX) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = XX) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = XX AND p.`active` = XX ORDER BY cp.`position` ASC LIMIT XX,XX
2 SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = XX
2 SELECT IF(COUNT(id_product_attribute), SUM(pa.`quantity`), p.`quantity`) as total FROM `ps_product` p LEFT JOIN `ps_product_attribute` AS pa ON pa.`id_product` = p.`id_product` WHERE p.`id_product` = XX AND `id_product_attribute` = XX GROUP BY p.`id_product`
2 SELECT COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = XX
2 SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = XX AND ccl.`id_lang` = XX AND bcl.`id_lang` = XX ORDER BY `position`
2 SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX
2 SELECT p.`price`, pa.`price` AS attribute_price, p.`ecotax` , pa.`ecotax` AS attribute_ecotax FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON pa.`id_product_attribute` = XX WHERE p.`id_product` = XX
2 SELECT * FROM `ps_currency` WHERE `deleted` = XX AND `active` = XX ORDER BY `name` ASC
1 SELECT bcp.`id_cms`, cl.`name`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_category_lang` cl ON (bcp.`id_cms` = cl.`id_cms_category`) WHERE bcp.`id_cms_block` = XX AND cl.`id_lang` = XX AND bcp.`is_category` = XX
1 SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` b ON (a.`id_cms` = b.`id_cms` AND `id_lang` = XX) WHERE a.`id_cms` = XX
1 SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`eanXX`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AS new, (p.`price` * ((XX + (t.`rate`))/XX)) AS orderprice, pa.id_product_attribute FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT OUTER JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND `default_on` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = XX AND tr.`id_state` = XX) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE p.`active` = XX AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = XX ) ORDER BY p.`date_add` DESC LIMIT XX, XX
1 SELECT cl.`id_cms`, cl.`meta_title`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_lang` cl ON (bcp.`id_cms` = cl.`id_cms`) INNER JOIN `ps_cms` c ON (bcp.`id_cms` = c.`id_cms`) WHERE bcp.`id_cms_block` = XX AND cl.`id_lang` = XX AND bcp.`is_category` = XX AND c.`active` = XX ORDER BY `position`
1 SELECT m.*, ml.`description` FROM `ps_manufacturer` m LEFT JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX) WHERE m.`active` = XX ORDER BY m.`name` ASC
1 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = XX
1 SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = XX OR c.`id_category` = XX) AND `level_depth` <= XX AND cg.`id_group` IN (XX) GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC
1 INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('XX','XX','XX-XX-XX XX:XX:XX')
1 SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
1 SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`eanXX`, p.`upc`, cl.`link_rewrite` AS category FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = XX) WHERE p.`active` = XX AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = XX ) ORDER BY sales DESC LIMIT XX, XX
1 SELECT p.id_product FROM `ps_product` p WHERE XX AND p.`active` = XX AND p.`id_product` IN (XX) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = XX ) ORDER BY RAND()
1 SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`eanXX`, p.`upc`, i.`id_image`, il.`legend`, t.`rate` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = XX AND tr.`id_state` = XX) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) WHERE p.id_product = XX
1 SELECT p.`id_page` FROM `ps_page` p LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type` WHERE pt.`name` = 'index.php'
1 SELECT t.name, COUNT(pt.id_tag) AS times FROM `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) WHERE t.`id_lang` = XX AND p.`active` = XX AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = XX ) GROUP BY t.id_tag ORDER BY times DESC LIMIT XX, XX
1 SELECT `id_product` FROM `ps_specific_price` WHERE `id_shop` IN(XX, XX) AND `id_currency` IN(XX, XX) AND `id_country` IN(XX, XX) AND `id_group` IN(XX, XX) AND `from_quantity` = 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 `reduction` > XX
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
1 SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = XX
1 SELECT c.`id_guest` FROM `ps_connections` c WHERE c.`id_guest` = XX AND DATE_ADD(c.`date_add`, INTERVAL XX MINUTE) > 'XX-XX-XX XX:XX:XX' ORDER BY c.`date_add` DESC
1 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m LEFT JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` LEFT JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` AND m.`active` = XX ORDER BY hm.`position`
1 SELECT `name` FROM `ps_subdomain`
1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` b ON (a.`id_country` = b.`id_country` AND `id_lang` = XX) WHERE a.`id_country` = XX
1 SELECT id_required_field, object_name, field_name FROM ps_required_field
1 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` b ON (a.`id_category` = b.`id_category` AND `id_lang` = XX) WHERE a.`id_category` = XX
1 SELECT COUNT(*) FROM `ps_lang` WHERE `active` = XX
1 SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = XX
1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'index' AND ml.id_lang = XX
1 SELECT page, url_rewrite FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta) WHERE id_lang = XX
1 SELECT * FROM `ps_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND `id_county` IN (XX, XX) ORDER BY `id_county` DESC, `id_state` DESC
1 SELECT * FROM `ps_lang` a WHERE a.`id_lang` = XX
1 SELECT * FROM `ps_currency` a WHERE a.`id_currency` = XX
1 SELECT * FROM `ps_module`
1 SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
1 SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
1 SELECT `reduction` FROM `ps_group` WHERE `id_group` = XX
1 SELECT c.`name`, cl.`id_lang`, cl.`value` as cl_value, c.`value` as c_value FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'order' AND ml.id_lang = XX

Tables stress


23 product
15 product_attribute
7 specific_price
7 category_lang
7 category_group
6 product_group_reduction_cache
6 category_product
6 specific_price_priority
5 image
5 product_lang
5 image_lang
5 tax_rule
4 tax
4 category
4 manufacturer
3 feature_product
3 cms_category_lang
3 hook
3 hook_module
3 feature_value_lang
3 lang
3 feature_lang
3 meta_lang
3 currency
3 meta
2 cms
2 tax_lang
2 cms_lang
2 cms_block
2 cms_block_page
2 module
2 image_type
2 cms_block_lang
2 group
2 date_range
1 page_type
1 page
1 address
1 product_sale
1 connections
1 product_tag
1 country
1 configuration
1 required_field
1 configuration_lang
1 country_lang
1 tag
1 hook_module_exceptions
1 subdomain
1 manufacturer_lang