Catégories

Déjà vus

Fabricants

Rechercher

Accueil>Accessories>Housse portefeuille en cuir (iPod nano) - Noir/Chocolat

Housse portefeuille en cuir (iPod nano) - Noir/Chocolat

Housse portefeuille en cuir (iPod nano) - Noir/Chocolat

Cet étui en cuir tendance assure une protection complète contre les éraflures et les petits aléas de la vie quotidienne. Sa conception élégante et compacte vous permet de glisser votre iPod directement dans votre poche ou votre sac à main.

Plus de détails


£25.04 TTC

92 pièces disponibles

Ajouter à ma liste

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


Caractéristiques

  • Cuir doux résistant
  • Accès au bouton Hold
  • Fermeture magnétique
  • Accès au Dock Connector
  • Protège-écran

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: 551ms
I hope it is a shared hosting
Hook processing: 303ms
Memory peak usage: 16.58 Mb
SQL Queries: 139 queries
Time spent querying: 82ms
Included files: 157
Size of included files: 1.5 Mb
Globals (> 1 Ko only): 943 Ko

Stopwatch (with SQL_NO_CACHE)

41.236 ms SELECT c.`id_guest` FROM `ps_connections` c WHERE c.`id_guest` = 0 AND DATE_ADD(c.`date_add`, INTERVAL 30 MINUTE) > '2012-05-18 04:58:00' ORDER BY c.`date_add` DESC
4.218 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1237 AND `id_page` = 50
2.882 ms INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('0','50','2012-05-18 04:58:22')
2.571 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.296 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` = 8 AND al.`id_lang` = 2 AND agl.`id_lang` = 2 ORDER BY agl.`public_name`, al.`name`
1.049 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
0.971 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` = 8) 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 = 8) 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.962 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 = 8 AND p.active = 1
0.912 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.815 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` = 8 AND l.`active` = 1
0.813 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` = 3 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, c.`position` ASC
0.791 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` = 8 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC
0.787 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` = 3 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,100
0.745 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 = 8
0.744 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.736 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` = 8 AND cg.`id_group` = 1
0.649 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` = 8
0.637 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` = 8 AND p.`active` = 1
0.547 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`=8
0.528 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.467 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 8
0.451 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` = 8 AND pccl.`id_lang` = 2 AND pc.`validate` = 1
0.433 ms SELECT * FROM `ps_product` a WHERE a.`id_product` = 8
0.396 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 9) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.391 ms SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 8 AND `active` = 1
0.374 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` = 3
0.368 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large'
0.363 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `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` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.348 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` = 8
0.333 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 0
0.331 ms SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 8
0.324 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 5) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.321 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` = 8 ORDER BY `position`
0.315 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 8) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.304 ms SELECT * FROM `ps_module`
0.304 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 <= 4 AND c.nright >= 7 AND cl.id_lang = 2 AND c.id_category != 1 ORDER BY c.level_depth ASC LIMIT 1
0.303 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.3 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 2) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.293 ms SELECT *, ( IF ('2012-05-18 04:58:22' >= `from` AND '2012-05-18 04:58:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 6) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.281 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` = 3
0.275 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.268 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1
0.264 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` = 8 AND ctg.`id_group` = 1
0.256 ms SELECT `id_product` FROM `ps_specific_price` WHERE `id_shop` IN(0, 1) AND `id_currency` IN(0, 3) AND `id_country` IN(0, 17) AND `id_group` IN(0, 1) AND `from_quantity` = 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:58:22' <= `to`) ) AND `reduction` > 0
0.24 ms SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = 8 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
0.239 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 8 ORDER BY `price` DESC
0.23 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` = 3
0.22 ms SELECT id_product FROM `ps_category_product` WHERE `id_product`=8 AND `id_category` IN(5)
0.206 ms INSERT INTO `ps_page_viewed` (`id_date_range`,`id_page`,`counter`) VALUES (1237,50,1)
0.203 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 8 AND `validate` = 1
0.198 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 3 AND ctg.`id_group` = 1
0.196 ms SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 8
0.193 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 8 AND `validate` = 1 AND `grade` > 0
0.193 ms SELECT id_product FROM `ps_product` p WHERE 1 AND id_product = 8 AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0
0.191 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.178 ms SELECT id_category, level_depth, nleft, nright FROM ps_category WHERE id_category = 3
0.177 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = 3
0.166 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.163 ms SELECT * FROM `ps_category` a WHERE a.`id_category` = 3
0.157 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.155 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 8
0.155 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.148 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1
0.143 ms SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
0.139 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9
0.139 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.138 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.133 ms SELECT * FROM `ps_currency` WHERE `deleted` = 0 AND `active` = 1 ORDER BY `name` ASC
0.132 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 1
0.13 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 0
0.12 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 (5,9) AND pl.id_lang = 2 AND cl.id_lang = 2
0.117 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.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2 AND `id_group` = 1
0.115 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.115 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.112 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.109 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.106 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.106 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 2
0.104 ms SELECT * FROM `ps_currency` a WHERE a.`id_currency` = 3
0.104 ms SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
0.103 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.096 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.096 ms SELECT `name` FROM `ps_subdomain`
0.095 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.095 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.093 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.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 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.092 ms SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
0.091 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
0.091 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.09 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
0.09 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.09 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.089 ms SELECT COUNT(*) FROM `ps_lang` WHERE `active` = 1
0.089 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr'
0.088 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.088 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.087 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 9
0.087 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.087 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 1
0.087 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1
0.087 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.086 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 31
0.086 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.085 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
0.085 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 5
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.085 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 1
0.084 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1 AND `id_group` = 1
0.084 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.082 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.081 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5
0.08 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.079 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1
0.079 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 6
0.078 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 2
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` = 6 AND `id_group` = 1
0.076 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2
0.076 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8
0.075 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9 AND `id_group` = 1
0.074 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6
0.073 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1

Doubles (IDs replaced by "XX")

7 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
7 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 *, ( 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
5 SELECT `id_tax_rules_group` FROM `ps_product` WHERE `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
4 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.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AS new, (p.`price` * IF(t.`rate`,((XX + (t.`rate`))/XX),XX)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = XX) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = XX AND tr.`id_state` = XX) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = XX) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = XX AND p.`active` = XX ORDER BY cp.`position` ASC LIMIT XX,XX
2 SELECT p.`price`, pa.`price` AS attribute_price, p.`ecotax` , pa.`ecotax` AS attribute_ecotax FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON pa.`id_product_attribute` = XX WHERE p.`id_product` = XX
2 SELECT IF(COUNT(id_product_attribute), SUM(pa.`quantity`), p.`quantity`) as total FROM `ps_product` p LEFT JOIN `ps_product_attribute` AS pa ON pa.`id_product` = p.`id_product` WHERE p.`id_product` = XX AND `id_product_attribute` = XX GROUP BY p.`id_product`
2 SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = 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 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 `reduction` FROM `ps_group` WHERE `id_group` = 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 * FROM `ps_lang` a WHERE a.`id_lang` = XX
2 SELECT * FROM `ps_currency` WHERE `deleted` = XX AND `active` = XX ORDER BY `name` ASC
2 SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 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
1 SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
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 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_required_field, object_name, field_name FROM ps_required_field
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 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 COUNT(*) FROM ps_pack WHERE id_product_pack = 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.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 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 *, ( 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 `width`, `height` FROM ps_image_type WHERE `name` = 'large'
1 SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX ORDER BY `price` DESC
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.`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 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 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 INSERT INTO `ps_page_viewed` (`id_date_range`,`id_page`,`counter`) VALUES (XX,XX,XX)
1 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = 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_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 GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 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
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 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 `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.*, 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 * 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 `name` FROM `ps_supplier` WHERE `id_supplier` = XX
1 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `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 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 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 * FROM `ps_module`
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 `width`, `height` FROM ps_image_type WHERE `name` = 'home'
1 SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr'
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 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_currency` a WHERE a.`id_currency` = XX
1 SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = XX
1 SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
1 SELECT * FROM `ps_product` a WHERE a.`id_product` = 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 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.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 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 * FROM `ps_category` a WHERE a.`id_category` = XX
1 SELECT `name` FROM `ps_subdomain`
1 SELECT * FROM `ps_category_lang` WHERE `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 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 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 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

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