Array [38]
| 0 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00636700 |
| 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 (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg:
order by
sort,
chkey desc |
|
| 1 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00185080 |
| query |
Stringselect
count(chkey) as cnt
from
t200_channel
where status = 1 and (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg: |
|
| 2 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00470300 |
| 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 (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg:
order by
sort,
chkey desc |
|
| 3 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00140500 |
| query |
Stringselect
count(chkey) as cnt
from
t200_channel
where status = 1 and (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg: |
|
| 4 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00188300 |
| 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 (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg:
order by
sort,
chkey desc |
|
| 5 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00149800 |
| 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 (chname like :word: or chdoc like :word:) and limited_flg = :limited_flg:
order by
sort,
chkey desc |
|
| 6 |
Array [3]
| file |
String/column\lib\classes\ArticleList.class - line 80 |
| time |
String0.00860310 |
| 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 t510.chkey in (select chkey from t200_channel where status = 1) and t500.ckey not in (3, 4) and (aname like :s_word: or adoc like :s_word:)
order by
t500.adate desc,
t500.akey desc |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00639080 |
| query |
Stringselect
count(t500.akey) as cnt
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 t510.chkey in (select chkey from t200_channel where status = 1) and t500.ckey not in (3, 4) and (aname like :s_word: or adoc like :s_word:) |
|
| 8 |
Array [3]
| file |
String/column\lib\classes\ArticleList.class - line 80 |
| time |
String0.00711200 |
| 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 t510.chkey in (select chkey from t200_channel where status = 1) and t500.ckey not in (3, 4) and (aname like :s_word: or adoc like :s_word:)
order by
t500.adate desc,
t500.akey desc
limit 12 offset 0 |
|
| 9 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00638410 |
| query |
Stringselect
count(t500.akey) as cnt
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 t510.chkey in (select chkey from t200_channel where status = 1) and t500.ckey not in (3, 4) and (aname like :s_word: or adoc like :s_word:) |
|
| 10 |
Array [4]
| file |
String/movie\lib\classes\MovieList.class - line 79 |
| time |
String0.01148490 |
| query |
Stringselect
t360.*,
CASE
WHEN t360.release_date IS NOT NULL THEN t360.release_date
WHEN t360.disp_fdate IS NOT NULL THEN t360.disp_fdate
ELSE t360.chdate
END as release_date2,
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.view_flg = 1 and
slkey is null and
(disp_fdate is null or disp_fdate <= :curdate:) and
(disp_tdate is null or disp_tdate >= :curdate:) and (t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and (t360.mname like :s_word: or t360.mdoc like :s_word:)
order by
release_date2 desc,
t360.disp_fdate desc,
t360.chdate desc |
| err |
Integer1 |
|
| 11 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00761910 |
| query |
Stringselect
count(t360.mkey) as cnt
from
t360_movie as t360
where
t360.view_flg = 1 and
slkey is null and
(disp_fdate is null or disp_fdate <= :curdate:) and
(disp_tdate is null or disp_tdate >= :curdate:) and (t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and (t360.mname like :s_word: or t360.mdoc like :s_word:) |
|
| 12 |
Array [3]
| file |
String/movie\lib\classes\MovieList.class - line 79 |
| time |
String0.00954600 |
| query |
Stringselect
t360.*,
CASE
WHEN t360.release_date IS NOT NULL THEN t360.release_date
WHEN t360.disp_fdate IS NOT NULL THEN t360.disp_fdate
ELSE t360.chdate
END as release_date2,
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.view_flg = 1 and
slkey is null and
(disp_fdate is null or disp_fdate <= :curdate:) and
(disp_tdate is null or disp_tdate >= :curdate:) and (t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and (t360.mname like :s_word: or t360.mdoc like :s_word:)
order by
release_date2 desc,
t360.disp_fdate desc,
t360.chdate desc
limit 12 offset 0 |
|
| 13 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00739690 |
| query |
Stringselect
count(t360.mkey) as cnt
from
t360_movie as t360
where
t360.view_flg = 1 and
slkey is null and
(disp_fdate is null or disp_fdate <= :curdate:) and
(disp_tdate is null or disp_tdate >= :curdate:) and (t360.target = 10 or t360.chkey in (select chkey from t200_channel where status = 1)) and (t360.mname like :s_word: or t360.mdoc like :s_word:) |
|
| 14 |
Array [3]
| file |
StringC:\home\site\wwwroot\live\lib\classes\LiveListCore.class - line 48 |
| time |
String0.00217800 |
| query |
Stringselect
*
from
t550_live
where status = 1 and (target = 10 or chkey in (select chkey from t200_channel where status = 1)) and list_flg = 1 and (lname like :word: or ldoc like :word:)
order by
ldate desc,
ftime desc,
lkey desc |
|
| 15 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00183080 |
| query |
Stringselect
count(lkey) as cnt
from
t550_live
where status = 1 and (target = 10 or chkey in (select chkey from t200_channel where status = 1)) and list_flg = 1 and (lname like :word: or ldoc like :word:) |
|
| 16 |
Array [4]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\LessonListCore.class - line 95 |
| time |
String0.01244190 |
| query |
Stringselect
*,
t310.status as t310_status
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 and (t300.snname like :word: or t300.seo_description like :word:)
order by
t310.ldate,
t310.ftime,
t310.lkey |
| err |
Integer1 |
|
| 17 |
Array [4]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.01375410 |
| query |
Stringselect
count(t310.lkey) as cnt
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 and (t300.snname like :word: or t300.seo_description like :word:) |
| err |
Integer1 |
|
| 18 |
Array [3]
| file |
String/seminar\practice\lib\classes\LimitedLessonList.class - line 67 |
| time |
String0.00153710 |
| query |
Stringselect
*
from
t430_lesson as t430
join
t420_group as t420 on (t430.slkey = t420.slkey and t430.gkey = t420.gkey)
and 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 |
|
| 19 |
Array [3]
| file |
String/seminar\practice\lib\classes\LimitedLessonList.class - line 137 |
| time |
String0.00145890 |
| query |
Stringselect
*
from
t400_limited
where
(slname like :word: or seo_description like :word:) and
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 |
|
| 20 |
Array [3]
| file |
String/seminar\practice\lib\classes\LimitedLessonList.class - line 139 |
| time |
String0.00153280 |
| query |
Stringselect
*
from
t400_limited
where
(slname like :word: or seo_description like :word:) and
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 |
|
| 21 |
Array [3]
| file |
String/tool\lib\classes\DownloadList.class - line 44 |
| time |
String0.00681810 |
| query |
Stringselect
*
from
t620_download
where 1 = 1 and status = 1 and category = :category: and (dname like :s_word: or doc like :s_word: or keyword like :s_word:)
order by
indate desc
limit 24
offset 0 |
|
| 22 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00171590 |
| query |
Stringselect
count(dkey) as cnt
from
t620_download
where 1 = 1 and status = 1 and category = :category: and (dname like :s_word: or doc like :s_word: or keyword like :s_word:) |
|
| 23 |
Array [3]
| file |
String/tool\lib\classes\DownloadList.class - line 44 |
| time |
String0.00163510 |
| query |
Stringselect
*
from
t620_download
where 1 = 1 and status = 1 and category = :category: and (dname like :s_word: or doc like :s_word: or keyword like :s_word:)
order by
indate desc
limit 24
offset 0 |
|
| 24 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00154900 |
| query |
Stringselect
count(dkey) as cnt
from
t620_download
where 1 = 1 and status = 1 and category = :category: and (dname like :s_word: or doc like :s_word: or keyword like :s_word:) |
|
| 25 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00183990 |
| 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.00144290 |
| 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.00152800 |
| 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.00124290 |
| 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.00122500 |
| 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.00142600 |
| 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.00140600 |
| 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.00142600 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 33 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00164290 |
| 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 |
|
| 34 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00197100 |
| 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 |
|
| 35 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00180600 |
| 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 |
|
| 36 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00173310 |
| 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 |
|
| 37 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00138190 |
| 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 |
|
