Catégories

Déjà vus

Fabricants

Rechercher

Accueil>Laptops>MacBook Air

MacBook Air

MacBook Air est ultra fin, ultra portable et ultra différent de tout le reste. Mais on ne perd pas des kilos et des centimètres en une nuit. C'est le résultat d'une réinvention des normes. D'une multitude d'innovations sans fil. Et d'une révolution dans le design. Avec MacBook Air, l'informatique mobile prend soudain une nouvelle dimension.

Plus de détails


£1,504.18 TTC

274 pièces disponibles

Ajouter à ma liste

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


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

MacBook Air est presque aussi fin que votre index. Pratiquement tout ce qui pouvait être simplifié l'a été. Il n'en dispose pas moins d'un écran panoramique de 13,3 pouces, d'un clavier complet et d'un vaste trackpad multi-touch. Incomparablement portable il vous évite les compromis habituels en matière d'écran et de clavier ultra-portables.

L'incroyable finesse de MacBook Air est le résultat d'un grand nombre d'innovations en termes de réduction de la taille et du poids. D'un disque dur plus fin à des ports d'E/S habilement dissimulés en passant par une batterie plus plate, chaque détail a été considéré et reconsidéré avec la finesse à l'esprit.

MacBook Air a été conçu et élaboré pour profiter pleinement du monde sans fil. Un monde dans lequel la norme Wi-Fi 802.11n est désormais si rapide et si accessible qu'elle permet véritablement de se libérer de toute attache pour acheter des vidéos en ligne, télécharger des logicééééiels, stocker et partager des fichiers sur le Web.

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: 510ms
I hope it is a shared hosting
Hook processing: 248ms
Memory peak usage: 16.61 Mb
SQL Queries: 144 queries
Time spent querying: 38ms
Included files: 157
Size of included files: 1.5 Mb
Globals (> 1 Ko only): 1012 Ko

Stopwatch (with SQL_NO_CACHE)

3.02 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 1
1.908 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` = 5 AND al.`id_lang` = 2 AND agl.`id_lang` = 2 ORDER BY agl.`public_name`, al.`name`
1.782 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
1.774 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.268 ms SELECT * FROM `ps_currency` a WHERE a.`id_currency` = 3
1.037 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.014 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` = 5) 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 = 5) 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.938 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.918 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` = 5 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC
0.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` = 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` = 4 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,100
0.751 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`=5
0.717 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` = 5 AND cg.`id_group` = 1
0.666 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1
0.662 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.645 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` = 5 AND p.`active` = 1
0.555 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 (12, 14, 15, 13) AND il.`id_lang` = 2 ORDER by i.`position`
0.554 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` = 5 AND pccl.`id_lang` = 2 AND pc.`validate` = 1
0.52 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.472 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 <= 8 AND c.nright >= 9 AND cl.id_lang = 2 AND c.id_category != 1 ORDER BY c.level_depth ASC LIMIT 1
0.448 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 31
0.444 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.441 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.43 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.402 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` = 5
0.385 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` = 5 AND l.`active` = 1
0.38 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` = 5 ORDER BY `position`
0.357 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` = 15 WHERE p.`id_product` = 5
0.354 ms SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 5
0.345 ms SELECT * FROM `ps_product` a WHERE a.`id_product` = 5
0.339 ms SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 5 AND `active` = 1
0.333 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.331 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.312 ms SELECT *, ( IF ('2012-05-18 05:07:42' >= `from` AND '2012-05-18 05:07:42' <= `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.308 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 = 5 AND p.active = 1
0.281 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` = 5
0.28 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 5
0.273 ms SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 5
0.272 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 `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:07:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 05:07:42' <= `to`) ) AND `reduction` > 0
0.27 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 5 AND `validate` = 1
0.26 ms SELECT id_product FROM `ps_category_product` WHERE `id_product`=5 AND `id_category` IN(3)
0.245 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` = 5 AND ctg.`id_group` = 1
0.244 ms SELECT * FROM `ps_module`
0.242 ms SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = 5 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
0.227 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 = 5
0.227 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 5
0.227 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 5 ORDER BY `price` DESC
0.222 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 4 AND ctg.`id_group` = 1
0.211 ms SELECT id_product FROM `ps_product` p WHERE 1 AND id_product = 5 AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0
0.206 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = 4
0.202 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` = 4
0.201 ms SELECT * FROM `ps_category` a WHERE a.`id_category` = 4
0.195 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1237 AND `id_page` = 72
0.194 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 5 AND `validate` = 1 AND `grade` > 0
0.191 ms SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
0.183 ms SELECT id_category, level_depth, nleft, nright FROM ps_category WHERE id_category = 4
0.179 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.169 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.169 ms INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('0','72','2012-05-18 05:07:43')
0.154 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.152 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.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.128 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.126 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 8
0.125 ms SELECT * FROM `ps_currency` WHERE `deleted` = 0 AND `active` = 1 ORDER BY `name` ASC
0.123 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 1
0.123 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.119 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.118 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.115 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 (2,1) AND pl.id_lang = 2 AND cl.id_lang = 2
0.112 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 8
0.11 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.108 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.103 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.102 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` = 4
0.101 ms SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
0.101 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.1 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.1 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.098 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.098 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` = 4 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, c.`position` ASC
0.096 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.095 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` = 13 WHERE p.`id_product` = 5
0.095 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.093 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 1
0.093 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.092 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.092 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.092 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.09 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
0.09 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.09 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.089 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.089 ms SELECT `name` FROM `ps_subdomain`
0.089 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 0
0.089 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` = 5 AND `id_product_attribute` = 13 GROUP BY p.`id_product`
0.089 ms SELECT `id_address` FROM ps_address WHERE `id_manufacturer` = 1
0.088 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.088 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large'
0.087 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 1 AND `active` = 1
0.087 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 2
0.087 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 9
0.087 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:07:00' ORDER BY c.`date_add` DESC
0.086 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 1
0.086 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr'
0.086 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
0.086 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1
0.085 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.084 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.084 ms SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
0.084 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.083 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.083 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.083 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 13
0.082 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 6
0.081 ms SELECT COUNT(*) FROM `ps_lang` WHERE `active` = 1
0.081 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.08 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2
0.08 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8
0.077 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8 AND `id_group` = 1
0.077 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1 AND `id_group` = 1
0.077 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1
0.076 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1
0.076 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
0.076 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 2
0.075 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1
0.075 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9
0.075 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5
0.073 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6
0.072 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2 AND `id_group` = 1
0.07 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 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
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
5 SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = XX
4 SELECT * FROM `ps_product_lang` WHERE `id_product` = XX
4 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
4 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
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 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`
3 SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX
3 SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 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 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
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 `reduction` FROM `ps_group` WHERE `id_group` = XX
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 COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX
2 SELECT * FROM `ps_currency` WHERE `deleted` = XX AND `active` = XX ORDER BY `name` ASC
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`
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 `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX ORDER BY `price` DESC
1 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = 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 *, ( 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 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 `id_product_download` FROM `ps_product_download` WHERE `id_product` = XX AND `active` = 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 COUNT(*) FROM ps_pack WHERE id_product_pack = XX
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 COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX AND `grade` > XX
1 SELECT `id_address` FROM ps_address WHERE `id_manufacturer` = XX
1 SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `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` = 'product.php' AND p.`id_object` = XX
1 INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('XX','XX','XX-XX-XX XX:XX: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_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 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 `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = XX
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 `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
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
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 `width`, `height` FROM ps_image_type WHERE `name` = 'large'
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 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 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 GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = XX
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 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 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 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 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 `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
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 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 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 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_product` a WHERE a.`id_product` = XX
1 SELECT * FROM `ps_category` a WHERE a.`id_category` = 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 * FROM `ps_category_lang` WHERE `id_category` = XX
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

Tables stress

36 product
23 product_attribute
20 category_lang
15 product_lang
14 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
4 feature_value_lang
4 feature_lang
4 feature_product
3 cms_category_lang
3 hook
3 hook_module
3 image_type
3 product_comment_criterion
3 currency
3 product_comment_criterion_lang
3 tax_lang
3 group
2 cms_block_lang
2 cms_block
2 cms_block_page
2 date_range
2 product_comment_criterion_category
2 customer
2 manufacturer_lang
2 product_comment_criterion_product
2 address
2 pack
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