SHOW FULL COLUMNS FROM `gd_fragment` [ RunTime:0.007272s ]
SELECT * FROM `gd_fragment` [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `gd_arctype` [ RunTime:0.006211s ]
SELECT `id`,`dirname` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' ORDER BY `sort_order` ASC LIMIT 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `gd_channelfield` [ RunTime:0.005992s ]
SELECT `name`,`title`,`dfvalue` FROM `gd_channelfield` WHERE `channel_id` = 28 AND `dtype` IN ('radio','checkbox') ORDER BY `sort_order` ASC [ RunTime:0.000374s ]
SELECT * FROM `gd_fragment` [ RunTime:0.000292s ]
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` = 'canyinzhuangxiusheji' AND `a`.`is_del` = 0 LIMIT 1 [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `gd_channel_type` [ RunTime:0.007790s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 [ RunTime:0.000600s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 73 [ RunTime:0.000344s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' LIMIT 1 [ RunTime:0.000459s ]
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.000579s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 47 [ RunTime:0.000262s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 48 [ RunTime:0.000242s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 49 [ RunTime:0.000202s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 50 [ RunTime:0.000161s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 51 [ RunTime:0.000173s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 52 [ RunTime:0.000178s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 53 [ RunTime:0.000183s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 72 [ RunTime:0.000204s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 73 [ RunTime:0.000175s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 75 [ RunTime:0.000194s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 77 [ RunTime:0.000165s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 54 [ RunTime:0.000164s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 55 [ RunTime:0.000173s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 56 [ RunTime:0.000173s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 57 [ RunTime:0.000176s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 58 [ RunTime:0.000156s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 59 [ RunTime:0.000176s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 60 [ RunTime:0.000168s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 63 [ RunTime:0.000119s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 64 [ RunTime:0.000108s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 65 [ RunTime:0.000104s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 66 [ RunTime:0.000109s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 67 [ RunTime:0.000123s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 68 [ RunTime:0.000119s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 69 [ RunTime:0.000103s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 61 [ RunTime:0.000109s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 62 [ RunTime:0.000121s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000538s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' LIMIT 1 [ RunTime:0.000359s ]
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.000487s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 47 [ RunTime:0.000282s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 48 [ RunTime:0.000229s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 49 [ RunTime:0.000226s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 50 [ RunTime:0.000224s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 51 [ RunTime:0.000209s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 52 [ RunTime:0.000174s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 53 [ RunTime:0.000175s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 72 [ RunTime:0.000174s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 73 [ RunTime:0.000165s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 75 [ RunTime:0.000187s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 77 [ RunTime:0.000177s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 54 [ RunTime:0.000179s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 55 [ RunTime:0.000176s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 56 [ RunTime:0.000188s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 57 [ RunTime:0.000146s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 58 [ RunTime:0.000140s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 59 [ RunTime:0.000124s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 60 [ RunTime:0.000126s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 63 [ RunTime:0.000128s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 64 [ RunTime:0.000151s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 65 [ RunTime:0.000130s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 66 [ RunTime:0.000135s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 67 [ RunTime:0.000155s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 68 [ RunTime:0.000145s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 69 [ RunTime:0.000129s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 61 [ RunTime:0.000130s ]
SELECT COUNT(`id`) AS think_count FROM `gd_arctype` WHERE `parent_id` = 62 [ RunTime:0.000178s ]
SELECT * FROM `gd_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000557s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' LIMIT 1 [ RunTime:0.000303s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`current_channel` FROM `gd_arctype` WHERE `id` = 73 LIMIT 1 [ RunTime:0.000210s ]
SELECT `current_channel` FROM `gd_arctype` WHERE `id` = 73 LIMIT 1 [ RunTime:0.000338s ]
SELECT `name`,`title`,`dfvalue` FROM `gd_channelfield` WHERE `channel_id` = 28 AND `dtype` = 'radio' ORDER BY `sort_order` ASC [ RunTime:0.000300s ]
SELECT `name`,`title`,`dfvalue` FROM `gd_channelfield` WHERE `channel_id` = 28 AND `dtype` = 'checkbox' ORDER BY `sort_order` ASC [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `gd_archives` [ RunTime:0.012514s ]
SELECT COUNT(*) AS think_count FROM `gd_archives` `a` LEFT JOIN `gd_arctype` `b` ON `b`.`id`=`a`.`typeid` LEFT JOIN `gd_anli_content` `t` ON `t`.`aid`=`a`.`aid` WHERE ( a.typeid IN (73) AND a.channel IN (28) AND t.industry = '服務業(yè)' AND (t.style = '文創(chuàng)' OR t.style like '文創(chuàng),%' OR t.style like '%,文創(chuàng),%' OR t.style like '%,文創(chuàng)') AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) [ RunTime:0.000365s ]
SELECT `b`.*,`a`.* FROM `gd_archives` `a` LEFT JOIN `gd_arctype` `b` ON `b`.`id`=`a`.`typeid` LEFT JOIN `gd_anli_content` `t` ON `t`.`aid`=`a`.`aid` WHERE ( a.typeid IN (73) AND a.channel IN (28) AND t.industry = '服務業(yè)' AND (t.style = '文創(chuàng)' OR t.style like '文創(chuàng),%' OR t.style like '%,文創(chuàng),%' OR t.style like '%,文創(chuàng)') AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.add_time desc LIMIT 0,16 [ RunTime:0.000394s ]
SELECT `id` FROM `gd_arctype` WHERE `dirname` = 'canyinzhuangxiusheji' LIMIT 1 [ RunTime:0.000258s ]
SELECT `id`,`current_channel` FROM `gd_arctype` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000250s ]
SELECT `b`.*,`a`.* FROM `gd_archives` `a` LEFT JOIN `gd_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (53,61,62) AND a.channel IN (1) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) ORDER BY a.sort_order asc, a.aid desc LIMIT 4 [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `gd_guestbook` [ RunTime:0.007224s ]
SELECT * FROM `gd_guestbook` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `gd_guestbook_attr` [ RunTime:0.005914s ]
SELECT * FROM `gd_guestbook_attr` WHERE `form_id` = 10 AND `is_del` = 0 ORDER BY `sort_order` ASC,`attr_id` ASC [ RunTime:0.000284s ]
免費咨詢
