Тормозит запрос в модуле, но не тормозит в консоле запросов #764700

Запрос к регистру бухгалтерии выполняется около 180 секунд при вызове из модуля. Он же формируется моментально в консоле запросов. Подскажите куда думать? Текст запроса: ВЫБРАТЬ     ВЫБОР         КОГДА Остатки.КоличествоОстатокДт ЕСТЬ NULL     ВЫБОР         КОГДА Остатки.КоличествоОстатокДт ЕСТЬ NULL     ВЫБОР         КОГДА Остатки.СуммаОстатокДт ЕСТЬ NULL                 ИЛИ СтруктурноеПодразделение ЕСТЬ NULL )                 И Субконто1 В (&Номенклатура)                 И Субконто2 В (&Склады)

подразлерие из нулл убрать

Не понятно зачем ЕСТЬ NULL, так же зачем Выбор когда. А так смотри план запроса

а СКД что скажет?

Запрос типовой, сейчас попробую.

Подскажите как посмотреть план запроса, база файловая.

А смысл в СКД еще проверять?

убрать NULL не помогло.

Параметры отличаются

есть другой смысл - копай.

Параметры в консоле запросов и в модуле приводил к одному виду. Дело не в параметрах.

параметр &МоментКон идентичен что в консоле, что в модуле?

ну как не в параметрах: если у вас тут (СтруктурноеПодразделение В (&ФильтрПодразделения)                 ИЛИ СтруктурноеПодразделение ЕСТЬ NULL ) ФильтрПодразделения = Истина, запрос отработает намного быстрее, т.к эту конструкцию ИЛИ СтруктурноеПодразделение оптимизатор откинет и ее вообще не будет в реальном запросе

Подсовывал в запрос, тот что в модуле, вместо момента времени дату. Так-же убрал условие "ИЛИ СтруктурноеПодразделение ЕСТЬ NULL" Результата нет.

Получил план запроса. Вот результат: [CODE] exec sp_executesql N'SELECT T1.AccountRRef, T1.Value1_TYPE, T1.Value1_RTRef, T1.Value1_RRRef, 0x01, T1.Fld377RRef, T1.Fld379RRef, CASE WHEN T1.Fld382BalanceDt_ IS NULL THEN 0.0 ELSE T1.Fld382BalanceDt_ END, CASE WHEN T1.Fld382BalanceDt_ IS NULL THEN 0.0 ELSE T1.Fld382BalanceDt_ END, CASE WHEN T1.Fld380BalanceDt_ IS NULL THEN 0.0 ELSE T1.Fld380BalanceDt_ END FROM (SELECT T2.Fld377RRef AS Fld377RRef, T2.AccountRRef AS AccountRRef, T2.Value1_TYPE AS Value1_TYPE, T2.Value1_RTRef AS Value1_RTRef, T2.Value1_RRRef AS Value1_RRRef, T2.Fld379RRef AS Fld379RRef, CASE WHEN CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 WHEN MAX(T11._Kind) = 0.0 OR MAX(T11._Kind) = 2.0 AND CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) > 0.0 THEN CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) ELSE 0.0 END AS Fld380BalanceDt_, CASE WHEN CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) IS NULL THEN 0.0 WHEN MAX(T11._Kind) = 0.0 OR MAX(T11._Kind) = 2.0 AND CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) > 0.0 THEN CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) ELSE 0.0 END AS Fld382BalanceDt_, T3._Fld377RRef AS Fld377RRef, T3._AccountRRef AS AccountRRef, T3._Value1_TYPE AS Value1_TYPE, T3._Value1_RTRef AS Value1_RTRef, T3._Value1_RRRef AS Value1_RRRef, T3._Fld379RRef AS Fld379RRef, T3._Fld380 AS Fld380Balance_, T3._Fld382 AS Fld382Balance_ FROM dbo._AccRgAT2401 T3 WITH(SERIALIZABLE) INNER JOIN #tt3 T4 WITH(NOLOCK) ON T4._IDRRef = T3._AccountRRef AND T4._LineNo1 = AND T4._LineNo2 = @P2 AND T4._Cnt = @P3 WHERE ((((((T3._Fld379RRef IN (@P4))) AND (T3._Value1_TYPE = 0x08 AND T3._Value1_RTRef = 0x0000003B AND T3._Value1_RRRef IN (@P5, @P6, @P7, @P8, @P9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, @P20, @P21, @P22, @P23, @P24, @P25, @P26, @P27, @P28, @P29, @P30, @P31, @P32, @P33, @P34, @P35, @P36, @P37, @P38, @P39, @P40, @P41, @P42, @P43, @P44, @P45, @P46, @P47, @P48, @P49, @P50, @P51))) AND (T3._Value2_TYPE = 0x08 AND T3._Value2_RTRef = 0x0000004A AND T3._Value2_RRRef IN (@P52))) AND (T3._Fld377RRef IN (@P53)))) AND T3._Period = @P54 AND (T3._Fld380 <> @P55 OR T3._Fld382 <> @P56) UNION ALL SELECT T5._Fld377RRef AS Fld377RRef, T5._AccountDtRRef AS AccountRRef, T6._Value_TYPE AS Value1_TYPE, T6._Value_RTRef AS Value1_RTRef, T6._Value_RRRef AS Value1_RRRef, T5._Fld379DtRRef AS Fld379RRef, CAST(-T5._Fld380 AS NUMERIC(21, 2)) AS Fld380Balance_, CAST(-T5._Fld382Dt AS NUMERIC(21, 3)) AS Fld382Balance_ FROM dbo._AccRg376 T5 WITH(SERIALIZABLE) INNER JOIN dbo._AccRgED404 T6 WITH(SERIALIZABLE) ON T6._RecorderTRef = T5._RecorderTRef AND T6._RecorderRRef = T5._RecorderRRef AND T6._LineNo = T5._LineNo AND T6._Period = T5._Period AND T6._Correspond = @P57 AND T6._KindRRef = @P58 AND (T6._Period > @P59 OR T6._Period = @P60 AND (T6._RecorderTRef > 0x00001D2B OR T6._RecorderTRef = 0x00001D2B AND T6._RecorderRRef >= @P61)) AND T6._Period < @P62 INNER JOIN dbo._AccRgED404 T7 WITH(SERIALIZABLE) ON T7._RecorderTRef = T5._RecorderTRef AND T7._RecorderRRef = T5._RecorderRRef AND T7._LineNo = T5._LineNo AND T7._Period = T5._Period AND T7._Correspond = @P63 AND T7._KindRRef = @P64 AND (T7._Period > @P65 OR T7._Period = @P66 AND (T7._RecorderTRef > 0x00001D2B OR T7._RecorderTRef = 0x00001D2B AND T7._RecorderRRef >= @P67)) AND T7._Period < @P68 WHERE T5._Active = 0x01 AND ((T5._AccountDtRRef IN (@P69))) AND ((((((T5._Fld379DtRRef IN (@P70))) AND (T6._Value_TYPE = 0x08 AND T6._Value_RTRef = 0x0000003B AND T6._Value_RRRef IN (@P71, @P72, @P73, @P74, @P75, @P76, @P77, @P78, @P79, @P80, @P81, @P82, @P83, @P84, @P85, @P86, @P87, @P88, @P89, @P90, @P91, @P92, @P93, @P94, @P95, @P96, @P97, @P98, @P99, 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17))) AND (T7._Value_TYPE = 0x08 AND T7._Value_RTRef = 0x0000004A AND T7._Value_RRRef IN (18))) AND (T5._Fld377RRef IN (19)))) AND (T5._Period > 20 OR T5._Period = 21 AND (T5._RecorderTRef > 0x00001D2B OR T5._RecorderTRef = 0x00001D2B AND T5._RecorderRRef >= 22)) AND T5._Period < 23 UNION ALL SELECT T8._Fld377RRef AS Fld377RRef, T8._AccountCtRRef AS AccountRRef, T9._Value_TYPE AS Value1_TYPE, T9._Value_RTRef AS Value1_RTRef, T9._Value_RRRef AS Value1_RRRef, T8._Fld379CtRRef AS Fld379RRef, CAST(T8._Fld380 AS NUMERIC(21, 2)) AS Fld380Balance_, CAST(T8._Fld382Ct AS NUMERIC(21, 3)) AS Fld382Balance_ FROM dbo._AccRg376 T8 WITH(SERIALIZABLE) INNER JOIN dbo._AccRgED404 T9 WITH(SERIALIZABLE) ON T9._RecorderTRef = T8._RecorderTRef AND T9._RecorderRRef = T8._RecorderRRef AND T9._LineNo = T8._LineNo AND T9._Period = T8._Period AND T9._Correspond = 24 AND T9._KindRRef = 25 AND (T9._Period > 26 OR T9._Period = 27 AND (T9._RecorderTRef > 0x00001D2B OR T9._RecorderTRef = 0x00001D2B AND T9._RecorderRRef >= 28)) AND T9._Period < 29 INNER JOIN dbo._AccRgED404 T10 WITH(SERIALIZABLE) ON T10._RecorderTRef = T8._RecorderTRef AND T10._RecorderRRef = T8._RecorderRRef AND T10._LineNo = T8._LineNo AND T10._Period = T8._Period AND T10._Correspond = 30 AND T10._KindRRef = 31 AND (T10._Period > 32 OR T10._Period = 33 AND (T10._RecorderTRef > 0x00001D2B OR T10._RecorderTRef = 0x00001D2B AND T10._RecorderRRef >= 34)) AND T10._Period < 35 WHERE T8._Active = 0x01 AND ((T8._AccountCtRRef IN (36))) AND ((((((T8._Fld379CtRRef IN (37))) AND (T9._Value_TYPE = 0x08 AND T9._Value_RTRef = 0x0000003B AND T9._Value_RRRef IN (38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84))) AND (T10._Value_TYPE = 0x08 AND T10._Value_RTRef = 0x0000004A AND T10._Value_RRRef IN (85))) AND (T8._Fld377RRef IN (86)))) AND (T8._Period > 87 OR T8._Period = 88 AND (T8._RecorderTRef > 0x00001D2B OR T8._RecorderTRef = 0x00001D2B AND T8._RecorderRRef >= 89)) AND T8._Period < 90) T2 INNER JOIN dbo._Acc16 T11 WITH(REPEATABLEREAD) ON T11._IDRRef = T2.AccountRRef GROUP BY T2.Fld377RRef, T2.AccountRRef, T2.Value1_TYPE, T2.Value1_RTRef, T2.Value1_RRRef, T2.Fld379RRef HAVING (CASE WHEN CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) IS NULL THEN 91 WHEN MAX(T11._Kind) = 92 OR MAX(T11._Kind) = 93 AND CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) > 94 THEN CAST(SUM(T2.Fld380Balance_) AS NUMERIC(33, 8)) ELSE 95 END) <> 96 OR (CASE WHEN CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) IS NULL THEN 97 WHEN MAX(T11._Kind) = 98 OR MAX(T11._Kind) = 99 AND CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) > @P200 THEN CAST(SUM(T2.Fld382Balance_) AS NUMERIC(32, 8)) ELSE @P201 END) <> @P202) T1 ORDER BY (T1.Value1_TYPE), (T1.Value1_RTRef), (T1.Value1_RRRef)',N' numeric,@P2 numeric,@P3 numeric,@P4 varbinary,@P5 varbinary,@P6 varbinary,@P7 varbinary,@P8 varbinary,@P9 varbinary,0 varbinary,1 varbinary,2 varbinary,3 varbinary,4 varbinary,5 varbinary,6 varbinary,7 varbinary,8 varbinary,9 varbinary,@P20 varbinary,@P21 varbinary,@P22 varbinary,@P23 varbinary,@P24 varbinary,@P25 varbinary,@P26 varbinary,@P27 varbinary,@P28 varbinary,@P29 varbinary,@P30 varbinary,@P31 varbinary,@P32 varbinary,@P33 varbinary,@P34 varbinary,@P35 varbinary,@P36 varbinary,@P37 varbinary,@P38 varbinary,@P39 varbinary,@P40 varbinary,@P41 varbinary,@P42 varbinary,@P43 varbinary,@P44 varbinary,@P45 varbinary,@P46 varbinary,@P47 varbinary,@P48 varbinary,@P49 varbinary,@P50 varbinary,@P51 varbinary,@P52 varbinary,@P53 varbinary,@P54 datetime2,@P55 numeric,@P56 numeric,@P57 numeric,@P58 varbinary,@P59 datetime2,@P60 datetime2,@P61 varbinary,@P62 datetime2,@P63 numeric,@P64 varbinary,@P65 datetime2,@P66 datetime2,@P67 varbinary,@P68 datetime2,@P69 varbinary,@P70 varbinary,@P71 varbinary,@P72 varbinary,@P73 varbinary,@P74 varbinary,@P75 varbinary,@P76 varbinary,@P77 varbinary,@P78 varbinary,@P79 varbinary,@P80 varbinary,@P81 varbinary,@P82 varbinary,@P83 varbinary,@P84 varbinary,@P85 varbinary,@P86 varbinary,@P87 varbinary,@P88 varbinary,@P89 varbinary,@P90 varbinary,@P91 varbinary,@P92 varbinary,@P93 varbinary,@P94 varbinary,@P95 varbinary,@P96 varbinary,@P97 varbinary,@P98 varbinary,@P99 varbinary,00 varbinary,01 varbinary,02 varbinary,03 varbinary,04 varbinary,05 varbinary,06 varbinary,07 varbinary,08 varbinary,09 varbinary,10 varbinary,11 varbinary,12 varbinary,13 varbinary,14 varbinary,15 varbinary,16 varbinary,17 varbinary,18 varbinary,19 varbinary,20 datetime2,21 datetime2,22 varbinary,23 datetime2,24 numeric,25 varbinary,26 datetime2,27 datetime2,28 varbinary,29 datetime2,30 numeric,31 varbinary,32 datetime2,33 datetime2,34 varbinary,35 datetime2,36 varbinary,37 varbinary,38 varbinary,39 varbinary,40 varbinary,41 varbinary,42 varbinary,43 varbinary,44 varbinary,45 varbinary,46 varbinary,47 varbinary,48 varbinary,49 varbinary,50 varbinary,51 varbinary,52 varbinary,53 varbinary,54 varbinary,55 varbinary,56 varbinary,57 varbinary,58 varbinary,59 varbinary,60 varbinary,61 varbinary,62 varbinary,63 varbinary,64 varbinary,65 varbinary,66 varbinary,67 varbinary,68 varbinary,69 varbinary,70 varbinary,71 varbinary,72 varbinary,73 varbinary,74 varbinary,75 varbinary,76 varbinary,77 varbinary,78 varbinary,79 varbinary,80 varbinary,81 varbinary,82 varbinary,83 varbinary,84 varbinary,85 varbinary,86 varbinary,87 datetime2,88 datetime2,89 varbinary,90 datetime2,91 numeric,92 numeric,93 numeric,94 numeric,95 numeric,96 numeric,97 numeric,98 numeric,99 numeric,@P200 numeric,@P201 numeric,@P202 numeric',1,2,2,0x00000000000000000000000000000000,0xA05394DE8061310F11E3D375AD93CDD1,0xAD1800241D7F102511E32B530093AF0D,0xB42E94DE8061310F11E3CEC1F4B71072,0xA13A2C44FD0EF4D311E3C5E552662381,0xA13A2C44FD0EF4D311E3C6C7568F0E4C,0xA13A2C44FD0EF4D311E3C6D51B9CA115,0xB42E94DE8061310F11E3CEAB16D42238,0xB42E94DE8061310F11E3CEAB16D4223A,0xB42E94DE8061310F11E3CEC1F4B71064,0xBE872C44FD14C82511E412DFD441A91D,0xAB8B2C44FD14C82511E3F508C30CB0E6,0xACC900241D7F102511E3364E417963BE,0x911B2C44FD0EF4D311E3EB9FE57BD3EE,0x915C2C44FD0EF4D311E3DB651E2A1163,0x845B2C44FD14C82511E4115A1A32A6B9,0x915C2C44FD0EF4D311E3DB616C564B71,0xA13A2C44FD0EF4D311E3C5E552662380,0xA13A2C44FD0EF4D311E3C5E55266237E,0xA13A2C44FD0EF4D311E3C9298292DF2B,0xA13A2C44FD0EF4D311E3C6C7568F0E3B,0xA13A2C44FD0EF4D311E3C6DCC7861235,0xA13A2C44FD0EF4D311E3C6EA5C6A3706,0xAE11B4B52FD2289211E27B2A2D6DE9FA,0x98ED94DE8061310F11E3CC541CB7F1AE,0xA13A2C44FD0EF4D311E3C5EE807B10E2,0xADD494DE8061310F11E3B3F73F5F310A,0xB56694DE8061310F11E3CAC5049874BF,0xBC7E2C44FD0EF4D311E3DC2C4EE2E0F0,0xA5F23408042DF1E711E275AAE0A2ABE2,0xAB8B2C44FD14C82511E3F508C30CB0F3,0xADB600241D7F102511E3451755412C9A,0xAB8B2C44FD14C82511E3F508C30CB0F2,0xA13A2C44FD0EF4D311E3C90300F1FA34,0x93EB2C44FD0EF4D311E3E22F77E5C981,0x96AE94DE8061310F11E3D4FEE7FF015E,0xA5F23408042DF1E711E275D18A8D38C7,0xB31394DE8061310F11E3A294FE42710C,0xB1162C44FD0EF4D311E3DFED193B6C76,0xA13A2C44FD0EF4D311E3C6EA5C6A370C,0xAB8B2C44FD14C82511E3F54721C137D5,0x881D2C44FD14C82511E49B8EE060253C,0x90E500241D7F102511E33C6096101E1B,0x8D6994DE8061310F11E39D58ED65C818,0x97B73408042DF1E711E2775830F0F5DE,0xAFF6B4B52FD2289211E27F34DA9FCD45,0xA5F23408042DF1E711E2759B6B5E4D17,0xA7FC3408042DF1E711E2742B3183B3D2,0x836F0019D1A9B0A611E1CEFDDB60B084,0x836F0019D1A9B0A611E1CEFDDB60B07C,'5999-11-01 00:00:00',0,0,0,0xB39A2D063397D7EB4AFDFAF9582F6043,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',0,0xA93CA2FCB671D57C41AC4DC8C1B92BA3,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',0xA3A05AC2AEEAF9BC4D763E59D90B277C,0x00000000000000000000000000000000,0xA05394DE8061310F11E3D375AD93CDD1,0xAD1800241D7F102511E32B530093AF0D,0xB42E94DE8061310F11E3CEC1F4B71072,0xA13A2C44FD0EF4D311E3C5E552662381,0xA13A2C44FD0EF4D311E3C6C7568F0E4C,0xA13A2C44FD0EF4D311E3C6D51B9CA115,0xB42E94DE8061310F11E3CEAB16D42238,0xB42E94DE8061310F11E3CEAB16D4223A,0xB42E94DE8061310F11E3CEC1F4B71064,0xBE872C44FD14C82511E412DFD441A91D,0xAB8B2C44FD14C82511E3F508C30CB0E6,0xACC900241D7F102511E3364E417963BE,0x911B2C44FD0EF4D311E3EB9FE57BD3EE,0x915C2C44FD0EF4D311E3DB651E2A1163,0x845B2C44FD14C82511E4115A1A32A6B9,0x915C2C44FD0EF4D311E3DB616C564B71,0xA13A2C44FD0EF4D311E3C5E552662380,0xA13A2C44FD0EF4D311E3C5E55266237E,0xA13A2C44FD0EF4D311E3C9298292DF2B,0xA13A2C44FD0EF4D311E3C6C7568F0E3B,0xA13A2C44FD0EF4D311E3C6DCC7861235,0xA13A2C44FD0EF4D311E3C6EA5C6A3706,0xAE11B4B52FD2289211E27B2A2D6DE9FA,0x98ED94DE8061310F11E3CC541CB7F1AE,0xA13A2C44FD0EF4D311E3C5EE807B10E2,0xADD494DE8061310F11E3B3F73F5F310A,0xB56694DE8061310F11E3CAC5049874BF,0xBC7E2C44FD0EF4D311E3DC2C4EE2E0F0,0xA5F23408042DF1E711E275AAE0A2ABE2,0xAB8B2C44FD14C82511E3F508C30CB0F3,0xADB600241D7F102511E3451755412C9A,0xAB8B2C44FD14C82511E3F508C30CB0F2,0xA13A2C44FD0EF4D311E3C90300F1FA34,0x93EB2C44FD0EF4D311E3E22F77E5C981,0x96AE94DE8061310F11E3D4FEE7FF015E,0xA5F23408042DF1E711E275D18A8D38C7,0xB31394DE8061310F11E3A294FE42710C,0xB1162C44FD0EF4D311E3DFED193B6C76,0xA13A2C44FD0EF4D311E3C6EA5C6A370C,0xAB8B2C44FD14C82511E3F54721C137D5,0x881D2C44FD14C82511E49B8EE060253C,0x90E500241D7F102511E33C6096101E1B,0x8D6994DE8061310F11E39D58ED65C818,0x97B73408042DF1E711E2775830F0F5DE,0xAFF6B4B52FD2289211E27F34DA9FCD45,0xA5F23408042DF1E711E2759B6B5E4D17,0xA7FC3408042DF1E711E2742B3183B3D2,0x836F0019D1A9B0A611E1CEFDDB60B084,0x836F0019D1A9B0A611E1CEFDDB60B07C,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',1,0xB39A2D063397D7EB4AFDFAF9582F6043,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',1,0xA93CA2FCB671D57C41AC4DC8C1B92BA3,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',0xA3A05AC2AEEAF9BC4D763E59D90B277C,0x00000000000000000000000000000000,0xA05394DE8061310F11E3D375AD93CDD1,0xAD1800241D7F102511E32B530093AF0D,0xB42E94DE8061310F11E3CEC1F4B71072,0xA13A2C44FD0EF4D311E3C5E552662381,0xA13A2C44FD0EF4D311E3C6C7568F0E4C,0xA13A2C44FD0EF4D311E3C6D51B9CA115,0xB42E94DE8061310F11E3CEAB16D42238,0xB42E94DE8061310F11E3CEAB16D4223A,0xB42E94DE8061310F11E3CEC1F4B71064,0xBE872C44FD14C82511E412DFD441A91D,0xAB8B2C44FD14C82511E3F508C30CB0E6,0xACC900241D7F102511E3364E417963BE,0x911B2C44FD0EF4D311E3EB9FE57BD3EE,0x915C2C44FD0EF4D311E3DB651E2A1163,0x845B2C44FD14C82511E4115A1A32A6B9,0x915C2C44FD0EF4D311E3DB616C564B71,0xA13A2C44FD0EF4D311E3C5E552662380,0xA13A2C44FD0EF4D311E3C5E55266237E,0xA13A2C44FD0EF4D311E3C9298292DF2B,0xA13A2C44FD0EF4D311E3C6C7568F0E3B,0xA13A2C44FD0EF4D311E3C6DCC7861235,0xA13A2C44FD0EF4D311E3C6EA5C6A3706,0xAE11B4B52FD2289211E27B2A2D6DE9FA,0x98ED94DE8061310F11E3CC541CB7F1AE,0xA13A2C44FD0EF4D311E3C5EE807B10E2,0xADD494DE8061310F11E3B3F73F5F310A,0xB56694DE8061310F11E3CAC5049874BF,0xBC7E2C44FD0EF4D311E3DC2C4EE2E0F0,0xA5F23408042DF1E711E275AAE0A2ABE2,0xAB8B2C44FD14C82511E3F508C30CB0F3,0xADB600241D7F102511E3451755412C9A,0xAB8B2C44FD14C82511E3F508C30CB0F2,0xA13A2C44FD0EF4D311E3C90300F1FA34,0x93EB2C44FD0EF4D311E3E22F77E5C981,0x96AE94DE8061310F11E3D4FEE7FF015E,0xA5F23408042DF1E711E275D18A8D38C7,0xB31394DE8061310F11E3A294FE42710C,0xB1162C44FD0EF4D311E3DFED193B6C76,0xA13A2C44FD0EF4D311E3C6EA5C6A370C,0xAB8B2C44FD14C82511E3F54721C137D5,0x881D2C44FD14C82511E49B8EE060253C,0x90E500241D7F102511E33C6096101E1B,0x8D6994DE8061310F11E39D58ED65C818,0x97B73408042DF1E711E2775830F0F5DE,0xAFF6B4B52FD2289211E27F34DA9FCD45,0xA5F23408042DF1E711E2759B6B5E4D17,0xA7FC3408042DF1E711E2742B3183B3D2,0x836F0019D1A9B0A611E1CEFDDB60B084,0x836F0019D1A9B0A611E1CEFDDB60B07C,'4015-01-11 12:00:27','4015-01-11 12:00:27',0x8F912C44FD0EF4D311E4A3B085A3BC03,'5999-11-01 00:00:00',0,0,2,0,0,0,0,0,2,0,0,0 [/CODE]

Блин, как прятать текст под спойлер?

Снимок запроса для отладки делал? Пользователь, под которым выполняешь запрос в консоли, тот же самый что и в рабочем режиме?

Про снимок запроса только сейчас узнал. Сейчас узнаю что-за зверь. Да пользователь один и тот же.