SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001371s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001063s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001175s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `pt` = 1 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000960s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001068s ]
SELECT * FROM `db_seo` WHERE `url` = '/' LIMIT 1 [ RunTime:0.000362s ]
SELECT * FROM `db_city` WHERE `name` LIKE '%阿什%' LIMIT 1 [ RunTime:0.008175s ]
SELECT * FROM `db_city` WHERE `is_open` = 1 AND `domain` <> '' ORDER BY `areaid` ASC [ RunTime:0.000571s ]
SELECT * FROM `db_city` WHERE `areaid` IN (1,2,3,4,231,233) AND `is_open` = 1 ORDER BY `areaid` ASC [ RunTime:0.000468s ]
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.000525s ]
SELECT * FROM `db_city` WHERE `parentid` = 0 AND `is_open` = 1 ORDER BY `areaid` ASC [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.002448s ]
SELECT * FROM `db_ad` WHERE `pid` = 3 AND `areaid` = 0 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000482s ]
SELECT * FROM `db_ad` WHERE `pid` = 5 AND `areaid` = 0 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000496s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.001469s ]
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.001513s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001519s ]
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.000453s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001495s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51456 [ RunTime:0.008407s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001954s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51456 [ RunTime:0.000368s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51457 [ RunTime:0.008185s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51457 [ RunTime:0.000364s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52481 [ RunTime:0.008251s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52481 [ RunTime:0.000382s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52482 [ RunTime:0.008252s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52482 [ RunTime:0.000377s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.008136s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000358s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52228 [ RunTime:0.008099s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52228 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51205 [ RunTime:0.008033s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51205 [ RunTime:0.000278s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51717 [ RunTime:0.008221s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51717 [ RunTime:0.000434s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51206 [ RunTime:0.008321s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51206 [ RunTime:0.000436s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51718 [ RunTime:0.008267s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51718 [ RunTime:0.000433s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51974 [ RunTime:0.008315s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51974 [ RunTime:0.000426s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51207 [ RunTime:0.008237s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51207 [ RunTime:0.000426s ]
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.000516s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50219 [ RunTime:0.008271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50219 [ RunTime:0.000363s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50034 [ RunTime:0.008208s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50034 [ RunTime:0.000502s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50003 [ RunTime:0.008349s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50003 [ RunTime:0.000429s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51456 [ RunTime:0.000392s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51456 [ RunTime:0.000355s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51457 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51457 [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52481 [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52481 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52482 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52482 [ RunTime:0.000264s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52228 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52228 [ RunTime:0.000270s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51205 [ RunTime:0.000268s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51205 [ RunTime:0.000270s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51717 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51717 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51206 [ RunTime:0.000266s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51206 [ RunTime:0.000272s ]
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.000335s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50380 [ RunTime:0.008075s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50380 [ RunTime:0.000282s ]
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` > '2023-09-03' GROUP BY `c`.`userid` ORDER BY `pvcum` DESC LIMIT 10 [ RunTime:0.420377s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001702s ]
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.000795s ]
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.001767s ]
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.001192s ]
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.000811s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002260s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.000765s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1518 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.007644s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1519 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.004092s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1521 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.002443s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1522 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001941s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1523 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.002483s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1524 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.002385s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1526 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001339s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1527 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001875s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1528 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001424s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1530 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001869s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1531 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001472s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1532 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001898s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1534 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.002380s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `fengge` = 1535 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.001334s ]
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.001504s ]
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` > '2023-09-03' GROUP BY `c`.`userid` ORDER BY `pvcum` DESC LIMIT 10 [ RunTime:10.568889s ]
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.000634s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001248s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000406s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000423s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000497s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000455s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000453s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000451s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000458s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000466s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000451s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000448s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000454s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000453s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000451s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000448s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000464s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000535s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000455s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000472s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000413s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000411s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000409s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000405s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000417s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000435s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000385s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000403s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000381s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000384s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000381s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000380s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000385s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000380s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000392s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000381s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000384s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000385s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000381s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000389s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000384s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000396s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000389s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000393s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000388s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000388s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000383s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000386s ]
SELECT `areaid`,`name` FROM `db_city` [ RunTime:0.000388s ]
