0.0002 |
LOCK TABLES v2_member_conn WRITE
|
0.0004 |
delete from v2_member_conn where conn_time < date_sub(now(), interval 5 minute)
|
0.0003 |
select count(*) from v2_member_conn where session_id='96d8ab6409b611a4b09aaa282a895eb4' and member_id=''
|
0.0002 |
insert into v2_member_conn (session_id,member_id,conn_time) values ('96d8ab6409b611a4b09aaa282a895eb4','',now())
|
0.0002 |
UNLOCK TABLES
|
0.0003 |
update v2_connect_log set wdate=now(), referer='',keyword='',host='',remote_addr='18.97.9.168' where sessid='96d8ab6409b611a4b09aaa282a895eb4'
|
0.0004 |
insert into v2_connect_log (sessid,menu_code,wdate,referer,keyword,host,link_gbn,remote_addr) values ('96d8ab6409b611a4b09aaa282a895eb4','main',now(),'','','','','18.97.9.168')
|
0.0002 |
insert into v2_counter_log (menu_code,wdate,remote_addr) values ('main',now(),'18.97.9.168')
|
0.0003 |
update v2_daily_counter set counter=counter+1 where ymd=date_format(now(),'%Y-%m-%d')
|
0.0005 |
select * from v2_popup where use_yn='Y' and now() between sdatetime and edatetime order by edatetime asc
|
0.0006 |
select a.board_no as no, a.member_id, a.writer, a.subject, a.wdate, a.wtime, concat(a.wdate,' ',a.wtime) as wdatetime, unix_timestamp(concat(a.wdate,' ',a.wtime)) as wtimestamp, a.parent, a.depth, a.sort_no, b.file_name, b.full_path from v2_board_data a LEFT JOIN v2_board_upfiles b ON a.board_id = b.board_id and a.board_no = b.board_no and b.file_no = 1 where a.board_id='notice' order by a.sort_no desc limit 5
|
0.0005 |
select a.board_no as no, a.member_id, a.writer, a.subject, a.wdate, a.wtime, concat(a.wdate,' ',a.wtime) as wdatetime, unix_timestamp(concat(a.wdate,' ',a.wtime)) as wtimestamp, a.parent, a.depth, a.sort_no, b.file_name, b.full_path from v2_board_data a LEFT JOIN v2_board_upfiles b ON a.board_id = b.board_id and a.board_no = b.board_no and b.file_no = 1 where a.board_id='free' order by a.sort_no desc limit 5
|
0.0004 |
select a.board_no as no, a.member_id, a.writer, a.subject, a.wdate, a.wtime, concat(a.wdate,' ',a.wtime) as wdatetime, unix_timestamp(concat(a.wdate,' ',a.wtime)) as wtimestamp, a.parent, a.depth, a.sort_no, b.file_name, b.full_path from v2_board_data a LEFT JOIN v2_board_upfiles b ON a.board_id = b.board_id and a.board_no = b.board_no and b.file_no = 1 where a.board_id='postscript' order by a.sort_no desc limit 5
|
0.0006 |
select position, subject, linkurl, target, upfile, width, height from v2_banner where output_yn = 'Y' order by pid desc
|