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.031251s ]
SHOW FULL COLUMNS FROM `ecms_main` [ RunTime:0.015626s ]
SELECT `id`,`title` FROM `ecms_main` WHERE `sort` = 9 ORDER BY `uptime` [ RunTime:0.031252s ]
SHOW FULL COLUMNS FROM `ecms_pro_class` [ RunTime:0.031252s ]
SELECT `id`,`onlyno`,`title`,`idpath`,`bimg` FROM `ecms_pro_class` WHERE `onlyno` = 'xRIdc9' AND `title` = 'Loose Cham Swltch' LIMIT 1 [ RunTime:0.015626s ]
SELECT COUNT(*) AS `count` FROM `view_pro` WHERE `shelve`=1 AND `idpath` LIKE '-0-4-%' [ RunTime:0.031252s ]
SELECT `title` FROM `ecms_pro_class` WHERE `id` = 4 LIMIT 1 [ RunTime:0.031251s ]
SELECT `id`,`onlyno`,`title`,`idpath`,`img` FROM `ecms_pro_class` WHERE `parentid` = 4 ORDER BY `sort` [ RunTime:0.031252s ]
SHOW FULL COLUMNS FROM `view_pro` [ RunTime:0.015626s ]
SELECT COUNT(*) AS think_count FROM `view_pro` WHERE `class_id` = '4' AND `shelve` = 1 AND `isdel` = 0 LIMIT 1 [ RunTime:0.031252s ]
SELECT `id`,`onlyno`,`idpath`,`title`,`title_sub`,`img` FROM `view_pro` WHERE `class_id` = '4' AND `shelve` = 1 AND `isdel` = 0 ORDER BY `sorttime` LIMIT 20,20 [ RunTime:0.031252s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.031251s ]
Loose Cham Swltch (2 results)
hanliwell@hanliwell.com