| 0.0002 |
SELECT *
FROM `cb_post`
WHERE `post_id` = 12278
LIMIT 1
|
| 0.0000 |
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.0004 |
INSERT INTO cb_stat_count_board (scb_date, brd_id, scb_count) VALUES ('2023-12-07', '16', 1) ON DUPLICATE KEY UPDATE scb_count= scb_count + 1
|
| 0.0006 |
UPDATE `cb_post` SET post_hit = post_hit+1
WHERE `post_id` = 12278
|
| 0.0000 |
SELECT `mem_icon`
FROM `cb_member`
WHERE `mem_id` = 1
LIMIT 1
|
| 0.0000 |
SELECT *
FROM `cb_board_category`
WHERE `brd_id` = 16
ORDER BY `bca_order` ASC
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `cb_scrap`
WHERE `post_id` = '12278'
|
| 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` = '16'
AND `post_del` <> 2
AND `post_secret` = 0
AND `post_num` > '-12278'
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` = '16'
AND `post_del` <> 2
AND `post_secret` = 0
AND `post_num` < '-12278'
ORDER BY `post_num` desc, `post_reply` 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 ('34.228.52.21', 0, '', '2023-12-07 11:28:42', 'Patent > Certificate and Patents - Triple Cores Technology', 'http://www.triplecores.com/post/12278', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
|
| 0.0096 |
SELECT count(*) as rownum
FROM `cb_currentvisitor`
LEFT JOIN `cb_member` ON `cb_currentvisitor`.`mem_id` = `cb_member`.`mem_id`
WHERE `cur_datetime` > '2023-12-07 11:18:42'
AND (
`cb_member`.`mem_is_admin` = 0
OR `cb_member`.`mem_is_admin` IS NULL
)
|
| 0.0001 |
SELECT *
FROM `cb_menu`
WHERE men_link not like '%_cn'
AND `men_desktop` = 1
ORDER BY `men_order` ASC
|
| 0.0004 |
INSERT INTO `cb_stat_count` (`sco_ip`, `sco_date`, `sco_time`, `sco_referer`, `sco_current`, `sco_agent`) VALUES ('34.228.52.21', '2023-12-07', '11:28:42', '', 'http://www.triplecores.com/post/12278', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
|
| 0.0003 |
INSERT INTO cb_stat_count_date (scd_date, scd_count) VALUES ('2023-12-07', 1) ON DUPLICATE KEY UPDATE scd_count= scd_count + 1
|
