Categorii

Producatori

Politica de confidentialitate

Aceasta pagina descrie Politica Noastra de Confidentialitate.

In conformitate cu Legea nr.677/2001, privind protectia persoanelor cu privire la prelucrarea datelor cu caracter personal si libera circulatie a acestor date, va informam ca societatea noastra va inregistra datele Dvs. personale in calitate de clienti, numai in vederea expedierii marfurilor si materialului de informare sau publicitar.

Prin comenzile pe care le realizati consultand ofertele noastre, va dati acordul expres si neechivoc ca datele Dvs. personale sa fie prelucrate de catre S.C.Roccas ICCP S.R.L. fara alte obligatii sau plati fata de Dvs. in scopul onorarii comenzii si pentru actiuni de marketing direct (trimiterea de mesaje publicitare si de marketing prin posta, telefon, e-mail sau alte mijloace de comunicare din partea noastra si a partenerilor nostri contractuali).

S.C.Roccas ICCP S.R.L. va respecta drepturile conferite de Legea nr. 677/2001 privind protectia persoanelor cu privire la prelucrarea datelor cu caracter personal si libera circulatie a acestor date, a Legii nr. 365/2002 privind comertul electronic, precum si a Ordonantei nr. 130/2000 privind protectia consumatorilor la incheierea si executarea contractelor la distanta cu modificarile ulterioare.

Mentionam ca societatea S.C.Roccas ICCP S.R.L. este inscrisa la Autoritatea Nationala de Supraveghere a Prelucrarii Datelor cu Caracter Personal, in registrul de evidenta a prelucrarilor de date cu caracter personal, sub nr. ..................................

Daca aveti intrebari cu privire la: “Conditiile de utilizare”, “Modalitati de plata”, “Cum cumpar”, “Transport si livrare” sau alte materiale asemanatoare, va rugam sa consultati casuta de informatii aflata in magazinul nostru online sau pot fi directionate catre noi apasand butonul "Contact" din meniul principal. Mai puteti trimite intrebarile Dvs. si direct la adresa de e-mail:  roccas(at)roccas(punct)ro.


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: 187ms
Good boy! That's what I call a webserver!
Hook processing: 154ms / 1.74 Mb
Memory peak usage: 3.92 Mb

Total cache size (in Cache class): 0.19 Mb
DB type: DbPDO
SQL Queries: 71 queries
Time spent querying: 153ms
Included files: 218
Size of included files: 2.13 Mb
Globals (> 1 Ko only): 414 Ko

Stopwatch (with SQL_NO_CACHE) (total = 71)


52.286 ms INSERT INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('0', '10', '2017-11-20 15:14:23')
in /var/www/roccas/prestashop/classes/Connection.php:98

46.4 ms UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1683 AND `id_page` = 10 AND `id_shop` = 1
in /var/www/roccas/prestashop/classes/Page.php:117

14.737 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
3.858 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.453 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
3.283 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
2.46 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
1.136 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.083 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
0.924 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.92 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.888 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
0.8 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
0.793 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.75 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 = 9) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.742 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.703 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.701 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.679 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/roccas/prestashop/classes/Hook.php:143
86 rows browsed
0.664 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.627 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.627 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.554 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.545 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.524 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.517 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.499 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.497 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.488 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.487 ms SELECT SQL_NO_CACHE `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = 7 AND id_cms = 9 LIMIT 1
in /var/www/roccas/prestashop/classes/Meta.php:361
1 row browsed
0.482 ms SELECT SQL_NO_CACHE id_shop FROM `ps_cms_shop` WHERE `id_cms` = 9 AND id_shop = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:1135
1 row browsed
0.475 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.463 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.463 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.451 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.445 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.443 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.431 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.388 ms SELECT SQL_NO_CACHE `price_display_method` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/Group.php:135
1 row browsed
0.386 ms SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 7 AND id_shop = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:1135
1 row browsed
0.384 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.376 ms SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE `id_country` = 36 LIMIT 1
in /var/www/roccas/prestashop/classes/Country.php:220
1 row browsed
0.28 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.273 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.245 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:14:23' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 15:14:23' <= `to`) ) AND `reduction` > 0
in /var/www/roccas/prestashop/classes/SpecificPrice.php:361
1 row browsed
0.23 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.221 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.218 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 = 11) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.214 ms SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = 0 AND DATE_ADD(`date_add`, INTERVAL 30 MINUTE) > '2017-11-20 15:14:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1
in /var/www/roccas/prestashop/classes/Connection.php:133
USING FILESORT - 1 row browsed
0.192 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.187 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 = 7) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.184 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.178 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.173 ms SELECT SQL_NO_CACHE * FROM `ps_cms_category` a LEFT JOIN `ps_cms_category_lang` `b` ON a.id_cms_category = b.id_cms_category AND b.id_lang = 7 WHERE (a.id_cms_category = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.172 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.169 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 = 16) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.169 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 = 3) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.164 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 = 5) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.164 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 = 10) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.162 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 = 12) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.159 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.157 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.155 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.144 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 = 7) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.136 ms SELECT SQL_NO_CACHE 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` = 7 AND bcp.`is_category` = 1
in /var/www/roccas/prestashop/modules/blockcms/BlockCMSModel.php:394
6 rows browsed
0.135 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 = 10) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.135 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 = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.133 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed
0.133 ms SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'cms' LIMIT 1
in /var/www/roccas/prestashop/classes/Page.php:97
1 row browsed
0.112 ms SELECT SQL_NO_CACHE `id_page` FROM `ps_page` WHERE `id_page_type` = 7 LIMIT 1
in /var/www/roccas/prestashop/classes/Page.php:79
1 row browsed
0.111 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayMyAccountBlock' OR `name` = 'myaccountblock' LIMIT 1
in /var/www/roccas/prestashop/classes/Hook.php:125
2 rows browsed

Doubles (IDs replaced by "XX") (total = 51)


13 SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = XX LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = XX WHERE (a.id_manufacturer = XX) LIMIT XX
6 SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = XX LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = XX WHERE (a.id_cms = XX) LIMIT XX
2 SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX GROUP BY c.id_currency ORDER BY `name` ASC
2 SELECT * FROM `ps_group_lang` WHERE `id_group` = XX
2 SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = XX LIMIT XX
1 SELECT 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 = XX AND s.deleted = XX ORDER BY LENGTH(uri) DESC
1 SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT XX
1 SELECT 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 = XX WHERE s.deleted = XX AND gs.deleted = XX ORDER BY gs.name, s.name
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT 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) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE t.`id_lang` = XX AND product_shop.`active` = XX 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` = XX ) GROUP BY t.id_tag ORDER BY times DESC LIMIT XX, XX
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 ) INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX) WHERE m.`active` = XX GROUP BY m.id_manufacturer ORDER BY m.`name` ASC
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT XX
1 SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, XX) 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 XX DAY ) ) > XX AS new, (product_shop.`price` * ((XX + (t.`rate`))/XX)) 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 = XX) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX 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 = XX AND image_shop.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 product_shop.`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` 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 = XX AND product_attribute_shop.default_on = XX) 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, XX) AND stock.id_shop = XX ) WHERE (product_shop.`active` = XX) AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=XX)) AND (product_shop.`visibility` IN ("both", "catalog")) AND ( DATEDIFF( product_shop.`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)) AND ((pa.id_product_attribute IS NULL OR product_attribute_shop.id_shop=XX)) ORDER BY p.`date_add` DESC LIMIT XX
1 SELECT `id_product`, `id_product_attribute` 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 `id_customer` 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 * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (XX)
1 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 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` = XX AND ccl.`id_lang` = XX AND bcl.`id_lang` = XX AND bcs.id_shop = XX ORDER BY `position`
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 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 * FROM `ps_cms_category` a LEFT JOIN `ps_cms_category_lang` `b` ON a.id_cms_category = b.id_cms_category AND b.id_lang = XX WHERE (a.id_cms_category = XX) LIMIT XX
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT XX
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayMyAccountBlock' OR `name` = 'myaccountblock' LIMIT XX
1 SELECT `id_guest` FROM `ps_connections` WHERE `id_guest` = XX AND DATE_ADD(`date_add`, INTERVAL XX MINUTE) > 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) ORDER BY `date_add` DESC LIMIT XX
1 SELECT id_page_type FROM ps_page_type WHERE name = 'cms' LIMIT XX
1 SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = XX LIMIT 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`) LIMIT XX
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT XX
1 SELECT m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX) as total FROM `ps_module` m
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT XX
1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayPayment' LIMIT XX
1 SELECT id_required_field, object_name, field_name FROM ps_required_field
1 SELECT 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 = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX
1 SELECT 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)
1 SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX
1 SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = XX) LIMIT XX
1 SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX
1 SELECT 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 = XX) WHERE l.`active` = XX LIMIT XX
1 SELECT 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 (XX)) = XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) AND (mg.`id_group` IN (XX)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
1 SELECT `iso_code` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
1 SELECT id_shop FROM `ps_cms_shop` WHERE `id_cms` = XX AND id_shop = XX LIMIT XX
1 SELECT 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 = XX) INNER JOIN `ps_module_group` mg ON (m.`id_module` = mg.`id_module` AND mg.id_shop = XX) INNER JOIN `ps_customer_group` cg on (cg.`id_group` = mg.`id_group`AND cg.`id_customer` = XX) 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(XX)) = XX AND hm.id_shop IN(XX) AND (mg.`id_group` IN(XX)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`, m.`name` DESC
1 SELECT * FROM `ps_hook_alias`
1 SELECT domain FROM ps_shop_url WHERE main=XX AND id_shop = XX LIMIT XX
1 SELECT domain_ssl FROM ps_shop_url WHERE main = XX AND id_shop=XX LIMIT XX
1 SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
1 SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX
1 SELECT `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = XX AND id_cms = XX LIMIT XX
1 SELECT * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = XX WHERE (a.id_group = XX) LIMIT XX
1 SELECT * FROM `ps_shop` a WHERE (a.id_shop = XX) LIMIT XX
1 UPDATE `ps_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = XX AND `id_shop` = XX

Tables stress


15 manufacturer
14 manufacturer_shop
14 manufacturer_lang
9 hook
8 cms_lang
7 cms
7 cms_shop
5 shop_url
4 lang_shop
4 shop
3 currency_shop
3 currency
3 module_shop
3 group
3 module
3 lang
3 cms_category_lang
2 product
2 category_group
2 category_product
2 group_lang
2 cms_block_page
2 product_shop
2 date_range
2 country
2 module_group
2 hook_module
2 shop_group
1 group_shop
1 stock_available
1 image_type
1 specific_price
1 cms_block
1 cms_block_shop
1 theme
1 required_field
1 cms_block_lang
1 product_attribute
1 cms_category
1 connections
1 page_type
1 page
1 product_attribute_shop
1 image_lang
1 tax
1 tax_rule
1 hook_alias
1 image_shop
1 image
1 product_lang
1 configuration
1 configuration_lang
1 country_lang
1 country_shop
1 tag
1 hook_module_exceptions
1 module_country
1 customer_group
1 product_tag

ObjectModel instances


18 Manufacturer
8 CMS
3 CMSCategory
2 Language
2 GroupCore
1 Shop
1 Country
1 ShopGroup
1 Customer
1 Currency
1 Cart
1 Guest

Included files

1 ./index.php
2 config/config.inc.php
3 config/settings.inc.php
4 config/defines.inc.php
5 config/autoload.php
6 config/alias.php
7 classes/Autoload.php
8 cache/class_index.php
9 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 classes/db/Db.php
17 classes/Context.php
18 override/classes/Context.php
19 classes/shop/Shop.php
20 override/classes/shop/Shop.php
21 classes/Tools.php
22 override/classes/Tools.php
23 classes/db/DbPDO.php
24 override/classes/db/DbPDO.php
25 classes/Validate.php
26 override/classes/Validate.php
27 classes/cache/Cache.php
28 override/classes/cache/Cache.php
29 classes/db/DbQuery.php
30 override/classes/db/DbQuery.php
31 config/defines_uri.inc.php
32 classes/Configuration.php
33 override/classes/Configuration.php
34 classes/Language.php
35 override/classes/Language.php
36 classes/Country.php
37 override/classes/Country.php
38 classes/Collection.php
39 override/classes/Collection.php
40 classes/shop/ShopGroup.php
41 override/classes/shop/ShopGroup.php
42 classes/Cookie.php
43 override/classes/Cookie.php
44 classes/Rijndael.php
45 override/classes/Rijndael.php
46 classes/Customer.php
47 override/classes/Customer.php
48 classes/Group.php
49 override/classes/Group.php
50 config/smarty.config.inc.php
51 tools/smarty/Smarty.class.php
52 tools/smarty/sysplugins/smarty_internal_data.php
53 tools/smarty/sysplugins/smarty_internal_templatebase.php
54 tools/smarty/sysplugins/smarty_internal_template.php
55 tools/smarty/sysplugins/smarty_resource.php
56 tools/smarty/sysplugins/smarty_internal_resource_file.php
57 tools/smarty/sysplugins/smarty_cacheresource.php
58 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
59 config/smartyfront.config.inc.php
60 classes/Dispatcher.php
61 override/classes/Dispatcher.php
62 controllers/front/CmsController.php
63 classes/controller/FrontController.php
64 override/classes/controller/FrontController.php
65 override/controllers/front/CmsController.php
66 classes/module/Module.php
67 override/classes/module/Module.php
68 tools/mobile_Detect/Mobile_Detect.php
69 classes/shop/ShopUrl.php
70 override/classes/shop/ShopUrl.php
71 themes/default/lang/ro.php
72 classes/Currency.php
73 override/classes/Currency.php
74 classes/Link.php
75 override/classes/Link.php
76 classes/Cart.php
77 override/classes/Cart.php
78 classes/CartRule.php
79 override/classes/CartRule.php
80 classes/Meta.php
81 override/classes/Meta.php
82 classes/Product.php
83 override/classes/Product.php
84 classes/CMS.php
85 override/classes/CMS.php
86 modules/cloudcache/cloudcache.php
87 modules/cloudcache/lib/CloudCacheApi.php
88 modules/cloudcache/lib/xmlrpc.inc.php
89 classes/Translate.php
90 override/classes/Translate.php
91 modules/cloudcache/ro.php
92 modules/cloudcache/backward_compatibility/backward.php
93 modules/cloudcache/backward_compatibility/Display.php
94 classes/Media.php
95 override/classes/Media.php
96 modules/blockbestsellers/blockbestsellers.php
97 modules/blockbestsellers/ro.php
98 modules/blockpaymentlogo/blockpaymentlogo.php
99 modules/blockpaymentlogo/ro.php
100 modules/blockpermanentlinks/blockpermanentlinks.php
101 modules/blockpermanentlinks/ro.php
102 modules/blockviewed/blockviewed.php
103 modules/blockviewed/ro.php
104 modules/blockcart/blockcart.php
105 modules/blockcart/ro.php
106 modules/blocksocial/blocksocial.php
107 modules/blocksocial/ro.php
108 modules/blockcontact/blockcontact.php
109 modules/blockcontact/ro.php
110 modules/blockmyaccount/blockmyaccount.php
111 modules/blockmyaccount/ro.php
112 modules/blockcustomerprivacy/blockcustomerprivacy.php
113 modules/blockcustomerprivacy/ro.php
114 modules/blockcategories/blockcategories.php
115 modules/blockcategories/ro.php
116 modules/blockspecials/blockspecials.php
117 modules/blockspecials/ro.php
118 modules/blockcurrencies/blockcurrencies.php
119 modules/blockcurrencies/ro.php
120 modules/blockmyaccountfooter/blockmyaccountfooter.php
121 modules/blockmyaccountfooter/ro.php
122 modules/blocknewproducts/blocknewproducts.php
123 modules/blocknewproducts/ro.php
124 modules/blockuserinfo/blockuserinfo.php
125 modules/blockuserinfo/ro.php
126 modules/blocklanguages/blocklanguages.php
127 modules/blocklanguages/ro.php
128 modules/blockmanufacturer/blockmanufacturer.php
129 modules/blockmanufacturer/ro.php
130 modules/blockcms/blockcms.php
131 modules/blockcms/BlockCMSModel.php
132 modules/blockcms/ro.php
133 modules/blocktags/blocktags.php
134 modules/blocktags/ro.php
135 modules/blockcontactinfos/blockcontactinfos.php
136 modules/blockcontactinfos/ro.php
137 modules/sendtoafriend/sendtoafriend.php
138 modules/sendtoafriend/ro.php
139 modules/mailalerts/mailalerts.php
140 modules/mailalerts/MailAlert.php
141 modules/mailalerts/ro.php
142 modules/blocknewsletter/blocknewsletter.php
143 modules/blocknewsletter/ro.php
144 modules/carriercompare/carriercompare.php
145 modules/carriercompare/ro.php
146 modules/blockwishlist/blockwishlist.php
147 modules/blockwishlist/ro.php
148 cache/smarty/compile/8fae460a059b1f94c7c7fdf9961ffb497fdc4afe.file.blocklanguages.tpl.php
149 cache/smarty/compile/b04a230f788ffac19682dcd7465728e38cd62a22.file.blockcurrencies.tpl.php
150 cache/smarty/compile/242310edf536e913943cd969e2343271a7e2f6f0.file.blockpermanentlinks-header.tpl.php
151 cache/smarty/compile/4b40c177f9b8fe57bcf112cf9259bd2aace25800.file.blockuserinfo.tpl.php
152 modules/blocktopmenu/blocktopmenu.php
153 modules/blocktopmenu/menutoplinks.class.php
154 modules/blocktopmenu/ro.php
155 cache/smarty/cache/blocktopmenu_cms_1_1_7_0_0_0_9_0^7db8acbf281791cfb329e149d69117998c54ed66.blocktopmenu.tpl.php
156 modules/sekeywords/sekeywords.php
157 classes/module/ModuleGraph.php
158 override/classes/module/ModuleGraph.php
159 modules/sekeywords/ro.php
160 classes/Customization.php
161 override/classes/Customization.php
162 cache/smarty/compile/850e13c1c9056a145a3d12dfee275a29e24ed2f8.file.blockcart.tpl.php
163 tools/smarty/plugins/modifier.escape.php
164 tools/smarty/plugins/modifier.replace.php
165 modules/pagesnotfound/pagesnotfound.php
166 modules/pagesnotfound/ro.php
167 modules/blockwishlist/WishList.php
168 cache/smarty/compile/4b7f4dc4a835a98164a89a5eeffd8fde93db46f7.file.blockwishlist_top.tpl.php
169 classes/Tag.php
170 override/classes/Tag.php
171 cache/smarty/compile/59a2e5550b625893ecbd6f75b49cbdda78122c66.file.blocktags.tpl.php
172 cache/smarty/cache/blockcategories^1_1_7_0_0^0966439c9fffb5bef6762aa2d7310fec2acffaa7.blockcategories.tpl.php
173 classes/Manufacturer.php
174 override/classes/Manufacturer.php
175 cache/smarty/compile/09814f5481ac06e20b130e3ef99235fbb80b91ce.file.blockmanufacturer.tpl.php
176 classes/Combination.php
177 override/classes/Combination.php
178 classes/stock/StockAvailable.php
179 override/classes/stock/StockAvailable.php
180 classes/Image.php
181 override/classes/Image.php
182 cache/smarty/compile/ac2fa373bb018a7baf3a73bb4a6d64532448d756.file.blocknewproducts.tpl.php
183 classes/Address.php
184 override/classes/Address.php
185 classes/SpecificPrice.php
186 override/classes/SpecificPrice.php
187 cache/smarty/compile/e3d281ce9ae558eac6a6f339b0dbdc15b638316b.file.blockspecials.tpl.php
188 tools/smarty/plugins/modifier.date_format.php
189 classes/CMSCategory.php
190 override/classes/CMSCategory.php
191 cache/smarty/compile/bf7b0d5e74081cd80709b58aaf520026c2a2d7b0.file.blockcms.tpl.php
192 cache/smarty/compile/14ec1be1ec74f1846b81c56784b53d0b2dc16718.file.blocknewsletter.tpl.php
193 cache/smarty/compile/32d1357062d91dd093fb97fc4dc9e95848aeb6f5.file.blockwishlist.tpl.php
194 cache/smarty/compile/2c20b9a23e4b06793668b5b8180519694e5c1c12.file.blockcontact.tpl.php
195 cache/smarty/cache/blockcategories^1_3_7_0_0^7e87cdab9d255a0e2e3238dadf7a3de06fc22854.blockcategories_footer.tpl.php
196 cache/smarty/compile/924f36b5284f750a7002c1b2d81faa173a96fcda.file.my-account.tpl.php
197 cache/smarty/compile/5a7ee69107c79dad2154a9d3475bc2d3a4372e6a.file.my-account.tpl.php
198 cache/smarty/compile/b5efc848c2d8373d14b5d7727eff851ddfe48cea.file.blockmyaccountfooter.tpl.php
199 cache/smarty/compile/ce6f77e6304bf9d9e2614f347b93a4a63e0f9083.file.blocksocial.tpl.php
200 cache/smarty/compile/5bad86de46d9a397e06c7a8cc7bab1bb72a1452d.file.blockcontactinfos.tpl.php
201 tools/smarty/plugins/function.mailto.php
202 modules/statsdata/statsdata.php
203 modules/statsdata/ro.php
204 classes/Guest.php
205 override/classes/Guest.php
206 classes/Connection.php
207 override/classes/Connection.php
208 classes/Page.php
209 override/classes/Page.php
210 classes/ConnectionsSource.php
211 override/classes/ConnectionsSource.php
212 classes/DateRange.php
213 override/classes/DateRange.php
214 cache/smarty/compile/48d819482ce22b62712b3dcdb92f1058aaf2ae27.file.cms.tpl.php
215 cache/smarty/compile/15c9f57458f351ca6a0544def50c87e9f39bfd87.file.breadcrumb.tpl.php
216 cache/smarty/compile/d41dac886076dcbd0445265be949e717ce2ecad0.file.layout.tpl.php
217 cache/smarty/compile/25d0d0398be0e0b6123289d01927c2bcb871e695.file.header.tpl.php
218 cache/smarty/compile/d6c09b14ff11f9e0a2efe6a880e077b3ae49c047.file.footer.tpl.php