Всего выполнено запросов: 497 шт. за 0.3226 сек. Развернуть Закрыть

# Запрос номер 1: SET names utf8 (0.0001 msec ) /var/www/u0853520/data/www/soyuztime.ru/mg-core/lib/db.php (line 236)

# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0 msec ) /var/www/u0853520/data/www/soyuztime.ru/mg-core/lib/mg.php (line 0)

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0 msec ) /var/www/u0853520/data/www/soyuztime.ru/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT COUNT(DISTINCT p.id) AS count FROM `mg_product` p LEFT JOIN `mg_category` c ON c.id = p.cat_id LEFT JOIN `mg_product_variant` pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, round(SUM(IF(pv.count <0, 1000000, pv.count)),2) AS varcount FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE (p.id IN (1340, 1347, 1973, 1977, 2381, 2840, 2958, 3744, 4227, 4836, 4837, 17042, 17044, 17608, 17609, 17611, 17612, 17922, 17927, 92, 1958, 2758, 18312, 83, 86, 108, 180, 290, 291, 593, 643, 674, 1194, 1195, 1327, 1330, 1333, 1350, 1381, 1387, 1394, 1395, 1396, 1397, 1398, 1399, 1403, 1404, 1737, 1751, 1801, 1885, 1896, 1903, 1907, 1960, 2108, 2193, 2374, 2375, 2431, 2458, 2459, 2461, 2571, 2854, 2904, 2994, 3007, 3046, 3059, 3200, 3201, 3665, 3728, 3761, 3910, 3911, 4098, 4108, 4246, 4413, 4582, 4594, 4651, 4940, 5124, 6766, 6767, 6773, 6774, 7136, 7139, 7257, 7258, 7260, 7334, 12430, 12435, 13965, 14593, 14972, 16571, 16677, 16843, 16937, 16939, 16940, 16942, 17093, 17095, 17104, 17105, 17106, 17120, 17121, 17423, 17425, 17530, 17532, 17591, 17593, 17595, 17597, 17599, 17793, 17800, 17801, 17861, 17892, 17893, 17895, 17919, 17920, 17943, 17944, 17946, 18080, 18081, 18083, 18084, 18085, 18087, 18088, 18089, 18090, 18091, 18093, 18094, 18095, 18096, 18098, 18099, 18100, 18102, 18103, 18105, 18107, 18108, 18110, 18111, 18112, 18113, 18115, 18119, 18120, 18121, 18122, 18150, 18213, 18214, 18217, 18225, 18226, 18227, 18228, 18234, 18235, 18236, 18237, 18247, 18341, 18342, 18343, 3080, 3088, 344, 1291, 1747, 1825, 3124, 3978, 3980, 4041, 5071, 5072, 5074, 5075, 7330, 2803, 2804, 2809, 2812, 2814, 5044, 5045, 15208, 17914, 17915, 17916, 17918, 1242, 4713, 15027, 5270, 5557, 5560, 5574, 6120, 6122, 6543, 9021, 10039, 10045, 11139, 17929, 17993, 17999, 18002, 18033, 18035, 518)) AND OR (p.id NOT IN (1823, 4141)) AND ( ((p.price_course + p.price_course * (IFNULL(rate,0))) BETWEEN '1' AND '175568')OR ((pv.price_course + pv.price_course * (IFNULL(rate,0))) BETWEEN '1' AND '175568') ) AND ( 1=1 or FIND_IN_SET(0,p.`inside_cat`) ) AND p.id IN (7137,7136,7069,6925,6921,6794,6793,6792,6783,6782,6781,6780,6779,6775,6774,6773,6771,6767,6766,5134,5131,5129,5128,5127,5126,5125,5122,5121,5120,5116,5115,5100,5064,5063,5055,5051,5050,5048,5047,5043,5027,5022,5007,4999,4996,4993,4992,4986,4983,4982,4981,4967,4965,4964,4960,4956,4954,4953,4951,4950,4948,4947,4911,4904,4894,4885,4829,4807,4799,4727,4717,4674,4671,4669,4668,4666,4665,4664,4662,4661,4660,4659,4651,4618,4612,4610,4594,4585,4564,4443,4420,4413,4385,4372,4344,4343,4246,4227,4203,4202,4195,4194,4175,4154,4141,4108,4100,4093,4091,4071,4055,4052,3997,3996,3992,3981,3980,3978,3975,3974,3947,3941,3911,3910,3900,3898,3795,3792,3775,3774,3772,3751,3748,3744,3743,3730,3729,3728,3726,3725,3720,3714,3699,3698,3697,3690,3685,3684,3679,3667,3665,3664,3663,3570,3422,3323,3321,3313,3295,3201,3200,3125,3124,3083,3076,3056,3047,3046,3045,3044,3042,3027,3025,3022,3008,3007,3006,3002,3001,3000,2998,2997,2996,2958,2951,2925,2921,2917,2908,2907,2905,2904,2900,2894,2890,2889,2888,2872,2871,2870,2863,2854,2851,2850,2843,2840,2838,2817,2758,2757,2756,2755,2754,2753,2751,2749,2748,2747,2737,2735,2733,2683,2607,2595,2594,2580,2571,2567,2555,2532,2528,2516,2511,2505,2499,2484,2483,2481,2461,2459,2458,2454,2452,2439,2438,2437,2434,2433,2431,2430,2429,2423,2420,2417,2416,2413,2412,2379,2377,2375,2374,2373,2331,2329,2296,2295,2274,2271,2257,2255,2215,2193,2185,2111,2110,2108,2062,2061,2059,2056,2054,2040,1986,1984,1983,1968,1966,1965,1964,1961,1937,1935,1934,1933,1929,1921,1915,1914,1913,1907,1904,1903,1901,1898,1896,1887,1886,1885,1884,1881,1880,1879,1875,1825,1823,1821,1801,1796,1792,1788,1776,1775,1760,1752,1751,1749,1737,1733,1670,1668,1666,1646,1644,1640,1585,1570,1541,1505,1502,1500,1468,1457,1456,1453,1449,1444,1443,1430,1422,1420,1418,1417,1413,1409,1407,1405,1404,1403,1402,1397,1396,1395,1394,1387,1383,1382,1375,1334,1333,1331,1330,1329,1328,1327,1326,1325,1322,1321,1314,1313,1308,1300,1299,1295,1291,1286,1281,1275,1260,1259,1258,1257,1256,1255,1253,1248,1243,1238,1237,1236,1235,1234,1231,1226,1225,1224,1221,1220,1219,1217,1214,1204,1203,1199,1195,1120,1118,1115,1113,1112,1109,1103,1088,1083,1082,1075,1071,1070,1066,1065,1040,1039,1038,1030,1029,1019,1016,1015,1010,1007,989,988,983,971,968,966,961,960,898,892,788,787,786,774,773,738,728,727,726,725,721,719,718,716,715,705,674,672,669,658,645,644,643,641,640,639,636,632,624,611,606,605,604,603,601,600,599,593,581,518,513,504,499,497,496,495,493,435,422,404,301,297,290,286,282,280,276,268,266,262,247,246,245,241,239,238,237,236,224,220,206,197,196,176,167,153,140,116,108,105,102,100,86,85,84,83,82,76,75,74,62,61,35,28,25,20,17,15,4,3,1,7138,7139,7140,2994,7179,7167,7166,1008,737,7117,635,634,623,49,585,7184,7185,7168,1538,7170,771,7171,7174,7182,1551,7183,7192,7194,7197,7203,2049,1058,1072,1076,1087,3749,6836,3773,3776,1247,994,2767,7152,7153,7165,7157,1020,7158,7159,7163,7162,1018,7161,3721,4244,4006,1756,7254,1970,7256,1381,7257,7258,7259,2436,3057,7267,7279,702,4319,4320,267,279,137,2515,2506,2504,2497,2214,151,162,4905,4907,4909,2864,7285,1401,7277,7278,7280,7281,7284,7282,6933,6790,6789,7329,4097,4098,4107,179,180,7333,7334,7335,1052,2372,7336,3700,7368,7369,4897,2927,2928,4095,7283,1745,7371,7372,7381,1597,7376,7380,7388,7387,7396,7397,7398,7399,4352,7389,7385,7386,7766,7769,7768,7767,7770,7775,7776,7772,7784,7790,7791,7792,12302,11407,9514,12435,12438,12430,12476,12679,12685,12752,12683,12686,12687,12688,12689,8330,2609,12874,14593,14594,14124,13668,14994,14569,14570,12958,16922,16937,8595,16843,16942,16940,16938,16939,16941,16865,15277,16936,16153,13522,12750,16943,16944,16945,16946,14572,14571,16857,16856,16854,16950,16947,16972,16973,16974,16975,16976,16977,16978,16979,17013,10014,9259,8437,17025,17015,10249,10251,10252,9500,11151,17023,17022,17008,17009,17010,17014,17016,17017,17020,17021,8584,17045,17046,17086,17085,17083,17081,17060,17061,17062,17063,17067,17068,17069,17071,17070,17064,8438,17089,17088,17087,14798,16994,16995,16851,13528,17091,17092,17093,17094,17095,17096,17097,17098,17099,17118,17119,17120,17121,15860,17124,17125,17126,17129,17132,17133,17134,17135,17137,17138,17136,17139,17140,17141,17152,17153,17154,17155,17147,17148,17104,17157,17158,17159,17105,17106,17160,17161,17162,17163,17164,12637,17146,17166,17167,17168,17149,17209,17210,17151,17211,17212,1249,17247,16320,14799,17246,17248,14980,15256,14791,14541,16992,15949,14926,17266,17267,17259,17260,17261,17272,17273,17274,17275,17276,17277,17150,17263,17278,6798,17255,17256,17314,17311,17312,17315,17317,17318,17319,17320,17321,17322,17323,17324,17325,17326,17327,17328,17329,17330,17331,17332,17333,17334,17338,17339,17340,17368,11125,17369,17370,11153,17372,17360,7390,17364,17365,9014,17343,17344,17345,17346,17347,17110,17116,17113,17114,17111,17112,13764,17423,17425,17424,13007,17435,17428,17429,17436,17437,17438,17440,17448,13314,17497,17142,17510,16432,17530,17531,17532,17563,17562,17540,17561,17560,17541,17533,17542,17534,17559,17558,17557,17556,17555,17546,17547,17568,17566,17565,17564,17571,17572,17579,17591,17590,15257,17584,17527,15176,14821,17599,17597,16677,17598,17596,17595,17593,2752,17600,761,17604,17605,17607,17615,17616,17433,3722,17065,13239,2848,17594,17640,17641,2435,12377,17592,17638,4713,17367,2053,17685,17728,13315,17748,17770,17771,17796,17793,17799,17800,17801,17803,17812,17813,17815,17804,17814,17808,17811,17810,17861,13965,17892,2443,17902,17906,17908,17909,12778,17899,17910,17911,17912,17888,17920,17893,17894,17895,17919,17887,12858,12860,17896,17900,17897,17921,17931,17930,17932,17924,17898,17889,17884,17945,17946,17944,17943,17942,17764,17883,17934,17882,17439,17809,17570,17849,17846,16571,14433,13763,17984,17985,17986,17987,17923,15058,17996,17995,17997,17998,18006,18005,18004,18009,17979,291,18031,18015,18081,18082,18083,18084,18086,18087,18088,18053,18051,18059,18089,18090,18085,18091,18092,18093,18094,18095,18096,18097,18098,18099,18100,18120,18122,18113,18114,18115,18130,18124,18125,18126,18132,18133,18144,18146,18137,18138,18139,18140,18141,18142,18143,18149,18150,18151,18168,18169,17115,18174,18176,18175,18177,18171,7068,7260,18185,16698,18182,18183,18186,18188,18043,17262,18190,18198,18199,18200,18205,18208,12919,18213,18214,18236,18237,18234,18235,18225,18226,18227,18228,18229,18216,18215,18238,18239,12777,18223,18222,18230,12645,18221,18145,18147,18243,18244,18247,18217,18218,18248,18249,18245,18310,18311,18312,18319,18318,18320,18342,18341,18343,14972,18340,18359,18358,18382,18383,9821,10020,9341,18369,18412,18409,18411,18414,18420,18413,18415,18416,18410,18422,18423,18368,18129,18388,18378,18373,18377,18429,18392,18393,18394,18395) AND p.`activity` = 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR (p.id NOT IN (1823, 4141)) AND ( ((p.price_course + p.price_course * (IFNU' at line 12

/var/www/u0853520/data/www/soyuztime.ru/mg-core/models/catalog.php (line 423)

/var/www/u0853520/data/www/soyuztime.ru/mg-core/models/catalog.php (line 103)

/var/www/u0853520/data/www/soyuztime.ru/mg-core/controllers/catalog.php (line 176)

/var/www/u0853520/data/www/soyuztime.ru/mg-core/lib/moguta.php (line 0)

/var/www/u0853520/data/www/soyuztime.ru/mg-core/mg-start.php (line 0)

/var/www/u0853520/data/www/soyuztime.ru/mg-core/index-start.php (line 126)

/var/www/u0853520/data/www/soyuztime.ru/index.php (line 4)