Array [47]
| 0 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00302700 |
| 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.00185200 |
| 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.00170090 |
| 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.00164510 |
| query |
Stringselect
*
from
t200_channel
where
chkey = :chkey: |
|
| 4 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00196410 |
| 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.00188990 |
| 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.00387880 |
| query |
Stringselect
*
from
t360_movie
where
mkey = :mkey: |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\community\lib\classes\ChannelList.class - line 83 |
| time |
String0.00176810 |
| 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 |
|
| 8 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00184820 |
| query |
Stringselect
count(chkey) as cnt
from
t200_channel
where status = 1 and limited_flg = :limited_flg: |
|
| 9 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00220680 |
| 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 '%104%')
order by
t300.snkey |
|
| 10 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00196000 |
| 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 |
|
| 11 |
Array [3]
| file |
String/community\channel\lib\classes\TeacherRelationshipArticleList.class - line 67 |
| time |
String0.00314690 |
| 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 '%104%')
order by
t500.adate desc,
t500.akey desc
limit 2 |
|
| 12 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00242500 |
| 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 '%104%') |
|
| 13 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00519010 |
| 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 |
|
| 14 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 42 |
| time |
String0.00224300 |
| 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 |
|
| 15 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieCategory.class - line 65 |
| time |
String0.00186680 |
| query |
Stringselect
ckey,
cname
from
t207_channel_movie_category
where
ckey in (99999,1) and
chkey = :chkey:
order by
sort |
|
| 16 |
Array [3]
| file |
String/community\channel\lib\classes\RelationshipMovieList.class - line 50 |
| time |
String0.00475790 |
| 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 |
|
| 17 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00165300 |
| 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.00215890 |
| 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.00148420 |
| 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.00172590 |
| 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.00165580 |
| 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.00168420 |
| 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.00148320 |
| 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.00178100 |
| 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.00168180 |
| 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.00152300 |
| 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.00200390 |
| 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.00160000 |
| 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.00157500 |
| 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.00188300 |
| 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.00176220 |
| 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.00140620 |
| 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.00167200 |
| 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.00197010 |
| 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.00148890 |
| 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.00163100 |
| 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.00175600 |
| 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.00175810 |
| 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.00149390 |
| 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.00191120 |
| 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.00149580 |
| query |
Stringselect
cache_value
from
t930_cache
where
cache_name = :cache_name: and
chdate >= :chdate: |
|
| 42 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00200610 |
| 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 |
|
| 43 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00201300 |
| 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 |
|
| 44 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00194190 |
| 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 |
|
| 45 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00152210 |
| 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 |
|
| 46 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00148990 |
| 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 |
|
![第31回 [現場の声]スタッフから見た湯村流「ノータッチ分院」が「タッチ分院」になったら？](https://honetsugiacademy.blob.core.windows.net/temp-honetsugi-academy-image/movie_right/thumb/7c308b07c7d34093b8aa96085ad23625_25_13_200x0.jpg)
第31回 [現場の声]スタッフから見た湯村流「ノータッチ分院」が「タッチ分院」になったら？![第30回 [現場の声]スタッフから見た湯村流「ノータッチ分院」で自発性の元はココ](https://honetsugiacademy.blob.core.windows.net/temp-honetsugi-academy-image/movie_right/thumb/b599e90ba6774e1191076948ea2f43e1_25_13_200x0.jpg)
第30回 [現場の声]スタッフから見た湯村流「ノータッチ分院」で自発性の元はココ![第29回 [現場の声]スタッフから見た湯村流「ノータッチ分院」の活用法](https://honetsugiacademy.blob.core.windows.net/temp-honetsugi-academy-image/movie_right/thumb/1e6b080c7d164c9daccf959025141f96_25_13_200x0.jpg)
第29回 [現場の声]スタッフから見た湯村流「ノータッチ分院」の活用法
第28回 「ノータッチ分院」達成の判断基準はあなたのストレス度
第27回 現場に行かずして現場が見える目の付け所
第22回 複数院経営における三種の神器を教えます
第21回 オーナーが院長に求めるべきは「理念」ただ1つでよい
第19回 ノータッチ分院の3つの疑問をぶつけてみた
《番外編》湯村先生からのメッセージ（アトラアカデミー会員全員視聴可能）≪アトラアカデミー会員全員視聴可能≫分院開業セミナー（2019年1月13日開催）に行ってみた！
自在なの機材・自費・患者さまの情報共有
【総集編】湯村先生の働き方
【総集編】物件の探し方
アトラアカウントでログイン