Categorii

Producatori

Termeni si conditii de utilizare

Vizitarea, utilizarea si cumpararea produselor de pe site-ul www.roccas.ro, implica acceptarea termenilor si conditiilor de mai jos:

Recomandam citirea cu atentie a acestora!

Societatea SC Roccas ICCP SRL isi asuma dreptul de a putea efectua orice modificari ale acestor prevederi, precum si orice modificari site-ului www.roccas.ro, fara a fi necesara vreo notificare prealabila catre utilizatori. Pentru a gasi cea mai recenta versiune va rugam sa accesati pagina "Conditii de utilizare".

Societatea SC Roccas ICCP SRL nu va putea fi facuta responsabila pentru eventualele erori aparute pe site din orice cauza, inclusiv din cauza unor modificari, setari, up-grade-uri, efectuate pe server-ul care gazduieste site-ul societatii.

Societatea SC Roccas ICCP SRL nu raspunde de continutul, calitatea sau natura site-urilor la care se ajunge prin legaturi de pe site-ul www.roccas.ro, indiferent de natura acestor legaturi. Pentru respectivele site-uri, raspunderea o poarta, integral, proprietarii site-urilor in cauza.

  • COMUNICARI ELECTRONICE:

Prin accesarea site-ului www.roccas.ro, folosirea, vizitarea, cumpararea de produse sau trimiterea de e-mail-uri adresate societatii SC Roccas ICCP SRL, comunicarea se realizeaza in mod electronic, considerandu-se astfel ca utilizatorul consimte primirea notificarilor de la societate in modalitate electronica, incluzand si comunicari prin e-mail sau prin anunturi pe site.

Persoanele care vor utiliza o adresa falsa de e-mail sau vor transmite mesaje electronice sau orice alte comunicari in numele unei alte persoane fizice sau juridice sau in numele oricarei alte entitati vor fi sanctionate in conformitate cu legile in vigoare.

In conformitate cu Legea nr. 365/2002 privind comertul electronic si Legea nr. 506/2004 privind prelucrarea datelor cu caracter personal si protectia vietii private in sectorul comunicarilor electronice, mesajele trimise de SC Roccas ICCP SRL, ca newsletter, nu pot fi considerate SPAM deoarece:

  1. contin datele necesare de identificare ale expeditorului si instructiuni de dezabonare;
  2. acceptarea de primire a mesajelor/ofertelor nu  implica financiar destinatarul;
  3. au scopul de a informa abonatii cu privire la produse sau servicii care le pot aduce beneficii;
  4. adresa de e-mail a destinatarilor, fie a fost obtinuta in mod direct ca urmare a abonarii la newsletter-ul Roccas ICCP, a unor corespondente anterioare sau deoarece destinarii sunt clienti/furnizori ai companiei noastre sau a fost selectata dintr-o baza de date la care au subscris destinatarii; fie a fost facuta publica de catre destinatari, prin afisari cu caracter publicitar intr-un ghid de afaceri sau in cadrul unei intalniri de afaceri.

 

  • DREPTURI DE AUTOR (COPYRIGHT):

Intregul continut al site-ului www.roccas.ro, incluzand, texte, imagini, grafice, butoane, elemente de grafica web, scripturi si orice alte date, este proprietatea SC Roccas ICCP SRL si/sau a furnizorilor sai si este protejat conform Legii drepturilor de autor si legilor privind dreptul de proprietate intelectuala si industriala. Folosirea fara acordul scris al SC Roccas ICCP SRL a oricaror elemente enumerate mai sus este sanctionata conform legilor in vigoare.

  • ACCESUL LA SITE:

SC Roccas ICCP SRL garanteaza utilizatorului acces limitat, in interes personal, pe acest site si nu ii confera dreptul de a descarca sau de a modifica partial sau integral, de a reproduce partial sau integral, de a copia, de a vinde/revinde sau de a exploata site-ul in orice alta maniera, in scopuri comerciale sau contrare intereselor societatii SC Roccas ICCP SRL, fara acordul scris al acesteia.

  • SECURITATEA DATELOR PERSONALE:

Pe site-ul www.roccas.ro, utilizatorul este responsabil pentru toate activitatile care survin prin accesarea acestuia.

Datele personale ale utilizatorului vor putea fi folosite de catre SC Roccas ICCP SRL numai in scopul declarat al acestui site. Datele personale din contul Dvs, nu vor fi furnizate, in nici o situatie, unei terte parti. Acestea vor fi folosite pentru a va trimite confirmarea comenzilor, livrarea produselor, informari despre eventualele promotii, etc. Datele personale vor putea fi insa transmise autoritatilor in drept sa verifice tranzactiile comerciale sau altor autoritati in drept sa efectueze orice verificari justificate in baza legii, daca acest lucru va fi solicitat in conformitate cu legile in vigoare.

SC Roccas ICCP SRL nu vinde, nu ofera si nu divulga adresa dumneavoastra de e-mail altor persoane care acceseaza paginile acestui site.

  • RESPONSABILITATI PRIVIND PRODUSELE:

SC Roccas ICCP SRL nu garanteaza ca descrierea produselor sau orice alt continut al site-ului este lipsit de erori sau ca este complet.

Produsele (atunci cand este cazul), sunt insotite de certificate de garantie ale importatorilor. Orice reclamatie va fi adusa la cunostinta SC Roccas ICCP SRL in maximum 24 de ore de la receptionarea produselor.

  • GARANTIA PRODUSELOR:

Toate produsele comercializate de catre site-ul nostru, beneficiaza de conditii de garantie, conform legislatiei in vigoare si politicilor comerciale ale importatorilor.

Produsele sunt noi, in ambalajele originale si provin din surse autorizate de fiecare producator/importator in parte.

Certificatele de garantie fie sunt emise direct de importator, fie sunt emise de catre societatea SC Roccas ICCP SRL.

  • RENUNTAREA LA CUMPARARE:

Conform legislatiei in vigoare, renuntarea la cumparare este aplicabila doar clientilor persoane fizice.

Astfel, consumatorul are dreptul sa notifice in scris comerciantului ca renunta la cumparare, fara penalitati si fara invocarea unui motiv, in termen de 10 zile lucratoare de la primirea produsului.

Renuntarea la cumparare in termen de 10 zile se poate aplica doar pentru produsele livrate prin curier.

Produsul returnat trebuie sa fie in aceeasi stare in care a fost livrat (in ambalajul original cu toate accesoriile, cu etichetele intacte si documentele care l-au insotit).

Cheltuielile de returnare vor fi suportate de client, iar rambursarea contravalorii produsului se va face in cel mult 30 de zile de la retur.

Daca produsul este returnat intr-o stare in care nu mai poate fi vandut ca si nou, ne rezervam dreptul de a solicita o taxa pentru readucerea in stadiul initial (daca este posibil) sau pentru a acoperi diferenta de pret rezultata din vanzarea produsului ca second-hand sau, la optiunea clientului, ii vom reexpedia produsul, pe cheltuiala acestuia.

Acesta clauza se aplica conform O.G. 130/2000 cu modificarile aduse prin Legea 51/2003, Legea 365/2002, Legea 363/2007 si O.U.G. 174/2008, in cazul achizitionarii de produse din acest site folosind tehnicile de comunicare la distanta, aplicandu-se definitiile cuprinse in O.G. 130/2000 art. 2

  • DECLINAREA RESPONSABILITATII:

Continutul site-ului www.roccas.ro (texte, descrieri ale produselor, caracteristici tehnice, imagini, etc.), a fost alcatuit in stransa colaborare cu furnizorii marcilor prezentate pe site, astfel incat SC Roccas ICCP SRL nu isi asuma responsabilitatea pentru descrierile produselor prezentate pe site in scopul comercializarii, acestea fiind corespunzatoare celor puse la dispozitia firmei de catre reprezentantii fiecarei dintre aceste marci in parte.

De asemenea, imaginile care sunt prezentate pe site, sunt cu titlu de exemplu, produsele efectiv livrate, putand diferi de acestea in ceea ce priveste culoarea, aspectul, etc.

SC Roccas ICCP SRL nu garanteaza, de asemenea, nici disponibilitatea in stoc a produselor afisate, motiv pentru care societatea va avea dreptul de a nu livra partial sau integral o anumita comanda in cazul in care anumite produse nu mai apar in oferta curenta a furnizorului sau nu sunt disponibile din alte motive (lipsa momentana din stoc, epuizarea acestuia, etc).

Daca plata se face in avans, clientul va avea dreptul de a primi inapoi banii platiti pentru produsul respectiv.

In toate cazurile in care produsele nu se pot livra, clientul va putea cere doar returnarea imediata a sumelor incasate deja de SC Roccas ICCP SRL, dar nu si alte despagubiri.

Valoarea maxima a obligatiilor societatii SC Roccas ICCP SRL fata de orice client in cazul nelivrarii sau al livrarii necorespunzatoare a produselor cumparate este valoarea sumelor incasate de SC Roccas ICCP SRL de la respectivul client.

Dupa expedierea produselor, societatii SC Roccas ICCP SRL nu i se mai poate cere in nici un fel returnarea banilor.

De asemenea, clientul nu mai poate returna produsele, insa produsele pot fi inlocuite daca reclamatia este intemeiata.

In cazul in care preturile sau alte detalii referitoare la produse au fost afisate gresit, inclusiv din cauza faptului ca au fost introduse gresit in baza de date, societatea SC Roccas ICCP SRL isi aloca dreptul de a anula livrarea respectivului produs si de a anunta clientul in cel mai scurt timp despre eroarea aparuta, daca livrarea nu s-a efectuat inca.

  • PRETURILE PRODUSELOR:

Preturile produselor sunt cele afisate pentru fiecare produs, sunt exprimate in RON/EURO si contin TVA.

Societatea SC Roccas ICCP SRL va putea desfasura orice campanie promotionala referitor la produsele afisate pe site, promotii ale caror conditii vor fi stabilite in intregime de catre SC Roccas ICCP SRL.

  • LITIGII:

Prin folosirea (vizitarea sau cumpararea produselor) site-ului, utilizatorul se declara de acord asupra faptului ca legile romane vor guverna Conditiile de utilizare de mai sus si orice disputa de orice fel care ar putea sa apara intre utilizator si societatea SC Roccas ICCP SRL. In cazul unor eventuale conflicte intre SC Roccas ICCP SRL si clientii sai, se va incerca mai intai rezolvarea acestora pe cale amiabila.

Daca rezolvarea pe cale amiabila nu va fi posibila, conflictul va fi solutionat in instanta competenta, in conformitate cu legile romane in vigoare.

  • FRAUDA:

Orice incercare de a accesa datele personale ale altui utilizator sau de a modifica continutul site-ului www.roccas.ro, sau de a afecta performantele serverului pe care ruleaza acest site, va fi considerata o tentativa de fraudare asupra site-ului www.roccas.ro si va face obiectul unei plangeri penale la organele de politie, impotriva persoanei sau persoanelor care a(au) incercat acest fapt.

  • DISPOZITII FINALE:

Odata cu accesarea site-ului www.roccas.ro, lansarea unei comenzi sau comunicarea electronica, clientul accepta fara obiectiuni conditiile si termenii de utilizare, valoarea acestora fiind aceeasi cu un contract valabil incheiat intre parti.



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: 216ms
Good boy! That's what I call a webserver!
Hook processing: 184ms / 1.72 Mb
Memory peak usage: 3.95 Mb

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

Stopwatch (with SQL_NO_CACHE) (total = 71)


54.646 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

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

19.475 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
4.112 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.923 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.349 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.301 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.473 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.176 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.086 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.071 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.965 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.953 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.951 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.914 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.864 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
in /var/www/roccas/prestashop/classes/Hook.php:143
86 rows browsed
0.844 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.798 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.77 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.709 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.69 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.631 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.565 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.555 ms SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:214
1 row browsed
0.543 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.497 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.493 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.491 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.486 ms SELECT SQL_NO_CACHE `meta_title`, `meta_description`, `meta_keywords` FROM `ps_cms_lang` WHERE id_lang = 7 AND id_cms = 3 LIMIT 1
in /var/www/roccas/prestashop/classes/Meta.php:361
1 row browsed
0.48 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.476 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:59' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2017-11-20 19:20:59' <= `to`) ) AND `reduction` > 0
in /var/www/roccas/prestashop/classes/SpecificPrice.php:361
1 row browsed
0.475 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.471 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.462 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.455 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.451 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 `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.44 ms SELECT SQL_NO_CACHE id_shop FROM `ps_cms_shop` WHERE `id_cms` = 3 AND id_shop = 1 LIMIT 1
in /var/www/roccas/prestashop/classes/ObjectModel.php:1135
1 row browsed
0.429 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.424 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.424 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.414 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.406 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.405 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.394 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.392 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.391 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.391 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.391 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.39 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.389 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.388 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.387 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.387 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.385 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.385 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.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.363 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.352 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.347 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.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
0.3 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.294 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.286 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.285 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.28 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.273 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.273 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.273 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.262 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.258 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

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