SHOW FULL COLUMNS FROM `zlkj_arctype` [ RunTime:0.000969s ]
SHOW FULL COLUMNS FROM `zlkj_archives` [ RunTime:0.000857s ]
SELECT `a`.`typeid`,`a`.`channel`,`b`.`nid`,`b`.`ctl_name` FROM `zlkj_archives` `a` LEFT JOIN `zlkj_channel_type` `b` ON `a`.`channel`=`b`.`id` WHERE `a`.`aid` = '203' AND `a`.`is_del` = '0' LIMIT 1 [ RunTime:0.000269s ]
SELECT `channel` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `zlkj_channel_type` [ RunTime:0.000646s ]
SELECT `nid` FROM `zlkj_channel_type` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000175s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_product_content` `b` ON `b`.`aid`=`a`.`aid` WHERE `a`.`aid` = '203' LIMIT 1 [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `zlkj_channelfield` [ RunTime:0.000702s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000298s ]
SELECT COUNT(`id`) AS think_count FROM `zlkj_arctype` WHERE `parent_id` = 102 LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = 7 [ RunTime:0.000260s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'yushuidou' LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `zlkj_nav_list` [ RunTime:0.000648s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 102 AND `position_id` = 1 LIMIT 1 [ RunTime:0.000231s ]
SELECT c.*, count(s.nav_id) as has_children, '' as children FROM `zlkj_nav_list` `c` LEFT JOIN `zlkj_nav_list` `s` ON `s`.`parent_id`=`c`.`nav_id` WHERE `c`.`is_del` = '0' AND `c`.`position_id` = '1' AND `c`.`status` = '1' GROUP BY `c`.`nav_id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`nav_id` [ RunTime:0.000549s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000316s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000159s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `zlkj_arctype` `c` LEFT JOIN `zlkj_arctype` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`is_hidden` = '0' AND `c`.`status` = '1' AND `c`.`is_del` = '0' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.001319s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000384s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `zlkj_arctype` `c` LEFT JOIN `zlkj_arctype` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`is_hidden` = '0' AND `c`.`status` = '1' AND `c`.`is_del` = '0' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.001305s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000357s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000170s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000187s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (14,15,16,89,90,91) AND a.channel IN (7) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 10 [ RunTime:0.000504s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000180s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000164s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (30,99,100) AND a.channel IN (7) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 10 [ RunTime:0.000453s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000179s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000160s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (31,101) AND a.channel IN (7) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 10 [ RunTime:0.000378s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000197s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000161s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (32,102,104) AND a.channel IN (7) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 10 [ RunTime:0.000434s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000177s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000183s ]
SELECT `b`.*,`a`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (33) AND a.channel IN (7) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 10 [ RunTime:0.000361s ]
SELECT `typeid` FROM `zlkj_archives` WHERE `aid` = 203 LIMIT 1 [ RunTime:0.000169s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'yushuidou' LIMIT 1 [ RunTime:0.000184s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 102 AND `position_id` = 4 LIMIT 1 [ RunTime:0.000172s ]
SELECT c.*, count(s.nav_id) as has_children, '' as children FROM `zlkj_nav_list` `c` LEFT JOIN `zlkj_nav_list` `s` ON `s`.`parent_id`=`c`.`nav_id` WHERE `c`.`is_del` = '0' AND `c`.`position_id` = '4' AND `c`.`status` = '1' GROUP BY `c`.`nav_id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`nav_id` [ RunTime:0.000577s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000249s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000176s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'yushuidou' LIMIT 1 [ RunTime:0.000160s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 102 AND `position_id` = 4 LIMIT 1 [ RunTime:0.000180s ]
SELECT c.*, count(s.nav_id) as has_children, '' as children FROM `zlkj_nav_list` `c` LEFT JOIN `zlkj_nav_list` `s` ON `s`.`parent_id`=`c`.`nav_id` WHERE `c`.`is_del` = '0' AND `c`.`position_id` = '4' AND `c`.`status` = '1' GROUP BY `c`.`nav_id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`nav_id` [ RunTime:0.000523s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000270s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000154s ]