Query : update artistdesc set hit = hit + 1 where no=15; : 0.2 ms : [line : 212] : /home1/www/dev/lib/connection.php [line : 27] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from artistdesc where no=15 [const/]:PRIMARY in PRIMARY (1) : 0.3 ms : [line : 246] : /home1/www/dev/lib/connection.php [line : 31] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from store where no=15 [const/]:PRIMARY in PRIMARY,idx_memberno (1) : 0.6 ms : [line : 246] : /home1/www/dev/lib/connection.php [line : 32] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(no) as con from art where artist=15 and display='Y' [ref/Using where]:idx_artist in idx_artist (26) : 0.9 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 1151] : /home1/www/dev/lib/system.php [line : 33] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(no) as con from ebook where editor=15 and status='ready' [ref/Using where]:idx_editor in idx_editor (2) : 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 1151] : /home1/www/dev/lib/system.php [line : 37] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(no) as con from easytalk where memberno=15 and type < 3 [ref/Using where]:idx_member in type,idx_member,blog (1) : 0.7 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 1151] : /home1/www/dev/lib/system.php [line : 42] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(a.no) as con from art a join fav_list f on a.no = f.artno where f.memberno=15 [ref/Using index]:memberno in memberno,idx_artno (82) : 3.2 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 1151] : /home1/www/dev/lib/system.php [line : 46] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from memberadds where no=15 [const/]:PRIMARY in PRIMARY (1) : 0.3 ms : [line : 246] : /home1/www/dev/lib/connection.php [line : 56] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from user_css where memberno = 15 [ref/]:memberno in memberno,memberno_2,idx_mname (13) : 1 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 52] : /home1/www/dev/lib/skin.php [line : 66] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from art where artist=15; [ref/]:idx_artist in idx_artist (26) : 13 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 375] : /home1/www/dev/lib/user.php [line : 80] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select f.tag as tag , a.title as title from art a join fav_list f on a.no = f.artno where f.memberno =15; [ref/]:memberno in memberno,idx_artno (82) : 12.6 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 420] : /home1/www/dev/lib/user.php [line : 81] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select a.artistno as artistno , a.nickname as nickname from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno order by a.regdate desc limit 8; [index/Using where]:idx_reg in PRIMARY (192) : 2.3 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 86] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(a.artistno) as con from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno; [ref/Using index]:PRIMARY in PRIMARY (292) : 1.2 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 88] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select b.nickname as nickname , b.artistno as artistno from beholdartist b where b.memberno=15 and b.artistno not in (select a.artistno as artistno from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno ) order by b.regdate desc limit 8; [index/Using where]:idx_reg in PRIMARY (192) : 1.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 96] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(b.artistno) as con from beholdartist b where b.memberno=15 and b.artistno not in (select a.artistno as artistno from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno ) ; [ref/Using where; Using index]:PRIMARY in PRIMARY (292) : 2.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 98] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select b.snickname as snickname , b.memberno as memberno from beholdartist b where b.artistno=15 and b.memberno not in (select a.artistno as artistno from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno ) order by b.regdate desc limit 8; [index/Using where]:idx_reg in (8) : 7.8 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 106] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select count(b.memberno) as con from beholdartist b where b.artistno=15 and b.memberno not in (select a.artistno as artistno from beholdartist a, beholdartist b where a.memberno=15 and b.artistno=15 and a.artistno = b.memberno ) ; [index/Using where; Using index]:idx_reg in (7016) : 3 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 108] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from beholdartist where memberno=0 and artistno=15 [/Impossible WHERE noticed after reading const tables]: in () : 0.4 ms : [line : 246] : /home1/www/dev/lib/connection.php [line : 113] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from artist_category where memberno=15 order by rank asc ; [ref/Using where]:PRIMARY in PRIMARY (2) : 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1184] : /home1/www/dev/lib/system.php [line : 116] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select b.grpno as grpno , a.actiondate as actiondate from group_member b left outer join group_actions a on a.grpno = b.grpno and a.action='submit' where b.memberno=15 order by b.grpno asc; [index/Using where; Using index]:PRIMARY in (5687) : 2.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 898] : /home1/www/dev/lib/user.php [line : 123] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select type , no,name,url,imgsrc from group_info where no in (1,5,8,9,10,12,13,14,16,17); [ALL/Using where]: in PRIMARY (16) : 0.7 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 908] : /home1/www/dev/lib/user.php [line : 123] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : (select 'recv' as subject, c.no as cmtno , '' as imgsrc1 , '0' as objtype , c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden , c.regdate as regdate, 'artist' as type , c.memberno as who , c.nickname as whonick, m.no as whom , m.nickname as whomnick, m.nickname as title , c.artistno as what , 'text' as how , c.comment as action from artistcomment c join member m on c.artistno = m.no where c.artistno != c.memberno and c.artistno = 15 and c.hidden = 'N' and c.regdate >= '2012-05-17 00:00:01' order by c.threadno desc , c.orderno asc) union all (select 'recv' as subject, 0 as cmtno , '' as imgsrc1 , '0' as objtype , 0 as threadno , 0 as orderno , 0 as depth, 'N' as hidden , c.regdate as regdate, 'artist' as type , c.memberno as who, c.snickname as whonick, c.memberno as whom , c.nickname as whomnick, c.nickname as title , c.artistno as what , 'id' as how , 'BECOMEAFAN' as action from beholdartist c where c.artistno = 15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'recv' as subject, c.no as cmtno , a.imgsrc1 as imgsrc1 , a.type as objtype , c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden , c.regdate as regdate, 'art' as type , c.memberno as who , c.nickname as whonick, a.artist as whom , a.nickname as whomnick, a.title as title , c.artno as what , 'text' as how , c.comment as action from artcomment c join art a on c.artno = a.no where a.artist =15 and c.hidden = 'N' and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'recv' as subject, 0 as cmtno , a.imgsrc1 as imgsrc1 , a.type as objtype , 0 as threadno , 0 as orderno , 0 as depth, 'N' as hidden, c.regdate as regdate, 'art' as type , c.memberno as who , m.nickname as whonick, c.memberno as whom , a.nickname as whomnick, a.title as title , c.artno as what , 'id' as how , 'ADDTOFAVORITE' as action from fav_list c , art a , member m where c.artno = a.no and m.no = c.memberno and a.artist =15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'recv' as subject, 0 as cmtno , '' as imgsrc1 , '1' as objtype , c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden , c.regdate as regdate, 'minilog' as type , c.memberno as who , c.nickname as whonick, a.memberno as whom , a.nickname as whomnick, a.title as title , c.postno as what , 'text' as how , c.comment as action from minilogcomment c , easytalk a where c.postno = a.no and a.memberno =15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'sent' as subject, c.no as cmtno , '' as imgsrc1 , '0' as objtype, c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden ,c.regdate as regdate, 'artist' as type , c.memberno as who , c.nickname as whonick, m.no as whom , m.nickname as whomnick, m.nickname as title , c.artistno as what , 'text' as how , c.comment as action from artistcomment c join member m on c.artistno = m.no where c.artistno != 15 and c.memberno =15 and c.hidden = 'N' and c.regdate >= '2012-05-17 00:00:01' order by c.threadno desc , c.orderno asc) union all (select 'sent' as subject,0 as cmtno , '' as imgsrc1 , '0' as objtype, 0 as threadno , 0 as orderno , 0 as depth, 'N' as hidden ,c.regdate as regdate, 'artist' as type , c.memberno as who, c.snickname as whonick, c.artistno as whom , c.nickname as whomnick, c.nickname as title , c.artistno as what , 'id' as how , 'BECOMEAFAN' as action from beholdartist c where c.memberno = 15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'sent' as subject,c.no as cmtno , a.imgsrc1 as imgsrc1 , a.type as objtype, c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden , c.regdate as regdate, 'art' as type , c.memberno as who , c.nickname as whonick, a.artist as whom , a.nickname as whomnick, a.title as title , c.artno as what , 'text' as how , c.comment as action from artcomment c join art a on c.artno = a.no where a.artist != 15 and c.memberno =15 and c.hidden = 'N' and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'sent' as subject,0 as cmtno , a.imgsrc1 as imgsrc1 , a.type as objtype, 0 as threadno , 0 as orderno , 0 as depth, 'N' as hidden, c.regdate as regdate, 'art' as type , c.memberno as who , m.nickname as whonick, 15 as whom , a.nickname as whomnick, a.title as title , c.artno as what , 'id' as how , 'ADDTOFAVORITE' as action from fav_list c , art a , member m where m.no = c.memberno and c.artno = a.no and c.memberno =15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) union all (select 'sent' as subject,0 as cmtno , '' as imgsrc1 , '1' as objtype, c.threadno as threadno , c.orderno as orderno , c.depth as depth, c.hidden as hidden , c.regdate as regdate, 'minilog' as type , c.memberno as who , c.nickname as whonick, a.memberno as whom , a.nickname as whomnick, a.title as title , c.postno as what , 'text' as how , c.comment as action from minilogcomment c , easytalk a where a.memberno != 15 and c.postno = a.no and c.memberno =15 and c.regdate >= '2012-05-17 00:00:01' order by c.regdate desc) order by regdate desc limit 0,1; [const/]:PRIMARY in PRIMARY (1) : 3.2 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1014] : /home1/www/dev/lib/user.php [line : 128] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select no from art where artist=15 and display = 'Y' and regdate >='2012-05-24 02:32:58' limit 1; [range/Using where]:idx_reg in idx_artist,idx_reg (1) : 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 131] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select no from fav_list where memberno=15 and regdate >='2012-05-24 02:32:58' limit 1; [range/Using where]:idx_reg in memberno,idx_reg (1) : 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 137] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select no from easytalk where memberno=15 and regdate >='2012-05-24 02:32:58' limit 1; [ref/Using where]:idx_member in idx_member,idx_regdate,blog (1) : 0.7 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 143] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select no from ebook where editor=15 and regdate >='' limit 1; [ref/Using where]:idx_editor in idx_editor (2) : 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 149] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : (select count(distinct itemcode) as cnt from custom_product_set where seller=15 and type in ('sell' ) and regdate >= '2012-05-09 00:00:00' ) union all (select count(itemcode) as cnt from premade_product_set where seller=15 and type in ('sell' ) and regdate >= '2012-05-09 00:00:00') [ALL/Using where]: in idx_regdate_type (4803) : 5.5 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 1165] : /home1/www/dev/lib/system.php [line : 168] : /home1/www/dev/inc/artist_header.php [line : 5] : /home1/www/dev/pages/artistview.php
Query : select * from art a join featured_list f on a.no = f.artno where f.memberno= 15 order by f.ordno asc; [ref/Using where; Using filesort]:PRIMARY in PRIMARY (2) : 0.9 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 70] : /home1/www/dev/pages/artistview.php
Query : select artno , count(no) as cnt from artcomment where artno in (20287,20301) group by artno [range/Using where; Using index]:idx_artistno in idx_artistno (10) : 0.6 ms : [line : 278] : /home1/www/dev/lib/connection.php [line : 178] : /home1/www/dev/lib/art.php [line : 92] : /home1/www/dev/pages/artistview.php
ARTWORK
HANDMADE
DESIGNSHOW
GROUP
Become a fan 
Leave a message 
Invite 
