Căutare

Queries: 21, Total time: 4.898 ms [By time] [By id] [By file]

1 (0.136)

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

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.155)

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.520)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("109674", "2", "1000", "85", "1", "61.750000000000", "1"),("210801", "1", "1000", "224", "1", "17.650000000000", "2"),("210803", "1", "1000", "224", "1", "17.650000000000", "3"),("218457", "1", "1000", "749", "1", "100.840000000000", "4"),("218467", "1", "1000", "749", "1", "100.840000000000", "5"),("218471", "1", "1000", "749", "1", "84.030000000000", "6"),("154429", "1", "1", "224", "1", "13.450000000000", "7"),("77842", "2", "1000", "85", "1", "55.560000000000", "8"),("84567", "2", "1000", "85", "1", "55.560000000000", "9"),("84566", "2", "1000", "85", "1", "55.560000000000", "10"),("218475", "1", "1000", "749", "1", "84.030000000000", "11"),("230041", "2", "1000", "285", "1", "18.120000000000", "12"),("218479", "1", "1000", "749", "1", "84.030000000000", "13"),("165294", "1", "1003", "611", "1", "28.320000000000", "14"),("165296", "1", "1003", "611", "1", "28.320000000000", "15"),("160927", "1", "1000", "637", "1", "25.210000000000", "16"),("160929", "1", "1000", "637", "1", "25.210000000000", "17"),("160931", "1", "1000", "637", "1", "25.210000000000", "18"),("160933", "1", "1000", "637", "1", "25.210000000000", "19"),("160935", "1", "1000", "637", "1", "25.210000000000", "20"),("160937", "1", "1000", "637", "1", "25.210000000000", "21"),("160943", "1", "1000", "637", "1", "25.210000000000", "22"),("161053", "1", "1000", "637", "1", "25.210000000000", "23"),("161055", "1", "1000", "637", "1", "25.210000000000", "24"),("161057", "1", "1000", "637", "1", "25.210000000000", "25"),("161061", "1", "1000", "637", "1", "25.210000000000", "26"),("161063", "1", "1000", "637", "1", "25.210000000000", "27"),("161065", "1", "1000", "637", "1", "25.210000000000", "28"),("161067", "1", "1000", "637", "1", "25.210000000000", "29"),("161071", "1", "1000", "637", "1", "25.210000000000", "30"),("161073", "1", "1000", "637", "1", "25.210000000000", "31"),("161051", "1", "1000", "637", "1", "25.210000000000", "32"),("178359", "1", "1010", "85", "1", "43.700000000000", "33"),("165293", "1", "1004", "611", "1", "28.320000000000", "34"),("172310", "1", "1000", "658", "1", "36.030000000000", "35"),("172311", "1", "1000", "658", "1", "36.030000000000", "36"),("239318", "2", "1000", "85", "1", "30.250000000000", "37"),("239320", "2", "1000", "85", "1", "30.250000000000", "38"),("239321", "2", "1000", "85", "1", "30.250000000000", "39"),("235310", "1", "1000", "85", "1", "33.610000000000", "40"),("171956", "1", "1000", "658", "1", "20.160000000000", "41"),("171958", "1", "1000", "658", "1", "20.160000000000", "42"),("172277", "1", "1000", "658", "1", "27.750000000000", "43"),("172278", "1", "1000", "658", "1", "27.750000000000", "44"),("235309", "1", "1000", "85", "1", "33.610000000000", "45"),("178361", "1", "1000", "85", "1", "44.440000000000", "46"),("178363", "1", "1000", "85", "1", "44.440000000000", "47"),("122105", "2", "1000", "85", "1", "36.760000000000", "48"),("178365", "1", "1000", "85", "1", "31.110000000000", "49"),("224368", "1", "1000", "224", "1", "37.820000000000", "50"),("224370", "1", "1000", "224", "1", "37.820000000000", "51"),("224371", "1", "1000", "224", "1", "37.820000000000", "52"),("179574", "1", "1000", "658", "1", "25.620000000000", "53"),("243058", "1", "1000", "85", "1", "67.230000000000", "54"),("230829", "1", "1000", "85", "1", "40.340000000000", "55"),("230832", "1", "1000", "85", "1", "40.340000000000", "56"),("230836", "1", "1000", "85", "1", "40.340000000000", "57"),("230838", "1", "1000", "85", "1", "40.340000000000", "58"),("134863", "1", "1000", "117", "1", "41.180000000000", "59"),("134865", "1", "1000", "117", "1", "41.180000000000", "60"),("134881", "1", "1000", "117", "1", "41.180000000000", "61"),("134883", "1", "1000", "117", "1", "41.180000000000", "62"),("178360", "1", "1000", "85", "1", "44.440000000000", "63"),("178362", "1", "1000", "85", "1", "44.440000000000", "64"),("178364", "1", "1000", "85", "1", "44.440000000000", "65"),("144471", "2", "1000", "85", "1", "59.310000000000", "66"),("122103", "2", "1000", "85", "1", "36.760000000000", "67"),("122109", "2", "1000", "85", "1", "36.760000000000", "68"),("122111", "2", "1000", "85", "1", "36.760000000000", "69"),("178366", "1", "1000", "85", "1", "31.110000000000", "70"),("230830", "1", "1000", "85", "1", "40.340000000000", "71"),("230831", "1", "1000", "85", "1", "40.340000000000", "72"),("230833", "1", "1000", "85", "1", "40.340000000000", "73"),("230834", "1", "1000", "85", "1", "40.340000000000", "74"),("230835", "1", "1000", "85", "1", "40.340000000000", "75"),("230837", "1", "1000", "85", "1", "40.340000000000", "76"),("236301", "1", "1000", "85", "1", "43.700000000000", "77"),("236302", "1", "1000", "85", "1", "43.700000000000", "78"),("228577", "1", "1000", "150", "1", "210.250000000000", "79"),("228579", "1", "1000", "150", "1", "210.250000000000", "80"),("134867", "1", "1000", "117", "1", "41.180000000000", "81"),("134869", "1", "1000", "117", "1", "41.180000000000", "82"),("134875", "1", "1000", "117", "1", "41.180000000000", "83"),("134877", "1", "1000", "117", "1", "41.180000000000", "84"),("210043", "2", "1010", "13", "1", "13.360000000000", "85"),("210045", "2", "1002", "13", "1", "13.360000000000", "86"),("179322", "2", "1000", "185", "1", "45.340000000000", "87"),("236118", "1", "1005", "85", "1", "43.700000000000", "88"),("236119", "1", "1005", "85", "1", "43.700000000000", "89"),("122107", "2", "1000", "85", "1", "36.760000000000", "90"),("122113", "2", "1000", "85", "1", "36.760000000000", "91"),("243026", "1", "1000", "85", "1", "36.970000000000", "92"),("243018", "1", "1000", "85", "1", "36.970000000000", "93"),("243020", "1", "1000", "85", "1", "36.970000000000", "94"),("228580", "1", "1000", "150", "1", "210.250000000000", "95"),("134859", "1", "1000", "117", "1", "41.180000000000", "96"),("134861", "1", "1000", "117", "1", "41.180000000000", "97"),("179320", "2", "1000", "185", "1", "45.340000000000", "98"),("236661", "1", "1000", "85", "1", "63.870000000000", "99"),("236662", "1", "1000", "85", "1", "63.870000000000", "100"),("243021", "1", "1000", "85", "1", "36.970000000000", "101"),("243024", "1", "1000", "85", "1", "36.970000000000", "102"),("243025", "1", "1000", "85", "1", "36.970000000000", "103"),("47459", "2", "1005", "85", "1", "57.140000000000", "104"),("228578", "1", "1000", "150", "1", "210.250000000000", "105"),("132535", "2", "1000", "105", "1", "29.410000000000", "106"),("132537", "2", "1000", "105", "1", "29.410000000000", "107"),("243022", "1", "1000", "85", "1", "36.970000000000", "108"),("243027", "1", "1000", "85", "1", "36.970000000000", "109"),("236672", "1", "1000", "85", "1", "63.870000000000", "110"),("235056", "1", "1001", "11", "1", "29.450000000000", "111"),("235049", "1", "1000", "11", "1", "30.760000000000", "112"),("235055", "1", "1000", "11", "1", "29.450000000000", "113"),("235054", "1", "1000", "11", "1", "29.450000000000", "114"),("147501", "1", "1000", "117", "1", "41.180000000000", "115"),("230802", "1", "1000", "117", "1", "34.450000000000", "116"),("243286", "1", "1000", "85", "1", "43.700000000000", "117"),("243283", "1", "1000", "85", "1", "43.700000000000", "118"),("230803", "1", "1000", "117", "1", "34.450000000000", "119"),("230804", "1", "1000", "117", "1", "34.450000000000", "120"),("230806", "1", "1000", "117", "1", "34.450000000000", "121"),("230807", "1", "1000", "117", "1", "34.450000000000", "122"),("230808", "1", "1000", "117", "1", "34.450000000000", "123"),("230810", "1", "1000", "117", "1", "34.450000000000", "124"),("230811", "1", "1000", "117", "1", "34.450000000000", "125"),("230812", "1", "1000", "117", "1", "34.450000000000", "126"),("230805", "1", "1000", "117", "1", "34.450000000000", "127"),("230809", "1", "1000", "117", "1", "34.450000000000", "128"),("134467", "2", "1000", "606", "1", "24.790000000000", "129"),("221370", "1", "1000", "117", "1", "34.450000000000", "130"),("91999", "2", "0", "85", "1", "45.740000000000", "131"),("92000", "2", "0", "85", "1", "45.740000000000", "132"),("59425", "2", "0", "11", "1", "42.040000000000", "133"),("59427", "2", "0", "11", "1", "42.040000000000", "134"),("91994", "2", "0", "85", "1", "42.740000000000", "135"),("77841", "2", "0", "85", "1", "42.740000000000", "136"),("92964", "2", "0", "85", "1", "36.980000000000", "137"),("230877", "2", "0", "85", "1", "25.700000000000", "138"),("236667", "1", "0", "85", "1", "41.130000000000", "139"),("236668", "1", "0", "85", "1", "41.130000000000", "140"),("236669", "1", "0", "85", "1", "41.130000000000", "141"),("236671", "1", "0", "85", "1", "41.130000000000", "142"),("230872", "2", "0", "85", "1", "25.700000000000", "143"),("230874", "2", "0", "85", "1", "25.700000000000", "144"),("230875", "2", "0", "85", "1", "25.700000000000", "145"),("230876", "2", "0", "85", "1", "25.700000000000", "146"),("161047", "1", "0", "637", "1", "15.000000000000", "147"),("161059", "1", "0", "637", "1", "15.000000000000", "148"),("160923", "1", "0", "637", "1", "15.000000000000", "149"),("160939", "1", "0", "637", "1", "15.000000000000", "150"),("160941", "1", "0", "637", "1", "15.000000000000", "151"),("236670", "1", "0", "85", "1", "41.130000000000", "152"),("235306", "1", "0", "85", "1", "25.700000000000", "153"),("243052", "1", "0", "85", "1", "51.460000000000", "154"),("243054", "1", "0", "85", "1", "51.460000000000", "155"),("243064", "1", "0", "85", "1", "51.460000000000", "156"),("235307", "1", "0", "85", "1", "25.700000000000", "157"),("67978", "2", "0", "85", "1", "27.850000000000", "158"),("224367", "1", "0", "224", "1", "21.050000000000", "159"),("224369", "1", "0", "224", "1", "21.050000000000", "160"),("243053", "1", "0", "85", "1", "51.460000000000", "161"),("243062", "1", "0", "85", "1", "51.460000000000", "162"),("243063", "1", "0", "85", "1", "51.460000000000", "163"),("109516", "2", "0", "85", "1", "24.520000000000", "164"),("146641", "2", "0", "85", "1", "20.900000000000", "165"),("236701", "2", "0", "85", "1", "43.700000000000", "166"),("243055", "1", "0", "85", "1", "51.460000000000", "167"),("134857", "1", "0", "117", "1", "32.000000000000", "168"),("134871", "1", "0", "117", "1", "32.000000000000", "169"),("134873", "1", "0", "117", "1", "32.000000000000", "170"),("134879", "1", "0", "117", "1", "32.000000000000", "171"),("122683", "2", "0", "185", "1", "23.730000000000", "172"),("68804", "2", "0", "85", "1", "25.470000000000", "173"),("68805", "2", "0", "85", "1", "25.630000000000", "174"),("68806", "2", "0", "85", "1", "25.470000000000", "175"),("236663", "1", "0", "85", "1", "48.840000000000", "176"),("236673", "1", "0", "85", "1", "48.840000000000", "177"),("132541", "2", "0", "105", "1", "24.000000000000", "178"),("67751", "2", "0", "85", "1", "16.010000000000", "179"),("134415", "2", "0", "606", "1", "18.530000000000", "180")

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

5 (0.135)

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.223)

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.135)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'