Căutare

Queries: 11, Total time: 1,075.552 ms [By time] [By id] [By file]

1 (0.115)

SELECT data
FROM `oc_session`
WHERE session_id = '1594a49ef6505373b33407d9cc'

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (823.563)

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

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

4 (1.199)

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

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

5 (72.886)

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 6620, 20

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

6 (0.152)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'

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

7 (12.838)

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

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

8 (0.130)

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

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

9 (2.695)

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

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

10 (161.738)

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

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

11 (0.137)

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

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

Produse ce potrivesc criteriilor de căutare

DISPOZITIV CUDA PENTRU ASCUTIT CUTIT/FOARFECA, 8CM

Fir Carp Expert Boilie Special Multicolor 0.20mm 150m

INEL ENERGOTEAM CU BUCSA SIC 25

Lanseta Colmic Pamir Tele Boat 2.50m 50 200g

Tub lansete Plano Jumbo 170cm

Ulei Ardent Reel Butter Bearing Lube

Cicada Strike PRO 7.5cm, 50g, A116L Glow Cyber Vibe

Fir Titan Power 0.30mm 100m

PORUMB CARP ZOOM HARD CORN 250GR AROMA VANILIE

FIR MONOFILAMENT MAVER SMART RED DEVIL 150M 0.50MM

PLUTA JAXON WAGLER STICK G3 2.50GR

SHAD SPRO FREESTYLE URBAN PREY SLUG WATERMELON 3.7CM 6BUC PLIC

ATA MATISAJ FUJI A-ULTRA BRIGHT 800m 50 CHESTNUT 011

PLUTA BFF TF1013 2.50GR

Agrafa Rapida NR 3 MAVER

Ancora VMC 8650BZ nr.5/0

Cleste Coast Multifunctional cu Lanterna LED150

Fir ASSO Ultra Molecular Shield White 0.20mm 150m

ADITIV LICHID GENLOG BUZZER COMPETITION FRUCTI DI MARE 250 ML

Cap Minciog Matrix Fine Mesh Landing Net 50x40cm

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare