Array [41]
| 0 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\CommonSeminarListCore.class - line 102 |
| time |
String0.00844810 |
| query |
Stringselect
distinct
v300.seminar_id,
v300.seminar_name,
v300.seminar_kind,
v300.chkey,
v300.simg_dir,
v300.simg,
v300.seminar_target,
v300.ldate,
v300.ftime,
v300.ttime,
v300.kougi_type,
v300.live_flg,
v300.price,
v300.card_flg,
v300.status,
v300.view_flg,
v300.honetsugi_view_flg,
v300.search_text,
v300.indate,
v300.ldatetime,
v300.sort,
v300.slide_view_flg
from
v300_seminar_list as v300
join
(select seminar_id, seminar_kind, min(ldatetime) as ldatetime from v300_seminar_list group by seminar_id, seminar_kind) as x300 on (v300.seminar_id = x300.seminar_id and v300.seminar_kind = x300.seminar_kind and v300.ldatetime = x300.ldatetime)
where 1 = 1 and v300.view_flg = 1 and v300.status != 3 and v300.status != 9
order by
v300.sort,
v300.ldatetime desc |
|
| 1 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\CommonSeminarListCore.class - line 123 |
| time |
String0.00267390 |
| query |
Stringselect
v300.*
from
v300_seminar_list as v300
where 1 = 1 and v300.view_flg = 1 and v300.status != 3 and v300.status != 9 and
v300.seminar_id in (319,244,102,98,96,100,97,99,101,295)
order by
v300.ldatetime desc |
|
| 2 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\CommonSeminarListCore.class - line 176 |
| time |
String0.00229810 |
| query |
Stringselect
t750.tkey,
t750.tname,
t760.contents_id,
t760.contents_type
from
t760_tags_mapping as t760
join
t750_tags as t750 on (t760.tkey = t750.tkey and t760.contents_type in ('normal', 'limited'))
where
cast(t760.contents_id as nvarchar) + '@' + t760.contents_type in ('319@normal','244@normal','102@limited','98@limited','96@limited','100@limited','97@limited','99@limited','101@limited','295@normal') |
|
| 3 |
Array [4]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.04136010 |
| query |
Stringselect
count(distinct v300.seminar_id) as cnt
from
v300_seminar_list as v300
join
(select seminar_id, seminar_kind, min(ldatetime) as ldatetime from v300_seminar_list group by seminar_id, seminar_kind) as x300 on (v300.seminar_id = x300.seminar_id and v300.seminar_kind = x300.seminar_kind and v300.ldatetime = x300.ldatetime)
where 1 = 1 and v300.view_flg = 1 and v300.status != 3 and v300.status != 9 |
| err |
Integer1 |
|
| 4 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00178290 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 5 |
Array [3]
| file |
String/admin\member\top\seminar\lib\classes\PickupSeminarList.class - line 30 |
| time |
String0.00175810 |
| query |
Stringselect
*
from
t823_topseminar
order by
sort,
pkey desc |
|
| 6 |
Array [3]
| file |
String/admin\member\top\seminar\lib\classes\PickupSeminarList.class - line 81 |
| time |
String0.00164890 |
| query |
Stringselect
snkey as seminar_id,
snname as seminar_name,
simg_dir as imgdir,
simg as img
from
t300_normal
where
snkey in (295,302,281) |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00177000 |
| query |
Stringselect
count(pkey) as cnt
from
t823_topseminar |
|
| 8 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00161600 |
| query |
Stringselect
*
from
t300_normal
where
snkey = :snkey: and
status = 1 |
|
| 9 |
Array [3]
| file |
String/seminar\det\lib\classes\SeminarDetail.class - line 53 |
| time |
String0.00156400 |
| query |
Stringselect
*
from
t310_lesson
where
snkey = :snkey: and
status in (1, 2, 3)
order by
ldate,
ftime,
snkey |
|
| 10 |
Array [3]
| file |
String/seminar\det\lib\classes\SeminarDetail.class - line 73 |
| time |
String0.00187210 |
| query |
Stringselect
lkey,
sum(join_cnt) as cnt
from
t320_entry
where
status = 1 and
( lkey = :lkey1:)
group by
lkey |
|
| 11 |
Array [3]
| file |
String/seminar\det\lib\classes\SeminarDetail.class - line 89 |
| time |
String0.00166580 |
| query |
Stringselect
lkey,
sum(join_cnt) as cnt
from
t320_entry
where
status in (2, 3) and
( lkey = :lkey1:)
group by
lkey |
|
| 12 |
Array [3]
| file |
String/seminar\det\lib\classes\SeminarDetail.class - line 105 |
| time |
String0.00718310 |
| query |
Stringselect
lkey,
sum(join_cnt) as cnt
from
t320_entry
where
status = 8 and
( lkey = :lkey1:)
group by
lkey |
|
| 13 |
Array [3]
| file |
String/seminar\det\lib\classes\TeacherList.class - line 34 |
| time |
String0.00166800 |
| query |
Stringselect
*
from
t800_teacher
where
status = 1 and
tkey in (84)
order by
sort |
|
| 14 |
Array [3]
| file |
String/lib\classes\top\TopPickupSeminar.class - line 125 |
| time |
String0.00203390 |
| query |
Stringselect
t750.tkey,
t750.tname,
t750.sort
from
t750_tags as t750
join
t760_tags_mapping as t760 on (t750.tkey = t760.tkey)
where
contents_id = :contents_id: and
contents_type = :contents_type:
group by
t750.tkey,
t750.tname,
t750.sort
order by
t750.sort,
t750.tkey desc |
|
| 15 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00158190 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 16 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00176410 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 17 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00171900 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 18 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00196700 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 19 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00155900 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 20 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00186200 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 21 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00183010 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 22 |
Array [3]
| file |
String/lib\classes\AlertList.class - line 31 |
| time |
String0.00177600 |
| query |
Stringselect
*
from
t610_alert
where
(fdate is null or fdate <= :cdate:) and
(tdate is null or tdate >= :cdate:)
order by
akey desc |
|
| 23 |
Array [3]
| file |
String/lib\classes\TopicList.class - line 47 |
| time |
String0.00232600 |
| query |
Stringselect
*
from
t600_topics
where 1 = 1 and status = 1 and (fdate is NULL or fdate <= :cdate:) and (tdate is NULL or tdate >= :cdate:)
order by
topics_date desc,
chdate desc,
indate desc
limit 3
offset 0 |
|
| 24 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00192710 |
| query |
Stringselect
count(tkey) as cnt
from
t600_topics
where 1 = 1 and status = 1 and (fdate is NULL or fdate <= :cdate:) and (tdate is NULL or tdate >= :cdate:) |
|
| 25 |
Array [3]
| file |
String/lib\classes\top\TopToolList.class - line 31 |
| time |
String0.00175000 |
| query |
Stringselect
*
from
t620_download
where
status = 1 and
category = 50
order by
indate desc
limit 5 |
|
| 26 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00170680 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 27 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00170020 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 28 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00162100 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 29 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00177810 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 30 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00163700 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 31 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 70 |
| time |
String0.01022510 |
| query |
Stringselect
*
from
v500_contents as v500
where 1 = 1 and contents_target != 30
order by
v500.contents_date desc,
v500.contents_id desc
limit 6 offset 0 |
| err |
Integer1 |
|
| 32 |
Array [3]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 96 |
| time |
String0.00323890 |
| query |
Stringselect
t750.tkey,
t750.tname,
t760.contents_id,
t760.contents_type
from
t760_tags_mapping as t760
join
t750_tags as t750 on (t760.tkey = t750.tkey and t760.contents_type in ('article', 'movie'))
where
cast(t760.contents_id as nvarchar) + '@' + t760.contents_type in ('508@article','507@article','505@article','506@article','504@article','503@article') |
|
| 33 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00605300 |
| query |
Stringselect
count(v500.contents_id) as cnt
from
v500_contents as v500
where 1 = 1 and contents_target != 30 |
|
| 34 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00183490 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 35 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00168510 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 36 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00222710 |
| 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 |
|
| 37 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00258400 |
| 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 |
|
| 38 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00209400 |
| 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 |
|
| 39 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00195720 |
| 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 |
|
| 40 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00176810 |
| 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 |
|
