Căutare

Queries: 23, Total time: 3.963 ms [By time] [By id] [By file]

1 (0.107)

SELECT data
FROM `oc_session`
WHERE session_id = '72cd0497d154b9f73922c7c2ba'

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

2 (0.076)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.091)

CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY

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

4 (0.404)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("171028", "2", "1000", "117", "1", "53.780000000000", "1"),("171030", "2", "1000", "117", "1", "53.780000000000", "2"),("171031", "2", "1000", "117", "1", "53.780000000000", "3"),("29910", "10", "1000", "117", "1", "53.780000000000", "4"),("171027", "2", "0", "117", "1", "43.000000000000", "5"),("171029", "2", "0", "117", "1", "43.000000000000", "6"),("171032", "2", "0", "117", "1", "43.000000000000", "7"),("142745", "1", "1011", "48", "1", "5.040000000000", "8"),("149133", "1", "1003", "48", "1", "5.040000000000", "9"),("160423", "2", "1001", "48", "1", "5.040000000000", "10"),("26945", "2", "1000", "117", "1", "47.060000000000", "11"),("174721", "1", "1003", "48", "1", "9.240000000000", "12"),("174710", "1", "1001", "48", "1", "9.240000000000", "13"),("174720", "1", "1000", "48", "1", "9.240000000000", "14"),("174724", "1", "1000", "48", "1", "9.240000000000", "15"),("174725", "1", "4", "48", "1", "9.240000000000", "16"),("174723", "1", "1", "48", "1", "9.240000000000", "17"),("43538", "2", "1000", "48", "1", "8.400000000000", "18"),("117106", "2", "17", "280", "1", "25.130000000000", "19"),("142491", "2", "1005", "48", "1", "7.560000000000", "20"),("44861", "2", "1000", "48", "1", "9.240000000000", "21"),("160235", "10", "1000", "48", "1", "7.560000000000", "22"),("141929", "2", "1000", "48", "1", "5.880000000000", "23"),("160039", "2", "1000", "48", "1", "9.240000000000", "24"),("142193", "2", "1", "48", "1", "7.560000000000", "25"),("197827", "2", "1010", "48", "1", "7.560000000000", "26"),("160883", "1", "1000", "637", "1", "26.890000000000", "27"),("160889", "1", "1000", "637", "1", "26.890000000000", "28"),("160893", "1", "1000", "637", "1", "26.890000000000", "29"),("160897", "1", "1000", "637", "1", "26.890000000000", "30"),("160899", "1", "1000", "637", "1", "26.890000000000", "31"),("160887", "1", "1000", "637", "1", "26.890000000000", "32"),("160891", "1", "1000", "637", "1", "26.890000000000", "33"),("160895", "1", "1000", "637", "1", "26.890000000000", "34"),("100977", "2", "1000", "177", "1", "34.450000000000", "35"),("100979", "2", "1000", "177", "1", "34.450000000000", "36"),("100980", "2", "1000", "177", "1", "34.450000000000", "37"),("100983", "2", "1000", "177", "1", "34.450000000000", "38"),("100986", "2", "1000", "177", "1", "34.450000000000", "39"),("44339", "2", "2", "48", "1", "20.170000000000", "40"),("29864", "2", "1000", "117", "1", "49.580000000000", "41"),("29882", "2", "2", "117", "1", "49.580000000000", "42"),("123867", "2", "1000", "297", "1", "8.400000000000", "43"),("94543", "2", "1006", "73", "1", "20.130000000000", "44"),("31258", "2", "1", "117", "1", "57.980000000000", "45"),("178643", "1", "1000", "117", "1", "57.980000000000", "46"),("57014", "2", "1004", "15", "1", "31.780000000000", "47"),("57015", "2", "1003", "15", "1", "31.780000000000", "48"),("57016", "2", "1002", "15", "1", "20.160000000000", "49"),("57013", "2", "1001", "15", "1", "31.780000000000", "50"),("57017", "2", "1000", "15", "1", "31.780000000000", "51"),("111584", "1", "1000", "117", "1", "57.980000000000", "52"),("111597", "1", "1000", "117", "1", "57.980000000000", "53"),("111581", "1", "1000", "117", "1", "57.980000000000", "54"),("111586", "1", "1000", "117", "1", "57.980000000000", "55"),("243620", "2", "1000", "73", "1", "10.460000000000", "56"),("7560", "2", "1000", "15", "1", "31.780000000000", "57"),("243892", "2", "1000", "73", "1", "31.470000000000", "58"),("243604", "2", "1000", "73", "1", "10.460000000000", "59"),("57968", "2", "1002", "15", "1", "15.680000000000", "60"),("57953", "2", "1001", "15", "1", "10.820000000000", "61"),("57961", "2", "1000", "15", "1", "10.820000000000", "62"),("57956", "2", "1000", "15", "1", "10.920000000000", "63"),("56960", "2", "1014", "15", "1", "15.760000000000", "64"),("57945", "2", "1012", "15", "1", "12.630000000000", "65"),("35195", "2", "1011", "15", "1", "15.680000000000", "66"),("57967", "2", "1004", "15", "1", "15.680000000000", "67"),("57947", "2", "1002", "15", "1", "11.800000000000", "68"),("57951", "2", "1002", "15", "1", "11.800000000000", "69"),("57943", "2", "1002", "15", "1", "12.630000000000", "70"),("57946", "2", "1001", "15", "1", "12.630000000000", "71"),("57942", "2", "1001", "15", "1", "12.630000000000", "72"),("57949", "2", "1000", "15", "1", "11.800000000000", "73"),("56963", "2", "1000", "15", "1", "15.760000000000", "74"),("35196", "2", "1000", "15", "1", "15.680000000000", "75"),("57957", "2", "1001", "15", "1", "7.690000000000", "76"),("57958", "2", "1000", "15", "1", "10.820000000000", "77"),("130139", "1", "1007", "193", "1", "11.680000000000", "78"),("130137", "1", "1006", "193", "1", "11.680000000000", "79"),("130135", "1", "1006", "193", "1", "11.680000000000", "80"),("164826", "1", "1000", "593", "1", "151.230000000000", "81"),("167128", "1", "1000", "193", "1", "9.660000000000", "82"),("135945", "1", "1000", "193", "1", "9.660000000000", "83"),("167129", "1", "4", "193", "1", "9.660000000000", "84"),("167132", "1", "1002", "193", "1", "10.080000000000", "85"),("149445", "4", "1001", "58", "1", "268.910000000000", "86"),("149447", "4", "1001", "58", "1", "298.320000000000", "87"),("149451", "4", "1001", "58", "1", "323.530000000000", "88"),("167134", "1", "1001", "193", "1", "10.080000000000", "89"),("135949", "1", "1001", "193", "1", "10.080000000000", "90"),("149453", "4", "1001", "58", "1", "335.290000000000", "91"),("149443", "4", "1001", "58", "1", "239.500000000000", "92"),("149449", "4", "1001", "58", "1", "306.720000000000", "93"),("167131", "1", "1000", "193", "1", "10.080000000000", "94"),("167135", "1", "1000", "193", "1", "10.080000000000", "95"),("167133", "1", "1", "193", "1", "6.640000000000", "96"),("192223", "2", "1004", "15", "1", "24.320000000000", "97"),("192225", "2", "1002", "15", "1", "28.300000000000", "98"),("192221", "2", "3", "15", "1", "20.060000000000", "99"),("216277", "1", "1008", "761", "1", "1461.340000000000", "100"),("216275", "1", "1007", "761", "1", "1294.290000000000", "101"),("239523", "1", "1005", "761", "1", "1424.370000000000", "102"),("239520", "1", "1005", "761", "1", "1260.080000000000", "103"),("239526", "1", "1004", "761", "1", "1428.150000000000", "104"),("216237", "1", "1018", "761", "1", "108.170000000000", "105"),("216235", "1", "1009", "761", "1", "108.170000000000", "106"),("174719", "1", "0", "48", "1", "7.850000000000", "107"),("142705", "1", "0", "48", "1", "5.040000000000", "108"),("228686", "2", "0", "117", "1", "49.580000000000", "109"),("187849", "2", "0", "117", "1", "39.000000000000", "110"),("174718", "1", "0", "48", "1", "6.600000000000", "111"),("174722", "1", "0", "48", "1", "7.850000000000", "112"),("174726", "1", "0", "48", "1", "6.596600000000", "113"),("174727", "1", "0", "48", "1", "7.850000000000", "114"),("174729", "1", "0", "48", "1", "7.850000000000", "115"),("174821", "1", "0", "48", "1", "4.000000000000", "116"),("174810", "1", "0", "48", "1", "5.210000000000", "117"),("177918", "1", "0", "48", "1", "4.880000000000", "118"),("45753", "2", "0", "48", "1", "9.830000000000", "119"),("121889", "2", "0", "297", "1", "5.920000000000", "120"),("160881", "1", "0", "637", "1", "16.000000000000", "121"),("160885", "1", "0", "637", "1", "16.000000000000", "122"),("29865", "2", "0", "117", "1", "39.000000000000", "123"),("29866", "2", "0", "117", "1", "35.000000000000", "124"),("29877", "2", "0", "117", "1", "39.000000000000", "125"),("29875", "2", "0", "117", "1", "39.000000000000", "126"),("29886", "2", "0", "117", "1", "39.000000000000", "127"),("29879", "2", "0", "117", "1", "39.000000000000", "128"),("121767", "2", "0", "297", "1", "5.920000000000", "129"),("167648", "2", "0", "117", "1", "39.000000000000", "130"),("167646", "2", "0", "117", "1", "39.000000000000", "131"),("99430", "2", "0", "117", "1", "39.000000000000", "132"),("99431", "2", "0", "117", "1", "39.000000000000", "133"),("99433", "2", "0", "117", "1", "35.000000000000", "134"),("99434", "2", "0", "117", "1", "39.000000000000", "135"),("31262", "2", "0", "117", "1", "42.000000000000", "136"),("31264", "2", "0", "117", "1", "45.000000000000", "137"),("99435", "2", "0", "117", "1", "39.000000000000", "138"),("99432", "2", "0", "117", "1", "39.000000000000", "139"),("99436", "2", "0", "117", "1", "39.000000000000", "140"),("98988", "2", "0", "117", "1", "45.000000000000", "141"),("4627", "2", "0", "95", "1", "15.000000000000", "142"),("111582", "1", "0", "117", "1", "44.000000000000", "143"),("111585", "1", "0", "117", "1", "44.000000000000", "144"),("111596", "1", "0", "117", "1", "44.000000000000", "145"),("169145", "2", "0", "280", "1", "20.020000000000", "146"),("91554", "2", "0", "85", "1", "25.630000000000", "147"),("109662", "2", "0", "85", "1", "10.590000000000", "148"),("43420", "2", "0", "297", "1", "10.920000000000", "149"),("164827", "1", "0", "593", "1", "105.040000000000", "150"),("164822", "1", "0", "593", "1", "111.080000000000", "151"),("164823", "1", "0", "593", "1", "111.080000000000", "152"),("164821", "1", "0", "593", "1", "111.080000000000", "153"),("135963", "2", "0", "193", "1", "11.760000000000", "154"),("135965", "2", "0", "193", "1", "11.760000000000", "155"),("135967", "2", "0", "193", "1", "13.450000000000", "156"),("135977", "2", "0", "193", "1", "10.920000000000", "157"),("130147", "1", "0", "193", "1", "8.070000000000", "158"),("135961", "2", "0", "193", "1", "12.610000000000", "159"),("192219", "2", "0", "15", "1", "11.060000000000", "160"),("192217", "2", "0", "15", "1", "9.650000000000", "161")

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

5 (0.084)

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:1593

6 (0.173)

SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20

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

7 (0.099)

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