| 0.0003 |
SELECT *
FROM `cb_post`
WHERE `post_id` = 1754
LIMIT 1
|
| 0.0036 |
SELECT *
FROM `cb_post_extra_vars`
WHERE `post_id` = 1754
|
| 0.0004 |
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.0019 |
INSERT INTO cb_stat_count_board (scb_date, brd_id, scb_count) VALUES ('2026-08-20', '9', 1) ON DUPLICATE KEY UPDATE scb_count= scb_count + 1
|
| 0.0011 |
UPDATE `cb_post` SET post_hit = post_hit+1
WHERE `post_id` = 1754
|
| 0.0001 |
SELECT `mem_icon`
FROM `cb_member`
WHERE `mem_id` = 2
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `cb_post_link`
WHERE `post_id` = 1754
ORDER BY `pln_id` ASC
|
| 0.0001 |
SELECT *
FROM `cb_post_file`
WHERE `post_id` = 1754
ORDER BY `pfi_id` ASC
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `cb_scrap`
WHERE `post_id` = '1754'
|
| 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` > '-1691'
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` < '-1691'
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.216.223', 0, '', '2026-08-20 20:29:25', '111회 고창 일원 > 답사 - 충북대학교 박물관', 'https://museum.chungbuk.ac.kr/post/1754', '', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
|
| 0.0333 |
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-20 20:19:25'
AND (
`cb_member`.`mem_is_admin` = 0
OR `cb_member`.`mem_is_admin` IS NULL
)
|
| 0.0012 |
INSERT INTO `cb_stat_count` (`sco_ip`, `sco_date`, `sco_time`, `sco_referer`, `sco_current`, `sco_agent`) VALUES ('216.73.216.223', '2026-08-20', '20:29:25', '', 'https://museum.chungbuk.ac.kr/post/1754', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
|
| 0.0011 |
INSERT INTO cb_stat_count_date (scd_date, scd_count) VALUES ('2026-08-20', 1) ON DUPLICATE KEY UPDATE scd_count= scd_count + 1
|
