SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001304s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000423s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001111s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000684s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001395s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `pt` = 1 [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001107s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001170s ]
SELECT * FROM `db_seo` WHERE `url` = '/' LIMIT 1 [ RunTime:0.000507s ]
SELECT * FROM `db_city` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.001961s ]
SELECT * FROM `db_city` WHERE `is_open` = 1 AND `domain` <> '' ORDER BY `areaid` ASC [ RunTime:0.000502s ]
SELECT * FROM `db_city` WHERE `areaid` IN (1,2,3,4,231,233) AND `is_open` = 1 ORDER BY `areaid` ASC [ RunTime:0.000508s ]
SELECT * FROM `db_city` WHERE `parentid` <> 0 AND `areaid` NOT IN (1,2,3,4,231,233) AND `is_open` = 1 ORDER BY `areaid` ASC [ RunTime:0.000579s ]
SELECT * FROM `db_city` WHERE `parentid` = 0 AND `is_open` = 1 ORDER BY `areaid` ASC [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.002822s ]
SELECT * FROM `db_ad` WHERE `pid` = 3 AND `areaid` = 0 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000443s ]
SELECT * FROM `db_ad` WHERE `pid` = 5 AND `areaid` = 0 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.001473s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1431,1432,1433,1434,1435) AND `cityjq` = 'www' AND `status` = 3 ORDER BY `itemid` DESC LIMIT 8 [ RunTime:0.001372s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001790s ]
SELECT `userid`,`company`,`company_jc`,`thumb`,`thumb2`,`areaid`,`vip`,`is_recomment` FROM `db_company` WHERE `groupid` = 1 AND `status` = 3 ORDER BY `is_recomment` DESC LIMIT 12 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001422s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51456 [ RunTime:0.008736s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001149s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51456 [ RunTime:0.000274s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51457 [ RunTime:0.008332s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51457 [ RunTime:0.000268s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52481 [ RunTime:0.008342s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52481 [ RunTime:0.000314s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52482 [ RunTime:0.008165s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52482 [ RunTime:0.000260s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.008292s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000260s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52228 [ RunTime:0.008304s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52228 [ RunTime:0.000266s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51205 [ RunTime:0.008290s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51205 [ RunTime:0.000275s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51717 [ RunTime:0.008208s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51717 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51206 [ RunTime:0.008324s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51206 [ RunTime:0.000270s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51718 [ RunTime:0.008218s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51718 [ RunTime:0.000286s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51974 [ RunTime:0.008776s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51974 [ RunTime:0.000444s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51207 [ RunTime:0.008602s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51207 [ RunTime:0.000452s ]
SELECT `userid`,`company`,`company_jc`,`thumb`,`thumb2`,`areaid`,`vip` FROM `db_company` WHERE `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 12 [ RunTime:0.000488s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50219 [ RunTime:0.008404s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50219 [ RunTime:0.000431s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50034 [ RunTime:0.008245s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50034 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50003 [ RunTime:0.008149s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50003 [ RunTime:0.000259s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51456 [ RunTime:0.000242s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51456 [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51457 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51457 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52481 [ RunTime:0.000242s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52481 [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52482 [ RunTime:0.000248s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52482 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000245s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52228 [ RunTime:0.000246s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52228 [ RunTime:0.000296s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51205 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51205 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51717 [ RunTime:0.000242s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51717 [ RunTime:0.000246s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51206 [ RunTime:0.000240s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51206 [ RunTime:0.000251s ]
SELECT `userid`,`company`,`company_jc`,`thumb`,`thumb2`,`areaid`,`vip` FROM `db_company` WHERE `groupid` = 3 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 12 [ RunTime:0.000311s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50380 [ RunTime:0.008278s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50380 [ RunTime:0.000274s ]
SELECT c.*,SUM(tj.pv) as pvcum FROM `db_company` `c` LEFT JOIN `db_company_tj` `tj` ON `tj`.`userid`=`c`.`userid` LEFT JOIN `db_city` `ci` ON `ci`.`areaid`=`c`.`areaid` WHERE `c`.`status` = 3 AND `c`.`groupid` = 3 AND `c_date` > '2022-11-07' GROUP BY `c`.`userid` ORDER BY `pvcum` DESC LIMIT 10 [ RunTime:0.313268s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002399s ]
SELECT `userid`,`passport`,`truename`,`p_userid`,`company_jc`,`thumb`,`areaid` FROM `db_member` WHERE `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) AND `groupid` = 2 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `userid` DESC LIMIT 12 [ RunTime:0.000657s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1426,1427,1428) AND `cityjq` = 'www' AND `status` = 3 ORDER BY `itemid` DESC LIMIT 5 [ RunTime:0.001773s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1431,1432,1433,1434,1435) AND `cityjq` = 'www' AND `status` = 3 ORDER BY `itemid` DESC LIMIT 5 [ RunTime:0.001151s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` = 1436，1437 AND `cityjq` = 'www' AND `status` = 3 ORDER BY `itemid` DESC LIMIT 5 [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.001492s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000671s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1518 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000816s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1519 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000781s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1521 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001125s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1522 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001161s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1523 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000700s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1524 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001413s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1526 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001021s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1527 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001014s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1528 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001068s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1530 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000618s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1531 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001539s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1532 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001544s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1534 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001501s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1535 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001095s ]
SELECT c.*,count(ba.userid) as count FROM `db_company` `c` LEFT JOIN `db_bidding_assign` `ba` ON `ba`.`userid`=`c`.`userid` LEFT JOIN `db_city` `ci` ON `ci`.`areaid`=`c`.`areaid` WHERE `thumb2` <> '' AND `c`.`status` = 3 AND `ci`.`is_open` = 1 GROUP BY `userid` ORDER BY `count` DESC LIMIT 10 [ RunTime:0.001570s ]
SELECT c.*,SUM(tj.pv) as pvcum FROM `db_company` `c` LEFT JOIN `db_company_tj` `tj` ON `tj`.`userid`=`c`.`userid` LEFT JOIN `db_city` `ci` ON `ci`.`areaid`=`c`.`areaid` WHERE `thumb2` <> '' AND `c`.`status` = 3 AND `ci`.`is_open` = 1 AND `c_date` > '2022-11-07' GROUP BY `c`.`userid` ORDER BY `pvcum` DESC LIMIT 10 [ RunTime:9.399199s ]
SELECT `userid`,`company`,`company_jc`,`thumb`,`areaid`,`logincount` FROM `db_member` WHERE `thumb` <> '' AND `groupid` = 1 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `logincount` DESC LIMIT 10 [ RunTime:0.000670s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001016s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000308s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000425s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000696s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000608s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000454s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000476s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000378s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000425s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000395s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000363s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000374s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000402s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000357s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000372s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000453s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000371s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000374s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000365s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000418s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000353s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000359s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000355s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000411s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000367s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000360s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000358s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000369s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000360s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000368s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000436s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000405s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000361s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000353s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000365s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000472s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000369s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000357s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000362s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000363s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000367s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000362s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000360s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000362s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000362s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000369s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000406s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000367s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000413s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000370s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000391s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000367s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000361s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000360s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000359s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000369s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000377s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000360s ]
