Căutare

Queries: 13, Total time: 990.043 ms [By time] [By id] [By file]

1 (0.141)

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

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

2 (0.110)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.103)

SELECT `trigger`, `action`
FROM oc_event

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

4 (576.666)

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

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

5 (1.665)

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

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

6 (102.128)

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

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

7 (17.564)

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

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

8 (0.096)

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

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

9 (3.816)

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

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

10 (287.498)

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

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

11 (0.098)

SELECT *
FROM oc_platforma_promovari

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

12 (0.081)

SELECT *
FROM oc_platforma_promovari

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

13 (0.077)

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

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

Produse ce potrivesc criteriilor de căutare

Mix Cereale Claumar SQUID OCTOPUS 1Kg

Boilies Claumar Fishmeal Solubile Squid Cu Pruna 16mm 1Kg

Carlige Claumar FANG Teflon Technology Nr 4 10Buc/Plic

Nada Claumar Special Anason Rosu 1KG

Pop Up Claumar Porumb Dulce Galben2 10mm 15Gr

Boilies Claumar Birdfood Tare Squid And Pruna 24mm 5kg PUNGA

Pop Up Claumar Tutti Frutti Mix 15Gr 10mm

Tub Siliconic Pentru Carlig Claumar 1 Metru 1.2mm

Fir Textil Teflonat Claumar Pescar Stiff Line 20M 0.14MM 8.0KG

Nectar, De, Porumb, Claumar, 1300gr, Scopex, clm139, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri Claumar, Aditivi Claumar, Lichizi Claumar, Arome Claumar, Dip-uri Claumar, Claumar

Fir Textil Claumar Spod And Marker Braid 0.16mm 200m

Tub Termocontractabil Claumar Shrink Tube Claumar Diametru 2.5mm Strangere Pana La 0.5mm

Fir Textil Teflonat Claumar Pescar Stiff Line 20M 0.16MM 9.0KG

Opritor Pe Fir Claumar Negru 18 Buc Marime S

Carlige Claumar CHODDY Teflon Technology Nr 6 10Buc/Plic

Boilies Claumar Fishmeal Solubile Squid And Pruna 24mm 1Kg

Boilies Claumar Birdfood De Carlig Semi-Solubil Squid Si Capsuni 100gr

Boilies Claumar Fishmeal De Carlig Critic Echilibrat Frankfurter 100gr

Mamaliga Claumar Patratica 100gr Taiata 10mm NATURALA

Pop Up Dumbells Claumar 10Buc 5x6mm-5x8mm Verde Fluoro

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare