Categorii

Producatori

Cum cumpar?

Pentru a efectua o comanda online in magazinul nostru, trebuie sa efectuati urmatorii pasi:

  • Alegeti produsele:

Navigati prin categoriile de produse, folosind meniul din stanga, sau navigati prin lista producatorilor, folosind meniul scroll-bar cu numele producatorilor (sau accesati link-ul PRODUCATORI si selectati producatorul dorit). Se va afisa lista cu produsele existente in magazin, din categoria aleasa, sau a producatorului selectat.

O alta modalitate, este utilizarea casutei de CAUTARE RAPIDA. Utilizand aceasta varianta, aveti posibilitatea de a cauta in paginile catalogului nostru, dupa orice criteriu de cautare: denumire produs, codul produsului, producator sau caracteristica tehnica a produsului.

Pentru a afla informatii suplimentare si a vizualiza fotografia marita a produsului, apasati pe link-ul cu denumirea acestuia sau pe imaginea lui.

Odata ce ati gasit un produs care se potriveste dorintelor Dvs, apasati butonul Adaugare in cos.

IMPORTANT ! Verificati disponibilitatea produsului ! Atunci cand produsul dorit nu este in prezent in stoc, acesta poate fi disponibil la comanda. Articolul va avea eticheta "La comanda", in dreptul disponibilitatii acestuia. Pentru toate produsele care nu se afla in stoc, va rugam sa contactati telefonic sau pe adresa de e-mail societatea. Comenzile vor fi preluate de un operator care va va oferi toate informatiile necesare si va va prelua comanda.

Pentru cantitatile mari de produse, comanda poate fi efectuata doar pe adresa de e-mail a societatii sau telefonic.

  • Cosul de cumparaturi:

Apasand link-ul COS CUMPARATURI, veti fi directionat in pagina cosului dumneavoastra de cumparaturi, unde aveti posibilitatea sa revedeti lista produselor, sa actualizati cantitatea produselor pe care intentionati sa le comandati sau sa renuntati la unul sau toate produsele selectate.

  • Finalizarea comenzii

Pentru a finaliza comanda trebuie sa va autentificati. Daca aveti un cont creat, va rugam sa introduceti adresa Dvs. de e-mail si parola in caseta Client inregistrat.

Daca nu, folositi caseta Creati un cont pentru a va crea un cont de membru. Completati toate casutele marcate ca informatii obligatorii.

Crearea unui cont va ofera avantajul de a fi la curent in permanenta cu statutul comenzilor Dvs pana in momentul livrarii, cu istoricul lor, precum si posibilitatea de a beneficia de informari periodice referitoare la noutati, promotii si evenimente in cadrul magazinului nostru.

Ulterior parcurgerii acestor pasi, se va deschide pagina de comanda, in care veti introduce diverse optiuni de livrare si plata.

  • Alegerea modalitatii de plata:

Pentru mai multe informatii, va rugam sa consultati capitolul “Modalitati de plata”.

  • Livrarea produselor:

Pentru mai multe informatii, va rugam sa consultati capitolul “Transport si livrare”.

IMPORTANT! Nu puteti finaliza comanda dumneavoastra daca nu sunteti de acord cu “Conditiile de livrare”.

  • Dupa finalizarea comenzii:

Dupa finalizarea comenzii veti primi pe adresa de e-mail furnizata de Dvs, o confimare a comenzii si factura proforma cu produsele selectate si valoarea comenzii. In cel mai scurt timp de la primirea comenzii, va vom contacta telefonic pentru confirmare. In cazul in care nu sunteti contactat, va rugam sa va autentificati si sa verificati continutul cosului de cumparaturi. Daca produsele selectate se afla in cosul Dvs de cumparaturi, comanda Dvs nu a fost finalizata si prin urmare, nu a fost transmisa. Atunci cand o comanda este procesata corect, cosul Dvs de cumparaturi nu mai contine produse.

  • Statutul comenzilor Dvs:

Dupa autentificare, apasati butonul Contul meu din meniul principal si link-ul Istoric si detalii pentru comenzile mele. Aici puteti vizualiza istoricul comenzilor dumneavoastra, dar si statutul comenzii in curs.


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

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

Stopwatch (with SQL_NO_CACHE) (total = 71)


46.264 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

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

19.431 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.25 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.926 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.419 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.316 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
1.935 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.608 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
1.5 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.446 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
1.355 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
1.246 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
1.193 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.182 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.102 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
1.078 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 19:20:12' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 19:20:12' <= `to`) ) AND `reduction` > 0
in /var/www/roccas/prestashop/classes/SpecificPrice.php:361
1 row browsed
1.065 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
1.005 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.906 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.87 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.836 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/roccas/prestashop/classes/Hook.php:143
86 rows browsed
0.807 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.781 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.768 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.73 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.726 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.724 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.699 ms SELECT SQL_NO_CACHE `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = 7 AND id_cms = 7 LIMIT 1
in /var/www/roccas/prestashop/classes/Meta.php:361
1 row browsed
0.692 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 19:20: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.688 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.662 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.657 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.645 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.597 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.59 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.586 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.582 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.558 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.555 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.554 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.554 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.552 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.552 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.552 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.549 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.548 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.547 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.543 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.541 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.532 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.501 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.494 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.486 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.472 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.462 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.445 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.442 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.44 ms SELECT SQL_NO_CACHE id_shop FROM `ps_cms_shop` WHERE `id_cms` = 7 AND id_shop = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:1135
1 row browsed
0.434 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.411 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.407 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.407 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.396 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.382 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.373 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.373 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.371 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.368 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
0.347 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.324 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

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_7_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