SHOW FULL COLUMNS FROM `os_website` [ RunTime:0.004758s ]
SELECT `mark` FROM `os_website` [ RunTime:0.002540s ]
SELECT `mark` FROM `os_website` [ RunTime:0.004069s ]
SHOW FULL COLUMNS FROM `os_category` [ RunTime:0.004136s ]
SELECT `urlroute` FROM `os_category` [ RunTime:0.004606s ]
SELECT `mark` FROM `os_website` [ RunTime:0.003824s ]
SELECT `urlroute` FROM `os_category` [ RunTime:0.005556s ]
SELECT `mark` FROM `os_website` [ RunTime:0.004383s ]
SELECT * FROM `os_website` WHERE `mark` = 'ja' LIMIT 1 [ RunTime:0.005269s ]
SELECT * FROM `os_category` WHERE `urlroute` = 'company-news' LIMIT 1 [ RunTime:0.004353s ]
SHOW FULL COLUMNS FROM `os_category_data` [ RunTime:0.004726s ]
SELECT `a`.*,b.urlroute as catroute,`b`.`pid`,`b`.`thumb`,a.catname as name,`b`.`outurl`,`b`.`type`,`b`.`modelid`,`b`.`id`,a.id as dataid,a.detail as content,`a`.`keyword`,`a`.`description`,`b`.`view` FROM `os_category_data` `a` INNER JOIN `os_category` `b` ON `a`.`catid`=`b`.`id` WHERE `b`.`urlroute` = 'company-news' AND `a`.`site_id` = '4' LIMIT 1 [ RunTime:0.008796s ]
SELECT `pid`,`id` FROM `os_category` [ RunTime:0.005845s ]
SELECT `a`.*,b.urlroute as catroute,`b`.`pid`,`b`.`thumb`,a.catname as name,`b`.`outurl`,`b`.`type`,`b`.`modelid`,`b`.`id`,a.id as dataid FROM `os_category_data` `a` INNER JOIN `os_category` `b` ON `a`.`catid`=`b`.`id` WHERE `b`.`id` = '3' AND `a`.`site_id` = '4' LIMIT 1 [ RunTime:0.005799s ]
SELECT `b`.`id` FROM `os_category_data` `a` INNER JOIN `os_category` `b` ON `a`.`catid`=`b`.`id` WHERE `a`.`site_id` = '4' AND `b`.`path` LIKE '%,5,%' [ RunTime:0.009743s ]
SHOW FULL COLUMNS FROM `os_news` [ RunTime:0.010660s ]
SELECT COUNT(*) AS think_count FROM `os_news` `a` INNER JOIN `os_category` `c` ON `a`.`fid`=`c`.`id` INNER JOIN `os_news_data` `b` ON `a`.`id`=`b`.`did` WHERE `a`.`fid` = '5' AND `b`.`site_id` = '4' LIMIT 1 [ RunTime:0.009860s ]
SHOW FULL COLUMNS FROM `os_config` [ RunTime:0.011310s ]
SELECT `name`,`value` FROM `os_config` [ RunTime:0.004671s ]
SELECT `markpic`,`mark`,`name` FROM `os_website` WHERE `status` = 1 [ RunTime:0.006817s ]
SELECT `name`,`value` FROM `os_config` [ RunTime:0.013798s ]
SELECT `markpic`,`mark`,`name` FROM `os_website` WHERE `status` = 1 [ RunTime:0.007798s ]
SELECT * FROM `os_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.006373s ]
SELECT * FROM `os_category_data` WHERE `catid` = 1 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007743s ]
SELECT * FROM `os_category_data` WHERE `catid` = 3 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006781s ]
SELECT * FROM `os_category_data` WHERE `catid` = 6 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006910s ]
SELECT * FROM `os_category_data` WHERE `catid` = 18 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006802s ]
SELECT * FROM `os_category_data` WHERE `catid` = 2 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005693s ]
SELECT * FROM `os_category_data` WHERE `catid` = 4 AND `site_id` = 4 LIMIT 1 [ RunTime:0.010562s ]
SELECT * FROM `os_category_data` WHERE `catid` = 5 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007789s ]
SELECT * FROM `os_category_data` WHERE `catid` = 7 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007892s ]
SELECT * FROM `os_category_data` WHERE `catid` = 8 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007923s ]
SELECT * FROM `os_category_data` WHERE `catid` = 9 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006820s ]
SELECT * FROM `os_category_data` WHERE `catid` = 10 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007833s ]
SELECT * FROM `os_category_data` WHERE `catid` = 11 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007786s ]
SELECT * FROM `os_category_data` WHERE `catid` = 12 AND `site_id` = 4 LIMIT 1 [ RunTime:0.004602s ]
SELECT * FROM `os_category_data` WHERE `catid` = 13 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006817s ]
SELECT * FROM `os_category_data` WHERE `catid` = 14 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006815s ]
SELECT * FROM `os_category_data` WHERE `catid` = 15 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005812s ]
SELECT * FROM `os_category_data` WHERE `catid` = 16 AND `site_id` = 4 LIMIT 1 [ RunTime:0.004058s ]
SELECT * FROM `os_category_data` WHERE `catid` = 17 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000222s ]
SELECT * FROM `os_category_data` WHERE `catid` = 19 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `os_category_data` WHERE `catid` = 20 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `os_category_data` WHERE `catid` = 21 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `os_category_data` WHERE `catid` = 22 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `os_category_data` WHERE `catid` = 23 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `os_category_data` WHERE `catid` = 24 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `os_category_data` WHERE `catid` = 25 AND `site_id` = 4 LIMIT 1 [ RunTime:0.001165s ]
SELECT * FROM `os_category_data` WHERE `catid` = 26 AND `site_id` = 4 LIMIT 1 [ RunTime:0.010030s ]
SELECT * FROM `os_category_data` WHERE `catid` = 27 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006810s ]
SELECT * FROM `os_category_data` WHERE `catid` = 28 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005872s ]
SELECT * FROM `os_category_data` WHERE `catid` = 29 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007877s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006850s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.006785s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.005809s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 16 LIMIT 1 [ RunTime:0.005832s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.006825s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.006833s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.005825s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.005826s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.005819s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006836s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.006808s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 11 LIMIT 1 [ RunTime:0.006825s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 12 LIMIT 1 [ RunTime:0.005821s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.005826s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 14 LIMIT 1 [ RunTime:0.005806s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.005814s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.005824s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.005818s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006815s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.005810s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.006826s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 23 LIMIT 1 [ RunTime:0.006810s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 24 LIMIT 1 [ RunTime:0.005809s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 10 LIMIT 1 [ RunTime:0.005878s ]
SELECT `a`.*,b.name as catname,b.urlroute as catroute,c.title as ctitle,`c`.`detail` FROM `os_news` `a` INNER JOIN `os_category` `b` ON `a`.`fid`=`b`.`id` INNER JOIN `os_news_data` `c` ON `a`.`id`=`c`.`did` WHERE ( a.status=1 AND a.mid=1 ) AND `c`.`site_id` = '4' ORDER BY `id` ASC LIMIT 4 [ RunTime:0.003738s ]
SELECT * FROM `os_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004437s ]
SELECT * FROM `os_category_data` WHERE `catid` = 1 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006746s ]
SELECT * FROM `os_category_data` WHERE `catid` = 3 AND `site_id` = 4 LIMIT 1 [ RunTime:0.004775s ]
SELECT * FROM `os_category_data` WHERE `catid` = 6 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005797s ]
SELECT * FROM `os_category_data` WHERE `catid` = 18 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005797s ]
SELECT * FROM `os_category_data` WHERE `catid` = 2 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006794s ]
SELECT * FROM `os_category_data` WHERE `catid` = 4 AND `site_id` = 4 LIMIT 1 [ RunTime:0.009802s ]
SELECT * FROM `os_category_data` WHERE `catid` = 5 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007818s ]
SELECT * FROM `os_category_data` WHERE `catid` = 7 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005779s ]
SELECT * FROM `os_category_data` WHERE `catid` = 8 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007820s ]
SELECT * FROM `os_category_data` WHERE `catid` = 9 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005797s ]
SELECT * FROM `os_category_data` WHERE `catid` = 10 AND `site_id` = 4 LIMIT 1 [ RunTime:0.004811s ]
SELECT * FROM `os_category_data` WHERE `catid` = 11 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006788s ]
SELECT * FROM `os_category_data` WHERE `catid` = 12 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006799s ]
SELECT * FROM `os_category_data` WHERE `catid` = 13 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006817s ]
SELECT * FROM `os_category_data` WHERE `catid` = 14 AND `site_id` = 4 LIMIT 1 [ RunTime:0.008810s ]
SELECT * FROM `os_category_data` WHERE `catid` = 15 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007827s ]
SELECT * FROM `os_category_data` WHERE `catid` = 16 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005799s ]
SELECT * FROM `os_category_data` WHERE `catid` = 17 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006826s ]
SELECT * FROM `os_category_data` WHERE `catid` = 19 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006818s ]
SELECT * FROM `os_category_data` WHERE `catid` = 20 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006805s ]
SELECT * FROM `os_category_data` WHERE `catid` = 21 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006782s ]
SELECT * FROM `os_category_data` WHERE `catid` = 22 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005821s ]
SELECT * FROM `os_category_data` WHERE `catid` = 23 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005828s ]
SELECT * FROM `os_category_data` WHERE `catid` = 24 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005831s ]
SELECT * FROM `os_category_data` WHERE `catid` = 25 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006795s ]
SELECT * FROM `os_category_data` WHERE `catid` = 26 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006881s ]
SELECT * FROM `os_category_data` WHERE `catid` = 27 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006859s ]
SELECT * FROM `os_category_data` WHERE `catid` = 28 AND `site_id` = 4 LIMIT 1 [ RunTime:0.004862s ]
SELECT * FROM `os_category_data` WHERE `catid` = 29 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006879s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.006793s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.005785s ]
SELECT `a`.*,b.name as catname,b.urlroute as catroute,c.title as ctitle,`c`.`detail` FROM `os_news` `a` INNER JOIN `os_category` `b` ON `a`.`fid`=`b`.`id` INNER JOIN `os_news_data` `c` ON `a`.`id`=`c`.`did` WHERE ( a.status=1 AND a.mid=1 ) AND `c`.`site_id` = '4' ORDER BY `id` ASC LIMIT 10 [ RunTime:0.004704s ]
SELECT * FROM `os_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.008276s ]
SELECT * FROM `os_category_data` WHERE `catid` = 1 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007524s ]
SELECT * FROM `os_category_data` WHERE `catid` = 3 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005779s ]
SELECT * FROM `os_category_data` WHERE `catid` = 6 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007821s ]
SELECT * FROM `os_category_data` WHERE `catid` = 18 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007848s ]
SELECT * FROM `os_category_data` WHERE `catid` = 2 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007803s ]
SELECT * FROM `os_category_data` WHERE `catid` = 4 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006814s ]
SELECT * FROM `os_category_data` WHERE `catid` = 5 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005793s ]
SELECT * FROM `os_category_data` WHERE `catid` = 7 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006818s ]
SELECT * FROM `os_category_data` WHERE `catid` = 8 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006814s ]
SELECT * FROM `os_category_data` WHERE `catid` = 9 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007821s ]
SELECT * FROM `os_category_data` WHERE `catid` = 10 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005794s ]
SELECT * FROM `os_category_data` WHERE `catid` = 11 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005808s ]
SELECT * FROM `os_category_data` WHERE `catid` = 12 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006826s ]
SELECT * FROM `os_category_data` WHERE `catid` = 13 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005845s ]
SELECT * FROM `os_category_data` WHERE `catid` = 14 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006763s ]
SELECT * FROM `os_category_data` WHERE `catid` = 15 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005826s ]
SELECT * FROM `os_category_data` WHERE `catid` = 16 AND `site_id` = 4 LIMIT 1 [ RunTime:0.007817s ]
SELECT * FROM `os_category_data` WHERE `catid` = 17 AND `site_id` = 4 LIMIT 1 [ RunTime:0.005781s ]
SELECT * FROM `os_category_data` WHERE `catid` = 19 AND `site_id` = 4 LIMIT 1 [ RunTime:0.006569s ]
SELECT * FROM `os_category_data` WHERE `catid` = 20 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000220s ]
SELECT * FROM `os_category_data` WHERE `catid` = 21 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000222s ]
SELECT * FROM `os_category_data` WHERE `catid` = 22 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000238s ]
SELECT * FROM `os_category_data` WHERE `catid` = 23 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000167s ]
SELECT * FROM `os_category_data` WHERE `catid` = 24 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000151s ]
SELECT * FROM `os_category_data` WHERE `catid` = 25 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000162s ]
SELECT * FROM `os_category_data` WHERE `catid` = 26 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000162s ]
SELECT * FROM `os_category_data` WHERE `catid` = 27 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000148s ]
SELECT * FROM `os_category_data` WHERE `catid` = 28 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000139s ]
SELECT * FROM `os_category_data` WHERE `catid` = 29 AND `site_id` = 4 LIMIT 1 [ RunTime:0.000166s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000158s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000135s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000137s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000291s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000139s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000132s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000136s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000156s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000132s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000131s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000137s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000155s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000150s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000133s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000138s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000141s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000132s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000133s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000137s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000147s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000134s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000138s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000157s ]
SELECT `urlroute` FROM `os_category` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000176s ]