Array [50]
| 0 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00482490 |
| 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.00183080 |
| 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.00368620 |
| 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.00331780 |
| query |
Stringselect
*
from
t200_channel
where
chkey = :chkey: |
|
| 4 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00169300 |
| 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.00637290 |
| 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.00195190 |
| query |
Stringselect
*
from
t360_movie
where
mkey = :mkey: |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00173310 |
| query |
Stringselect
*
from
t220_channel_follower
where
chkey = :chkey: and
pk_user = :pk_user: |
|
| 8 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00193290 |
| query |
Stringselect
chname
from
t200_channel
where
chkey = :chkey: |
|
| 9 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00201700 |
| 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 |
|
| 10 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00170090 |
| query |
Stringselect
count(chkey) as cnt
from
t200_channel
where status = 1 and limited_flg = :limited_flg: |
|
| 11 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00235010 |
| 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 '%79%')
order by
t300.snkey |
|
| 12 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00186300 |
| 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 [4]
| file |
String/community\channel\lib\classes\TeacherRelationshipArticleList.class - line 67 |
| time |
String0.01898000 |
| 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 '%79%')
order by
t500.adate desc,
t500.akey desc
limit 2 |
| err |
Integer1 |
|
| 14 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00235080 |
| 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 '%79%') |
|
| 15 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00585480 |
| 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 |
|
| 16 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 42 |
| time |
String0.00227310 |
| 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 |
|
| 17 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 65 |
| time |
String0.00153490 |
| query |
Stringselect
ckey,
cname
from
t207_channel_movie_category
where
ckey in (1,2) and
chkey = :chkey:
order by
sort |
|
| 18 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00538900 |
| 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 |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00166510 |
| 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.00164410 |
| 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.00146700 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 22 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00147200 |
| 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.00149800 |
| 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.00173780 |
| 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.00183490 |
| 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.00165700 |
| 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.00161100 |
| 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.00209000 |
| 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.00171110 |
| 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.00167890 |
| 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.00168610 |
| 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.00171400 |
| 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.00175310 |
| 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.00186710 |
| 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.00167700 |
| 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.00165700 |
| 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.00169010 |
| 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.00169400 |
| 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.00146700 |
| 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.00163010 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 41 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00182990 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 42 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00170520 |
| 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.00152990 |
| 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.00158290 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 45 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00233390 |
| 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 |
|
| 46 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00259210 |
| 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 |
|
| 47 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00255300 |
| 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 |
|
| 48 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00202610 |
| 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 |
|
| 49 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00183890 |
| 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 |
|
アトラアカウントでログイン