0.0003 |
LOCK TABLES v2_member_conn WRITE
|
0.0005 |
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='3b3ffe6a6d601b928b6d02657fc1a354' and member_id=''
|
0.0003 |
insert into v2_member_conn (session_id,member_id,conn_time) values ('3b3ffe6a6d601b928b6d02657fc1a354','',now())
|
0.0002 |
UNLOCK TABLES
|
0.0003 |
update v2_connect_log set wdate=now(), referer='',keyword='',host='',remote_addr='44.211.24.175' where sessid='3b3ffe6a6d601b928b6d02657fc1a354'
|
0.0004 |
insert into v2_connect_log (sessid,menu_code,wdate,referer,keyword,host,link_gbn,remote_addr) values ('3b3ffe6a6d601b928b6d02657fc1a354','main',now(),'','','','','44.211.24.175')
|
0.0002 |
insert into v2_counter_log (menu_code,wdate,remote_addr) values ('main',now(),'44.211.24.175')
|
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.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='free' 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='postscript' order by a.sort_no desc limit 5
|
0.0005 |
select position, subject, linkurl, target, upfile, width, height from v2_banner where output_yn = 'Y' order by pid desc
|