| 0.0003 |
SELECT *
FROM `cb_post`
WHERE `post_id` = 282
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `cb_post_meta`
WHERE `post_id` = 282
|
| 0.0003 |
SELECT IF(m.men_parent <> 0,
(
SELECT IF(m2.men_parent <> 0,
(
SELECT CONCAT(m3.men_id,'^^',m3.men_name,'^^',m3.men_link,'>>>',m2.men_id,'^^',m2.men_name,'^^',m2.men_link,'>>>',m.men_id,'^^',m.men_name,'^^',m.men_link)
FROM cb_menu m3
WHERE m3.men_id = m2.men_parent
),
CONCAT(m2.men_id,'^^',m2.men_name,'^^',m2.men_link,'>>>',m.men_id,'^^',m.men_name,'^^',m.men_link))
FROM cb_menu m2
WHERE m2.men_id = m.men_parent), CONCAT(m.men_id,'^^',m.men_name,'^^',m.men_link)
) as cate_list
FROM cb_menu m
WHERE m.men_link = 'https://museum.chungbuk.ac.kr/board/eb2' or m.men_link = 'http://museum.chungbuk.ac.kr/board/eb2' or m.men_link = '/board/eb2' or m.men_link = '/board/eb2?'
ORDER BY men_parent
DESC LIMIT 1;
|
| 0.0017 |
UPDATE `cb_post` SET post_hit = post_hit+1
WHERE `post_id` = 282
|
| 0.0001 |
SELECT `mem_icon`
FROM `cb_member`
WHERE `mem_id` = 1
LIMIT 1
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `cb_scrap`
WHERE `post_id` = '282'
|
| 0.0003 |
SELECT `cb_post`.*, `cb_member`.`mem_id`, `cb_member`.`mem_userid`, `cb_member`.`mem_nickname`, `cb_member`.`mem_icon`, `cb_member`.`mem_photo`, `cb_member`.`mem_point`
FROM `cb_post`
LEFT JOIN `cb_member` ON `cb_post`.`mem_id` = `cb_member`.`mem_id`
WHERE `brd_id` = '9'
AND `post_del` <> 2
AND `post_secret` = 0
AND `post_num` > '-282'
ORDER BY `post_num`, `post_reply`
LIMIT 1
|
| 0.0002 |
SELECT `cb_post`.*, `cb_member`.`mem_id`, `cb_member`.`mem_userid`, `cb_member`.`mem_nickname`, `cb_member`.`mem_icon`, `cb_member`.`mem_photo`, `cb_member`.`mem_point`
FROM `cb_post`
LEFT JOIN `cb_member` ON `cb_post`.`mem_id` = `cb_member`.`mem_id`
WHERE `brd_id` = '9'
AND `post_del` <> 2
AND `post_secret` = 0
AND `post_num` < '-282'
ORDER BY `post_num` desc, `post_reply` desc
LIMIT 1
|
| 0.0012 |
REPLACE INTO `cb_currentvisitor` (`cur_ip`, `mem_id`, `cur_mem_name`, `cur_datetime`, `cur_page`, `cur_url`, `cur_referer`, `cur_useragent`) VALUES ('216.73.217.39', 0, '', '2026-08-21 09:05:54', '23회 충남 서산ㆍ예산일원 > 답사 - 충북대학교 박물관', 'https://museum.chungbuk.ac.kr/post/282', '', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
|
| 0.0338 |
SELECT count(*) as rownum
FROM `cb_currentvisitor`
LEFT JOIN `cb_member` ON `cb_currentvisitor`.`mem_id` = `cb_member`.`mem_id`
WHERE `cur_datetime` > '2026-08-21 08:55:54'
AND (
`cb_member`.`mem_is_admin` = 0
OR `cb_member`.`mem_is_admin` IS NULL
)
|
