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.015626s ]
SHOW FULL COLUMNS FROM `ecms_main` [ RunTime:0.296892s ]
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 '%h%' OR `class_title` LIKE '%h%') AND shelve=1 AND isdel=0 ) LIMIT 1 [ RunTime:0.031252s ]
SELECT COUNT(*) AS think_count FROM `ecms_search_hot` WHERE `title` = 'h' LIMIT 1 [ RunTime:0.031251s ]
UPDATE `ecms_search_hot` SET `counts` = `counts` + 1 WHERE `title` = 'h' [ RunTime:0.015626s ]
SELECT COUNT(*) AS think_count FROM `view_pro` WHERE ( (`title` LIKE '%h%' OR `class_title` LIKE '%h%') AND shelve=1 AND isdel=0 ) LIMIT 1 [ RunTime:0.031252s ]
SELECT `id`,`onlyno`,`idpath`,`title`,`img` FROM `view_pro` WHERE ( (`title` LIKE '%h%' OR `class_title` LIKE '%h%') AND shelve=1 AND isdel=0 ) ORDER BY `sorttime` LIMIT 0,20 [ RunTime:0.031252s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.031252s ]
Products Search: h（42 results）
hanliwell@hanliwell.com