Array [59]
| 0 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00325510 |
| query |
Stringselect
t360.*,
t350.thumbnail_url_ssl,
t350.duration,
t370.pk_user
from
t360_movie as t360
left outer join
t350_movie_master as t350 on (t350.mid = t360.mid)
left outer join
t370_movie_play_history as t370 on (t370.mkey = t360.mkey and t370.pk_user = :pk_user:)
where
t360.mkey = :mkey: and
t360.chkey = :chkey: and
t360.view_flg = 1 and
(t360.disp_fdate is null or t360.disp_fdate <= :cur_date:) and
(t360.disp_tdate is null or t360.disp_tdate >= :cur_date:)
limit 1 |
|
| 1 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00182100 |
| query |
Stringselect
*
from
t200_channel
where
chkey = :chkey: and
status = 1
limit 1 |
|
| 2 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00180010 |
| query |
Stringselect
*
from
t730_items
where
ikey = :ikey: and
view_flg = 1 and
(fdate is null or fdate <= :cdate:) and
(tdate is null or tdate >= :cdate:) |
|
| 3 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00189810 |
| query |
Stringselect
*
from
t200_channel
where
chkey = :chkey: |
|
| 4 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00147890 |
| query |
Stringselect
count(chkey) as cnt
from
t220_channel_follower
where
chkey = :chkey: |
|
| 5 |
Array [3]
| file |
String/admin\member\channel\lib\classes\ChannelName.class - line 28 |
| time |
String0.00212290 |
| query |
Stringselect
chkey,
chname
from
t200_channel
order by
sort,
chkey |
|
| 6 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00203390 |
| query |
Stringselect
*
from
t360_movie
where
mkey = :mkey: |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\lib\classes\ContentsAuthorityCore.class - line 312 |
| time |
String0.00327400 |
| query |
Stringselect
*
from
t440_entry as t440
join
t450_entry_lesson as t450 on (t440.ekey = t450.ekey)
join
t430_lesson as t430 on (t450.lkey = t430.lkey and t440.slkey = t430.slkey)
where
t440.slkey = :slkey: and
pk_user = :pk_user: and
status in (40, 50)
order by
ldate; |
|
| 8 |
Array [3]
| file |
StringC:\home\site\wwwroot\lib\classes\ContentsAuthorityCore.class - line 336 |
| time |
String0.00463990 |
| query |
Stringselect
*
from
t440_entry as t440
join
t445_entry_guest as t445 on (t440.ekey = t445.ekey)
join
t450_entry_lesson as t450 on (t440.ekey = t450.ekey)
join
t430_lesson as t430 on (t450.lkey = t430.lkey and t440.slkey = t430.slkey)
where
t440.slkey = :slkey: and
t445.pk_user = :pk_user: and
status in (40, 50)
order by
ldate; |
|
| 9 |
Array [3]
| file |
StringC:\home\site\wwwroot\lib\classes\ContentsAuthorityCore.class - line 358 |
| time |
String0.00200490 |
| query |
Stringselect
*
from
t4040_entry as t4040
join
t4050_entry_lesson as t4050 on (t4040.ekey = t4050.ekey)
join
t4030_lesson as t4030 on (t4050.lkey = t4030.lkey and t4040.slkey = t4030.slkey)
where
t4040.slkey = :slkey: and
pk_user = :pk_user: and
status = 50
order by
ldate; |
|
| 10 |
Array [3]
| file |
StringC:\home\site\wwwroot\lib\classes\ContentsAuthorityCore.class - line 382 |
| time |
String0.00355510 |
| query |
Stringselect
*
from
t4040_entry as t4040
join
t4045_entry_guest as t4045 on (t4040.ekey = t4045.ekey)
join
t4050_entry_lesson as t4050 on (t4040.ekey = t4050.ekey)
join
t4030_lesson as t4030 on (t4050.lkey = t4030.lkey and t4040.slkey = t4030.slkey)
where
t4040.slkey = :slkey: and
t4045.pk_user = :pk_user: and
status = 50
order by
ldate; |
|
| 11 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00160500 |
| query |
Stringselect
slname
from
t400_limited
where
slkey = :slkey: |
|
| 12 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00194380 |
| query |
Stringselect
t200.*,
CASE
WHEN t210.cnt is null THEN 0
ELSE t210.cnt
END as user_cnt,
CASE
WHEN t210_user.pk_user is null THEN 0
ELSE 1
END as is_member
from
t200_channel as t200
left join (
select
chkey,
count(chkey) as cnt
from
t210_channel_user
where
status != 9
group by
chkey
) as t210
on t200.chkey = t210.chkey
left join (
select
distinct pk_user,
chkey
from
t210_channel_user
where
status != 9 and
pk_user = null
) as t210_user
on t200.chkey = t210_user.chkey
where status = 1 and limited_flg = :limited_flg:
order by
sort,
chkey desc
limit 12 offset 0 |
|
| 13 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00199200 |
| query |
Stringselect
count(chkey) as cnt
from
t200_channel
where status = 1 and limited_flg = :limited_flg: |
|
| 14 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00236800 |
| query |
Stringselect
*
from
t300_normal as t300
where
t300.status = 1 and
chkey in (select chkey from t200_channel where status = 1) and (t300.tkey like '%85%')
order by
t300.snkey |
|
| 15 |
Array [4]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.01642110 |
| 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 |
| err |
Integer1 |
|
| 16 |
Array [3]
| file |
String/community\channel\lib\classes\TeacherRelationshipArticleList.class - line 67 |
| time |
String0.00338600 |
| query |
Stringselect
t500.*,
t510.cname,
t502.*
from
t500_article as t500
join
t510_category as t510
on (t500.ckey = t510.ckey)
join
(
SELECT
t502.akey,
simg_dir,
simg
FROM
t502_section as t502
INNER JOIN (
SELECT
akey,
MIN(skey) AS min
FROM
t502_section
GROUP BY
akey
) AS t502_min
ON t502.skey = t502_min.min
AND t502.akey = t502_min.akey
) as t502
on (t500.akey = t502.akey)
where 1 = 1 and status = 1 and t500.ckey not in (3, 4) and (t500.tkey like '%85%')
order by
t500.adate desc,
t500.akey desc
limit 2 |
|
| 17 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00323200 |
| query |
Stringselect
count(t500.akey) as cnt
from
t500_article as t500
join
t510_category as t510 on (t500.ckey = t510.ckey)
where 1 = 1 and status = 1 and t500.ckey not in (3, 4) and (t500.tkey like '%85%') |
|
| 18 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00569200 |
| query |
Stringselect
t360.*,
t350.thumbnail_url_ssl,
t350.duration,
t370.pk_user
from
t360_movie as t360
left outer join
t350_movie_master as t350 on (t350.mid = t360.mid)
left outer join
t370_movie_play_history as t370 on (t370.mkey = t360.mkey and t370.pk_user = :pk_user:)
left outer join
t205_movie_order as t205 on (t360.mkey = t205.mkey)
where
t360.view_flg = 1 and
(t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and
t360.chkey = :chkey: and
(t360.disp_fdate is null or t360.disp_fdate <= :cur_date:) and
(t360.disp_tdate is null or t360.disp_tdate >= :cur_date:)
order by
t360.channel_movie_category,
t205.sort,
t360.disp_fdate desc,
t360.indate desc |
|
| 19 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 42 |
| time |
String0.00808100 |
| query |
Stringselect
case
when channel_movie_category is not null then channel_movie_category
else 99999
end as channel_movie_category
from
t360_movie
where
view_flg = 1 and
(target = 10 or chkey in (select chkey from t200_channel where status = 1)) and
chkey = :chkey: and
(disp_fdate is null or disp_fdate <= :cur_date:) and
(disp_tdate is null or disp_tdate >= :cur_date:)
group by
channel_movie_category |
|
| 20 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 65 |
| time |
String0.00172310 |
| query |
Stringselect
ckey,
cname
from
t207_channel_movie_category
where
ckey in (1) and
chkey = :chkey:
order by
sort |
|
| 21 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00545410 |
| query |
Stringselect
t360.*,
t350.thumbnail_url_ssl,
t350.duration,
t370.pk_user
from
t360_movie as t360
left outer join
t350_movie_master as t350 on (t350.mid = t360.mid)
left outer join
t370_movie_play_history as t370 on (t370.mkey = t360.mkey and t370.pk_user = :pk_user:)
left outer join
t205_movie_order as t205 on (t360.mkey = t205.mkey)
where
t360.view_flg = 1 and
(t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and
t360.chkey = :chkey: and
(t360.disp_fdate is null or t360.disp_fdate <= :cur_date:) and
(t360.disp_tdate is null or t360.disp_tdate >= :cur_date:)
order by
t360.channel_movie_category,
t205.sort,
t360.disp_fdate desc,
t360.indate desc |
|
| 22 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00183820 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 23 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00332710 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 24 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00160380 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 25 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00154090 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 26 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00149800 |
| 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.00147510 |
| 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.00167700 |
| 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.00149010 |
| 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.00175290 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 31 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00178890 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 32 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00201110 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 33 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00148700 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 34 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00184420 |
| 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.00169610 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 36 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00161410 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 37 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00144000 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 38 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00170110 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 39 |
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: |
|
| 40 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00155400 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 41 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipSeminarList.class - line 35 |
| time |
String0.00155710 |
| query |
Stringselect
*
from
t400_limited
where
slkey = :slkey: |
|
| 42 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00166990 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 43 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00140910 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 44 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00148010 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 45 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00218390 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 46 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00169400 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 47 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00146700 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 48 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00161100 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 49 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00163480 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 50 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00159720 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 51 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00157400 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 52 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00150800 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 53 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00169680 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 54 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00191590 |
| 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 |
|
| 55 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00223590 |
| 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 |
|
| 56 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00200890 |
| 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 |
|
| 57 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00166010 |
| 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 |
|
| 58 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00174400 |
| 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 |
|
アトラアカウントでログイン