Căutare

Queries: 963, Total time: 192.506 ms [By time] [By id] [By file]

1 (0.083)

SELECT data
FROM `oc_session`
WHERE session_id = '8d1cafd1662ede02b73f7e448e'

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

2 (6.155)

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '2'
ORDER BY store_id ASC

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

3 (0.079)

SELECT `trigger`, `action`
FROM oc_event

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

4 (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 = '0' AND cd.language_id = '2' AND c2s.store_id = '2' 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.429)

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 = '2' 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.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 = '218' AND cd.language_id = '2' AND c2s.store_id = '2' 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.302)

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 = '2' 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.314)

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 = '2' 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.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 = '222' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '279' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '380' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '637' AND cd.language_id = '2' AND c2s.store_id = '2' 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.395)

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 = '2' 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.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 = '92' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '653' AND cd.language_id = '2' AND c2s.store_id = '2' 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.304)

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 = '2' 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.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 = '487' AND cd.language_id = '2' AND c2s.store_id = '2' 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.365)

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 = '2' 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 = '2' 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.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 = '262' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '88' AND cd.language_id = '2' AND c2s.store_id = '2' 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.437)

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 = '2' 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 = '2' 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.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 = '272' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '293' AND cd.language_id = '2' AND c2s.store_id = '2' 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.294)

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 = '2' 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.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 = '278' AND cd.language_id = '2' AND c2s.store_id = '2' 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.417)

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 = '2' 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.309)

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 = '2' 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.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 = '779' AND cd.language_id = '2' AND c2s.store_id = '2' 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.311)

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 = '2' 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.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 = '435' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '422' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '441' AND cd.language_id = '2' AND c2s.store_id = '2' 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.343)

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 = '2' 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.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 = '439' AND cd.language_id = '2' AND c2s.store_id = '2' 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.361)

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 = '2' 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.458)

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 = '2' 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.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 = '226' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '390' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '392' AND cd.language_id = '2' AND c2s.store_id = '2' 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.289)

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 = '2' 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.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 = '393' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '292' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '383' AND cd.language_id = '2' AND c2s.store_id = '2' 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.362)

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 = '2' 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.331)

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 = '2' 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.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 = '229' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '230' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '228' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '231' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '421' AND cd.language_id = '2' AND c2s.store_id = '2' 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.296)

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 = '2' 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.615)

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 = '2' 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.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 = '387' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '179' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '405' AND cd.language_id = '2' AND c2s.store_id = '2' 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.397)

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 = '2' 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.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 = '251' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '252' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '661' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '741' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '256' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '727' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '769' AND cd.language_id = '2' AND c2s.store_id = '2' 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.416)

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 = '2' 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.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 = '257' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '253' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '255' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '632' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '263' AND cd.language_id = '2' AND c2s.store_id = '2' 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.292)

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 = '2' 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.486)

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 = '2' 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.371)

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 = '2' 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.293)

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 = '2' 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.304)

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 = '2' 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.399)

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 = '2' 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.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 = '259' AND cd.language_id = '2' AND c2s.store_id = '2' 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.296)

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 = '2' 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.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 = '384' AND cd.language_id = '2' AND c2s.store_id = '2' 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.433)

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 = '2' 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.471)

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 = '2' 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.414)

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 = '2' 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.355)

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 = '2' 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.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 = '777' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '643' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '436' AND cd.language_id = '2' AND c2s.store_id = '2' 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.293)

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 = '2' 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.331)

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 = '2' 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.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 = '677' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '119' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '180' AND cd.language_id = '2' AND c2s.store_id = '2' 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 = '440' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '543' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '282' AND cd.language_id = '2' AND c2s.store_id = '2' 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.302)

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 = '2' 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.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 = '286' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '290' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '287' AND cd.language_id = '2' AND c2s.store_id = '2' 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.437)

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 = '2' 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.365)

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 = '2' 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.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 = '284' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '288' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '306' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '178' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '172' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '419' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '325' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '75' AND cd.language_id = '2' AND c2s.store_id = '2' 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.328)

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 = '2' 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.331)

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 = '2' 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.558)

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 = '2' 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.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 = '204' AND cd.language_id = '2' AND c2s.store_id = '2' 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.447)

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 = '2' 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.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 = '94' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '579' AND cd.language_id = '2' AND c2s.store_id = '2' 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.382)

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 = '2' 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.302)

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 = '2' 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.466)

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 = '2' 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.363)

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 = '2' 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.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 = '95' AND cd.language_id = '2' AND c2s.store_id = '2' 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.375)

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 = '2' 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.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 = '575' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '471' AND cd.language_id = '2' AND c2s.store_id = '2' 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.375)

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 = '2' 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.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 = '417' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '106' AND cd.language_id = '2' AND c2s.store_id = '2' 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.328)

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 = '2' 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.337)

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 = '2' 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.336)

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 = '2' 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.520)

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 = '2' 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.417)

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 = '2' 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.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 = '113' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '438' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '112' AND cd.language_id = '2' AND c2s.store_id = '2' 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.294)

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 = '2' 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.458)

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 = '2' 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.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 = '743' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '158' AND cd.language_id = '2' AND c2s.store_id = '2' 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.309)

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 = '2' 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.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 = '682' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '679' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '541' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '681' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '208' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '609' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '391' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '2' 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.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 = '160' AND cd.language_id = '2' AND c2s.store_id = '2' 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.282)

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 = '2' 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.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 = '663' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '155' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '154' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '539' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '537' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '666' AND cd.language_id = '2' AND c2s.store_id = '2' 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.387)

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 = '2' 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.463)

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 = '2' 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.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 = '648' AND cd.language_id = '2' AND c2s.store_id = '2' 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.397)

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 = '2' 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.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 = '684' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '418' AND cd.language_id = '2' AND c2s.store_id = '2' 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.362)

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 = '2' 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.387)

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 = '2' 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.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 = '121' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '123' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '565' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '395' AND cd.language_id = '2' AND c2s.store_id = '2' 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.310)

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 = '2' 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.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 = '563' AND cd.language_id = '2' AND c2s.store_id = '2' 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.383)

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 = '2' 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.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 = '195' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '192' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '191' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '194' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '211' AND cd.language_id = '2' AND c2s.store_id = '2' 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.324)

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 = '2' 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.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 = '725' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '654' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '377' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '729' AND cd.language_id = '2' AND c2s.store_id = '2' 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.400)

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 = '2' 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.312)

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 = '2' 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.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 = '129' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '394' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '132' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '130' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '635' AND cd.language_id = '2' AND c2s.store_id = '2' 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.314)

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 = '2' 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.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 = '447' AND cd.language_id = '2' AND c2s.store_id = '2' 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.383)

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 = '2' 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.336)

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 = '2' 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.282)

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 = '2' 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.397)

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 = '2' 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.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 = '415' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '301' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '304' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '300' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '303' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '302' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '299' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '371' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '196' AND cd.language_id = '2' AND c2s.store_id = '2' 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.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 = '183' AND cd.language_id = '2' AND c2s.store_id = '2' 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.919)

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+echilibrate +mg +special +carp' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737

206 (0.064)

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561

207 (0.099)

SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 1500, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

208 (0.097)

SELECT layout_id
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '2'
ORDER BY route DESC LIMIT 1

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:8

209 (0.096)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_left'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

210 (0.065)

SELECT *
FROM oc_module
WHERE module_id = '1183'

/var/www/clients/client1/web1/web/catalog/model/extension/module.php:16

211 (0.081)

SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248

212 (0.075)

SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270

213 (0.050)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035

214 (0.070)

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949

215 (0.082)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_right'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

216 (0.090)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_top'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

217 (0.093)

SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_bottom'
ORDER BY sort_order

/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28

218 (0.529)

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

219 (0.491)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

220 (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 = '218' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

221 (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 = '483' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

222 (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 = '84' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

223 (0.296)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

224 (0.282)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

225 (0.308)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

226 (0.319)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

227 (0.416)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

228 (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 = '92' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

229 (0.342)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

230 (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 = '223' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

231 (0.349)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

232 (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 = '453' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

233 (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 = '224' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

234 (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 = '262' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

235 (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 = '88' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

236 (0.445)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

237 (0.295)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

238 (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 = '272' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

239 (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 = '293' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

240 (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 = '382' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

241 (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 = '278' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

242 (0.362)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

243 (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 = '277' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

244 (0.292)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

245 (0.333)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

246 (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 = '435' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

247 (0.336)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

248 (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 = '441' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

249 (0.359)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

250 (0.282)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

251 (0.362)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

252 (0.470)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

253 (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 = '226' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

254 (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 = '390' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

255 (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 = '392' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

256 (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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

257 (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 = '393' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

258 (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 = '292' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

259 (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 = '383' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

260 (0.380)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

261 (0.351)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

262 (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 = '229' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

263 (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 = '230' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

264 (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 = '228' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

265 (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 = '231' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

266 (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 = '421' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

267 (0.314)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

268 (0.618)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

269 (0.344)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

270 (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 = '179' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

271 (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 = '405' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

272 (0.615)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

273 (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 = '251' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

274 (0.396)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

275 (0.386)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

276 (0.390)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

277 (0.386)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

278 (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 = '727' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

279 (0.393)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

280 (0.453)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

281 (0.389)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

282 (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 = '253' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

283 (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 = '255' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

284 (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 = '632' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

285 (0.397)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

286 (0.386)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

287 (0.694)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

288 (0.522)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

289 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

290 (0.105)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=258'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

291 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=368'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

292 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

293 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=258'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

294 (0.383)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

295 (0.387)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

296 (0.536)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

297 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

298 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

299 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=378'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

300 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

301 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

302 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=357'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

303 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

304 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

305 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=358'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

306 (0.153)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

307 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

308 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=359'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

309 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

310 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

311 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=361'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

312 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

313 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=261'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

314 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=362'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

315 (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 = '259' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

316 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

317 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=259'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

318 (0.380)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

319 (0.386)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

320 (0.446)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

321 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

322 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=266'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

323 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=800'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

324 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

325 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=266'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

326 (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 = '789' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

327 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

328 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=789'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

329 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=791'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

330 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

331 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=789'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

332 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=795'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

333 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

334 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=789'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

335 (0.472)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

336 (0.098)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

337 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=719'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

338 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=721'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

339 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

340 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=719'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

341 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=771'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

342 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

343 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=719'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

344 (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 = '264' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

345 (0.375)

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 = '777' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

346 (0.457)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

347 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

348 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=643'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

349 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=527'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

350 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

351 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=643'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

352 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=525'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

353 (0.365)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

354 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

355 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=436'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

356 (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 = '137' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

357 (0.448)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

358 (0.104)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

359 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=693'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

360 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=759'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

361 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

362 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=693'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

363 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=695'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

364 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

365 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=693'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

366 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=633'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

367 (0.432)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

368 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

369 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=677'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

370 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

371 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

372 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=677'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

373 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=265'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

374 (0.377)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

375 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

376 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=119'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

377 (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 = '180' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

378 (0.377)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

379 (0.366)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

380 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=221'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

381 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=543'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

382 (0.554)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

383 (0.377)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

384 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

385 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=285'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

386 (0.425)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

387 (0.387)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

388 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

389 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=290'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

390 (0.390)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

391 (0.104)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

392 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=287'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

393 (0.488)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

394 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

395 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=650'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

396 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=283'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

397 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

398 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=650'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

399 (0.368)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

400 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

401 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=381'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

402 (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 = '284' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

403 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

404 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=284'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

405 (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 = '288' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

406 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

407 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=288'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

408 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=282'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

409 (0.417)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

410 (0.310)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

411 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

412 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=178'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

413 (0.282)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

414 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

415 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=172'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

416 (0.307)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

417 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

418 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=419'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

419 (0.333)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

420 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

421 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=325'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

422 (0.289)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

423 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

424 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=75'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

425 (0.311)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

426 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=306'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

427 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=198'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

428 (0.319)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

429 (0.469)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

430 (0.333)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

431 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

432 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=204'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

433 (0.342)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

434 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

435 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

436 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=326'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

437 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

438 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

439 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=327'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

440 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

441 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=96'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

442 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=239'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

443 (0.292)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

444 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

445 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=94'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

446 (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 = '579' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

447 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

448 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=579'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

449 (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 = '202' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

450 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

451 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=202'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

452 (0.314)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

453 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

454 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

455 (0.500)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

456 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

457 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

458 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=473'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

459 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

460 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

461 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=336'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

462 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

463 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

464 (0.098)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=337'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

465 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

466 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

467 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=352'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

468 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

469 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

470 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=341'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

471 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

472 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

473 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=335'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

474 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

475 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

476 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=333'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

477 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

478 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

479 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=332'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

480 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

481 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

482 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=339'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

483 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

484 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=93'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

485 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=340'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

486 (0.305)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

487 (0.301)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

488 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

489 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

490 (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 = '141' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

491 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

492 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

493 (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 = '575' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

494 (0.343)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

495 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

496 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=471'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

497 (0.310)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

498 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=91'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

499 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=577'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

500 (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 = '417' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

501 (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 = '106' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

502 (0.304)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

503 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

504 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=591'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

505 (0.297)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

506 (0.319)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

507 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

508 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=108'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

509 (0.701)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

510 (0.107)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

511 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

512 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=114'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

513 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

514 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

515 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=674'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

516 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

517 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

518 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=585'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

519 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

520 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

521 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=581'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

522 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

523 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

524 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=583'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

525 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

526 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

527 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=245'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

528 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

529 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

530 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=675'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

531 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

532 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

533 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=107'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

534 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

535 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=673'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

536 (0.463)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

537 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

538 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

539 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=601'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

540 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

541 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

542 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=481'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

543 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

544 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

545 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=587'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

546 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

547 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

548 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=348'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

549 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

550 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

551 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=589'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

552 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

553 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

554 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=349'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

555 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

556 (0.247)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

557 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=595'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

558 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

559 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

560 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=404'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

561 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

562 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

563 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=599'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

564 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

565 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

566 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=603'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

567 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

568 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

569 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=597'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

570 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

571 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

572 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=351'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

573 (0.387)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

574 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

575 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=113'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

576 (0.389)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

577 (0.368)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

578 (0.104)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

579 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=112'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

580 (0.380)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

581 (0.104)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

582 (0.679)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

583 (0.380)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

584 (0.377)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

585 (0.106)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

586 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=158'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

587 (0.375)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

588 (0.378)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

589 (0.475)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

590 (0.111)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

591 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

592 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=152'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

593 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

594 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

595 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=680'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

596 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

597 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

598 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=690'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

599 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

600 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

601 (0.299)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

602 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

603 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=541'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

604 (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 = '681' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

605 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

606 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

607 (0.362)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

608 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

609 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

610 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=802'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

611 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

612 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

613 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=803'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

614 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

615 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

616 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=804'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

617 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

618 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

619 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=801'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

620 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

621 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

622 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=805'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

623 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

624 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

625 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=806'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

626 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

627 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=208'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

628 (0.355)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

629 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

630 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

631 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=688'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

632 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

633 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

634 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=607'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

635 (0.064)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

636 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

637 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=605'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

638 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

639 (0.061)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

640 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=156'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

641 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

642 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

643 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=611'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

644 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

645 (0.060)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=609'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

646 (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 = '391' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

647 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

648 (0.065)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=391'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

649 (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 = '153' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

650 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

651 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=153'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

652 (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 = '160' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

653 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

654 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=160'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

655 (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 = '535' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

656 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

657 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=535'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

658 (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 = '663' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

659 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

660 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

661 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=437'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

662 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

663 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

664 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=159'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

665 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

666 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

667 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=664'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

668 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

669 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

670 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=665'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

671 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

672 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

673 (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 = '155' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

674 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

675 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=155'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

676 (0.393)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

677 (0.432)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

678 (0.102)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

679 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=539'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

680 (0.391)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

681 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

682 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=537'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

683 (0.533)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

684 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

685 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

686 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=686'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

687 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

688 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

689 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=697'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

690 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

691 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

692 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=672'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

693 (0.105)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

694 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

695 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

696 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

697 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

698 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=667'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

699 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

700 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

701 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=671'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

702 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

703 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

704 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=668'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

705 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

706 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=666'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

707 (0.570)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

708 (0.705)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

709 (0.107)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

710 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

711 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=105'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

712 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

713 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

714 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=709'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

715 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

716 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

717 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=757'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

718 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

719 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

720 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=101'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

721 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

722 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

723 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=102'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

724 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

725 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

726 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=401'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

727 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

728 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

729 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=749'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

730 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

731 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

732 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=103'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

733 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

734 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

735 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=715'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

736 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

737 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

738 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=400'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

739 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

740 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

741 (0.108)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=403'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

742 (0.442)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

743 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

744 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

745 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=399'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

746 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

747 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

748 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=398'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

749 (0.098)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

750 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

751 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=717'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

752 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

753 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=648'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

754 (0.559)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

755 (0.104)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

756 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

757 (0.107)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=763'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

758 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

759 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

760 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=753'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

761 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

762 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

763 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=99'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

764 (0.096)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

765 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

766 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=388'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

767 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

768 (0.068)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

769 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=713'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

770 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

771 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

772 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=297'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

773 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

774 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

775 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=711'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

776 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

777 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

778 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

779 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

780 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

781 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=755'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

782 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

783 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=649'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

784 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=751'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

785 (0.391)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

786 (0.108)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

787 (0.100)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

788 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=735'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

789 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

790 (0.278)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=684'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

791 (0.239)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=737'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

792 (0.508)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

793 (0.527)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

794 (0.546)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

795 (0.110)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

796 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

797 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=275'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

798 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

799 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

800 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=555'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

801 (0.098)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

802 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

803 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=559'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

804 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

805 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

806 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=549'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

807 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

808 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

809 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=747'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

810 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

811 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

812 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=571'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

813 (0.094)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

814 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=655'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

815 (0.383)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

816 (0.480)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

817 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

818 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

819 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=689'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

820 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

821 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

822 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=553'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

823 (0.097)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

824 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

825 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=773'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

826 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

827 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

828 (0.092)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=551'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

829 (0.101)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

830 (0.099)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

831 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=569'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

832 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

833 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

834 (0.360)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

835 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

836 (0.072)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=565'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

837 (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 = '395' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

838 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

839 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=395'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

840 (0.289)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

841 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

842 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=122'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

843 (0.304)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

844 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

845 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=563'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

846 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

847 (0.462)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

848 (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 = '195' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

849 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

850 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=195'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

851 (0.289)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

852 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

853 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=192'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

854 (0.292)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

855 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

856 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=191'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

857 (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 = '194' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

858 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

859 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=194'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

860 (0.289)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

861 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

862 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=211'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

863 (0.299)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

864 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

865 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=190'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

866 (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 = '725' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

867 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

868 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=725'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

869 (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 = '654' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

870 (0.089)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

871 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

872 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=193'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

873 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

874 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

875 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=389'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

876 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

877 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

878 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=373'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

879 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

880 (0.075)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=654'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

881 (0.296)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

882 (0.087)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

883 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=377'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

884 (0.289)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

885 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

886 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=729'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

887 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

888 (0.393)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

889 (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 = '745' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

890 (0.090)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

891 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=745'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

892 (0.292)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

893 (0.088)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

894 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=129'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

895 (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 = '394' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

896 (0.083)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

897 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=394'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

898 (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 = '132' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

899 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

900 (0.066)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=132'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

901 (0.299)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

902 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

903 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=130'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

904 (0.366)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

905 (0.081)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

906 (0.147)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

907 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=657'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

908 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

909 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

910 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=658'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

911 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

912 (0.073)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

913 (0.063)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=659'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

914 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

915 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

916 (0.076)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=660'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

917 (0.069)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

918 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=635'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

919 (0.328)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

920 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

921 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

922 (0.487)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

923 (0.119)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

924 (0.095)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=447'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

925 (0.415)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

926 (0.290)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

927 (0.080)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

928 (0.074)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=629'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

929 (0.310)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

930 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

931 (0.079)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=631'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

932 (0.085)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

933 (0.473)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

934 (0.424)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

935 (0.084)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

936 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=415'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

937 (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 = '301' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

938 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

939 (0.086)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=301'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

940 (0.312)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

941 (0.082)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

942 (0.071)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=304'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

943 (0.315)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

944 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

945 (0.078)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=300'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

946 (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 = '303' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

947 (0.093)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

948 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=303'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

949 (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 = '302' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

950 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

951 (0.077)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=302'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

952 (0.331)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

953 (0.117)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

954 (0.067)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=299'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

955 (0.307)

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 = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

956 (0.106)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

957 (0.070)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=371'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

958 (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 = '196' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

959 (0.103)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=298'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

960 (0.091)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=196'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:210

961 (0.106)

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

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

962 (0.098)

SELECT *
FROM oc_language
ORDER BY sort_order, name

/var/www/clients/client1/web1/web/catalog/model/localisation/language.php:15

963 (0.087)

SELECT *
FROM oc_currency
ORDER BY title ASC

/var/www/clients/client1/web1/web/catalog/model/localisation/currency.php:15

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Produse ce potrivesc criteriilor de căutare