Categorii

Producatori

MTP102-16B-E Măriţi

MTP102-16B-E

MTP102-16B-E Mecanism pentru imprimare termica. Pretul nu contine TVA.                                                           

Detalii

MTP102-16B-E

Acest produs nu se comercializează individual. Vă rugăm să selectaţi cel puţin 50 bucati din acest produs

Disponibilitate: In stoc

50 produse în stoc

MTP102-16B-E Mecanism pentru imprimare termica cu cap mobil.

Latime hartie 38mm.

Imprimare:16caractere/linie.

Interfata compatibila:IFM001-01B

CPU compatibila:PTM01F01

Seria de imprimante MTP este utilizata pe scară largă în aplicaţii cum ar fi instrumente de măsurare,analizoare, dispozitive medicale, echipamente de învăţământ şi diverse terminale.

Produse noi

» Nici un produs nou

Oferte speciale

Nici o oferta speciala in prezent

Newsletter

Contactati-ne

Programul nostru este zilnic, de luni pana vineri, intre orele 9,00 - 17,00

Telefon: +4 021 252 89 90+40 21 252 89 90

Contactati-ne: roccas@roccas.ro


Load time: 294ms
Good boy! That's what I call a webserver!
Hook processing: 230ms / 1.78 Mb
Memory peak usage: 5.13 Mb

Total cache size (in Cache class): 0.41 Mb
DB type: DbPDO
SQL Queries: 120 queries
Time spent querying: 209ms
Included files: 255
Size of included files: 2.37 Mb
Globals (> 1 Ko only): 442 Ko

Stopwatch (with SQL_NO_CACHE) (total = 120)


62.203 ms INSERT INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('0', '176', '2017-11-20 15:35:32')
in /var/www/roccas/prestashop/classes/Connection.php:98

53.632 ms INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('1683', '176', '1', '1', '1')
in /var/www/roccas/prestashop/classes/Page.php:126

18.482 ms SELECT SQL_NO_CACHE 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) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 7 AND product_shop.`active` = 1 AND product_shop.`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
in /var/www/roccas/prestashop/classes/Tag.php:151
USING FILESORT - 3966 rows browsed
6.61 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 10 DAY ) ) > 0 AS new, (product_shop.`price` * ((100 + (t.`rate`))/100)) AS orderprice, pa.id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 LEFT JOIN `ps_image` `i` ON i.`id_product` = p.`id_product` LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` `il` ON i.`id_image` = il.`id_image` AND il.`id_lang` = 7 LEFT JOIN `ps_tax_rule` `tr` ON product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 36 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` LEFT OUTER JOIN `ps_product_attribute` pa ON p.`id_product` = pa.`id_product` LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.default_on = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) WHERE (product_shop.`active` = 1) AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1)) AND (product_shop.`visibility` IN ("both", "catalog")) AND ( DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 10 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)) AND ((pa.id_product_attribute IS NULL OR product_attribute_shop.id_shop=1)) ORDER BY p.`date_add` DESC LIMIT 5
in /var/www/roccas/prestashop/classes/Product.php:1958
USING FILESORT - 3966 rows browsed
3.757 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)
in /var/www/roccas/prestashop/classes/Configuration.php:117
2142 rows browsed
3.507 ms SELECT SQL_NO_CACHE `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
in /var/www/roccas/prestashop/classes/DateRange.php:50
2531281 rows browsed
3.318 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /var/www/roccas/prestashop/classes/Hook.php:296
USING FILESORT - 414 rows browsed
1.896 ms SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook` h INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
in /var/www/roccas/prestashop/classes/Hook.php:187
131 rows browsed
1.515 ms SELECT SQL_NO_CACHE m.*, ml.`description` FROM `ps_manufacturer` m LEFT JOIN `ps_manufacturer_lang` ml ON ( m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 7 ) INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE m.`active` = 1 GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
in /var/www/roccas/prestashop/classes/Manufacturer.php:180
USING FILESORT - 13 rows browsed
Useless GROUP BY need to be removed
1.238 ms SELECT SQL_NO_CACHE *, ( IF ('2017-11-20 15:35:32' >= `from` AND '2017-11-20 15:35:32' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 36, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 84) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 3) AND `id_country` IN (0, 36) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /var/www/roccas/prestashop/classes/SpecificPrice.php:232
USING FILESORT - 2 rows browsed
1.103 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `ps_module` m
in /var/www/roccas/prestashop/classes/module/Module.php:159
69 rows browsed
1.081 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
in /var/www/roccas/prestashop/classes/shop/Shop.php:587
USING FILESORT - 1 row browsed
1.073 ms SELECT SQL_NO_CACHE DISTINCT m.`id_module`, h.`id_hook`, m.`name`, hm.`position` FROM `ps_module` m LEFT JOIN `ps_module_country` mc ON (m.`id_module` = mc.`id_module` AND mc.id_shop = 1) INNER JOIN `ps_module_group` mg ON (m.`id_module` = mg.`id_module` AND mg.id_shop = 1) INNER JOIN `ps_customer_group` cg on (cg.`id_group` = mg.`id_group`AND cg.`id_customer` = 0) 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` WHERE h.`name` = 'displayPayment' AND (SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN(1)) = 1 AND hm.id_shop IN(1) AND (mg.`id_group` IN(3)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`, m.`name` DESC
in /var/www/roccas/prestashop/classes/module/Module.php:1325
0 rows browsed
1.042 ms SELECT SQL_NO_CACHE 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`=84
in /var/www/roccas/prestashop/classes/Tag.php:160
1 row browsed
1.019 ms SELECT SQL_NO_CACHE * FROM `ps_tax_rule` WHERE `id_country` = 36 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR `zipcode_from` = 0 OR `zipcode_from` = '0') ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /var/www/roccas/prestashop/classes/tax/TaxRulesTaxManager.php:88
USING FILESORT - 1 row browsed
0.964 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/shop/Shop.php:197
1 row browsed
0.923 ms SELECT SQL_NO_CACHE 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` = 84 AND ctg.`id_group` = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/Product.php:4100
4 rows browsed
0.921 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, 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 10 DAY ) ) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 36 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE `id_product_1` = 84 AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1)) AND product_shop.`active` = 1
in /var/www/roccas/prestashop/classes/Product.php:3045
1 row browsed
0.905 ms SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASC
in /var/www/roccas/prestashop/classes/Currency.php:209
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed
0.841 ms SELECT SQL_NO_CACHE 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 LEFT JOIN `ps_cms_block_shop` bcs ON (bcs.id_cms_block = bc.id_cms_block) 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` = 7 AND bcl.`id_lang` = 7 AND bcs.id_shop = 1 ORDER BY `position`
in /var/www/roccas/prestashop/modules/blockcms/BlockCMSModel.php:345
USING FILESORT - 1 row browsed
0.83 ms SELECT SQL_NO_CACHE `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` AND pl.id_shop = 1 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 7 AND pl.id_product = 84 AND product_shop.active = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/Meta.php:241
1 row browsed
0.825 ms SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 7 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 84) AND (b.id_shop = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.819 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop=1) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute=pa.id_product_attribute AND product_attribute_shop.id_shop=1) WHERE (p.`id_product` = 84)
in /var/www/roccas/prestashop/classes/Product.php:2537
1 row browsed
0.817 ms SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 7 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 84) AND (b.id_shop = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.808 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.roccas.ro' OR su.domain_ssl = 'www.roccas.ro') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(uri) DESC
in /var/www/roccas/prestashop/classes/shop/Shop.php:314
USING FILESORT - 1 row browsed
0.807 ms SELECT SQL_NO_CACHE 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` = 7 AND bcp.`is_category` = 0 AND c.`active` = 1 ORDER BY `position`
in /var/www/roccas/prestashop/modules/blockcms/BlockCMSModel.php:381
USING FILESORT - 6 rows browsed
0.718 ms SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASC
in /var/www/roccas/prestashop/classes/Currency.php:209
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed
0.711 ms SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 7 LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 51) AND (b.id_shop = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.71 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 84 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /var/www/roccas/prestashop/classes/SpecificPrice.php:188
1 row browsed
0.684 ms SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 51 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
in /var/www/roccas/prestashop/classes/Category.php:530
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
0.682 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1683 AND `id_page` = 176 AND `id_shop` = 1
in /var/www/roccas/prestashop/classes/Page.php:117

0.663 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /var/www/roccas/prestashop/classes/Language.php:668
7 rows browsed
0.663 ms SELECT SQL_NO_CACHE `id_product`, `id_product_attribute` FROM `ps_specific_price` WHERE `id_shop` IN(0, 1) AND `id_currency` IN(0, 3) AND `id_country` IN(0, 36) AND `id_group` IN(0, 1) AND `id_customer` IN(0, 0) AND `from_quantity` = 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' <= `to`) ) AND `reduction` > 0
in /var/www/roccas/prestashop/classes/SpecificPrice.php:361
1 row browsed
0.655 ms SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 84 AND `id_group` = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/GroupReduction.php:140
0 rows browsed
0.652 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 7 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 36) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.629 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/Language.php:770
7 rows browsed
0.618 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/roccas/prestashop/classes/Hook.php:143
86 rows browsed
0.612 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 3) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.568 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 51 LIMIT 1
in /var/www/roccas/prestashop/classes/Category.php:859
1 row browsed
0.555 ms SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.549 ms SELECT SQL_NO_CACHE 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 AND cl.id_shop = 1 ) WHERE c.nleft <= 105 AND c.nright >= 106 AND c.nleft >= 2 AND c.nright <= 651 AND cl.id_lang = 7 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
in /var/www/roccas/prestashop/classes/Tools.php:891
USING FILESORT - 54 rows browsed
0.539 ms SELECT SQL_NO_CACHE p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 84 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 10 DAY ) ) > 0
in /var/www/roccas/prestashop/classes/Product.php:999
0 rows browsed
0.533 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 84) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/stock/StockAvailable.php:354
1 row browsed
0.528 ms SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 7 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 4) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.518 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.517 ms SELECT SQL_NO_CACHE `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 7 AND `active` = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/Manufacturer.php:239
1 row browsed
0.514 ms SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:230
7 rows browsed
0.499 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.498 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 4) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.495 ms SELECT SQL_NO_CACHE domain FROM ps_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/shop/ShopUrl.php:151
1 row browsed
0.492 ms SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
in /var/www/roccas/prestashop/classes/Image.php:367
1 row browsed
0.492 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.48 ms SELECT SQL_NO_CACHE *, ( IF ('2017-11-20 15:35:32' >= `from` AND '2017-11-20 15:35:32' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 36, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN(0, 84) AND `id_shop` IN(0, 1) AND `id_currency` IN(0, 3) AND `id_country` IN(0, 36) AND `id_group` IN(0, 1) AND `id_customer` IN(0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 15:35:32' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC
in /var/www/roccas/prestashop/classes/SpecificPrice.php:292
USING FILESORT - 2 rows browsed
0.479 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 7) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.478 ms SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:230
7 rows browsed
0.47 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.467 ms SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /var/www/roccas/prestashop/classes/module/Module.php:1471
1 row browsed
0.461 ms SELECT SQL_NO_CACHE `price_display_method` FROM `ps_group` WHERE `id_group` = 3 LIMIT 1
in /var/www/roccas/prestashop/classes/Group.php:135
1 row browsed
0.455 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 13) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.453 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayPayment' LIMIT 1
in /var/www/roccas/prestashop/classes/module/Module.php:1304
1 row browsed
0.449 ms SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 7 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 3) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.436 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field
in /var/www/roccas/prestashop/classes/ObjectModel.php:1094
1 row browsed
0.435 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 9) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.435 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 14) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.434 ms SELECT SQL_NO_CACHE domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1
in /var/www/roccas/prestashop/classes/shop/ShopUrl.php:163
1 row browsed
0.432 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 15) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.426 ms SELECT SQL_NO_CACHE * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 7 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 8) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.426 ms SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
in /var/www/roccas/prestashop/classes/Supplier.php:177
0 rows browsed
0.425 ms SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 7 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /var/www/roccas/prestashop/classes/Category.php:733
USING FILESORT - 12 rows browsed
Useless GROUP BY need to be removed
0.42 ms SELECT SQL_NO_CACHE 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`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, pa.`weight`, product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`, pa.`minimal_quantity`, pa.`available_date`, ag.`group_type` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 ) 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` INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 84 AND al.`id_lang` = 7 AND agl.`id_lang` = 7 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC
in /var/www/roccas/prestashop/classes/Product.php:2953
[PHP Warning #2] Invalid argument supplied for foreach() (/var/www/roccas/prestashop/tools/profiling/Controller.php, line 398)