Array [16]
| 0 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 70 |
| time |
String0.01283290 |
| query |
Stringselect
*
from
v500_contents as v500
where 1 = 1 and contents_target != 30
order by
v500.contents_date desc,
v500.contents_id desc |
| err |
Integer1 |
|
| 1 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 96 |
| time |
String0.02194310 |
| 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','502@article','501@article','475@movie','426@movie','549@movie','505@movie','266@article','241@article','105@article','102@article','500@article','319@article','291@article','408@article','311@article','289@article','331@article','134@article','287@article','34@article','499@article','498@article','497@article','496@article','495@article','494@article','493@article','492@article','491@article','490@article','489@article','488@article','1319@movie','1307@movie','1306@movie','1303@movie','1300@movie','108@movie','506@movie','487@article','428@article','486@article','1036@movie','485@article','1308@movie','1305@movie','484@article','1304@movie','483@article','1299@movie','1298@movie','482@article','1295@movie','1296@movie','481@article','1294@movie','1293@movie','1292@movie','1291@movie','1290@movie','1289@movie','1288@movie','480@article','479@article','478@article','477@article','476@article','475@article','1287@movie','474@article','473@article','471@article','1285@movie','472@article','1284@movie','470@article','469@article','468@article','1005@movie','1006@movie','1003@movie','1004@movie','154@article','335@article','467@article','163@article','396@article','1157@movie','466@article','465@article','294@article','464@article','463@article','462@article','1109@movie','461@article','460@article','459@article','342@article','458@article','457@article','285@article','896@movie','325@article','1132@movie','1131@movie','455@article','454@article','446@article','453@article','318@article','452@article','451@article','1126@movie','1125@movie','1124@movie','1123@movie','1122@movie','1121@movie','1120@movie','450@article','329@article','449@article','448@article','447@article','444@article','443@article','442@article','445@article','441@article','440@article','410@article','439@article','438@article','437@article','436@article','435@article','434@article','421@article','433@article','201@article','432@article','431@article','137@article','351@article','43@article','259@article','1095@movie','41@article','332@article','429@article','427@article','426@article','425@article','424@article','423@article','422@article','420@article','419@article','372@article','312@article','1073@movie','418@article','417@article','416@article','385@article','415@article','413@article','412@article','409@article','407@article','406@article','405@article','404@article','403@article','401@article','402@article','336@article','1043@movie','1042@movie','1041@movie','1040@movie','1039@movie','399@article','1038@movie','398@article','397@article','22@article','279@article','1037@movie','215@article','1034@movie','395@article','394@article','1045@movie','1035@movie','948@movie','947@movie','946@movie','389@article','393@article','382@article','1033@movie','1032@movie','392@article','391@article','383@article','388@article','390@article','387@article','386@article','384@article','381@article','380@article','379@article','377@article','376@article','254@article','375@article','374@article','373@article','976@movie','371@article','1002@movie','370@article','975@movie','987@movie','986@movie','982@movie','368@article','367@article','974@movie','980@movie','979@movie','985@movie','973@movie','984@movie','983@movie','989@movie','978@movie','977@movie','366@article','365@article','364@article','363@article','362@article','361@article','970@movie','962@movie','952@movie','360@article','951@movie','949@movie','950@movie','359@article','358@article','943@movie','357@article','932@movie','356@article','942@movie','354@article','355@article','940@movie','934@movie','353@article','935@movie','937@movie','936@movie','352@article','525@movie','537@movie','528@movie','457@movie','440@movie','439@movie','438@movie','428@movie','427@movie','414@movie','413@movie','412@movie','399@movie','398@movie','397@movie','383@movie','382@movie','381@movie','372@movie','371@movie','370@movie','474@movie','473@movie','472@movie','456@movie','455@movie','425@movie','424@movie','407@movie','406@movie','379@movie','929@movie','933@movie','415@movie','350@article','560@movie','555@movie','928@movie','348@article','519@movie','518@movie','493@movie','492@movie','459@movie','930@movie','927@movie','417@movie','416@movie','410@movie','925@movie','922@movie','924@movie','923@movie','921@movie','346@article','341@article','340@article','338@article','918@movie','917@movie','913@movie','912@movie','904@movie','347@article','345@article','909@movie','487@movie','526@movie','343@article','193@article','903@movie','901@movie','349@article','339@article','874@movie','337@article','873@movie','870@movie','872@movie','344@article','907@movie','863@movie','194@movie','862@movie','908@movie','858@movie','859@movie','851@movie','850@movie','856@movie','910@movie','971@movie','920@movie','919@movie','849@movie','334@article','848@movie','906@movie','845@movie','841@movie','840@movie','839@movie','46@article','838@movie','836@movie','328@article','327@article','304@article','835@movie','322@article','320@article','317@article','45@article','834@movie','825@movie','316@article','314@article','823@movie','315@article','821@movie','822@movie','820@movie','819@movie','313@article','307@article','802@movie','801@movie','800@movie','799@movie','798@movie','797@movie','306@article','39@article','310@article','309@article','308@article','36@article','789@movie','788@movie','774@movie','772@movie','305@article','761@movie','708@movie','600@movie','300@article','299@article','760@movie','298@article','751@movie','750@movie','702@movie','749@movie','296@article','89@article','18@article','747@movie','746@movie','744@movie','741@movie','740@movie','739@movie','738@movie','737@movie','736@movie','735@movie','734@movie','730@movie','721@movie','729@movie','728@movie','725@movie','720@movie','719@movie','715@movie','714@movie','713@movie','709@movie','703@movie','688@movie','687@movie','681@movie','682@movie','610@movie','609@movie','601@movie','595@movie','594@movie','488@movie','502@movie','503@movie','515@movie','516@movie','527@movie','530@movie','531@movie','548@movie','583@movie','590@movie','486@movie','504@movie','442@movie','409@movie','288@article','286@article','284@article','283@article','282@article','281@article','792@movie','280@article','278@article','277@article','276@article','275@article','274@article','272@article','270@article','265@article','264@article','263@article','262@article','261@article','260@article','258@article','253@article','256@article','271@movie','272@movie','255@article','252@article','234@movie','250@article','249@article','248@article','245@article','247@article','224@movie','242@article','244@article','240@article','238@article','236@article','173@article','237@article','233@article','230@article','228@article','227@article','226@article','225@article','205@movie','224@article','223@article','222@article','221@article','220@article','197@movie','218@article','196@movie','217@article','216@article','195@movie','214@article','213@article','172@article','212@article','211@article','210@article','209@article','76@movie','82@movie','71@movie','81@movie','102@movie','103@movie','160@movie','120@movie','169@movie','171@article','207@article','205@article','166@movie','164@movie','110@movie','106@movie','62@movie','204@article','203@article','200@article','198@article','197@article','158@movie','196@article','195@article','194@article','190@article','170@article','192@article','188@article','184@article','181@article','179@article','178@article','176@article','175@article','69@movie','101@movie','98@movie','88@movie','65@movie','147@movie','145@movie','107@movie','92@movie','86@movie','80@movie','74@movie','67@movie','168@article','151@article','150@article','147@article','146@article','145@article','144@article','143@article','142@article','141@article','166@article','136@article','135@article','165@article','130@article','129@article','128@article','127@article','126@article','125@article','124@article','123@article','162@article','121@article','120@article','113@article','108@article','161@article','160@article','112@article','159@article','115@article','111@article','158@article','114@article','110@article','157@article','101@article','100@article','99@article','156@article','97@article','96@article','95@article','155@article','94@article','93@article','153@article','88@article','140@article','87@article','86@article','85@article','139@article','84@article','138@article','83@article','81@article','80@article','76@article','58@article','54@article','35@article','26@article','25@article','24@article','23@article','20@article','16@article','15@article') |
| err |
Integer1 |
|
| 2 |
Array [4]
| file |
String/contents\lib\classes\ContentsTags.class - line 52 |
| time |
String0.39779090 |
| query |
Stringselect
t750.tkey,
t750.tname,
t750.sort,
t750.page_tag_flg
from
t750_tags as t750
join
t760_tags_mapping as t760 on (t750.tkey = t760.tkey)
where
cast(contents_id as nvarchar) + '@' + contents_type in ('508@article','507@article','505@article','506@article','504@article','503@article','502@article','501@article','475@movie','426@movie','549@movie','505@movie','266@article','241@article','105@article','102@article','500@article','319@article','291@article','408@article','311@article','289@article','331@article','134@article','287@article','34@article','499@article','498@article','497@article','496@article','495@article','494@article','493@article','492@article','491@article','490@article','489@article','488@article','1319@movie','1307@movie','1306@movie','1303@movie','1300@movie','108@movie','506@movie','487@article','428@article','486@article','1036@movie','485@article','1308@movie','1305@movie','484@article','1304@movie','483@article','1299@movie','1298@movie','482@article','1295@movie','1296@movie','481@article','1294@movie','1293@movie','1292@movie','1291@movie','1290@movie','1289@movie','1288@movie','480@article','479@article','478@article','477@article','476@article','475@article','1287@movie','474@article','473@article','471@article','1285@movie','472@article','1284@movie','470@article','469@article','468@article','1005@movie','1006@movie','1003@movie','1004@movie','154@article','335@article','467@article','163@article','396@article','1157@movie','466@article','465@article','294@article','464@article','463@article','462@article','1109@movie','461@article','460@article','459@article','342@article','458@article','457@article','285@article','896@movie','325@article','1132@movie','1131@movie','455@article','454@article','446@article','453@article','318@article','452@article','451@article','1126@movie','1125@movie','1124@movie','1123@movie','1122@movie','1121@movie','1120@movie','450@article','329@article','449@article','448@article','447@article','444@article','443@article','442@article','445@article','441@article','440@article','410@article','439@article','438@article','437@article','436@article','435@article','434@article','421@article','433@article','201@article','432@article','431@article','137@article','351@article','43@article','259@article','1095@movie','41@article','332@article','429@article','427@article','426@article','425@article','424@article','423@article','422@article','420@article','419@article','372@article','312@article','1073@movie','418@article','417@article','416@article','385@article','415@article','413@article','412@article','409@article','407@article','406@article','405@article','404@article','403@article','401@article','402@article','336@article','1043@movie','1042@movie','1041@movie','1040@movie','1039@movie','399@article','1038@movie','398@article','397@article','22@article','279@article','1037@movie','215@article','1034@movie','395@article','394@article','1045@movie','1035@movie','948@movie','947@movie','946@movie','389@article','393@article','382@article','1033@movie','1032@movie','392@article','391@article','383@article','388@article','390@article','387@article','386@article','384@article','381@article','380@article','379@article','377@article','376@article','254@article','375@article','374@article','373@article','976@movie','371@article','1002@movie','370@article','975@movie','987@movie','986@movie','982@movie','368@article','367@article','974@movie','980@movie','979@movie','985@movie','973@movie','984@movie','983@movie','989@movie','978@movie','977@movie','366@article','365@article','364@article','363@article','362@article','361@article','970@movie','962@movie','952@movie','360@article','951@movie','949@movie','950@movie','359@article','358@article','943@movie','357@article','932@movie','356@article','942@movie','354@article','355@article','940@movie','934@movie','353@article','935@movie','937@movie','936@movie','352@article','525@movie','537@movie','528@movie','457@movie','440@movie','439@movie','438@movie','428@movie','427@movie','414@movie','413@movie','412@movie','399@movie','398@movie','397@movie','383@movie','382@movie','381@movie','372@movie','371@movie','370@movie','474@movie','473@movie','472@movie','456@movie','455@movie','425@movie','424@movie','407@movie','406@movie','379@movie','929@movie','933@movie','415@movie','350@article','560@movie','555@movie','928@movie','348@article','519@movie','518@movie','493@movie','492@movie','459@movie','930@movie','927@movie','417@movie','416@movie','410@movie','925@movie','922@movie','924@movie','923@movie','921@movie','346@article','341@article','340@article','338@article','918@movie','917@movie','913@movie','912@movie','904@movie','347@article','345@article','909@movie','487@movie','526@movie','343@article','193@article','903@movie','901@movie','349@article','339@article','874@movie','337@article','873@movie','870@movie','872@movie','344@article','907@movie','863@movie','194@movie','862@movie','908@movie','858@movie','859@movie','851@movie','850@movie','856@movie','910@movie','971@movie','920@movie','919@movie','849@movie','334@article','848@movie','906@movie','845@movie','841@movie','840@movie','839@movie','46@article','838@movie','836@movie','328@article','327@article','304@article','835@movie','322@article','320@article','317@article','45@article','834@movie','825@movie','316@article','314@article','823@movie','315@article','821@movie','822@movie','820@movie','819@movie','313@article','307@article','802@movie','801@movie','800@movie','799@movie','798@movie','797@movie','306@article','39@article','310@article','309@article','308@article','36@article','789@movie','788@movie','774@movie','772@movie','305@article','761@movie','708@movie','600@movie','300@article','299@article','760@movie','298@article','751@movie','750@movie','702@movie','749@movie','296@article','89@article','18@article','747@movie','746@movie','744@movie','741@movie','740@movie','739@movie','738@movie','737@movie','736@movie','735@movie','734@movie','730@movie','721@movie','729@movie','728@movie','725@movie','720@movie','719@movie','715@movie','714@movie','713@movie','709@movie','703@movie','688@movie','687@movie','681@movie','682@movie','610@movie','609@movie','601@movie','595@movie','594@movie','488@movie','502@movie','503@movie','515@movie','516@movie','527@movie','530@movie','531@movie','548@movie','583@movie','590@movie','486@movie','504@movie','442@movie','409@movie','288@article','286@article','284@article','283@article','282@article','281@article','792@movie','280@article','278@article','277@article','276@article','275@article','274@article','272@article','270@article','265@article','264@article','263@article','262@article','261@article','260@article','258@article','253@article','256@article','271@movie','272@movie','255@article','252@article','234@movie','250@article','249@article','248@article','245@article','247@article','224@movie','242@article','244@article','240@article','238@article','236@article','173@article','237@article','233@article','230@article','228@article','227@article','226@article','225@article','205@movie','224@article','223@article','222@article','221@article','220@article','197@movie','218@article','196@movie','217@article','216@article','195@movie','214@article','213@article','172@article','212@article','211@article','210@article','209@article','76@movie','82@movie','71@movie','81@movie','102@movie','103@movie','160@movie','120@movie','169@movie','171@article','207@article','205@article','166@movie','164@movie','110@movie','106@movie','62@movie','204@article','203@article','200@article','198@article','197@article','158@movie','196@article','195@article','194@article','190@article','170@article','192@article','188@article','184@article','181@article','179@article','178@article','176@article','175@article','69@movie','101@movie','98@movie','88@movie','65@movie','147@movie','145@movie','107@movie','92@movie','86@movie','80@movie','74@movie','67@movie','168@article','151@article','150@article','147@article','146@article','145@article','144@article','143@article','142@article','141@article','166@article','136@article','135@article','165@article','130@article','129@article','128@article','127@article','126@article','125@article','124@article','123@article','162@article','121@article','120@article','113@article','108@article','161@article','160@article','112@article','159@article','115@article','111@article','158@article','114@article','110@article','157@article','101@article','100@article','99@article','156@article','97@article','96@article','95@article','155@article','94@article','93@article','153@article','88@article','140@article','87@article','86@article','85@article','139@article','84@article','138@article','83@article','81@article','80@article','76@article','58@article','54@article','35@article','26@article','25@article','24@article','23@article','20@article','16@article','15@article')
group by
t750.tkey,
t750.tname,
t750.sort,
t750.page_tag_flg
order by
t750.sort,
t750.tkey desc |
| err |
Integer1 |
|
| 3 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 70 |
| time |
String0.09802890 |
| 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 18 offset 540 |
| err |
Integer1 |
|
| 4 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 96 |
| time |
String0.06285120 |
| 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 ('213@article','172@article','212@article','211@article','210@article','209@article','76@movie','82@movie','71@movie','81@movie','102@movie','103@movie','160@movie','120@movie','169@movie','171@article','207@article','205@article') |
| err |
Integer1 |
|
| 5 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00593210 |
| query |
Stringselect
count(v500.contents_id) as cnt
from
v500_contents as v500
where 1 = 1 and contents_target != 30 |
|
| 6 |
Array [4]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 70 |
| time |
String0.02061990 |
| 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 18 offset 540 |
| err |
Integer1 |
|
| 7 |
Array [3]
| file |
StringC:\home\site\wwwroot\contents\lib\classes\ContentsListCore.class - line 96 |
| time |
String0.00550580 |
| 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 ('213@article','172@article','212@article','211@article','210@article','209@article','76@movie','82@movie','71@movie','81@movie','102@movie','103@movie','160@movie','120@movie','169@movie','171@article','207@article','205@article') |
|
| 8 |
Array [3]
| file |
StringC:\home\site\wwwroot\module\classes\MYDB.class - line 160 |
| time |
String0.00548100 |
| query |
Stringselect
count(v500.contents_id) as cnt
from
v500_contents as v500
where 1 = 1 and contents_target != 30 |
|
| 9 |
Array [3]
| file |
String/column\lib\classes\ArticleCategoryList.class - line 66 |
| time |
String0.00212190 |
| query |
Stringselect
*
from
t500_article
where
status = 1 and
ckey not in(4) |
|
| 10 |
Array [3]
| file |
String/column\lib\classes\ArticleCategoryList.class - line 36 |
| time |
String0.00260500 |
| query |
Stringselect
*
from
t510_category
where 1 = 1 and list_flg = 1 and ckey = :ckey1: or ckey = :ckey2: or ckey = :ckey3: or ckey = :ckey4: or ckey = :ckey5: or ckey = :ckey6: or ckey = :ckey7: or ckey = :ckey8: or ckey = :ckey9: or ckey = :ckey10: or ckey = :ckey11: or ckey = :ckey12: and chkey in (select chkey from t200_channel where status = 1)
order by
sort
asc |
|
| 11 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 139 |
| time |
String0.00789310 |
| 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 |
|
| 12 |
Array [3]
| file |
StringC:\home\site\wwwroot\seminar\lib\classes\SeminarListCore.class - line 149 |
| time |
String0.00872110 |
| 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 [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 44 |
| time |
String0.00831600 |
| 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 |
|
| 14 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 72 |
| time |
String0.00203800 |
| 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 |
|
| 15 |
Array [3]
| file |
String/seminar\lib\classes\LimitedSeminarList.class - line 74 |
| time |
String0.00155500 |
| 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 |
|
|
