| 0.0002 |
LOCK TABLES v2_member_conn WRITE
|
| 0.0003 |
delete from v2_member_conn where conn_time < date_sub(now(), interval 5 minute)
|
| 0.0002 |
select count(*) from v2_member_conn where session_id='7d9ce258fb710e65619eedb901f5abb5' and member_id=''
|
| 0.0003 |
insert into v2_member_conn (session_id,member_id,conn_time) values ('7d9ce258fb710e65619eedb901f5abb5','',now())
|
| 0.0002 |
UNLOCK TABLES
|
| 0.0003 |
update v2_connect_log set wdate=now(), referer='http://mj-soft.co.kr/BBSv2/www',keyword='',host='mj-soft.co.kr',remote_addr='3.23.102.124' where sessid='7d9ce258fb710e65619eedb901f5abb5'
|
| 0.0005 |
insert into v2_connect_log (sessid,menu_code,wdate,referer,keyword,host,link_gbn,remote_addr) values ('7d9ce258fb710e65619eedb901f5abb5','main',now(),'http://mj-soft.co.kr/BBSv2/www','','mj-soft.co.kr','','3.23.102.124')
|
| 0.0002 |
insert into v2_counter_log (menu_code,wdate,remote_addr) values ('main',now(),'3.23.102.124')
|
| 0.0003 |
update v2_daily_counter set counter=counter+1 where ymd=date_format(now(),'%Y-%m-%d')
|
| 0.0006 |
select * from v2_popup where use_yn='Y' and now() between sdatetime and edatetime order by edatetime asc
|
| 0.0008 |
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.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.0008 |
select
position,
subject,
linkurl,
target,
upfile,
width,
height
from
v2_banner
where
output_yn = 'Y'
order by pid desc
|
