Căutare

Queries: 28, Total time: 5.702 ms [By time] [By id] [By file]

1 (0.159)

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

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

2 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.168)

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

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("143053", "2", "1001", "17", "1", "150.420000000000", "1"),("143051", "2", "1000", "17", "1", "113.450000000000", "2"),("119993", "2", "8", "17", "1", "125.210000000000", "3"),("143049", "2", "1000", "17", "1", "135.380000000000", "4"),("36531", "2", "1004", "17", "1", "211.010000000000", "5"),("147861", "2", "1000", "17", "1", "211.010000000000", "6"),("64", "2", "1", "17", "1", "203.360000000000", "7"),("112712", "2", "1000", "17", "1", "127.730000000000", "8"),("239590", "1", "1000", "17", "1", "276.470000000000", "9"),("239587", "1", "1000", "17", "1", "242.860000000000", "10"),("239588", "1", "1000", "17", "1", "259.660000000000", "11"),("239589", "1", "1000", "17", "1", "276.470000000000", "12"),("131189", "2", "0", "17", "1", "125.210000000000", "13"),("90755", "2", "0", "17", "1", "174.000000000000", "14"),("63", "2", "0", "17", "1", "159.660000000000", "15"),("143055", "2", "0", "17", "1", "147.060000000000", "16"),("143057", "2", "0", "17", "1", "165.000000000000", "17"),("147859", "2", "0", "17", "1", "174.000000000000", "18"),("36514", "2", "0", "17", "1", "151.200000000000", "19"),("239591", "1", "0", "17", "1", "335.290000000000", "20"),("239592", "1", "0", "17", "1", "343.700000000000", "21"),("180523", "1", "1000", "682", "1", "210.840000000000", "22"),("180525", "1", "1000", "682", "1", "236.050000000000", "23"),("233768", "1", "1000", "357", "1", "16.080000000000", "24"),("179655", "1", "1000", "677", "1", "41.090000000000", "25"),("91663", "2", "1000", "115", "1", "45.290000000000", "26"),("91672", "2", "1000", "115", "1", "53.700000000000", "27"),("151729", "2", "1000", "364", "1", "110.000000000000", "28"),("223256", "2", "1001", "768", "1", "83.950000000000", "29"),("15073", "2", "1000", "115", "1", "51.930000000000", "30"),("52967", "2", "1000", "115", "1", "27.820000000000", "31"),("79958", "4", "8", "13", "1", "201.600000000000", "32"),("110902", "-100", "12", "26", "1", "17.497600000000", "33"),("5920", "2", "1001", "42", "1", "107.560000000000", "34"),("215761", "2", "1000", "656", "1", "32.710000000000", "35"),("175784", "2", "1000", "124", "1", "131.930000000000", "36"),("166161", "2", "1", "59", "1", "218.400000000000", "37"),("239868", "1", "10", "802", "1", "27.942400000000", "38"),("239867", "1", "4", "802", "1", "109.568000000000", "39"),("166173", "2", "4", "59", "1", "126.990000000000", "40"),("86399", "2", "13", "28", "1", "15.270400000000", "41"),("47192", "2", "4", "28", "1", "15.270400000000", "42"),("211279", "1", "1002", "224", "1", "21.760000000000", "43"),("92480", "2", "1000", "278", "1", "24.409600000000", "44"),("211273", "1", "1000", "224", "1", "21.760000000000", "45"),("211275", "1", "1000", "224", "1", "21.760000000000", "46"),("211277", "1", "1000", "224", "1", "21.760000000000", "47"),("211281", "1", "1000", "224", "1", "21.760000000000", "48"),("211283", "1", "1000", "224", "1", "21.760000000000", "49"),("211285", "1", "1000", "224", "1", "21.760000000000", "50"),("211287", "1", "1000", "224", "1", "21.760000000000", "51"),("211289", "1", "1000", "224", "1", "21.760000000000", "52"),("211291", "1", "1000", "224", "1", "21.760000000000", "53"),("211293", "1", "1000", "224", "1", "21.760000000000", "54"),("100132", "1", "27", "28", "1", "25.830400000000", "55"),("2951", "2", "14", "28", "1", "22.310400000000", "56"),("100177", "1", "11", "28", "1", "21.132800000000", "57"),("244018", "1", "5", "802", "1", "23.488000000000", "58"),("128429", "2", "1000", "85", "1", "131.090000000000", "59"),("42973", "2", "1000", "163", "1", "85.390000000000", "60"),("247226", "1", "1000", "285", "1", "16.550000000000", "61"),("68613", "4", "1016", "30", "1", "14.796800000000", "62"),("66657", "2", "1008", "30", "1", "16.320000000000", "63"),("57179", "2", "1000", "30", "1", "15.270400000000", "64"),("211261", "1", "1000", "224", "1", "32.690000000000", "65"),("211263", "1", "1000", "224", "1", "32.690000000000", "66"),("211295", "1", "1000", "224", "1", "21.760000000000", "67"),("211297", "1", "1000", "224", "1", "32.690000000000", "68"),("10829", "2", "1000", "30", "1", "31.705600000000", "69"),("100127", "1", "33", "28", "1", "22.310400000000", "70"),("86318", "2", "15", "28", "1", "28.185600000000", "71"),("243798", "1", "13", "802", "1", "14.092800000000", "72"),("100299", "1", "5", "28", "1", "29.363200000000", "73"),("128427", "2", "2", "85", "1", "151.800000000000", "74"),("68606", "2", "1005", "30", "1", "13.504000000000", "75"),("61345", "2", "1002", "30", "1", "18.086400000000", "76"),("209283", "1", "1002", "654", "1", "11.680000000000", "77"),("68611", "2", "1000", "30", "1", "24.537600000000", "78"),("211265", "1", "1000", "224", "1", "27.650000000000", "79"),("211267", "1", "1000", "224", "1", "27.650000000000", "80"),("211269", "1", "1000", "224", "1", "27.650000000000", "81"),("211271", "1", "1000", "224", "1", "27.650000000000", "82"),("68612", "2", "1000", "30", "1", "24.537600000000", "83"),("94943", "2", "1000", "516", "1", "23.030000000000", "84"),("200419", "1", "9", "28", "1", "52.838400000000", "85"),("118041", "1", "3", "28", "1", "34.060800000000", "86"),("173941", "1", "2", "28", "1", "25.830400000000", "87"),("173973", "1", "2", "28", "1", "25.830400000000", "88"),("173930", "1", "6", "28", "1", "25.830400000000", "89"),("119684", "1", "1000", "30", "1", "19.840000000000", "90"),("47514", "2", "7", "342", "1", "52.838400000000", "91"),("200415", "1", "7", "28", "1", "34.060800000000", "92"),("173794", "2", "1", "28", "1", "30.528000000000", "93"),("59424", "2", "1", "342", "1", "49.318400000000", "94"),("118055", "2", "1", "28", "1", "16.204800000000", "95"),("68866", "4", "1007", "30", "1", "17.612800000000", "96"),("237738", "1", "1001", "30", "1", "36.288000000000", "97"),("162205", "1", "1000", "354", "1", "29.235200000000", "98"),("162207", "1", "1000", "354", "1", "24.537600000000", "99"),("237728", "1", "1000", "30", "1", "36.288000000000", "100"),("149255", "1", "65", "625", "1", "31.705600000000", "101"),("149257", "1", "22", "625", "1", "31.705600000000", "102"),("200401", "1", "17", "28", "1", "21.132800000000", "103"),("237397", "1", "9", "28", "1", "16.435200000000", "104"),("200367", "1", "8", "28", "1", "35.225600000000", "105"),("49658", "2", "6", "342", "1", "29.363200000000", "106"),("174024", "1", "6", "28", "1", "25.830400000000", "107"),("173980", "1", "3", "28", "1", "30.528000000000", "108"),("222233", "2", "2", "342", "1", "27.008000000000", "109"),("49942", "10", "1000", "372", "1", "115.760000000000", "110"),("47513", "2", "9", "342", "1", "55.193600000000", "111"),("174007", "1", "6", "28", "1", "25.830400000000", "112"),("174033", "1", "3", "28", "1", "37.580800000000", "113"),("100570", "1", "1000", "545", "1", "2151.030000000000", "114"),("49961", "10", "1000", "268", "1", "213.710000000000", "115"),("179156", "2", "1000", "354", "1", "75.033600000000", "116"),("5124", "2", "17", "69", "1", "21.132800000000", "117"),("49352", "2", "7", "342", "1", "22.310400000000", "118"),("70571", "10", "1000", "222", "1", "1242.760000000000", "119"),("70600", "10", "1000", "261", "1", "213.710000000000", "120"),("22152", "2", "1000", "17", "1", "79.130000000000", "121"),("110811", "10", "1000", "557", "1", "420.630000000000", "122"),("183327", "10", "1000", "703", "1", "403.120000000000", "123"),("22183", "2", "1000", "17", "1", "81.640000000000", "124"),("95742", "10", "1000", "261", "1", "314.880000000000", "125"),("70492", "10", "1000", "445", "1", "172.820000000000", "126"),("110812", "10", "1000", "557", "1", "509.980000000000", "127"),("110815", "10", "1000", "557", "1", "540.730000000000", "128"),("114379", "2", "1000", "190", "1", "5.290000000000", "129"),("81000", "10", "1000", "445", "1", "128.970000000000", "130"),("70599", "10", "1000", "261", "1", "213.710000000000", "131"),("110809", "10", "1000", "557", "1", "342.450000000000", "132"),("110813", "10", "1000", "557", "1", "342.450000000000", "133"),("110814", "10", "1000", "557", "1", "420.630000000000", "134"),("179797", "1", "1000", "290", "1", "588.150000000000", "135"),("81005", "10", "1000", "445", "1", "132.340000000000", "136"),("92117", "10", "1000", "445", "1", "179.570000000000", "137"),("110806", "10", "1000", "445", "1", "296.730000000000", "138"),("110807", "10", "1000", "445", "1", "312.630000000000", "139"),("115486", "10", "1000", "557", "1", "420.630000000000", "140"),("180389", "2", "1000", "682", "1", "164.620000000000", "141"),("166988", "1", "7", "280", "1", "45.290000000000", "142"),("237958", "1", "1000", "13", "1", "29.550000000000", "143"),("121271", "1", "1000", "13", "1", "177.230000000000", "144"),("178791", "2", "1", "672", "1", "160.760000000000", "145"),("179523", "2", "1", "672", "1", "105.130000000000", "146"),("179526", "2", "1", "672", "1", "258.400000000000", "147"),("93859", "2", "0", "467", "1", "152.590000000000", "148"),("193049", "1", "0", "238", "1", "2339.300000000000", "149"),("215759", "2", "0", "656", "1", "32.710000000000", "150"),("100145", "1", "0", "28", "1", "4.697600000000", "151"),("183425", "1", "0", "17", "1", "500.000000000000", "152"),("65873", "2", "0", "28", "1", "12.531200000000", "153"),("173954", "1", "0", "28", "1", "25.830400000000", "154"),("173969", "1", "0", "28", "1", "17.228800000000", "155"),("201393", "1", "0", "28", "1", "31.705600000000", "156"),("236009", "2", "0", "654", "1", "16.819200000000", "157"),("224057", "1", "0", "13", "1", "9.600000000000", "158"),("47530", "2", "0", "342", "1", "21.132800000000", "159"),("2426", "2", "0", "45", "1", "4.600000000000", "160"),("33967", "2", "0", "60", "1", "9.932800000000", "161"),("229581", "2", "0", "342", "1", "34.060800000000", "162"),("39145", "10", "0", "238", "1", "826.200000000000", "163"),("178441", "1", "0", "487", "1", "15.360000000000", "164"),("178442", "1", "0", "487", "1", "14.080000000000", "165"),("49959", "10", "0", "222", "1", "174.000000000000", "166"),("22261", "2", "0", "17", "1", "69.560000000000", "167"),("47512", "2", "0", "342", "1", "17.612800000000", "168"),("110817", "10", "0", "557", "1", "407.660000000000", "169"),("80999", "10", "0", "445", "1", "99.410000000000", "170"),("92116", "10", "0", "445", "1", "156.650000000000", "171"),("149797", "10", "0", "557", "1", "943.740000000000", "172"),("149795", "10", "0", "557", "1", "1083.319900000000", "173"),("159319", "10", "0", "557", "1", "1090.450000000000", "174"),("104465", "1", "0", "13", "1", "80.000000000000", "175"),("190707", "1", "0", "13", "1", "131.090000000000", "176")

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

5 (0.182)

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

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

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