Lansete SI Undite

1 (0.194)

SELECT data
FROM `oc_session`
WHERE session_id = '8184ce06903f12297a318c2f90'

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

2 (0.162)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client0/web1/web/index.php:106

3 (0.245)

SELECT *
FROM `oc_language`
WHERE status = '1'

/var/www/clients/client0/web1/web/index.php:291

4 (0.109)

SELECT *
FROM oc_currency

/var/www/clients/client0/web1/web/system/library/currency.php:17

5 (0.337)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

/var/www/clients/client0/web1/web/system/library/tax.php:32

6 (0.234)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

/var/www/clients/client0/web1/web/system/library/tax.php:60

7 (0.098)

SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

/var/www/clients/client0/web1/web/system/library/weight.php:12

8 (0.111)

SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

/var/www/clients/client0/web1/web/system/library/length.php:12

9 (0.080)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client0/web1/web/index.php:392

10 (0.824)

SELECT *
FROM dmc_bazar_url_alias
WHERE keyword = 'pescuit'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:44

11 (1.433)

SELECT *
FROM dmc_bazar_url_alias
WHERE keyword = 'lansete'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:44

12 (0.940)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
WHERE p.status = '1' AND p.valabil > NOW() AND (p2c.category_id = '2' OR (p.category_id = '2' AND p.valabil_alta_categorie > NOW())) AND p.valabil_promo > NOW() GROUP BY p.product_id
ORDER BY RAND() LIMIT 3

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:239

13 (0.125)

SELECT DISTINCT *
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '1' AND c.status = '1'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:5

14 (0.969)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

15 (0.171)

SELECT DISTINCT *
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '2' AND c.status = '1'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:5

16 (0.927)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

17 (0.968)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

18 (0.568)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

19 (0.921)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

20 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

21 (0.900)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=3'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

22 (0.759)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

23 (0.944)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

24 (0.978)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

25 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=9'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

26 (0.822)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

27 (0.967)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

28 (0.977)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

29 (1.233)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=5'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

30 (1.195)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

31 (1.702)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

32 (1.820)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

33 (1.662)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=83'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

34 (1.140)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

35 (1.224)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

36 (1.254)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

37 (1.252)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=12'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

38 (1.228)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

39 (1.629)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

40 (1.607)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

41 (1.586)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=7'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

42 (1.019)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

43 (1.519)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

44 (0.926)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

45 (0.916)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=111'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

46 (0.842)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

47 (0.965)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

48 (0.959)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

49 (0.964)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=11'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

50 (0.829)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

51 (0.967)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

52 (0.953)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

53 (0.914)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=6'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

54 (0.823)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

55 (0.949)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

56 (0.957)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

57 (0.950)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=8'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

58 (0.836)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

59 (0.969)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

60 (0.965)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

61 (0.951)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=4'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

62 (0.816)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

63 (0.985)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

64 (0.968)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

65 (1.016)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=10'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

66 (0.834)

SELECT p.product_id
FROM dmc_bazar_product_to_category p2c
LEFT JOIN dmc_bazar_product p ON (p2c.product_id = p.product_id)
LEFT JOIN dmc_bazar_category_path cp ON (cp.category_id = p2c.category_id)
WHERE p.status = '1' AND p.valabil > NOW() AND p.valabil_promo > NOW() AND cp.path_id = '2' GROUP BY p.product_id
ORDER BY RAND() LIMIT 25

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:259

67 (0.970)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, "1" AS match_filters
FROM `dmc_bazar_product` AS p
INNER JOIN `dmc_bazar_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `dmc_bazar_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p2c.category_id = '2' AND p.valabil > NOW() AND p.status = 1 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:486

68 (0.886)

SELECT p.product_id, p.sort_order, "1" AS match_filters, pp.sort_order
FROM `dmc_bazar_product` AS p
INNER JOIN `dmc_bazar_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `dmc_bazar_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `dmc_bazar_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `dmc_bazar_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2c.category_id = '2' AND p.valabil > NOW() AND p.status = 1 GROUP BY p.product_id HAVING match_filters = 1
ORDER BY pp.sort_order ASC, pd.name ASC LIMIT 0, 20

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:84

69 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

70 (0.887)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

71 (0.886)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

72 (0.872)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

73 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

74 (0.866)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

75 (0.917)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

76 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

77 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

78 (0.899)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

79 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

80 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

81 (0.899)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

82 (0.897)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

83 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

84 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

85 (0.897)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

86 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

87 (0.896)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

88 (0.861)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

89 (0.907)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

90 (0.900)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

91 (0.214)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:4

92 (0.139)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:14

93 (0.098)

SELECT *
FROM oc_module
WHERE module_id = '1198'

/var/www/clients/client0/web1/web/catalog/model/extension/module.php:11

94 (0.918)

SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ag.name AS group_name, a.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `dmc_bazar_bf_product_attribute_value` AS af
INNER JOIN ( SELECT p.*
FROM `dmc_bazar_product` AS p
INNER JOIN `dmc_bazar_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p2c.category_id = '2') AS p ON (af.product_id = p.product_id)
INNER JOIN `dmc_bazar_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `dmc_bazar_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `dmc_bazar_attribute_group` AS ag ON (ag.attribute_group_id = a.attribute_group_id)
WHERE p.status = 1 AND p.valabil > NOW() GROUP BY av.attribute_value_id
ORDER BY ag.sort_order, ag.attribute_group_id, a.sort_order, a.name, av.sort_order, length(av.value), av.value

/var/www/clients/client0/web1/web/catalog/model/module/brainyfilter_bazar.php:937

95 (0.834)

SELECT DISTINCT m.manufacturer_id AS id, m.name
FROM `dmc_bazar_manufacturer` AS m
INNER JOIN `dmc_bazar_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `dmc_bazar_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND p.valabil > NOW() AND p2c.category_id = '2'
ORDER BY m.sort_order, m.name

/var/www/clients/client0/web1/web/catalog/model/module/brainyfilter_bazar.php:1001

96 (0.135)

SELECT *
FROM oc_module
WHERE module_id = '1201'

/var/www/clients/client0/web1/web/catalog/model/extension/module.php:11

97 (0.174)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:4

98 (0.113)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:14

99 (0.123)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:4

100 (0.070)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:14

101 (0.146)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:4

102 (0.082)

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

/var/www/clients/client0/web1/web/catalog/model/design/layout.php:14

103 (0.058)

SELECT *
FROM oc_module
WHERE module_id = '1202'

/var/www/clients/client0/web1/web/catalog/model/extension/module.php:11

104 (0.804)

SELECT p.product_id
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
WHERE p.status = '1' AND p.valabil > NOW() GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,20

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:191

105 (0.579)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2823'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

106 (20.347)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2823"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

107 (0.714)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2821'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

108 (19.849)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2821"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

109 (0.707)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2819'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

110 (24.430)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2819"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

111 (1.052)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2817'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

112 (26.704)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2817"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

113 (0.714)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2815'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

114 (19.985)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2815"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

115 (0.770)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2813'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

116 (20.352)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2813"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

117 (0.695)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2811'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

118 (20.571)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2811"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

119 (0.677)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2809'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

120 (20.504)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2809"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

121 (0.649)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2807'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

122 (20.285)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2807"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

123 (0.583)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2805'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

124 (20.699)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2805"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

125 (0.879)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2803'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

126 (19.906)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2803"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

127 (0.696)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2801'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

128 (23.286)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2801"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

129 (1.043)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2795'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

130 (29.042)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2795"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

131 (0.692)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2789'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

132 (20.363)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2789"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

133 (0.712)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2781'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

134 (19.804)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2781"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

135 (0.749)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2744'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

136 (21.051)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2744"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

137 (0.704)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2565'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

138 (20.017)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2565"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

139 (0.647)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '2563'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

140 (20.726)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B2563"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

141 (0.574)

SELECT DISTINCT *, ac.name AS oras, acc.name AS judet, pd.name AS name, p.image, m.name AS manufacturer, p.sort_order, cd.name AS categoria, (SELECT price
FROM dmc_bazar_product_special ps
WHERE ps.product_id = p.product_id LIMIT 1) AS special
FROM dmc_bazar_product p
LEFT JOIN dmc_bazar_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN dmc_bazar_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN dmc_bazar_category_description cd ON (p2c.category_id = cd.category_id)
LEFT JOIN dmc_bazar_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN dmc_bazar_account_city ac ON (p.oras = ac.id)
LEFT JOIN dmc_bazar_account_county acc ON (ac.county_id = acc.id)
WHERE p.product_id = '1759'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:25

142 (20.154)

SELECT COUNT(1) AS total
FROM oc_customer
WHERE wishlist LIKE '%"B1759"%'

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_product.php:30

143 (1.386)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2823'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

144 (1.274)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2821'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

145 (1.268)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2819'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

146 (1.252)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2817'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

147 (1.246)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2815'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

148 (1.284)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2813'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

149 (1.277)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2811'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

150 (1.265)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2809'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

151 (1.221)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2807'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

152 (1.212)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2805'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

153 (1.208)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2803'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

154 (1.280)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2801'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

155 (1.256)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2795'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

156 (1.198)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2789'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

157 (1.243)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2781'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

158 (1.244)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2744'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

159 (1.201)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2565'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

160 (1.252)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=2563'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

161 (1.251)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_product_id=1759'
ORDER BY url_alias_id DESC

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:189

162 (0.161)

SELECT *
FROM oc_module
WHERE module_id = '1228'

/var/www/clients/client0/web1/web/catalog/model/extension/module.php:11

163 (0.120)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client0/web1/web/catalog/model/common/platforma.php:4

164 (0.488)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

165 (0.219)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '112' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

166 (0.944)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=112'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

167 (0.594)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

168 (0.347)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '24' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

169 (0.940)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

170 (0.992)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

171 (0.960)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=25'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

172 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

173 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

174 (0.893)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=27'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

175 (0.942)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

176 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

177 (0.989)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=26'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

178 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

179 (0.884)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

180 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=29'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

181 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

182 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

183 (0.885)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=28'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

184 (0.876)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

185 (0.873)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=24'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

186 (0.284)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '85' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

187 (0.886)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

188 (0.887)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=85'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

189 (0.212)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '39' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

190 (0.882)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

191 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=39'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

192 (0.217)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '33' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

193 (0.881)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

194 (0.881)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=33'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

195 (0.210)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '68' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

196 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

197 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=68'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

198 (0.198)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '40' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

199 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

200 (0.884)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=40'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

201 (0.478)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

202 (0.882)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

203 (0.874)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

204 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=3'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

205 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

206 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

207 (0.865)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=9'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

208 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

209 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

210 (0.873)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=5'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

211 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

212 (0.865)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

213 (0.864)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=83'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

214 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

215 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

216 (0.861)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=12'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

217 (0.862)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

218 (0.863)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

219 (0.867)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=7'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

220 (0.866)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

221 (0.864)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

222 (0.865)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=111'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

223 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

224 (0.864)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

225 (0.865)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=11'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

226 (0.916)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

227 (0.894)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

228 (0.881)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=6'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

229 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

230 (0.964)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

231 (0.893)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=8'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

232 (0.889)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

233 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

234 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=4'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

235 (0.876)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

236 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

237 (0.878)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=10'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

238 (0.874)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

239 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

240 (0.280)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '35' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

241 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

242 (0.924)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=35'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

243 (0.478)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '13' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

244 (0.922)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

245 (0.914)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

246 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=16'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

247 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

248 (0.909)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

249 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=19'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

250 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

251 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

252 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=14'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

253 (0.899)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

254 (0.901)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

255 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=17'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

256 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

257 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

258 (0.901)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=84'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

259 (0.900)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

260 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

261 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=20'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

262 (0.896)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

263 (0.900)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

264 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=15'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

265 (0.898)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

266 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

267 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=18'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

268 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

269 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=13'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

270 (0.296)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '32' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

271 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

272 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=32'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

273 (0.240)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '69' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

274 (0.923)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

275 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=69'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

276 (0.257)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '87' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

277 (0.940)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

278 (0.912)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=87'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

279 (0.206)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '30' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

280 (0.953)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

281 (0.950)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=30'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

282 (0.229)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '37' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

283 (0.882)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

284 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=37'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

285 (0.199)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '31' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

286 (0.925)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

287 (0.917)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=31'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

288 (0.245)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '36' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

289 (0.914)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

290 (0.912)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=36'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

291 (0.220)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '38' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

292 (0.919)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

293 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=38'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

294 (0.326)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '21' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

295 (0.917)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

296 (0.901)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=21'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

297 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=23'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

298 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

299 (0.901)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=21'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

300 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=22'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

301 (0.919)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

302 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=21'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

303 (0.288)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '86' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

304 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

305 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=86'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

306 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

307 (0.256)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '76' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

308 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=76'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

309 (0.340)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '77' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

310 (0.214)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '81' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

311 (0.912)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=77'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

312 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=81'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

313 (0.229)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '79' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

314 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=77'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

315 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=79'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

316 (0.218)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '78' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

317 (0.909)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=77'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

318 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=78'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

319 (0.216)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '80' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

320 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=77'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

321 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=80'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

322 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=77'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

323 (0.478)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '55' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

324 (0.219)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '63' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

325 (0.912)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

326 (0.907)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=63'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

327 (0.216)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '56' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

328 (0.874)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

329 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=56'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

330 (0.223)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '64' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

331 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

332 (0.902)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=64'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

333 (0.222)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '62' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

334 (0.901)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

335 (0.921)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=62'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

336 (0.259)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '61' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

337 (0.916)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

338 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=61'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

339 (0.218)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '59' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

340 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

341 (0.931)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=59'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

342 (0.256)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '58' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

343 (0.931)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

344 (0.891)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=58'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

345 (0.241)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '66' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

346 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

347 (0.881)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=66'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

348 (0.218)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '57' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

349 (0.878)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

350 (0.876)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=57'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

351 (0.203)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '110' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

352 (0.887)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

353 (0.872)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=110'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

354 (0.195)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '65' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

355 (0.878)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

356 (0.873)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=65'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

357 (0.213)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '67' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

358 (0.922)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

359 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=67'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

360 (0.238)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '60' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

361 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

362 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=60'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

363 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=55'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

364 (0.414)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '70' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

365 (0.219)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '71' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

366 (0.914)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

367 (0.906)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=71'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

368 (0.179)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '72' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

369 (0.890)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

370 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=72'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

371 (0.221)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '74' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

372 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

373 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=74'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

374 (0.230)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '75' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

375 (0.921)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

376 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=75'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

377 (0.224)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '73' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

378 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

379 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=73'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

380 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=70'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

381 (0.485)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '34' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

382 (0.217)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '42' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

383 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

384 (0.899)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=42'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

385 (0.178)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '41' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

386 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

387 (0.907)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=41'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

388 (0.224)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '47' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

389 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

390 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=47'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

391 (0.228)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '50' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

392 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

393 (0.913)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=50'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

394 (0.226)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '44' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

395 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

396 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=44'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

397 (0.228)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '43' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

398 (0.937)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

399 (0.916)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=43'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

400 (0.244)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '49' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

401 (1.000)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

402 (0.889)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=49'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

403 (0.224)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '53' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

404 (0.891)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

405 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=53'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

406 (0.212)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '45' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

407 (0.881)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

408 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=45'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

409 (0.210)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '54' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

410 (0.890)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

411 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=54'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

412 (0.203)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '51' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

413 (0.878)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

414 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=51'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

415 (0.200)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '52' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

416 (0.886)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

417 (0.872)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=52'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

418 (0.209)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '46' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

419 (0.878)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

420 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=46'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

421 (0.886)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=34'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

422 (0.226)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '88' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

423 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=88'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

424 (0.188)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '82' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

425 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=82'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

426 (0.263)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '89' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

427 (0.967)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=89'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

428 (0.553)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '90' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

429 (0.260)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '92' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

430 (0.953)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

431 (0.958)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=92'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

432 (0.229)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '109' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

433 (0.920)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

434 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=109'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

435 (0.238)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '98' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

436 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

437 (0.908)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=98'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

438 (0.186)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '96' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

439 (0.915)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

440 (0.905)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=96'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

441 (0.219)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '94' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

442 (0.907)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

443 (0.903)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=94'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

444 (0.187)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '91' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

445 (0.910)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

446 (0.907)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=91'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

447 (0.227)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '95' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

448 (0.911)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

449 (0.884)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=95'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

450 (0.214)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '100' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

451 (0.890)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

452 (0.885)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=100'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

453 (0.208)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '93' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

454 (0.877)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

455 (0.871)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=93'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

456 (0.202)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '99' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

457 (0.875)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

458 (0.871)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=99'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

459 (0.205)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '101' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

460 (0.916)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

461 (0.904)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=101'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

462 (0.264)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '108' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

463 (0.926)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

464 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=108'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

465 (0.186)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '97' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

466 (0.959)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

467 (0.937)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=97'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

468 (0.368)

SELECT *, (SELECT GROUP_CONCAT(cd1.name
ORDER BY cp.level SEPARATOR ' > ')
FROM dmc_bazar_category_path cp
LEFT JOIN dmc_bazar_category c1 ON (cp.category_id = c1.category_id)
LEFT JOIN dmc_bazar_category c2 ON (cp.path_id = c2.category_id)
LEFT JOIN dmc_bazar_category_description cd1 ON (cp.path_id = cd1.category_id)
LEFT JOIN dmc_bazar_category_description cd2 ON (cp.category_id = cd2.category_id)
WHERE c1.category_id = c.category_id) AS nume_complet
FROM dmc_bazar_category c
LEFT JOIN dmc_bazar_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '102' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/var/www/clients/client0/web1/web/catalog/model/catalog/bazar_category.php:14

469 (0.888)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

470 (0.879)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

471 (0.874)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=105'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

472 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

473 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

474 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=106'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

475 (0.870)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

476 (0.865)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

477 (0.897)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=107'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

478 (0.876)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

479 (0.871)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

480 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=103'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

481 (0.880)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

482 (0.869)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

483 (0.871)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=104'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

484 (0.868)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

485 (0.864)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=102'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

486 (0.876)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=90'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

487 (0.873)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

488 (0.869)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

489 (0.918)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=1'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

490 (0.974)

SELECT *
FROM dmc_bazar_url_alias
WHERE `query` = 'dmc_bazar_category_id=2'

/var/www/clients/client0/web1/web/catalog/controller/common/seo_url.php:232

491 (0.677)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

492 (0.139)

SELECT *
FROM oc_extension
WHERE `type` = 'total' AND status = '1'

/var/www/clients/client0/web1/web/catalog/model/extension/extension.php:4

493 (0.529)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

494 (0.485)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

495 (0.341)

SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0
ORDER BY `sort_order` ASC

/var/www/clients/client0/web1/web/catalog/model/module/productbundles.php:106

496 (0.721)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

497 (0.492)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

498 (0.441)

SELECT ca.product_id, ca.quantity AS quantity_cart, ca.option, ca.price AS price_cart, ca.recurring_id, ca.cart_id, ca.notificat_furnizor, (SELECT c.easybox
FROM oc_product_to_category p2c
LEFT JOIN oc_category c ON p2c.category_id = c.category_id
WHERE p2c.product_id = p.product_id
ORDER BY easybox DESC LIMIT 1) AS easybox, p.price AS price_product, (SELECT price
FROM oc_product_discount p2d
WHERE p2d.product_id = ca.product_id AND customer_group_id = '1' AND quantity <= ca.quantity AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1) AS price_discount, (SELECT ps.price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS price_special, (SELECT m.name
FROM oc_manufacturer m
WHERE m.manufacturer_id = p.manufacturer_id) AS manufacturer, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT pr.points
FROM oc_product_reward pr
WHERE pr.product_id = ca.product_id AND pr.customer_group_id = '1') AS points, p.date_modified, p.length_class_id, p.height, p.width, p.length, p.weight, p.weight_class_id, p.tax_class_id, p.subtract, p.minimum, p.quantity AS quantity_product, opp.stoc_online, opp.stoc_magazin, p.stoc_claumar, p.stoc_ffb, p.stoc_claumardepozit, p.furnizor, p.image, p.shipping, p.manufacturer_id, p.model, pd.name
FROM oc_cart ca
LEFT JOIN oc_product p ON p.product_id = ca.product_id
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS stoc_magazin, os.online AS stoc_online
FROM oc_order_stoc os) opp ON (opp.product_id = p.product_id)
WHERE ca.api_id = '0' AND ca.customer_id = '0' AND ca.session_id = '8184ce06903f12297a318c2f90' AND pd.language_id = '2' AND p.date_available <= NOW() AND p.status = '1'

/var/www/clients/client0/web1/web/system/library/cart.php:575

Lansete Crap

Lansete Somn

Lansete Spinning

Rubeziene

Vergi (Undite)

Lansete Bolognese

Lansete Casting

Lansete Copca

Lansete Feeder - Picker

Lansete Match

Lansete Musca

Lansete Universale

Recent adăugate

Vand Set 3 Mulinete Crap Prowess Nightfall Camou 7005 Fd

Combo Lansetă Feeder Black Force 4.20 60-180g+mulinetă Fl 6000

Adimarius.anghel@gmail.com

Combo Crap,caraș,platica

Vând Lanseta Noua Wolf X3k

2 Lansete Fox Eos 3.60

Incalzitor Mr.heater Portable Buddy

Cutie Korda

Lanseta Okuma 3buc.custom Black Feeder 3,90m/60-120g

Mulineta Okuma Inception 6000

Mulineta Tica Galant Long Cast Gbat 5000.

Deeper

Cort Umbrar Coleman 4,5x4m

Vad Lansete Flx 30 Echipate Cu Mulinete Okuma 8k

3 Lansete Prologic Inspire 3,90 M

Senzori Carp Zoom 6th Sense 4+1

Senzori Delkim Txi Plus

Mulinete Crap

Lansete Crap Camoupro

Produsul a fost adăugat în coș

Lansete Crap

Lansete Somn

Lansete Spinning

Rubeziene

Vergi (Undite)

Lansete Bolognese

Lansete Casting

Lansete Copca

Lansete Feeder - Picker

Lansete Match

Lansete Musca

Lansete Universale

Recent adăugate

Inscrie-te acum și vei fi la curent cu noutățile!