Catégories

Déjà vus

Fabricants

Rechercher

Accueil>iPods>iPod shuffle

iPod shuffle

iPod shuffle, le baladeur le plus portable du monde, se clippe maintenant en bleu, vert, rose et rouge.

Plus de détails


£66.05 TTC

Disponibilité : En stock

98 pièces disponibles

Ajouter à ma liste

Programme de fidélisation En achetant ce produit vous pouvez gagner jusqu'à 6 points de fidélité. Votre panier totalisera 6 points pouvant être transformé(s) en un bon de réduction de £1.20.


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

Un lien immédiat.

Portez jusqu'à 500 chansons accrochées à votre manche, à votre ceinture ou à votre short. Arborez votre iPod shuffle comme signe extérieur de votre passion pour la musique. Existe désormais en quatre nouveaux coloris encore plus éclatants.

Emplissez votre iPod shuffle.

iTunes est un immense magasin dédié au divertissement, une collection musicale parfaitement organisée et un jukebox. Vous pouvez en un seul clic remplir votre iPod shuffle de chansons.

La musique en technicolor.

iPod shuffle s'affiche désormais dans de nouveaux coloris intenses qui rehaussent le design épuré du boîtier en aluminium anodisé. Choisissez parmi le bleu, le vert, le rose, le rouge et l'argenté d'origine.

  • Hauteur 27,3 mm
  • Largeur 41,2 mm
  • Profondeur 10,5 mm (clip compris)
  • Poids 15,5 g
  • Prise casque Mini-jack stéréo

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

Seuls les utilisateurs enregistrés peuvent poster des commentaires.

Panier  

Aucun produit

Expédition £0.00
Total £0.00

Panier Commander

Réductions

Toutes les promos

Rechercher



Load time: 742ms
I hope it is a shared hosting
Hook processing: 370ms
Memory peak usage: 16.59 Mb
SQL Queries: 140 queries
Time spent querying: 48ms
Included files: 157
Size of included files: 1.5 Mb
Globals (> 1 Ko only): 1029 Ko

Stopwatch (with SQL_NO_CACHE)

10.871 ms INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('0','8','2012-05-18 05:05:50')
1.677 ms SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity` FROM `ps_product_attribute` pa LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON a.`id_attribute` = al.`id_attribute` LEFT JOIN `ps_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group` WHERE pa.`id_product` = 2 AND al.`id_lang` = 2 AND agl.`id_lang` = 2 ORDER BY agl.`public_name`, al.`name`
1.472 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` = 2) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) 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` = 2) 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` = 2) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = 2 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,100
1.2 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` = 2) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) 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` = 2) 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` = 2) 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.18 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` = 2) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) 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` = 2) 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` = 2) 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.066 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)
0.922 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` = 2) 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` = 2) 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.883 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, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2) 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` = 2) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) 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 `id_product_1` = 2 AND p.`active` = 1
0.847 ms SELECT pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`) LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = pl.`id_lang`) WHERE p.`id_product` = 2 AND l.`active` = 1
0.737 ms SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (7, 9, 10, 8) AND il.`id_lang` = 2 ORDER by i.`position`
0.712 ms SELECT i.id_image, p.id_product, il.legend, p.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM ps_product p LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN ps_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN ps_image_lang il ON (il.id_image = i.id_image) LEFT JOIN ps_category_lang cl ON (cl.id_category = p.id_category_default) WHERE p.id_product IN (1,9) AND pl.id_lang = 2 AND cl.id_lang = 2
0.691 ms SELECT pc.`id_product_comment`, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `ps_product_comment` pc LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = 2 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC
0.689 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product`) WHERE pl.id_lang = 2 AND pl.id_product = 2 AND p.active = 1
0.664 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (a.`id_product` = b.`id_product` AND `id_lang` = 2) WHERE a.`id_product` = 2
0.608 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.574 ms SELECT COUNT(cug.`id_customer`) AS total FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`) LEFT JOIN `ps_customer_group` cug ON (cug.`id_group` = cg.`id_group`) WHERE p.`id_product` = 2 AND cg.`id_group` = 1
0.559 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.554 ms SELECT i.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 2 ORDER BY `position`
0.519 ms SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 2 AND pccl.`id_lang` = 2 AND pc.`validate` = 1
0.516 ms SELECT ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = 2 AND ctg.`id_group` = 1
0.509 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 2
0.495 ms SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 2 AND `active` = 1
0.49 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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) AND `reduction` > 0
0.487 ms SELECT * FROM `ps_product` a WHERE a.`id_product` = 2
0.456 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.433 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 2 ORDER BY `price` DESC
0.424 ms SELECT id_product FROM `ps_product` p WHERE 1 AND id_product = 2 AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0
0.419 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` = 7 WHERE p.`id_product` = 2
0.412 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.409 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.405 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.397 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` = 'product.php' AND p.`id_object` = 2
0.388 ms SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 2) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product` p ON (p.id_category_default = pccc.id_category AND p.id_product = 2) WHERE pccl.`id_lang` = 2 AND (pccp.id_product IS NOT NULL OR p.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion
0.382 ms SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 2
0.381 ms SELECT id_product FROM `ps_category_product` WHERE `id_product`=2 AND `id_category` IN(2)
0.366 ms SELECT *, ( IF ('2012-05-18 05:05:50' >= `from` AND '2012-05-18 05:05: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 05:05:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:05:50' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.364 ms SELECT * FROM `ps_module`
0.355 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 2 AND `validate` = 1
0.352 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=2
0.344 ms SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 2
0.341 ms SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = 2 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
0.338 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.315 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 2
0.31 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 31
0.294 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.294 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 1
0.291 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` = 2) 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
0.272 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` = 2 AND bcl.`id_lang` = 2 ORDER BY `position`
0.265 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` = 2) 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` = 2) 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.252 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.251 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1
0.248 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.245 ms SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
0.222 ms SELECT * FROM `ps_currency` WHERE `deleted` = 0 AND `active` = 1 ORDER BY `name` ASC
0.211 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 2 AND `validate` = 1 AND `grade` > 0
0.207 ms INSERT INTO `ps_page_viewed` (`id_date_range`,`id_page`,`counter`) VALUES (1237,8,1)
0.202 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` = 2 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
0.197 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
0.185 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`
0.181 ms SELECT * FROM `ps_currency` a WHERE a.`id_currency` = 3
0.173 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` = 2 AND c.`id_category` = 2
0.166 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.161 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.159 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 = 2
0.153 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1237 AND `id_page` = 8
0.153 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 = 2
0.151 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1
0.148 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` b ON (a.`id_category` = b.`id_category` AND `id_lang` = 2) WHERE a.`id_category` = 2
0.147 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` = 2 AND c.`id_category` = 4
0.145 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1 AND `id_group` = 1
0.143 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1
0.14 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 6
0.14 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2
0.137 ms SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` b ON (a.`id_manufacturer` = b.`id_manufacturer` AND `id_lang` = 2) WHERE a.`id_manufacturer` = 1
0.137 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` = 2) 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` = 2) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = 2) 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.137 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = 2
0.137 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6
0.135 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 1
0.135 ms SELECT c.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = 2 AND c.`id_parent` = 1 AND `active` = 1 ORDER BY `position` ASC
0.133 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1
0.133 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.13 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 05:05:00' ORDER BY c.`date_add` DESC
0.127 ms SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, c.`position` ASC
0.127 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.124 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.123 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` = 2 AND bcl.`id_lang` = 2 ORDER BY `position`
0.121 ms SELECT c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category) WHERE c.nleft <= 2 AND c.nright >= 3 AND cl.id_lang = 2 AND c.id_category != 1 ORDER BY c.level_depth ASC LIMIT 1
0.121 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 = 2) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) WHERE pf.id_product = 6
0.12 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
0.12 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large'
0.119 ms SELECT * FROM `ps_category` a WHERE a.`id_category` = 2
0.118 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 0
0.117 ms SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
0.115 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.113 ms SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
0.113 ms SELECT id_category, level_depth, nleft, nright FROM ps_category WHERE id_category = 2
0.112 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 = 2) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) WHERE pf.id_product = 1
0.112 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.111 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 1 AND `active` = 1
0.109 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 1
0.107 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 = 2) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2) WHERE pf.id_product = 2
0.106 ms SELECT `id_address` FROM ps_address WHERE `id_manufacturer` = 1
0.105 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 1
0.102 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` = 0 AND c.`id_category` = 2
0.098 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 2 AND ctg.`id_group` = 1
0.097 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
0.094 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 8
0.092 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.092 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr'
0.089 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 2
0.089 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 2
0.089 ms SELECT `name` FROM `ps_subdomain`
0.086 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.085 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.084 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` = 2 AND bcp.`is_category` = 0 AND c.`active` = 1 ORDER BY `position`
0.081 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` = 2 AND bcp.`is_category` = 1
0.081 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.081 ms SELECT COUNT(*) FROM `ps_lang` WHERE `active` = 1
0.08 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
0.078 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8
0.076 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5
0.076 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 8
0.075 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2 AND `id_group` = 1
0.074 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 5
0.073 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 9
0.072 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9
0.071 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8 AND `id_group` = 1
0.071 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1
0.067 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9 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 `priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX
6 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX
6 SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 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
5 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
3 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
3 SELECT * FROM `ps_product_lang` WHERE `id_product` = XX
3 SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX
3 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
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 pc.`id_product_comment`, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, XX)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `ps_product_comment` pc LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = XX AND pc.`validate` = XX ORDER BY pc.`date_add` DESC
2 SELECT * FROM `ps_lang` a WHERE a.`id_lang` = XX
2 SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX
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 `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 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 * FROM `ps_currency` WHERE `deleted` = XX AND `active` = XX ORDER BY `name` ASC
2 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
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 `reduction` FROM `ps_group` WHERE `id_group` = XX
2 SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = XX) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product` p ON (p.id_category_default = pccc.id_category AND p.id_product = XX) WHERE pccl.`id_lang` = XX AND (pccp.id_product IS NOT NULL OR p.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = XX) AND pcc.active = XX GROUP BY pcc.id_product_comment_criterion
1 SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = XX AND pccl.`id_lang` = XX AND pc.`validate` = XX
1 SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX AND `grade` > XX
1 INSERT INTO `ps_page_viewed` (`id_date_range`,`id_page`,`counter`) VALUES (XX,XX,XX)
1 SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = XX AND pc.`id_customer` = XX ORDER BY pc.`date_add` DESC LIMIT XX
1 SELECT `id_address` FROM ps_address WHERE `id_manufacturer` = XX
1 SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description 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 `id_parent` = XX AND `active` = XX AND cg.`id_group` = XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, c.`position` ASC
1 SELECT c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category) WHERE c.nleft <= XX AND c.nright >= XX AND cl.id_lang = XX AND c.id_category != XX ORDER BY c.level_depth ASC LIMIT XX
1 SELECT id_category, level_depth, nleft, nright FROM ps_category WHERE id_category = XX
1 SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = XX
1 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` = '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
1 SELECT i.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
1 SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` b ON (a.`id_manufacturer` = b.`id_manufacturer` AND `id_lang` = XX) WHERE a.`id_manufacturer` = XX
1 SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX ORDER BY `price` DESC
1 SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
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_page` FROM `ps_page` p LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type` WHERE pt.`name` = 'product.php' AND p.`id_object` = 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 `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 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 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = XX
1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = XX AND `active` = XX
1 SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = XX
1 SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`, pa.`unit_price_impact`, pa.`minimal_quantity` FROM `ps_product_attribute` pa LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON a.`id_attribute` = al.`id_attribute` LEFT JOIN `ps_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group` WHERE pa.`id_product` = XX AND al.`id_lang` = XX AND agl.`id_lang` = XX ORDER BY agl.`public_name`, al.`name`
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, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_XX` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`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_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) 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 `id_product_XX` = XX AND p.`active` = XX
1 SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
1 SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 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 c.`id_category`, cl.`name`, 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_parent` = XX AND `active` = XX ORDER BY `position` ASC
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large'
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 `width`, `height` FROM ps_image_type WHERE `name` = 'home'
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 COUNT(*) FROM `ps_lang` WHERE `active` = XX
1 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (a.`id_product` = b.`id_product` AND `id_lang` = XX) WHERE a.`id_product` = XX
1 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX
1 SELECT id_product FROM `ps_product` p WHERE XX AND id_product = XX AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX
1 SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 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 `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product`) WHERE pl.id_lang = XX AND pl.id_product = XX AND p.active = XX
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 `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
1 SELECT `name` FROM `ps_subdomain`
1 SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr'
1 SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = XX
1 SELECT * FROM `ps_currency` a WHERE a.`id_currency` = XX
1 SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
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 COUNT(cug.`id_customer`) AS total FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`) LEFT JOIN `ps_customer_group` cug ON (cug.`id_group` = cg.`id_group`) WHERE p.`id_product` = XX AND cg.`id_group` = XX
1 SELECT i.id_image, p.id_product, il.legend, p.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM ps_product p LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN ps_image i ON (i.id_product = p.id_product AND i.cover = XX) LEFT JOIN ps_image_lang il ON (il.id_image = i.id_image) LEFT JOIN ps_category_lang cl ON (cl.id_category = p.id_category_default) WHERE p.id_product IN (XX,XX) AND pl.id_lang = XX AND cl.id_lang = XX
1 SELECT id_product FROM `ps_category_product` WHERE `id_product`=XX AND `id_category` IN(XX)
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
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 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 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 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 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_product` a WHERE a.`id_product` = XX
1 SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
1 SELECT * FROM `ps_module`
1 SELECT * FROM `ps_category` a WHERE a.`id_category` = XX
1 SELECT * FROM `ps_category_lang` WHERE `id_category` = XX
1 SELECT pl.`id_lang`, pl.`link_rewrite`, p.`eanXX`, cl.`link_rewrite` AS category_rewrite FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product`) LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = pl.`id_lang`) WHERE p.`id_product` = XX AND l.`active` = XX
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
1 SELECT ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = XX AND ctg.`id_group` = XX

Tables stress

35 product
20 product_attribute
19 category_lang
14 product_lang
13 category
11 category_group
10 category_product
10 image
10 image_lang
8 specific_price
8 manufacturer
7 tax_rule
7 product_comment
6 tax
6 product_group_reduction_cache
6 lang
6 specific_price_priority
3 feature_value_lang
3 feature_lang
3 product_comment_criterion
3 image_type
3 hook_module
3 cms_category_lang
3 hook
3 currency
3 feature_product
3 product_comment_criterion_lang
3 group
3 tax_lang
2 product_comment_criterion_product
2 manufacturer_lang
2 date_range
2 cms_block
2 cms_block_lang
2 pack
2 product_comment_criterion_category
2 address
2 customer
2 cms_block_page
2 product_tag
2 meta
2 meta_lang
2 tag
2 module
1 attribute_lang
1 attribute_group_lang
1 attribute_group
1 attribute
1 product_attribute_combination
1 configuration_lang
1 page_type
1 connections
1 product_sale
1 accessory
1 product_attribute_image
1 page
1 country
1 cms
1 cms_lang
1 configuration
1 hook_module_exceptions
1 product_download
1 supplier
1 required_field
1 customer_group
1 country_lang
1 subdomain
1 product_comment_grade