Carti din domeniul Filtrul produs

ARDEALUL N-ARE DUMNEZEU

Stoc limitat
ARTA FERICIRII

În stoc
ASCUNSA RANA

Stoc limitat
BIZANTUL

BIZANTUL MIHAI CAZACU

Pret:39,00lei


Stoc limitat
BLESTEMUL AURULUI

Stoc limitat
CAMINUL ADVENT

Stoc limitat
CANTECE FARA TARA

Stoc limitat
CANTECE TIGANESTI

În stoc
CARDIOLOGIE PEDIATRICA

Stoc limitat
CEI TREI MUSCHETARI

Stoc limitat
COPIL STRAIN

COPIL STRAIN A.J. CRONIN

Pret:8,99lei


Stoc limitat
CRUCI DE GRATII. VERSURI DIN INCHISOARE

Stoc limitat
DICTIONARUL ROSTIRILOR BIBLICE

Stoc limitat
DINCOLO DE DISPERARE

Stoc limitat
DISPRETUL VANITATII

În stoc
Afişare 1 - 15 din 209 (14 pagini)
Queries: 76, Total time: 5,789.707 ms [By time] [By id] [By file]
1 (0.466)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'f58099a12b028abd3e328c0567' AND expire > 1713444247
/var/www/clients/client1/web1/web/system/library/session/db.php:41
2 (0.471)
SELECT `data`
FROM `oc_session`
WHERE session_id = '84d6c06602a3caa036f7b4862e' AND expire > 1713444247
/var/www/clients/client1/web1/web/system/library/session/db.php:41
3 (0.480)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anticariat-ursu.ro/'
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:6
4 (3.238)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:25
5 (0.368)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/storage/modification/system/library/cart/currency.php:10
6 (0.720)
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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:30
7 (0.543)
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 = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:44
8 (0.509)
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/client1/web1/web/system/library/cart/weight.php:10
9 (0.430)
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/client1/web1/web/system/library/cart/length.php:10
10 (5.571)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 DAY)
/var/www/clients/client1/web1/web/system/library/cart/cart.php:29
11 (0.188)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/setting/event.php:4
12 (0.408)
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 = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:7
13 (0.802)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:745
14 (2,106.420)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, p.tax_class_id, if (SUM(if((f.filter_group = "a1" AND filter_id IN ('134')), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), IF(pov.price IS NOT NULL, pov.price, 0))) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT product_id, price
FROM `oc_product_option_value`
WHERE quantity > '0' GROUP BY product_id) AS pov ON (pov.product_id = p.product_id)
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`
WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '175' AND zone_id IN ('0', '2703')) OR (based = 'payment' AND country_id = '175' AND zone_id IN ('0', '2703'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p.date_available <= NOW() GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:746
15 (12.952)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1145
16 (188.836)
SELECT p.*, pp.sort_order, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pd.name ASC, IF ((p.quantity) > 0, 1, 0) LIMIT 0, 15
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:179
17 (40.848)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (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 wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '96392' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
18 (0.104)
SELECT *
FROM oc_product_image
WHERE product_id = '96392'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
19 (0.152)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '96392' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
20 (0.282)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '96392' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
21 (27.069)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '96392' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
22 (44.121)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '96392' AND pov.product_option_id = '57517' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
23 (38.843)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (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 wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '155326' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
24 (0.177)
SELECT *
FROM oc_product_image
WHERE product_id = '155326'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
25 (0.227)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '155326' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
26 (0.275)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '155326' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
27 (25.540)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '155326' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
28 (44.635)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '155326' AND pov.product_option_id = '76248' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
29 (0.089)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
30 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
31 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
32 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
33 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
34 (0.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
35 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
36 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
37 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
38 (0.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
39 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
40 (0.072)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=155326' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
41 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
42 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
43 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
44 (0.070)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=38065' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
45 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
46 (0.073)
SELECT *
FROM oc_layout_route
WHERE 'extension/module/brainyfilter/filter' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
47 (0.070)
SELECT *
FROM oc_layout_module
WHERE layout_id = '14' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
48 (0.052)
SELECT *
FROM oc_module
WHERE module_id = '35'
/var/www/clients/client1/web1/web/catalog/model/setting/module.php:4
49 (1,747.275)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM ( SELECT afc.*
FROM `oc_bf_product_attribute_value` AS afc) AS af
INNER JOIN ( SELECT p.*
FROM `oc_product` AS p) AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND p.status = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, av.value
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1129
50 (666.822)
SELECT DISTINCT m.manufacturer_id AS id, m.name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE p.status = 1 AND p.date_available <= NOW()
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:1230
51 (14.777)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('a1') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:947
52 (808.627)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('a1') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:981
53 (0.227)
SELECT *
FROM oc_layout_route
WHERE 'extension/module/brainyfilter/filter' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
54 (0.128)
SELECT *
FROM oc_layout_module
WHERE layout_id = '14' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
55 (0.125)
SELECT *
FROM oc_layout_route
WHERE 'extension/module/brainyfilter/filter' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
56 (0.114)
SELECT *
FROM oc_layout_module
WHERE layout_id = '14' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
57 (0.117)
SELECT *
FROM oc_layout_route
WHERE 'extension/module/brainyfilter/filter' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
58 (0.142)
SELECT *
FROM oc_layout_module
WHERE layout_id = '14' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
59 (1.851)
SELECT *
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 id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
60 (0.115)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
61 (0.089)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
62 (0.077)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
63 (0.119)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
64 (0.138)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
65 (0.136)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:200
66 (0.137)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '84d6c06602a3caa036f7b4862e'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
67 (0.102)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
68 (0.072)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '84d6c06602a3caa036f7b4862e'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
69 (0.074)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '84d6c06602a3caa036f7b4862e'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
70 (0.070)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '84d6c06602a3caa036f7b4862e'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
71 (0.100)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/extension/module/productbundles.php:92
72 (0.126)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '84d6c06602a3caa036f7b4862e'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
73 (0.111)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/clients/client1/web1/web/system/library/cart/customer.php:243
74 (1.765)
SELECT *
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 id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
75 (0.146)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=7' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
76 (0.124)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169