| 0.0001 |
SELECT *
FROM `cb_board`
WHERE `brd_key` = 'hb2'
LIMIT 1
|
| 0.0001 |
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 = 16 AND post_notice = 1) OR post_notice = 2)
AND `post_del` <> 2
ORDER BY `post_num`, `post_reply`
|
| 0.0004 |
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 `cb_post`.`brd_id` = '16'
AND `post_del` <> 2
AND (
`post_category` = 2
OR `post_category` LIKE '2.%' ESCAPE '!'
)
ORDER BY `post_category` asc, `post_datetime` asc
LIMIT 20
|
| 0.0002 |
SELECT count(*) as rownum
FROM `cb_post`
LEFT JOIN `cb_member` ON `cb_post`.`mem_id` = `cb_member`.`mem_id`
WHERE `cb_post`.`brd_id` = '16'
AND `post_del` <> 2
AND (
`post_category` = 2
OR `post_category` LIKE '2.%' ESCAPE '!'
)
|
| 0.0005 |
INSERT INTO cb_stat_count_board (scb_date, brd_id, scb_count) VALUES ('2023-09-21', '16', 1) ON DUPLICATE KEY UPDATE scb_count= scb_count + 1
|
| 0.0001 |
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 = 'http://www.triplecores.com/board/hb2' or m.men_link = 'http://www.triplecores.com/board/hb2' or m.men_link = '/board/hb2' or m.men_link = '/board/hb2?'
ORDER BY men_parent
DESC LIMIT 1;
|
| 0.0005 |
REPLACE INTO `cb_currentvisitor` (`cur_ip`, `mem_id`, `cur_mem_name`, `cur_datetime`, `cur_page`, `cur_url`, `cur_referer`, `cur_useragent`) VALUES ('44.192.254.173', 0, '', '2023-09-21 21:25:24', 'Certificate and Patents - Triple Cores Technology', 'http://www.triplecores.com/board/hb2?category_id=2', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
|
| 0.0079 |
SELECT count(*) as rownum
FROM `cb_currentvisitor`
LEFT JOIN `cb_member` ON `cb_currentvisitor`.`mem_id` = `cb_member`.`mem_id`
WHERE `cur_datetime` > '2023-09-21 21:15:24'
AND (
`cb_member`.`mem_is_admin` = 0
OR `cb_member`.`mem_is_admin` IS NULL
)
|
| 0.0004 |
INSERT INTO `cb_stat_count` (`sco_ip`, `sco_date`, `sco_time`, `sco_referer`, `sco_current`, `sco_agent`) VALUES ('44.192.254.173', '2023-09-21', '21:25:24', '', 'http://www.triplecores.com/board/hb2?category_id=2', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
|
| 0.0003 |
INSERT INTO cb_stat_count_date (scd_date, scd_count) VALUES ('2023-09-21', 1) ON DUPLICATE KEY UPDATE scd_count= scd_count + 1
|