Categorii

Pescuit la Crap

Lansete Crap Daiwa

Lansete Pescuit din Barca

Lansete Universale

Oferte Combo-uri Crap

Accesorii Diverse Crap

Accesorii Monturi Crap

Accesorii pentru Nadire

Avertizoare / Swingere / Indicatori Trasatura

Mincioguri Crap

Plumbi / Momitoare

Saltele / Juvelnice / Saci de Pastrare

Pescuit la Feeder

Mulinete Feeder

Oferte Combo-uri Feeder

Accesorii Diverse Feeder

Accesorii Monturi Feeder

Clopotei, Starlite

Juvelnice Feeder

Mincioguri Feeder

Monturi / Carlige Legate Feeder

Plumbi / Momitoare Feeder

Scaune Modulare Feeder

Accesorii Scaune Feeder

Pescuit la Rapitor

Lansete Rapitori

Lansete Casting

Mulinete Rapitori

Mulinete Casting

Oferte Combo-uri Spinning

Accesorii Diverse Rapitor

Accesorii Monturi Rapitor

Carlige Rapitor

Mincioguri Rapitor

Monturi Rapitor

Naluci Artificiale

Pescuit la Somn

Oferte Combo-uri Somn

Accesorii Diverse Somn

Accesorii Monturi Somn

Avertizoare / Indicatori Trasatura Somn

Naluci Artificiale Somn

Pescuit la Stationar

Lansete Bolognese

Mulinete Bolognese

Mulinete Stationar

Oferte Combo-uri Stationar

Accesorii Diverse Stationar

Accesorii Elasticare

Accesorii Monturi Stationar

Carlige Stationar

Juvelnice Stationar

Mincioguri Stationar

Monturi / Carlige Legate Stationar

Plumbi Stationar

Plute Stationar

Scaune Modulare Stationar

Accesorii Scaune Stationar

Pescuit la Copca

Accesorii Diverse Copca

Avertizoare / Indicatori Trasatura Copca

Nade / Momeli Copca

Naluci Artificiale Copca

Pescuit la Musca

Accesorii Diverse Musca

Instrumente Fly Fishing

Nade si Momeli

Accesorii Preparare Boilies

Aditivi / Arome / Dip-uri / Colanti Nada

Boilies pentru Nadit

Ingrediente Mix-uri Boilies

Momeli de Carlig

Nada (Groundbait)

Pelete pentru Nadit

Plancton / Nada Novac

Saci Uscare Boilies

Saculeti Solubili Gata Facuti

Site pentru Nada si Momeli

Bagajerie

Benzi Fixare / Protectii Lansete

Genti si Borsete

Penare / Portofele

Roabe Bagajerie

Camping

Oferte Combo-uri Camping

Aragaze / Incalzitoare

Articole Diverse Camping

Articole Drumetii / Outdoor

Corturi si Accesorii

Instrumente pentru Taiat

Lanterne / Felinare / Proiectoare

Lazi Frigorifice

Perne Pescuit / Camping

Protectie si Refacere

Suporturi Umbrela

Umbrele Pescuit / Camping

Vesela si Tacamuri

Imbracaminte, Incaltaminte, Accesorii

Imbracaminte / Incaltaminte / Accesorii Vanatoare

Oferte Combo Imbracaminte si Incaltaminte

Suporturi si Rod Pod-uri

Accesorii Suporturi / Rod Pod

Stabilizatori Suporturi/ Rod Pod

Picheti Masurare Distanta

Componente Lansete si Mulinete

Inele de Lanseta

Manere Mulinete

Tamburi Mulinete

Tronsoane Lansete / Vergi

Varfuri Lansete / Vergi

Alte Componente

Produse Intretinere Lansete si Mulinete

Barci, Accesorii, Motoare

Oferte Combo-uri Barci, Accesorii, Motoare

Accesorii Barci

Sisteme Prindere / Suporturi Ram Mounts

Navomodele Plantat

Veste de Salvare

Baterii si Acumulatori

Vanatoare si Airsoft

Articole Airsoft

Articole Diverse Vanatoare

Atractanti Vanat

Chematori, Atrape

Intretinere Arme

Recompense Caini

Queries: 207, Total time: 65.874 ms [By time] [By id] [By file]

1 (0.076)

SELECT data
FROM `oc_session`
WHERE session_id = 'c352d5700b2e8756d06469abbd'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.112)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.696)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

4 (0.630)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '217' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

5 (0.320)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '218' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

6 (0.332)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '823' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

7 (0.271)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '483' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

8 (0.267)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '84' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

9 (0.320)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '222' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

10 (0.339)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '279' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

11 (0.270)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '380' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

12 (0.322)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '637' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

13 (0.557)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '225' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

14 (0.465)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

15 (0.407)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '653' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

16 (0.323)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '223' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

17 (0.434)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '487' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

18 (0.372)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '453' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

19 (0.269)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '224' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

20 (0.325)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '262' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

21 (0.381)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '88' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

22 (0.583)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '270' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

23 (0.270)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '271' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

24 (0.298)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '272' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

25 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '293' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

26 (0.300)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '382' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

27 (0.379)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '278' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

28 (0.612)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '274' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

29 (0.392)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '277' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

30 (0.376)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '779' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

31 (0.327)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '644' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

32 (0.269)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '435' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

33 (0.364)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '422' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

34 (0.373)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '441' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

35 (0.370)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '276' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

36 (0.276)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '439' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

37 (0.419)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '396' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

38 (0.460)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '220' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

39 (0.285)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '226' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

40 (0.287)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '390' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

41 (0.277)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '392' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

42 (0.273)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '227' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

43 (0.257)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '393' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

44 (0.259)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '292' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

45 (0.273)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '383' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

46 (0.350)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '491' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

47 (0.323)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '651' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

48 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '229' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

49 (0.260)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '230' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

50 (0.322)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '228' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

51 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '231' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

52 (0.285)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '421' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

53 (0.274)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '434' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

54 (0.552)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '355' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

55 (0.313)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '387' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

56 (0.264)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

57 (0.278)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '405' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

58 (0.394)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '250' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

59 (0.281)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '251' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

60 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '252' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

61 (0.258)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '661' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

62 (0.286)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '741' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

63 (0.278)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '256' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

64 (0.259)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '727' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

65 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '769' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

66 (0.345)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '781' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

67 (0.280)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '257' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

68 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '253' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

69 (0.277)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '255' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

70 (0.274)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '632' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

71 (0.269)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '263' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

72 (0.321)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '636' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

73 (0.601)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

74 (0.422)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '258' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

75 (0.335)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '269' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

76 (0.338)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '370' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

77 (0.452)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '261' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

78 (0.330)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '259' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

79 (0.278)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '268' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

80 (0.274)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '824' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

81 (0.353)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '384' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

82 (0.376)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '266' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

83 (0.334)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '789' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

84 (0.326)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '719' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

85 (0.329)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '264' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

86 (0.317)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '643' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

87 (0.318)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '817' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

88 (0.276)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '436' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

89 (0.269)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '137' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

90 (0.341)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '693' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

91 (0.320)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '677' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

92 (0.352)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '119' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

93 (0.266)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '180' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

94 (0.268)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '440' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

95 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '543' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

96 (0.444)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '282' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

97 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '285' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

98 (0.260)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '286' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

99 (0.259)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '290' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

100 (0.270)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '287' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

101 (0.306)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '650' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

102 (0.278)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '381' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

103 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '284' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

104 (0.287)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '288' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

105 (0.354)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '306' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

106 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '178' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

107 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '172' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

108 (0.260)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '419' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

109 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '325' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

110 (0.257)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '75' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

111 (0.258)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '198' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

112 (0.258)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '787' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

113 (0.544)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

114 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '204' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

115 (0.385)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

116 (0.271)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '94' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

117 (0.259)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '579' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

118 (0.256)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '202' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

119 (0.254)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

120 (0.494)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

121 (0.264)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '254' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

122 (0.257)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

123 (0.272)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '141' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

124 (0.255)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '575' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

125 (0.259)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '471' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

126 (0.255)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '577' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

127 (0.255)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '417' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

128 (0.401)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '106' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

129 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '591' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

130 (0.257)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '109' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

131 (0.257)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '108' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

132 (0.444)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '673' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

133 (0.495)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '111' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

134 (0.369)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

135 (0.341)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '438' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

136 (0.281)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '112' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

137 (0.270)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

138 (0.622)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '151' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

139 (0.274)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '743' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

140 (0.266)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '158' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

141 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '215' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

142 (0.264)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '682' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

143 (0.345)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '679' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

144 (0.271)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '541' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

145 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '681' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

146 (0.402)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '208' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

147 (0.388)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '609' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

148 (0.280)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '391' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

149 (0.272)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '153' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

150 (0.273)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '160' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

151 (0.284)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '535' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

152 (0.357)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '663' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

153 (0.287)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '155' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

154 (0.321)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '154' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

155 (0.269)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '539' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

156 (0.300)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '537' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

157 (0.474)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '666' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

158 (0.413)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

159 (0.556)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '647' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

160 (0.385)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '648' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

161 (0.499)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '649' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

162 (0.374)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '684' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

163 (0.278)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '418' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

164 (0.374)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '120' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

165 (0.384)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '655' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

166 (0.283)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '121' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

167 (0.340)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

168 (0.280)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '565' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

169 (0.275)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '395' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

170 (0.275)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '122' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

171 (0.279)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '820' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

172 (0.275)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '563' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

173 (0.485)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

174 (0.277)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '195' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

175 (0.273)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '192' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

176 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '191' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

177 (0.266)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '194' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

178 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '211' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

179 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '190' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

180 (0.264)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '725' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

181 (0.347)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '654' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

182 (0.303)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '377' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

183 (0.267)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '729' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

184 (0.403)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

185 (0.266)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '745' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

186 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '129' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

187 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '394' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

188 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '132' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

189 (0.279)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '130' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

190 (0.358)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '635' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

191 (0.268)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '131' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

192 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '447' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

193 (0.335)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '133' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

194 (0.262)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '629' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

195 (0.263)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '631' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

196 (0.374)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

197 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '415' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

198 (0.267)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '301' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

199 (0.260)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '304' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

200 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '196' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

201 (0.276)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '300' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

202 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '303' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

203 (0.260)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '302' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

204 (0.261)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '299' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

205 (0.265)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '807' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

206 (0.288)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '371' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46

207 (0.081)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37