SHOW FULL COLUMNS FROM `ecms_search_hot` [ RunTime:0.031252s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.015625s ]
SHOW FULL COLUMNS FROM `ecms_main` [ RunTime:0.031252s ]
SELECT `id`,`title` FROM `ecms_main` WHERE `sort` = 9 ORDER BY `uptime` [ RunTime:0.031252s ]
SHOW FULL COLUMNS FROM `view_pro` [ RunTime:0.031252s ]
SELECT COUNT(*) AS think_count FROM `view_pro` WHERE ( (`title` LIKE '%HPS%' OR `class_title` LIKE '%HPS%') AND shelve=1 AND isdel=0 ) LIMIT 1 [ RunTime:0.031252s ]
SELECT COUNT(*) AS think_count FROM `ecms_search_hot` WHERE `title` = 'HPS' LIMIT 1 [ RunTime:0.015626s ]
UPDATE `ecms_search_hot` SET `counts` = `counts` + 1 WHERE `title` = 'HPS' [ RunTime:0.046877s ]
SELECT COUNT(*) AS think_count FROM `view_pro` WHERE ( (`title` LIKE '%HPS%' OR `class_title` LIKE '%HPS%') AND shelve=1 AND isdel=0 ) LIMIT 1 [ RunTime:0.031252s ]
SELECT `id`,`onlyno`,`idpath`,`title`,`img` FROM `view_pro` WHERE ( (`title` LIKE '%HPS%' OR `class_title` LIKE '%HPS%') AND shelve=1 AND isdel=0 ) ORDER BY `sorttime` LIMIT 20,20 [ RunTime:0.015626s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.015626s ]
Products Search: HPS（3 results）
hanliwell@hanliwell.com