| 0.0002 |
SELECT *
FROM `cb_document`
WHERE `doc_key` = 'a004'
LIMIT 1
|
| 0.0005 |
UPDATE `cb_document` SET doc_hit = doc_hit+1
WHERE `doc_id` = '23'
|
| 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 = 'http://www.triplecores.com/document/a004' or m.men_link = 'http://www.triplecores.com/document/a004' or m.men_link = '/document/a004' or m.men_link = '/document/a004?'
ORDER BY men_parent
DESC LIMIT 1;
|
| 0.0003 |
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:41:59', 'History - Triple Cores Technology', 'http://www.triplecores.com/document/a004', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
|
| 0.0094 |
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:31:59'
AND (
`cb_member`.`mem_is_admin` = 0
OR `cb_member`.`mem_is_admin` IS NULL
)
|
| 0.0000 |
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:41:59', '', 'http://www.triplecores.com/document/a004', '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
|