Array [16]
| 0 |
Array [3]
| file |
String/seminar\lib\classes\SeminarChannelList.class - line 32 |
| time |
String0.00208520 |
| query |
Stringselect
t300.chkey
from
t310_lesson as t310
join
t300_normal as t300 on (t310.snkey = t300.snkey)
where
t300.status = 1 and
t310.status in (1, 2, 3) and
t300.cate <> 80150 and
((t310.tdate is null and t310.ldate > :ldate:) or t310.tdate >= :tdate:) and
chkey in (select chkey from t200_channel where status = 1) and
list_view_flg = 1
group by
t300.chkey |
|
| 1 |
Array [3]
| file |
String/seminar\lib\classes\SeminarChannelList.class - line 51 |
| time |
String0.00172400 |
| query |
Stringselect
*
from
t200_channel
where
status = 1 and
chkey = :chkey1:
order by
sort,
chkey |
|
| 2 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00185610 |
| query |
Stringselect
*
from
t300_normal as t300
where
t300.status = 1 and
chkey in (select chkey from t200_channel where status = 1) and t300.seminar_type != 30
order by
t300.snkey |
|
| 3 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00244000 |
| query |
Stringselect
*
from
t310_lesson as t310
where
t310.status in (1, 2, 3) and
((t310.tdate is null and t310.ldate > :ldate:) or t310.tdate >= :tdate:) and t310.remark_flg = 1
order by
t310.lkey,
t310.ldate,
t310.ftime |
|
| 4 |
Array [3]
| file |
String/seminar\lib\classes\PastLessonList.class - line 47 |
| time |
String0.00222490 |
| query |
Stringselect
*
from
t310_lesson as t310
where
t310.status = 1 and
t310.ldate > :past: and
t310.ldate <= :cdate: and
(t310.tdate is null or t310.tdate < :tdate:)
order by
t310.lkey,
t310.ldate,
t310.ftime |
|
| 5 |
Array [3]
| file |
String/seminar\lib\classes\PastLessonList.class - line 70 |
| time |
String0.00186610 |
| query |
Stringselect
*
from
t300_normal as t300
where
t300.status = 1 and
t300.form_flg = 1 and
t300.chdate > :past: and
t300.chkey in (select chkey from t200_channel where status = 1)
and snkey in (233,179,197,243,238,177,188,240,211,226,248,220,247,252,256,257,259,260,263,265,264,266,267,249,269,272,274,275,276,277,278,279,280,281,282,283,284,285,286,288,289,290,291,292,293,300,297,301,298,299,302,303,305,296,306,307,308,310,316,319,320,321,322,323,324,325,326,327,328)
order by
t300.snkey
limit 12 offset 0 |
|
| 6 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00526020 |
| query |
Stringselect
count(t300.snkey) as cnt
from
t300_normal as t300
where
t300.status = 1 and
t300.form_flg = 1 and
t300.chdate > :past: and
t300.chkey in (select chkey from t200_channel where status = 1)
and snkey in (233,179,197,243,238,177,188,240,211,226,248,220,247,252,256,257,259,260,263,265,264,266,267,249,269,272,274,275,276,277,278,279,280,281,282,283,284,285,286,288,289,290,291,292,293,300,297,301,298,299,302,303,305,296,306,307,308,310,316,319,320,321,322,323,324,325,326,327,328) |
|
| 7 |
Array [3]
| file |
String/admin\member\teacher\lib\classes\TeacherName.class - line 31 |
| time |
String0.00251700 |
| query |
Stringselect
tkey,
fname,
lname
from
t800_teacher
where
status <> 9
order by
sort,
tkey desc |
|
| 8 |
Array [3]
| file |
String/seminar\lib\classes\PastLessonList.class - line 47 |
| time |
String0.00229100 |
| query |
Stringselect
*
from
t310_lesson as t310
where
t310.status = 1 and
t310.ldate > :past: and
t310.ldate <= :cdate: and
(t310.tdate is null or t310.tdate < :tdate:)
order by
t310.lkey,
t310.ldate,
t310.ftime |
|
| 9 |
Array [3]
| file |
String/seminar\lib\classes\PastLessonList.class - line 70 |
| time |
String0.00181390 |
| query |
Stringselect
*
from
t300_normal as t300
where
t300.status = 1 and
t300.form_flg = 1 and
t300.chdate > :past: and
t300.chkey in (select chkey from t200_channel where status = 1)
and snkey in (233,179,197,243,238,177,188,240,211,226,248,220,247,252,256,257,259,260,263,265,264,266,267,249,269,272,274,275,276,277,278,279,280,281,282,283,284,285,286,288,289,290,291,292,293,300,297,301,298,299,302,303,305,296,306,307,308,310,316,319,320,321,322,323,324,325,326,327,328)
order by
t300.snkey |
|
| 10 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00228790 |
| query |
Stringselect
count(t300.snkey) as cnt
from
t300_normal as t300
where
t300.status = 1 and
t300.form_flg = 1 and
t300.chdate > :past: and
t300.chkey in (select chkey from t200_channel where status = 1)
and snkey in (233,179,197,243,238,177,188,240,211,226,248,220,247,252,256,257,259,260,263,265,264,266,267,249,269,272,274,275,276,277,278,279,280,281,282,283,284,285,286,288,289,290,291,292,293,300,297,301,298,299,302,303,305,296,306,307,308,310,316,319,320,321,322,323,324,325,326,327,328) |
|
| 11 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00178810 |
| query |
Stringselect
*
from
t300_normal as t300
where
t300.status = 1 and
chkey in (select chkey from t200_channel where status = 1) and t300.list_view_flg = 1
order by
t300.snkey |
|
| 12 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00212690 |
| query |
Stringselect
*
from
t310_lesson as t310
where
t310.status in (1, 2, 3) and
((t310.tdate is null and t310.ldate > :ldate:) or t310.tdate >= :tdate:)
order by
t310.lkey,
t310.ldate,
t310.ftime |
|
| 13 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00210910 |
| query |
Stringselect
*
from
t430_lesson as t430
join
t420_group as t420 on (t430.slkey = t420.slkey and t430.gkey = t420.gkey)
where
t420.view_flg = 1 and
((t420.tdate is null and t430.ldate > :ldate:) or (t420.tdate >= :tdate: and t430.ldate >= :ldate:))
order by
t430.slkey,
t430.ldate,
t430.ftime |
|
| 14 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00175810 |
| query |
Stringselect
*
from
t400_limited
where
chkey in (select chkey from t200_channel where status = 1) and
status <> 9 and
view_flg = 1 and
status <> 3 and
( slkey = :slkey1:)
order by
slkey desc |
|
| 15 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00178100 |
| query |
Stringselect
*
from
t400_limited
where
chkey in (select chkey from t200_channel where status = 1) and
status <> 9 and
view_flg = 1 and
status <> 3 and
( slkey = :slkey1:)
order by
slkey desc |
|
|
