Uygulamayı Mağazadan Edinebilirsiniz

MENÜ
Çamaşır Dükkanım

Vergi Dairesi : KEMERALTI

Vergi Numarası : 3870048845

Şehir : İstanbul

Mağaza merkez adresi ve onaylanmış telefon numarası bpazar.com kayıtlarında mevcuttur.


FİKRİ ERON A.Ş.

Vergi Dairesi : KEMERALTI

Vergi Numarası : 3870048845

Şehir : İstanbul

Mağaza merkez adresi ve onaylanmış telefon numarası bpazar.com kayıtlarında mevcuttur.


Bu kategoride ürün bulunamadı.

Queries: 189, Total time: 278.580 ms [By time] [By id] [By file]
1 (0.355)
SELECT `data`
FROM `oc_session`
WHERE session_id = '5eec6ef40dfac1985bf00b2f5d' AND expire > 1571349153
/home/bpazar/public_html/system/library/session/db.php:21
2 (0.270)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
3 (0.030)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
4 (0.153)
SELECT `data`
FROM `oc_session`
WHERE session_id = '8c72f0a027aa9e886612d3e2e8' AND expire > 1571349153
/home/bpazar/public_html/system/library/session/db.php:21
5 (0.454)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://bpazar.com/'
/home/bpazar/storage/modification/catalog/controller/startup/startup.php:7
6 (0.612)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/bpazar/storage/modification/catalog/controller/startup/startup.php:26
7 (0.072)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
8 (0.077)
SELECT *
FROM oc_currency
/home/bpazar/storage/modification/system/library/cart/currency.php:10
9 (0.064)
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 = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354')
ORDER BY tr1.priority ASC
/home/bpazar/public_html/system/library/cart/tax.php:16
10 (0.060)
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 = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3354')
ORDER BY tr1.priority ASC
/home/bpazar/public_html/system/library/cart/tax.php:44
11 (0.070)
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 = '3'
/home/bpazar/public_html/system/library/cart/weight.php:10
12 (0.066)
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 = '3'
/home/bpazar/public_html/system/library/cart/length.php:10
13 (3.905)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/bpazar/storage/modification/system/library/cart/cart.php:15
14 (0.035)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/bpazar/public_html/system/library/openbay.php:61
15 (0.050)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/bpazar/public_html/catalog/model/setting/event.php:4
16 (0.439)
show tables like "oc\_journal2\_config"
/home/bpazar/public_html/system/journal2/startup.php:154
17 (0.097)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' OR store_id = -1
/home/bpazar/public_html/catalog/model/journal2/db.php:7
18 (1.676)
SELECT *
FROM oc_journal2_settings
WHERE `theme_id` = '13'
/home/bpazar/public_html/system/journal2/classes/journal2_skin.php:111
19 (0.131)
SELECT parent_id
FROM oc_journal2_skins
WHERE `skin_id` = '13'
/home/bpazar/public_html/system/journal2/classes/journal2_skin.php:195
20 (0.075)
SELECT *
FROM oc_layout_route
WHERE 'customerpartner/profile' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
21 (0.066)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
22 (0.063)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
23 (0.076)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/bpazar/public_html/catalog/model/journal2/module.php:90
24 (0.066)
SELECT *
FROM oc_layout_route
WHERE 'customerpartner/profile' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
25 (0.064)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'top'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
26 (0.061)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'bottom'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
27 (0.062)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'header'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
28 (0.065)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'footer'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
29 (0.099)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
30 (0.105)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
31 (0.265)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
32 (0.097)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '5' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
33 (0.100)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '3' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
34 (0.084)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
/home/bpazar/public_html/catalog/model/catalog/information.php:4
35 (0.077)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '256' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
36 (0.078)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '267' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
37 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '212' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
38 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '223' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
39 (0.067)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '884' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
40 (0.060)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '202' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
41 (0.058)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '177' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/bpazar/public_html/catalog/model/catalog/category.php:4
42 (0.355)
SELECT custom_field
from oc_customer
where customer_id = 1884
/home/bpazar/public_html/catalog/model/account/custom_field.php:50
43 (0.428)
SELECT custom_field
from oc_customer
where customer_id = 1884
/home/bpazar/public_html/catalog/model/account/custom_field.php:58
44 (0.240)
SELECT c2c.*, c.*,c.firstname,c.lastname,co.name as country, a.address_1, a.address_2, a.city, a.postcode, a.country_id, a.zone_id, a.custom_field
FROM oc_customerpartner_to_customer c2c
LEFT JOIN oc_customer c ON (c2c.customer_id = c.customer_id)
LEFT JOIN oc_address a ON (c.address_id = a.address_id)
LEFT JOIN oc_country co ON (c2c.country = co.iso_code_2)
WHERE c2c.customer_id = '1884' AND c2c.is_partner = '1' AND c.status = '1'
/home/bpazar/public_html/catalog/model/customerpartner/master.php:120
45 (0.064)
SELECT *
FROM oc_zone
WHERE zone_id = '3354' AND status = '1'
/home/bpazar/public_html/catalog/model/localisation/zone.php:4
46 (0.306)
SELECT round(AVG(field_value)) avg
FROM `oc_wk_feedback_attribute_values`
WHERE feedback_id IN (SELECT id
FROM `oc_customerpartner_to_feedback`
WHERE seller_id='1884' AND status = '1')
/home/bpazar/public_html/catalog/model/customerpartner/master.php:147
47 (23.375)
SELECT DISTINCT p.product_id
FROM oc_customerpartner_to_product c2p
LEFT JOIN oc_product p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE c2p.customer_id='1884' AND p.status='1' AND p.date_available <= NOW() AND p2s.store_id = '0'
ORDER BY c2p.product_id
/home/bpazar/public_html/catalog/model/customerpartner/master.php:107
48 (0.425)
SELECT r.*
FROM oc_customerpartner_to_product c2p
INNER JOIN oc_review r ON (c2p.product_id = r.product_id)
WHERE c2p.customer_id = '1884' AND r.status = 1
/home/bpazar/public_html/catalog/model/customerpartner/master.php:162
49 (7.721)
SELECT DISTINCT p.product_id
FROM oc_customerpartner_to_product c2p
LEFT JOIN oc_product p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE c2p.customer_id='1884' AND p.status='1' AND p.date_available <= NOW() AND p2s.store_id = '0'
ORDER BY c2p.product_id
/home/bpazar/public_html/catalog/model/customerpartner/master.php:107
50 (0.063)
SELECT *
FROM oc_layout_route
WHERE 'customerpartner/profile' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
51 (0.060)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
52 (0.060)
SELECT *
FROM oc_layout_route
WHERE 'customerpartner/profile' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/bpazar/public_html/catalog/model/design/layout.php:13
53 (0.054)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/home/bpazar/public_html/catalog/model/design/layout.php:23
54 (0.056)
SELECT *
FROM oc_wk_feedback_attribute
WHERE field_status = 1
/home/bpazar/public_html/catalog/model/customerpartner/master.php:237
55 (0.081)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
56 (0.073)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1457
57 (0.979)
SELECT *
FROM oc_customerpartner_to_customer
WHERE customer_id = '0'
/home/bpazar/public_html/catalog/model/account/customerpartner.php:1457
58 (0.065)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/bpazar/public_html/catalog/model/localisation/language.php:15
59 (0.083)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
60 (0.178)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8c72f0a027aa9e886612d3e2e8'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
61 (1.821)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/bpazar/public_html/catalog/model/setting/extension.php:4
62 (0.070)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
63 (0.065)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8c72f0a027aa9e886612d3e2e8'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
64 (0.076)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
65 (0.063)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8c72f0a027aa9e886612d3e2e8'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
66 (0.068)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/bpazar/storage/modification/system/library/cart/customer.php:122
67 (0.088)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
68 (0.091)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8c72f0a027aa9e886612d3e2e8'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
69 (0.095)
SELECT *
FROM oc_pointsvalues
/home/bpazar/storage/modification/system/library/cart/cart.php:144
70 (0.092)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8c72f0a027aa9e886612d3e2e8'
ORDER BY seller_id ASC
/home/bpazar/storage/modification/system/library/cart/cart.php:147
71 (0.160)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
72 (0.166)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
73 (0.145)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
74 (1.345)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2019-10-17 20:52:33'
/home/bpazar/public_html/catalog/model/tool/online.php:4
75 (0.138)
REPLACE INTO `oc_customer_online` SET `ip` = '18.207.134.98', `customer_id` = '0', `url` = 'https://www.bpazar.com/Camasir-Dukkanim/profile-1884', `referer` = '', `date_added` = '2019-10-17 21:52:33'
/home/bpazar/public_html/catalog/model/tool/online.php:6
76 (0.092)
SELECT c2c.*, c.*,c.firstname,c.lastname,co.name as country, a.address_1, a.address_2, a.city, a.postcode, a.country_id, a.zone_id, a.custom_field
FROM oc_customerpartner_to_customer c2c
LEFT JOIN oc_customer c ON (c2c.customer_id = c.customer_id)
LEFT JOIN oc_address a ON (c.address_id = a.address_id)
LEFT JOIN oc_country co ON (c2c.country = co.iso_code_2)
WHERE c2c.customer_id = '1884' AND c2c.is_partner = '1' AND c.status = '1'
/home/bpazar/public_html/catalog/model/customerpartner/master.php:120
77 (0.096)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
78 (0.125)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
79 (3.568)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '256' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
80 (3.353)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '245' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
81 (4.247)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '247' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
82 (3.759)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '243' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
83 (5.899)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '105' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
84 (3.409)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1184' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
85 (3.349)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1131' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
86 (3.491)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '244' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
87 (5.750)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '107' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
88 (0.210)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1267' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
89 (8.713)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '59' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
90 (0.142)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
91 (3.304)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '184' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
92 (3.267)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '20' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
93 (3.268)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '18' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
94 (3.260)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '25' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
95 (3.261)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '24' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
96 (3.237)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '33' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
97 (3.390)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '34' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
98 (3.402)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '69' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
99 (0.167)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '172' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
100 (0.331)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '218' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
101 (1.587)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '210' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
102 (1.973)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1188' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
103 (0.206)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '2586' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
104 (0.170)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '2624' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
105 (3.852)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '213' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
106 (3.857)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '214' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
107 (0.426)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '2615' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
108 (0.702)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1251' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
109 (1.506)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1223' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
110 (0.313)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '2640' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
111 (3.860)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '212' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
112 (3.829)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '211' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
113 (3.837)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '216' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
114 (3.877)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '217' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
115 (2.084)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '215' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
116 (3.789)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '172' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
117 (0.149)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '176' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
118 (3.862)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '189' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
119 (0.178)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '2346' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
120 (3.837)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1190' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
121 (0.587)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1218' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
122 (2.129)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '186' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
123 (2.144)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '191' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
124 (2.138)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '185' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
125 (2.144)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '187' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
126 (1.441)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '188' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
127 (2.164)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '190' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
128 (2.174)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '176' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
129 (0.132)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '170' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
130 (2.175)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '239' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
131 (2.169)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '242' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
132 (2.198)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '236' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
133 (2.168)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '237' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
134 (2.153)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '752' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
135 (2.163)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '884' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
136 (0.903)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '234' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
137 (2.166)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '235' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
138 (2.173)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '238' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
139 (2.151)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '240' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
140 (2.172)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '241' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
141 (2.154)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '170' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
142 (0.125)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '173' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
143 (2.168)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '209' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
144 (0.170)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '201' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
145 (0.543)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '205' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
146 (2.193)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '208' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
147 (2.460)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '207' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
148 (2.259)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '206' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
149 (0.270)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '203' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
150 (0.396)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '204' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
151 (2.295)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '202' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
152 (2.295)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '173' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
153 (0.156)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '171' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
154 (1.679)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '232' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
155 (0.318)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '222' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
156 (1.539)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '229' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
157 (0.888)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '571' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
158 (1.693)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '220' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
159 (1.126)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '230' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
160 (1.175)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '228' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
161 (0.958)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '231' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
162 (1.957)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '224' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
163 (0.583)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '225' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
164 (0.588)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '226' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
165 (1.673)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '221' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
166 (0.511)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '223' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
167 (0.268)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '227' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
168 (2.692)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '171' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
169 (0.104)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '174' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
170 (2.277)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '177' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
171 (2.210)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '181' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
172 (2.167)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '182' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
173 (0.741)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '180' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
174 (2.159)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '179' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
175 (0.732)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '1183' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
176 (2.173)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '174' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
177 (0.131)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '175' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/bpazar/public_html/catalog/model/catalog/category.php:11
178 (0.265)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '196' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
179 (2.119)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '195' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
180 (0.946)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '198' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
181 (2.129)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '192' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
182 (1.659)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '197' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
183 (2.166)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '194' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
184 (2.178)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '193' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
185 (2.156)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '200' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
186 (0.377)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '199' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
187 (2.140)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2c.category_id = '175' AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541
188 (5.411)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT 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 special
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884 GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,10
/home/bpazar/public_html/catalog/model/account/customerpartner.php:481
189 (4.996)
SELECT count(*) as total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_customerpartner_to_product c2p ON (c2p.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1' AND c2p.customer_id = 1884
/home/bpazar/public_html/catalog/model/account/customerpartner.php:541