Căutare

Queries: 31, Total time: 6.939 ms [By time] [By id] [By file]

1 (0.093)

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

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.160)

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

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("99951", "2", "1000", "176", "1", "16.810000000000", "1"),("99958", "2", "1000", "176", "1", "16.810000000000", "2"),("175458", "1", "1000", "117", "1", "49.580000000000", "3"),("177196", "2", "1000", "117", "1", "49.580000000000", "4"),("177192", "2", "1000", "117", "1", "47.900000000000", "5"),("171078", "2", "1000", "331", "1", "58.820000000000", "6"),("171079", "2", "1000", "331", "1", "58.820000000000", "7"),("171080", "2", "1000", "331", "1", "58.820000000000", "8"),("171081", "2", "1000", "331", "1", "58.820000000000", "9"),("171083", "2", "1000", "331", "1", "58.820000000000", "10"),("197915", "1", "1000", "331", "1", "92.440000000000", "11"),("197921", "1", "1000", "331", "1", "92.440000000000", "12"),("197923", "1", "1000", "331", "1", "92.440000000000", "13"),("197925", "1", "1000", "331", "1", "92.440000000000", "14"),("197957", "1", "1000", "331", "1", "58.820000000000", "15"),("197963", "1", "1000", "331", "1", "58.820000000000", "16"),("171082", "2", "1000", "331", "1", "58.820000000000", "17"),("197961", "1", "1000", "331", "1", "58.820000000000", "18"),("234878", "1", "1000", "331", "1", "54.620000000000", "19"),("234879", "1", "1000", "331", "1", "54.620000000000", "20"),("234880", "1", "1000", "331", "1", "54.620000000000", "21"),("234881", "1", "1000", "331", "1", "54.620000000000", "22"),("234882", "1", "1000", "331", "1", "54.620000000000", "23"),("234883", "1", "1000", "331", "1", "54.620000000000", "24"),("234884", "1", "1000", "331", "1", "54.620000000000", "25"),("234885", "1", "1000", "331", "1", "54.620000000000", "26"),("234886", "1", "1000", "331", "1", "54.620000000000", "27"),("234887", "1", "1000", "331", "1", "54.620000000000", "28"),("234888", "1", "1000", "331", "1", "54.620000000000", "29"),("234889", "1", "1000", "331", "1", "54.620000000000", "30"),("197917", "1", "1000", "331", "1", "92.440000000000", "31"),("197919", "1", "1000", "331", "1", "92.440000000000", "32"),("197931", "2", "1000", "331", "1", "54.620000000000", "33"),("197933", "2", "1000", "331", "1", "54.620000000000", "34"),("197939", "2", "1000", "331", "1", "54.620000000000", "35"),("197959", "1", "1000", "331", "1", "58.820000000000", "36"),("197965", "1", "1000", "331", "1", "58.820000000000", "37"),("197967", "1", "1000", "331", "1", "58.820000000000", "38"),("197969", "1", "1000", "331", "1", "58.820000000000", "39"),("133501", "2", "1000", "331", "1", "38.320000000000", "40"),("197929", "2", "1000", "331", "1", "54.620000000000", "41"),("197935", "2", "1000", "331", "1", "54.620000000000", "42"),("197937", "2", "1000", "331", "1", "54.620000000000", "43"),("195071", "2", "1000", "331", "1", "92.440000000000", "44"),("195073", "2", "1000", "331", "1", "92.440000000000", "45"),("195075", "2", "1000", "331", "1", "92.440000000000", "46"),("195365", "1", "1000", "331", "1", "58.820000000000", "47"),("133469", "2", "1", "331", "1", "37.820000000000", "48"),("133461", "2", "1000", "331", "1", "37.820000000000", "49"),("195077", "2", "1000", "331", "1", "92.440000000000", "50"),("195081", "2", "1000", "331", "1", "92.440000000000", "51"),("195363", "1", "1000", "331", "1", "58.820000000000", "52"),("47411", "2", "1000", "331", "1", "67.640000000000", "53"),("195357", "1", "1000", "331", "1", "58.820000000000", "54"),("195359", "1", "1000", "331", "1", "58.820000000000", "55"),("47406", "2", "1001", "331", "1", "67.230000000000", "56"),("47404", "2", "1000", "331", "1", "42.350000000000", "57"),("47408", "2", "1000", "331", "1", "42.350000000000", "58"),("47410", "2", "1000", "331", "1", "67.230000000000", "59"),("42989", "2", "2", "331", "1", "52.520000000000", "60"),("130149", "2", "1000", "331", "1", "57.980000000000", "61"),("130151", "2", "1000", "331", "1", "57.980000000000", "62"),("130169", "2", "1000", "331", "1", "54.620000000000", "63"),("130171", "2", "1000", "331", "1", "54.620000000000", "64"),("130167", "2", "1000", "331", "1", "54.620000000000", "65"),("142291", "2", "1000", "331", "1", "47.060000000000", "66"),("142665", "2", "1000", "331", "1", "54.620000000000", "67"),("173241", "1", "1000", "331", "1", "58.820000000000", "68"),("142679", "2", "1000", "331", "1", "54.620000000000", "69"),("173222", "1", "1000", "331", "1", "58.820000000000", "70"),("142675", "2", "1000", "331", "1", "54.620000000000", "71"),("142677", "2", "1000", "331", "1", "54.620000000000", "72"),("173230", "1", "1", "331", "1", "58.820000000000", "73"),("173232", "1", "1001", "331", "1", "58.820000000000", "74"),("173239", "1", "1000", "331", "1", "58.820000000000", "75"),("173242", "1", "1000", "331", "1", "58.820000000000", "76"),("173243", "1", "1000", "331", "1", "58.820000000000", "77"),("173245", "1", "1000", "331", "1", "58.820000000000", "78"),("173246", "1", "1000", "331", "1", "58.820000000000", "79"),("148703", "2", "1000", "331", "1", "37.820000000000", "80"),("148713", "2", "1000", "331", "1", "37.820000000000", "81"),("173224", "1", "1000", "331", "1", "58.820000000000", "82"),("173238", "1", "1000", "331", "1", "58.820000000000", "83"),("148697", "2", "1000", "331", "1", "37.820000000000", "84"),("148701", "2", "1000", "331", "1", "37.820000000000", "85"),("148707", "2", "1000", "331", "1", "37.820000000000", "86"),("148709", "2", "1000", "331", "1", "37.820000000000", "87"),("142669", "2", "1000", "331", "1", "54.620000000000", "88"),("142671", "2", "1000", "331", "1", "54.620000000000", "89"),("141531", "2", "1000", "331", "1", "56.300000000000", "90"),("126993", "2", "1000", "583", "1", "50.420000000000", "91"),("229288", "2", "1000", "583", "1", "52.100000000000", "92"),("200879", "2", "1000", "583", "1", "54.620000000000", "93"),("207775", "1", "1000", "117", "1", "66.390000000000", "94"),("228800", "2", "1000", "583", "1", "67.230000000000", "95"),("224226", "1", "1000", "337", "1", "47.900000000000", "96"),("224327", "2", "1000", "337", "1", "36.130000000000", "97"),("137263", "2", "1000", "296", "1", "32.770000000000", "98"),("137279", "2", "1000", "296", "1", "32.770000000000", "99"),("4360", "2", "1003", "98", "1", "46.970000000000", "100"),("19518", "2", "1000", "42", "1", "5.290000000000", "101"),("56337", "2", "1", "222", "1", "8.140000000000", "102"),("19366", "2", "1002", "42", "1", "6.720000000000", "103"),("19372", "2", "1001", "42", "1", "9.660000000000", "104"),("19368", "2", "1000", "42", "1", "8.400000000000", "105"),("79698", "2", "1000", "42", "1", "66.390000000000", "106"),("79708", "2", "1000", "42", "1", "75.630000000000", "107"),("19380", "2", "1000", "42", "1", "13.450000000000", "108"),("19376", "2", "2", "42", "1", "10.500000000000", "109"),("37458", "2", "1010", "160", "1", "39.010000000000", "110"),("19398", "2", "2", "42", "1", "9.660000000000", "111"),("18960", "2", "1", "42", "1", "12.610000000000", "112"),("19392", "2", "1", "42", "1", "7.140000000000", "113"),("52141", "2", "1000", "115", "1", "33.702400000000", "114"),("229907", "2", "1000", "42", "1", "21.010000000000", "115"),("240598", "2", "1000", "163", "1", "23.730000000000", "116"),("240600", "2", "1000", "163", "1", "30.950000000000", "117"),("240601", "2", "1000", "163", "1", "34.050000000000", "118"),("161821", "2", "1000", "589", "1", "57.536000000000", "119"),("240599", "2", "1000", "163", "1", "27.860000000000", "120"),("147319", "2", "1003", "178", "1", "41.100800000000", "121"),("26954", "2", "1000", "178", "1", "15.270400000000", "122"),("147321", "2", "1000", "178", "1", "41.100800000000", "123"),("106248", "1", "1002", "75", "1", "50.496000000000", "124"),("179584", "1", "1000", "178", "1", "41.180000000000", "125"),("240203", "1", "1000", "162", "1", "39.380000000000", "126"),("179587", "1", "1000", "178", "1", "92.774400000000", "127"),("222237", "2", "5", "342", "1", "29.363200000000", "128"),("226", "2", "1006", "19", "1", "19.000000000000", "129"),("137375", "2", "1002", "296", "1", "33.610000000000", "130"),("231542", "-100", "1001", "570", "1", "105.000000000000", "131"),("97424", "2", "1000", "160", "1", "15.580000000000", "132"),("243153", "2", "1000", "162", "1", "50.380000000000", "133"),("243278", "1", "1000", "162", "1", "71.390000000000", "134"),("67119", "2", "3", "141", "1", "45.798400000000", "135"),("228", "2", "1028", "19", "1", "20.170000000000", "136"),("229", "2", "1024", "19", "1", "20.170000000000", "137"),("227", "2", "1020", "19", "1", "20.170000000000", "138"),("222365", "1", "1005", "370", "1", "11.430000000000", "139"),("222366", "1", "1004", "370", "1", "11.430000000000", "140"),("17857", "2", "1001", "42", "1", "52.100000000000", "141"),("47935", "2", "1000", "75", "1", "25.830400000000", "142"),("137349", "2", "1000", "296", "1", "25.210000000000", "143"),("243045", "1", "1000", "162", "1", "25.170000000000", "144"),("101523", "1", "1000", "42", "1", "26.890000000000", "145"),("122735", "2", "1", "358", "1", "94.500000000000", "146"),("91374", "2", "1000", "167", "1", "15.270400000000", "147"),("233611", "1", "1000", "122", "1", "1063.030000000000", "148"),("233613", "1", "1000", "122", "1", "1063.030000000000", "149"),("233614", "1", "1000", "122", "1", "1063.030000000000", "150"),("239427", "2", "1000", "122", "1", "30.250000000000", "151"),("174643", "1", "1000", "487", "1", "18.490000000000", "152"),("162221", "2", "1000", "354", "1", "29.363200000000", "153"),("208347", "2", "5", "141", "1", "28.185600000000", "154"),("208345", "2", "3", "141", "1", "28.185600000000", "155"),("63955", "2", "1002", "178", "1", "45.798400000000", "156"),("243280", "1", "1000", "162", "1", "71.390000000000", "157"),("116188", "2", "1005", "178", "1", "34.060800000000", "158"),("244078", "1", "1000", "11", "1", "353.390000000000", "159"),("166693", "1", "1047", "357", "1", "9.450000000000", "160"),("166688", "1", "1033", "357", "1", "9.450000000000", "161"),("166692", "1", "1022", "357", "1", "9.450000000000", "162"),("166691", "1", "1021", "357", "1", "9.450000000000", "163"),("166690", "1", "1014", "357", "1", "9.450000000000", "164"),("100331", "1", "1000", "73", "1", "155.970000000000", "165"),("178799", "2", "1", "672", "1", "82.100000000000", "166"),("133453", "2", "0", "331", "1", "29.200000000000", "167"),("234890", "1", "0", "331", "1", "54.620000000000", "168"),("234891", "1", "0", "331", "1", "54.620000000000", "169"),("234892", "1", "0", "331", "1", "54.620000000000", "170"),("234893", "1", "0", "331", "1", "54.620000000000", "171"),("197951", "2", "0", "331", "1", "40.000000000000", "172"),("197953", "2", "0", "331", "1", "40.000000000000", "173"),("197945", "2", "0", "331", "1", "40.000000000000", "174"),("197947", "2", "0", "331", "1", "40.000000000000", "175"),("197949", "2", "0", "331", "1", "40.000000000000", "176"),("195079", "2", "0", "331", "1", "55.000000000000", "177"),("42993", "2", "0", "331", "1", "29.200000000000", "178"),("47409", "2", "0", "331", "1", "40.400000000000", "179"),("130153", "2", "0", "331", "1", "45.380000000000", "180"),("130155", "2", "0", "331", "1", "45.380000000000", "181"),("130163", "2", "0", "331", "1", "45.380000000000", "182"),("173233", "1", "0", "331", "1", "58.820000000000", "183"),("173225", "1", "0", "331", "1", "58.820000000000", "184"),("148693", "2", "0", "331", "1", "29.200000000000", "185"),("148705", "2", "0", "331", "1", "29.200000000000", "186"),("229616", "1", "0", "331", "1", "67.230000000000", "187"),("229617", "1", "0", "331", "1", "67.230000000000", "188"),("229618", "1", "0", "331", "1", "67.230000000000", "189"),("229619", "1", "0", "331", "1", "67.230000000000", "190"),("229620", "1", "0", "331", "1", "67.230000000000", "191"),("229621", "1", "0", "331", "1", "67.230000000000", "192"),("229622", "1", "0", "331", "1", "67.230000000000", "193"),("30581", "2", "0", "117", "1", "29.000000000000", "194"),("126987", "2", "0", "583", "1", "52.000000000000", "195"),("200911", "2", "0", "583", "1", "60.500000000000", "196"),("160559", "2", "0", "583", "1", "35.000000000000", "197"),("134821", "1", "0", "117", "1", "41.000000000000", "198"),("174991", "-100", "0", "570", "1", "747.300000000000", "199"),("19357", "2", "0", "42", "1", "1.700000000000", "200"),("19342", "2", "0", "42", "1", "5.500000000000", "201"),("19346", "2", "0", "42", "1", "6.600000000000", "202"),("19394", "2", "0", "42", "1", "6.500000000000", "203"),("19402", "2", "0", "42", "1", "8.200000000000", "204"),("229720", "2", "0", "463", "1", "23.731200000000", "205"),("229716", "2", "0", "463", "1", "23.731200000000", "206"),("230409", "2", "0", "463", "1", "23.731200000000", "207"),("230419", "2", "0", "463", "1", "23.731200000000", "208"),("165009", "2", "0", "463", "1", "73.932800000000", "209"),("120175", "-100", "0", "570", "1", "2800.000000000000", "210"),("120176", "2", "0", "570", "1", "2951.000000000000", "211"),("152565", "-100", "0", "570", "1", "2644.429900000000", "212"),("230420", "2", "0", "463", "1", "23.731200000000", "213"),("152559", "-100", "0", "570", "1", "2115.010000000000", "214"),("19252", "2", "0", "42", "1", "7.500000000000", "215"),("19257", "2", "0", "42", "1", "8.200000000000", "216"),("103511", "1", "0", "185", "1", "34.000000000000", "217"),("152557", "-100", "0", "570", "1", "1972.080000000000", "218"),("152563", "-100", "0", "570", "1", "2369.120100000000", "219"),("152567", "-100", "0", "570", "1", "2927.169900000000", "220"),("152569", "-100", "0", "570", "1", "3094.429900000000", "221"),("125579", "-100", "0", "570", "1", "2436.890000000000", "222"),("67777", "2", "0", "73", "1", "149.660000000000", "223")

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

5 (0.171)

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

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

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