Profiling Summary Report (Time: 2.14998s, Memory: 21,111KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `view_shelf_music` `t` WHERE catesub_id=:catesub_id AND SongActive=1 AND status="P" AND (FLV_MV=1 OR URLmv_YOUTUBE != "" OR URLmv_Dailymotion != "" ) ORDER BY weight DESC LIMIT 18 OFFSET 36) 1 0.86175 0.86175 0.86175 0.86175
system.db.CDbCommand.query(SELECT COUNT(*) FROM `view_shelf_music` `t` WHERE catesub_id=:catesub_id AND SongActive=1 AND status="P" AND (FLV_MV=1 OR URLmv_YOUTUBE != "" OR URLmv_Dailymotion != "" )) 1 0.59575 0.59575 0.59575 0.59575
system.db.CDbCommand.query(SELECT gmmd_code,cover,mv_youtube,chord_guitar,chord_ukulele,code_download,text_song,text_mv FROM `gm_music` `t` WHERE gmmd_code=:gmmd_code AND status="P" LIMIT 1) 18 0.01095 0.00061 0.00053 0.00075
system.db.CDbCommand.query(SELECT GMMD_CODE, AlbumId, SongNameTH,AlbumNameTH, ArtistConceptName_CallName FROM `dcpview` `t` WHERE GMMD_CODE=:GMMD_CODE AND SongActive=1 LIMIT 1) 12 0.00805 0.00067 0.00062 0.00076
ads 1 0.00283 0.00283 0.00283 0.00283
system.db.CDbCommand.query(SELECT * FROM `gm_seo_metatag` `t` WHERE page_code=:page_code LIMIT 1) 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT * FROM `gm_ads_network` `t` WHERE section_id=:section_id and position=:position AND status='P' LIMIT 1) 1 0.00079 0.00079 0.00079 0.00079