SHOW FULL COLUMNS FROM `zlkj_arctype` [ RunTime:0.000992s ]
SELECT `a`.`id`,`a`.`current_channel`,`a`.`litpic`,`b`.`nid` FROM `zlkj_arctype` `a` LEFT JOIN `zlkj_channel_type` `b` ON `a`.`current_channel`=`b`.`id` WHERE `a`.`dirname` = 'csses' AND `a`.`is_del` = '0' LIMIT 1 [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `zlkj_cases_content` [ RunTime:0.000712s ]
SELECT `xmtime` FROM `zlkj_cases_content` GROUP BY `xmtime` ORDER BY `xmtime` DESC [ RunTime:0.000198s ]
SELECT `xmlx` FROM `zlkj_cases_content` GROUP BY `xmlx` ORDER BY `xmlx` DESC [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `zlkj_channel_type` [ RunTime:0.000707s ]
SHOW FULL COLUMNS FROM `zlkj_channelfield` [ RunTime:0.000745s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000300s ]
SELECT COUNT(`id`) AS think_count FROM `zlkj_arctype` WHERE `parent_id` = 13 LIMIT 1 [ RunTime:0.000178s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `zlkj_nav_list` [ RunTime:0.000700s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 13 AND `position_id` = 1 LIMIT 1 [ RunTime:0.000207s ]
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.000540s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000289s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000149s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000184s ]
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.001296s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000384s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000169s ]
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.001283s ]
SELECT * FROM `zlkj_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000394s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `zlkj_archives` [ RunTime:0.000806s ]
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.000491s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000198s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000188s ]
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.000416s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000202s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000163s ]
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.000398s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000175s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000189s ]
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.000415s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000208s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 33 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 (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.000369s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000173s ]
SELECT `id`,`current_channel` FROM `zlkj_arctype` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000166s ]
SELECT COUNT(*) AS think_count FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` LEFT JOIN `zlkj_cases_content` `c` ON `c`.`aid`=`a`.`aid` WHERE ( a.typeid IN (13) AND a.channel IN (16) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 AND c.xmlx like '%种植屋面项目%' AND c.xmtime like '%2019年%' ) LIMIT 1 [ RunTime:0.000277s ]
SELECT `b`.*,`a`.*,`c`.* FROM `zlkj_archives` `a` LEFT JOIN `zlkj_arctype` `b` ON `b`.`id`=`a`.`typeid` LEFT JOIN `zlkj_cases_content` `c` ON `c`.`aid`=`a`.`aid` WHERE ( a.typeid IN (13) AND a.channel IN (16) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 AND c.xmlx like '%种植屋面项目%' AND c.xmtime like '%2019年%' ) ORDER BY a.sort_order desc,a.add_time desc LIMIT 0,6 [ RunTime:0.000494s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000183s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 13 AND `position_id` = 4 LIMIT 1 [ RunTime:0.000198s ]
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.000564s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000266s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000143s ]
SELECT `id` FROM `zlkj_arctype` WHERE `dirname` = 'csses' LIMIT 1 [ RunTime:0.000183s ]
SELECT `nav_id`,`topid`,`parent_id` FROM `zlkj_nav_list` WHERE `type_id` = 13 AND `position_id` = 4 LIMIT 1 [ RunTime:0.000175s ]
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.000536s ]
SELECT `id`,`typename`,`dirname`,`current_channel`,`is_part`,`typelink`,`englist_name` FROM `zlkj_arctype` [ RunTime:0.000294s ]
SELECT `id`,`ctl_name` FROM `zlkj_channel_type` [ RunTime:0.000158s ]
021-52660046
13651638750
客服
招聘
手机
微信
