Categories

Manufacturers

Search

Home>Delivery

Shipments and returns

Your pack shipment

Packages are generally dispatched within 2 days after receipt of payment and are shipped via Colissimo with tracking and drop-off without signature. If you prefer delivery by Colissimo Extra with required signature, an additional cost will be applied, so please contact us before choosing this method. Whichever shipment choice you make, we will provide you with a link to track your package online.

Shipping fees include handling and packing fees as well as postage costs. Handling fees are fixed, whereas transport fees vary according to total weight of the shipment. We advise you to group your items in one order. We cannot group two distinct orders placed separately, and shipping fees will apply to each of them. Your package will be dispatched at your own risk, but special care is taken to protect fragile objects.

Boxes are amply sized and your items are well-protected.


Cart  

No products

Shipping £0.00
Total £0.00

Cart Check out

Specials

All specials

Search



Load time: 375ms
Good boy! That's what I call a webserver!
Hook processing: 152ms
Memory peak usage: 14.38 Mb
SQL Queries: 91 queries
Time spent querying: 35ms
Included files: 141
Size of included files: 1.17 Mb
Globals (> 1 Ko only): 413 Ko

Stopwatch (with SQL_NO_CACHE)

14.221 ms SELECT * FROM `ps_cms_category` a LEFT JOIN `ps_cms_category_lang` b ON (a.`id_cms_category` = b.`id_cms_category` AND `id_lang` = 1) WHERE a.`id_cms_category` = 1
1.986 ms SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = 1 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,8
1.641 ms INSERT INTO `ps_connections_page` (`id_connections`,`id_page`,`time_start`) VALUES ('0','13','2012-05-18 04:42:53')
1.152 ms SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = 1 AND p.`active` = 1 ORDER BY cp.`position` ASC LIMIT 0,4
1.076 ms SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (p.`price` * ((100 + (t.`rate`))/100)) AS orderprice, pa.id_product_attribute FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT OUTER JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND `default_on` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE p.`active` = 1 AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY p.`date_add` DESC LIMIT 0, 5
1.052 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1237 AND `id_page` = 13
0.964 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.817 ms SELECT l.`id_lang`, c.`link_rewrite` FROM `ps_cms_lang` AS c LEFT JOIN `ps_lang` AS l ON c.`id_lang` = l.`id_lang` WHERE c.`id_cms` = 1 AND l.`active` = 1
0.728 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` b ON (a.`id_cms` = b.`id_cms` AND `id_lang` = 1) WHERE a.`id_cms` = 1
0.663 ms SELECT `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = 1 AND id_cms = 1
0.448 ms SELECT *, ( IF ('2012-05-18 04:42:52' >= `from` AND '2012-05-18 04:42:52' <= `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:42:52' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:52' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.423 ms SELECT *, ( IF ('2012-05-18 04:42:52' >= `from` AND '2012-05-18 04:42:52' <= `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:42:52' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:52' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.412 ms SELECT *, ( IF ('2012-05-18 04:42:52' >= `from` AND '2012-05-18 04:42:52' <= `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:42:52' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:52' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.398 ms SELECT *, ( IF ('2012-05-18 04:42:53' >= `from` AND '2012-05-18 04:42:53' <= `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:42:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:53' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.39 ms SELECT *, ( IF ('2012-05-18 04:42:53' >= `from` AND '2012-05-18 04:42:53' <= `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:42:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:53' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.336 ms SELECT *, ( IF ('2012-05-18 04:42:53' >= `from` AND '2012-05-18 04:42:53' <= `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:42:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:53' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
0.333 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.298 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:42:53' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2012-05-18 04:42:53' <= `to`) ) AND `reduction` > 0
0.284 ms SELECT * FROM `ps_module`
0.244 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` = 'cms.php'
0.206 ms SELECT * FROM `ps_lang` a WHERE a.`id_lang` = 1
0.198 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.195 ms SELECT * FROM `ps_currency` WHERE `deleted` = 0 AND `active` = 1 ORDER BY `name` ASC
0.185 ms SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) AND `level_depth` <= 3 AND cg.`id_group` IN (1) GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC
0.177 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.176 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6
0.175 ms SELECT t.name, COUNT(pt.id_tag) AS times FROM `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) WHERE t.`id_lang` = 1 AND p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 0, 10
0.173 ms SELECT cl.`id_cms`, cl.`meta_title`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_lang` cl ON (bcp.`id_cms` = cl.`id_cms`) INNER JOIN `ps_cms` c ON (bcp.`id_cms` = c.`id_cms`) WHERE bcp.`id_cms_block` = 1 AND cl.`id_lang` = 1 AND bcp.`is_category` = 0 AND c.`active` = 1 ORDER BY `position`
0.17 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
0.169 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.163 ms SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 17 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) WHERE p.id_product = 1
0.158 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8 AND `id_group` = 1
0.157 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'order' AND ml.id_lang = 1
0.148 ms SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = 0 AND ccl.`id_lang` = 1 AND bcl.`id_lang` = 1 ORDER BY `position`
0.147 ms SELECT page, url_rewrite FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta) WHERE id_lang = 1
0.142 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.14 ms SELECT `name` FROM `ps_subdomain`
0.14 ms SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, i.`id_image`, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = p.`id_category_default` AND cl.`id_lang` = 1) WHERE p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY sales DESC LIMIT 0, 5
0.132 ms SELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name FROM `ps_cms_block` bc INNER JOIN `ps_cms_category_lang` ccl ON (bc.`id_cms_category` = ccl.`id_cms_category`) INNER JOIN `ps_cms_block_lang` bcl ON (bc.`id_cms_block` = bcl.`id_cms_block`) WHERE bc.`location` = 1 AND ccl.`id_lang` = 1 AND bcl.`id_lang` = 1 ORDER BY `position`
0.129 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 1 AND ctg.`id_group` = 1
0.125 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.124 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9
0.119 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5 AND `id_group` = 1
0.116 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.109 ms SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
0.108 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.107 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en'
0.107 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 2
0.106 ms SELECT cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = 1 AND c.`id_category` = 2
0.105 ms SELECT * FROM `ps_currency` a WHERE a.`id_currency` = 3
0.104 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 1
0.104 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:42:00' ORDER BY c.`date_add` DESC
0.102 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 1
0.098 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.094 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.093 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.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` = 31 WHERE p.`id_product` = 1
0.091 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) WHERE pf.id_product = 6
0.091 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.09 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.09 ms SELECT `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 8
0.09 ms SELECT cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = 1 AND c.`id_category` = 4
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 `price` FROM `ps_product_attribute` WHERE `id_product_attribute` = 31
0.088 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 1
0.087 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5
0.087 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1
0.086 ms SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
0.084 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1 AND `id_group` = 1
0.082 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8
0.082 ms SELECT bcp.`id_cms`, cl.`name`, cl.`link_rewrite` FROM `ps_cms_block_page` bcp INNER JOIN `ps_cms_category_lang` cl ON (bcp.`id_cms` = cl.`id_cms_category`) WHERE bcp.`id_cms_block` = 1 AND cl.`id_lang` = 1 AND bcp.`is_category` = 1
0.081 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 2
0.081 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 8
0.081 ms SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = 5 AND default_on = 1), 0) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = 5
0.08 ms SELECT `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`)
0.08 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address` WHERE `id_address` = 0
0.08 ms SELECT COUNT(*) FROM `ps_lang` WHERE `active` = 1
0.079 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
0.078 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 6
0.077 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6 AND `id_group` = 1
0.077 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1
0.077 ms SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2
0.077 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 9
0.076 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
0.075 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.072 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9 AND `id_group` = 1
0.071 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2 AND `id_group` = 1
0.068 ms SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = 5

Doubles (IDs replaced by "XX")

6 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `from_quantity` <= XX AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) ORDER BY `score` DESC, `from_quantity` DESC
6 SELECT `id_tax_rules_group` FROM `ps_product` WHERE `id_product` = XX
6 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX
6 SELECT `priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX
6 SELECT p.`price`, IFNULL((SELECT pa.price FROM `ps_product_attribute` pa WHERE id_product = XX AND default_on = XX), XX) AS attribute_price, p.`ecotax` FROM `ps_product` p WHERE p.`id_product` = XX
3 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) WHERE pf.id_product = XX
2 SELECT * 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 ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX
2 SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL XX DAY)) > XX AS new, (p.`price` * IF(t.`rate`,((XX + (t.`rate`))/XX),XX)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = XX) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = XX AND tr.`id_state` = XX) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = XX) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = XX AND p.`active` = XX ORDER BY cp.`position` ASC LIMIT XX,XX
2 SELECT 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 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 cl.`link_rewrite` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE `id_lang` = XX AND c.`id_category` = XX
2 SELECT p.`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 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
1 SELECT * FROM `ps_cms_category` a LEFT JOIN `ps_cms_category_lang` b ON (a.`id_cms_category` = b.`id_cms_category` AND `id_lang` = XX) WHERE a.`id_cms_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
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 l.`id_lang`, c.`link_rewrite` FROM `ps_cms_lang` AS c LEFT JOIN `ps_lang` AS l ON c.`id_lang` = l.`id_lang` WHERE c.`id_cms` = XX AND l.`active` = 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 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 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 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_page` FROM `ps_page` p LEFT JOIN `ps_page_type` pt ON p.`id_page_type` = pt.`id_page_type` WHERE pt.`name` = 'cms.php'
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 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = 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 `width`, `height` FROM ps_image_type WHERE `name` = 'medium'
1 SELECT `id_product` FROM `ps_specific_price` WHERE `id_shop` IN(XX, XX) AND `id_currency` IN(XX, XX) AND `id_country` IN(XX, XX) AND `id_group` IN(XX, XX) AND `from_quantity` = XX AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND `reduction` > XX
1 SELECT p.id_product FROM `ps_product` p WHERE XX AND p.`active` = XX AND p.`id_product` IN (XX) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = XX ) ORDER BY RAND()
1 SELECT p.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 * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` b ON (a.`id_cms` = b.`id_cms` AND `id_lang` = XX) WHERE a.`id_cms` = XX
1 SELECT COUNT(*) FROM `ps_lang` WHERE `active` = XX
1 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` b ON (a.`id_category` = b.`id_category` AND `id_lang` = XX) WHERE a.`id_category` = XX
1 SELECT * 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 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 `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = XX AND id_cms = XX
1 SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en'
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 * FROM `ps_lang` a WHERE a.`id_lang` = XX
1 SELECT * FROM `ps_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND `id_county` IN (XX, XX) ORDER BY `id_county` DESC, `id_state` DESC
1 SELECT 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 * FROM `ps_module`
1 SELECT CONCAT(id_hook, '-', id_module) as `key`, `file_name` as value FROM `ps_hook_module_exceptions`
1 SELECT `name` FROM `ps_subdomain`
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home'
1 SELECT `id_lang`, `name`, `iso_code`, `active` FROM `ps_lang`
1 SELECT `reduction` FROM `ps_group` WHERE `id_group` = XX
1 SELECT c.`name`, cl.`id_lang`, cl.`value` as cl_value, c.`value` as c_value FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE m.page = 'order' AND ml.id_lang = XX

Tables stress

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