SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001135s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001070s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `existence` = 1 AND `pt` = 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000842s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001037s ]
SELECT * FROM `db_seo` WHERE `url` = '/' LIMIT 1 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.002070s ]
SELECT * FROM `db_ad` WHERE `pid` = 11 AND `areaid` = 0 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.002291s ]
SELECT `p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`community`,`p`.`mid`,`m`.`groupid`,`m`.`areaid` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`is_tj` >= 1 AND `p`.`status` = 3 AND `m`.`groupid` = 1 AND `m`.`areaid` IN (35,39,46,57,69,83,92,105,109,118,120,129,146,155,166,167,183,200,217,231,233,236,247,252,266,284,305,314,330,337,347,361,369,374,1,2,3,4) ORDER BY `p`.`is_tj` DESC,`p`.`itemid` DESC LIMIT 5 [ RunTime:0.013873s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001667s ]
SELECT `userid`,`company`,`company_jc`,`thumb`,`areaid`,`vip`,`status` FROM `db_company` WHERE `groupid` = 1 AND `status` = 3 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 60 [ RunTime:0.000549s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50219 [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001838s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50219 [ RunTime:0.000313s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50034 [ RunTime:0.000292s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50034 [ RunTime:0.000290s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50003 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50003 [ RunTime:0.000299s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51456 [ RunTime:0.000286s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51456 [ RunTime:0.000297s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51457 [ RunTime:0.000289s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51457 [ RunTime:0.000301s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52481 [ RunTime:0.000288s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52481 [ RunTime:0.000294s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52482 [ RunTime:0.000292s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52482 [ RunTime:0.000299s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000293s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000296s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52228 [ RunTime:0.000330s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52228 [ RunTime:0.000336s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51205 [ RunTime:0.000330s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51205 [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51717 [ RunTime:0.000332s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51717 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51206 [ RunTime:0.000335s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51206 [ RunTime:0.000337s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51718 [ RunTime:0.000339s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51718 [ RunTime:0.000335s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51974 [ RunTime:0.000333s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51974 [ RunTime:0.000329s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51207 [ RunTime:0.000339s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51207 [ RunTime:0.000333s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51463 [ RunTime:0.008200s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51463 [ RunTime:0.000356s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51719 [ RunTime:0.008122s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51719 [ RunTime:0.000334s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51464 [ RunTime:0.007951s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51464 [ RunTime:0.000334s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51720 [ RunTime:0.000332s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51720 [ RunTime:0.000337s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52488 [ RunTime:0.008078s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52488 [ RunTime:0.000346s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52233 [ RunTime:0.007943s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52233 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53001 [ RunTime:0.007929s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53001 [ RunTime:0.000256s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51211 [ RunTime:0.007876s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51211 [ RunTime:0.000307s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51212 [ RunTime:0.007893s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51212 [ RunTime:0.000314s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51213 [ RunTime:0.000278s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51213 [ RunTime:0.000298s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51725 [ RunTime:0.007972s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51725 [ RunTime:0.000295s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52237 [ RunTime:0.007817s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52237 [ RunTime:0.000306s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51214 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51214 [ RunTime:0.000240s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51726 [ RunTime:0.000238s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51726 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52238 [ RunTime:0.008092s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52238 [ RunTime:0.000255s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52494 [ RunTime:0.007946s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52494 [ RunTime:0.000257s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51215 [ RunTime:0.007930s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51215 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51727 [ RunTime:0.000240s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51727 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53007 [ RunTime:0.007861s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53007 [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51216 [ RunTime:0.007916s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51216 [ RunTime:0.000248s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51728 [ RunTime:0.008014s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51728 [ RunTime:0.000260s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51984 [ RunTime:0.008071s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51984 [ RunTime:0.000255s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51217 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51217 [ RunTime:0.000248s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51218 [ RunTime:0.007964s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51218 [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51475 [ RunTime:0.007842s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51475 [ RunTime:0.000255s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51987 [ RunTime:0.008365s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51987 [ RunTime:0.000316s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50708 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50708 [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50709 [ RunTime:0.007962s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50709 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53013 [ RunTime:0.008057s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53013 [ RunTime:0.000423s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50710 [ RunTime:0.000407s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50710 [ RunTime:0.000406s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51734 [ RunTime:0.007964s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51734 [ RunTime:0.000260s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52502 [ RunTime:0.000240s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52502 [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51223 [ RunTime:0.007878s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51223 [ RunTime:0.000259s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51735 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51735 [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50200 [ RunTime:0.007922s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50200 [ RunTime:0.000260s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51481 [ RunTime:0.000242s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51481 [ RunTime:0.000242s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51993 [ RunTime:0.007950s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51993 [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52505 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52505 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51482 [ RunTime:0.000239s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51482 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52250 [ RunTime:0.008005s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52250 [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51483 [ RunTime:0.007932s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51483 [ RunTime:0.000346s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51995 [ RunTime:0.007931s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51995 [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52251 [ RunTime:0.007834s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52251 [ RunTime:0.000262s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53019 [ RunTime:0.007895s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53019 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50204 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50204 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001541s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`areaid`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE `groupid` = 2 AND `status` = 3 AND `status` = 3 ORDER BY `exp` DESC LIMIT 8 [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001242s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001212s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1524,1535) ORDER BY `listorder` [ RunTime:0.000462s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1528,1535) ORDER BY `listorder` [ RunTime:0.000449s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1524,1525,1526,1528,1529,1533) ORDER BY `listorder` [ RunTime:0.000497s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1526,1528) ORDER BY `listorder` [ RunTime:0.000411s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1523,1524,1526,1527,1528,1532,1534,1535) ORDER BY `listorder` [ RunTime:0.000503s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1523,1526,1527,1533,1534) ORDER BY `listorder` [ RunTime:0.000463s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1526,1531) ORDER BY `listorder` [ RunTime:0.000450s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1522) ORDER BY `listorder` [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.001979s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `ov`.`status` = 3 LIMIT 8 [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.001439s ]
SELECT `itemid`,`catid`,`title`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `status` = 3 AND `catid` IN (1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1479) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 8 [ RunTime:0.006958s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001266s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000496s ]