SHOW FULL COLUMNS FROM `ecms_search_hot` [ RunTime:0.028322s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.028321s ]
SHOW FULL COLUMNS FROM `ecms_main` [ RunTime:0.028321s ]
SELECT `id`,`title` FROM `ecms_main` WHERE `sort` = 9 ORDER BY `uptime` [ RunTime:0.028322s ]
SHOW FULL COLUMNS FROM `ecms_pro_class` [ RunTime:0.028321s ]
SELECT `id`,`onlyno`,`title`,`idpath`,`bimg` FROM `ecms_pro_class` WHERE `onlyno` = '50FJH7' AND `title` = 'Other Product Lines' LIMIT 1 [ RunTime:0.028322s ]
SELECT COUNT(*) AS `count` FROM `view_pro` WHERE `shelve`=1 AND `idpath` LIKE '-0-7-%' [ RunTime:0.030274s ]
SELECT `title` FROM `ecms_pro_class` WHERE `id` = 7 LIMIT 1 [ RunTime:0.039064s ]
SELECT `id`,`onlyno`,`title`,`idpath`,`img` FROM `ecms_pro_class` WHERE `parentid` = 7 ORDER BY `sort` [ RunTime:0.028322s ]
SHOW FULL COLUMNS FROM `view_pro` [ RunTime:0.029298s ]
SELECT COUNT(*) AS think_count FROM `view_pro` WHERE `class_id` = '7' AND `shelve` = 1 AND `isdel` = 0 LIMIT 1 [ RunTime:0.030274s ]
SELECT `id`,`onlyno`,`idpath`,`title`,`title_sub`,`img` FROM `view_pro` WHERE `class_id` = '7' AND `shelve` = 1 AND `isdel` = 0 ORDER BY `sorttime` LIMIT 20,20 [ RunTime:0.030275s ]
SELECT `title` FROM `ecms_search_hot` ORDER BY `counts` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.028322s ]
Other Product Lines (10 results)
hanliwell@hanliwell.com