SHOW FULL COLUMNS FROM `gd_arctype` [ RunTime:0.001129s ]
SELECT `id`,`dirname` FROM `gd_arctype` WHERE `dirname` = 'productCenter' ORDER BY `sort_order` ASC LIMIT 1 [ RunTime:0.000475s ]
SELECT `a`.`id`,`a`.`current_channel`,`a`.`litpic`,`b`.`nid` FROM `gd_arctype` `a` LEFT JOIN `gd_channel_type` `b` ON `a`.`current_channel`=`b`.`id` WHERE `a`.`dirname` = 'productCenter' AND `a`.`is_del` = 0 LIMIT 1 [ RunTime:0.000449s ]
SELECT `c`.*,`a`.*,a.id as typeid FROM `gd_arctype` `a` LEFT JOIN `gd_channel_type` `c` ON `c`.`id`=`a`.`current_channel` WHERE `a`.`id` = 102 LIMIT 1 [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `gd_channel_type` [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `gd_channelfield` [ RunTime:0.000537s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000524s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 102 [ RunTime:0.000314s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000298s ]
SELECT * FROM `gd_arctype` WHERE `status` = 1 AND `is_hidden` = 0 AND `is_del` = 0 AND `status` = 1 ORDER BY `parent_id` ASC,`sort_order` ASC,`id` [ RunTime:0.000774s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 101 [ RunTime:0.000318s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 102 [ RunTime:0.000314s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 128 [ RunTime:0.000308s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 103 [ RunTime:0.000217s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 100 [ RunTime:0.000197s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 104 [ RunTime:0.000196s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 105 [ RunTime:0.000182s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 114 [ RunTime:0.000165s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 115 [ RunTime:0.000205s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 116 [ RunTime:0.000183s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 132 [ RunTime:0.000166s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 106 [ RunTime:0.000165s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 107 [ RunTime:0.000186s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 108 [ RunTime:0.000190s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 109 [ RunTime:0.000195s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 126 [ RunTime:0.000175s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 127 [ RunTime:0.000184s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000785s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000317s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000310s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.001841s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`current_channel` FROM `gd_arctype` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `gd_archives` [ RunTime:0.000943s ]
SELECT COUNT(*) AS think_count FROM `gd_archives` `a` LEFT JOIN `gd_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (102,110,111,112,113) AND a.channel IN (30) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) [ RunTime:0.000658s ]
SELECT `b`.*,`a`.* FROM `gd_archives` `a` LEFT JOIN `gd_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (102,110,111,112,113) AND a.channel IN (30) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order asc, a.aid desc LIMIT 0,10 [ RunTime:0.000980s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000331s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000535s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000316s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.001328s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000338s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000540s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000303s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.001333s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000590s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000306s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.001384s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000694s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000533s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000266s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.001323s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000646s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'productCenter' LIMIT 1 [ RunTime:0.000289s ]
SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `gd_arctype` `c` LEFT JOIN `gd_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.000910s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `gd_links` [ RunTime:0.001125s ]
SELECT * FROM `gd_links` WHERE `typeid` = 1 ORDER BY `sort_order` ASC LIMIT 24 [ RunTime:0.000435s ]
微信咨询
