基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-10-04 14:53:15 HTTP/1.1 GET : https://www.yiyebang.com/index/demand_index.html?type=6
- 运行时间 : 0.406392s [ 吞吐率:2.46req/s ] 内存消耗:1,094.56kb 文件加载:159
- 查询信息 : 38 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=961d5d4749e74f880de9cd2664fedc34
- CONNECT:[ UseTime:0.007855s ] mysql:host=rm-uf65tn56653ryi031ro.mysql.rds.aliyuncs.com;port=3306;dbname=sc_new_db;charset=utf8
- SHOW FULL COLUMNS FROM `sc_black_ip` [ RunTime:0.006251s ]
- SELECT * FROM `sc_black_ip` WHERE `ip` = '44.201.72.250' LIMIT 1 [ RunTime:0.005201s ]
- SHOW FULL COLUMNS FROM `sc_user` [ RunTime:0.006466s ]
- SELECT * FROM `sc_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.005003s ]
- SHOW FULL COLUMNS FROM `sc_company_join` [ RunTime:0.006217s ]
- SELECT * FROM `sc_company_join` WHERE `u_id` IS NULL AND `status` <> 0 LIMIT 1 [ RunTime:0.005009s ]
- SHOW FULL COLUMNS FROM `sc_user_wallet_log` [ RunTime:0.006423s ]
- SELECT COUNT(*) AS think_count FROM `sc_user_wallet_log` WHERE `u_id` IS NULL AND `action` = '3' LIMIT 1 [ RunTime:0.004933s ]
- SHOW FULL COLUMNS FROM `sc_user_wallet` [ RunTime:0.005938s ]
- SELECT * FROM `sc_user_wallet` WHERE `u_id` IS NULL LIMIT 1 [ RunTime:0.005022s ]
- SHOW FULL COLUMNS FROM `sc_vip_set` [ RunTime:0.005878s ]
- SELECT * FROM `sc_vip_set` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004945s ]
- SHOW FULL COLUMNS FROM `sc_user_vip` [ RunTime:0.006416s ]
- SELECT * FROM `sc_user_vip` WHERE `u_id` IS NULL LIMIT 1 [ RunTime:0.004978s ]
- SHOW FULL COLUMNS FROM `sc_user_apply_num` [ RunTime:0.005661s ]
- SELECT * FROM `sc_user_apply_num` WHERE `u_id` IS NULL LIMIT 1 [ RunTime:0.004917s ]
- SHOW FULL COLUMNS FROM `sc_user_card` [ RunTime:0.006102s ]
- SELECT * FROM `sc_user_card` WHERE `u_id` IS NULL LIMIT 1 [ RunTime:0.004971s ]
- SHOW FULL COLUMNS FROM `sc_industry_class` [ RunTime:0.005960s ]
- SELECT * FROM `sc_industry_class` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005052s ]
- SHOW FULL COLUMNS FROM `sc_district` [ RunTime:0.005849s ]
- SELECT `id`,`name` FROM `sc_district` WHERE `usetype` = 1 [ RunTime:0.005919s ]
- SELECT `id`,`name` FROM `sc_district` WHERE `level` = 1 AND `displayorder` <> 1 ORDER BY `displayorder` ASC [ RunTime:0.005970s ]
- SHOW FULL COLUMNS FROM `sc_class_coupon_mode` [ RunTime:0.005838s ]
- SELECT * FROM `sc_class_coupon_mode` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005047s ]
- SHOW FULL COLUMNS FROM `sc_class_consume` [ RunTime:0.005798s ]
- SELECT * FROM `sc_class_consume` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005027s ]
- SHOW FULL COLUMNS FROM `sc_class_use` [ RunTime:0.005705s ]
- SELECT * FROM `sc_class_use` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005034s ]
- SHOW FULL COLUMNS FROM `sc_class_roll` [ RunTime:0.005717s ]
- SELECT * FROM `sc_class_roll` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005097s ]
- SHOW FULL COLUMNS FROM `sc_class_group` [ RunTime:0.005751s ]
- SELECT * FROM `sc_class_group` WHERE `status` = 0 ORDER BY `sort` DESC [ RunTime:0.005016s ]
- SHOW FULL COLUMNS FROM `sc_demand` [ RunTime:0.006137s ]
- SELECT COUNT(*) AS think_count FROM `sc_demand` `a` INNER JOIN `sc_demand_info` `b` ON `a`.`id`=`b`.`id` WHERE `a`.`status` = '2' AND `a`.`type_id` = '6' LIMIT 1 [ RunTime:0.017853s ]
- SELECT `a`.`id`,`a`.`title`,`a`.`views`,`a`.`city`,`a`.`sq_num`,`a`.`top_time`,`a`.`thetop`,`a`.`type_id`,`b`.`department`,`b`.`position`,`c`.`name`,`uc`.`contact`,`uc`.`company_alias`,`u`.`avatarUrl`,`e`.`name` AS `province_name` FROM `sc_demand` `a` INNER JOIN `sc_demand_info` `b` ON `a`.`id`=`b`.`id` INNER JOIN `sc_user` `u` ON `u`.`id`=`a`.`u_id` INNER JOIN `sc_user_card` `uc` ON `uc`.`u_id`=`a`.`u_id` LEFT JOIN `sc_district` `e` ON `e`.`id`=`a`.`province` LEFT JOIN `sc_company` `c` ON `c`.`id`=`a`.`c_id` WHERE `a`.`status` = '2' AND `a`.`is_show` = '0' AND `thetop` = 0 AND `top_time` = 0 ORDER BY `a`.`add_time` DESC LIMIT 12 [ RunTime:0.005844s ]
- SELECT * FROM `sc_user_card` WHERE `u_id` IS NULL LIMIT 1 [ RunTime:0.004901s ]
- SELECT `a`.*,`b`.`avatarUrl`,`c`.`name` AS `hy_name`,`d`.`name` AS `sf_name` FROM `sc_user_card` `a` INNER JOIN `sc_user` `b` ON `a`.`u_id`=`b`.`id` LEFT JOIN `sc_industry` `c` ON `a`.`hy_type`=`c`.`id` LEFT JOIN `sc_user_sf` `d` ON `a`.`sf_type`=`d`.`id` ORDER BY CASE WHEN a.add_time>=1695797595 THEN `views` ELSE a.id END DESC LIMIT 12 [ RunTime:0.167841s ]

0.407232s