【前海航交所】金融资产交易平台|互联网理财|海航集团成员企业|交易所持牌机构|专注于航空航运领域

基本文件流程错误 SQL 调试

/data/web_v2/index.php ( 3.13 KB )
/data/web_v2/CORE/Core.php ( 1.72 KB )
/data/web_v2/CORE/Common/runtime.php ( 9.72 KB )
/data/web_v2/CORE/Common/common.php ( 23.15 KB )
/data/web_v2/CORE/Lib/Core/Think.class.php ( 11.39 KB )
/data/web_v2/CORE/Lib/Core/ThinkException.class.php ( 0.78 KB )
/data/web_v2/CORE/Lib/Core/Behavior.class.php ( 1.71 KB )
/data/web_v2/CORE/Conf/alias.php ( 1.15 KB )
/data/web_v2/CORE/Conf/convention.php ( 9.02 KB )
/data/web_v2/App/Conf/config.php ( 5.91 KB )
/data/web_v2/App/Conf/config.biz.php ( 40.59 KB )
/data/web_v2/CORE/Lang/zh-cn.php ( 2.59 KB )
/data/web_v2/CORE/Conf/tags.php ( 1.56 KB )
/data/web_v2/App/Conf/tags.php ( 0.11 KB )
/data/web_v2/CORE/Common/functions.php ( 26.40 KB )
/data/web_v2/CORE/Lib/Core/Log.class.php ( 5.19 KB )
/data/web_v2/CORE/Lib/Core/Dispatcher.class.php ( 11.37 KB )
/data/web_v2/CORE/Lib/Core/App.class.php ( 13.90 KB )
/data/web_v2/CORE/Lib/Core/Action.class.php ( 14.87 KB )
/data/web_v2/CORE/Lib/Core/View.class.php ( 4.38 KB )
/data/web_v2/App/Common/common.php ( 63.56 KB )
/data/web_v2/App/Common/Lib.php ( 202.92 KB )
/data/web_v2/App/Common/DataSource.php ( 3.79 KB )
/data/web_v2/App/Common/General.php ( 104.44 KB )
/data/web_v2/App/Common/bonus.functions.php ( 6.50 KB )
/data/web_v2/CORE/Conf/debug.php ( 1.73 KB )
/data/web_v2/App/Conf/debug.php ( 1.28 KB )
/data/web_v2/App/Conf/log.php ( 23.66 KB )
/data/web_v2/App/Conf/borrow_config.php ( 8.26 KB )
/data/web_v2/CORE/Lib/Behavior/CheckRouteBehavior.class.php ( 9.51 KB )
/data/web_v2/App/Group/Home/Conf/config.php ( 0.95 KB )
/data/web_v2/App/Group/Home/Common/function.php ( 11.03 KB )
/data/web_v2/CORE/Lib/Behavior/ReadHtmlCacheBehavior.class.php ( 5.48 KB )
/data/web_v2/CORE/Extend/Behavior/CheckLangBehavior.class.php ( 3.57 KB )
/data/web_v2/App/Group/Home/Action/IndexAction.class.php ( 61.86 KB )
/data/web_v2/App/Group/Home/Action/HCommonAction.class.php ( 18.98 KB )
/data/web_v2/CORE/Lib/Core/Cache.class.php ( 3.77 KB )
/data/web_v2/CORE/Extend/Driver/Cache/CacheMemcache.class.php ( 3.63 KB )
/data/web_v2/CORE/Lib/Driver/Cache/CacheFile.class.php ( 5.95 KB )
/data/web_v2/CORE/Lib/Core/Model.class.php ( 54.48 KB )
/data/web_v2/CORE/Lib/Core/Db.class.php ( 33.53 KB )
/data/web_v2/CORE/Lib/Driver/Db/DbMysql.class.php ( 11.05 KB )
/data/web_v2/Webconfig/loginconfig.php ( 0.23 KB )
/data/web_v2/App/Lib/Util/Sql.class.php ( 1.44 KB )
/data/web_v2/App/Lib/Behavior/DebtBehavior.class.php ( 62.76 KB )
/data/web_v2/CORE/Extend/Library/ORG/Util/Page.class.php ( 14.89 KB )
/data/web_v2/CORE/Lib/Behavior/LocationTemplateBehavior.class.php ( 2.22 KB )
/data/web_v2/CORE/Lib/Behavior/ParseTemplateBehavior.class.php ( 5.90 KB )
/data/web_v2/CORE/Lib/Template/ThinkTemplate.class.php ( 30.39 KB )
/data/web_v2/CORE/Lib/Driver/TagLib/TagLibCx.class.php ( 24.35 KB )
/data/web_v2/CORE/Lib/Template/TagLib.class.php ( 8.55 KB )
/data/web_v2/App/Runtime/Cache/Home/d6993fd376950bea27a95d0e1fb7631c.php ( 45.14 KB )
/data/web_v2/CORE/Lib/Behavior/ContentReplaceBehavior.class.php ( 2.29 KB )
/data/web_v2/CORE/Lib/Behavior/TokenBuildBehavior.class.php ( 2.51 KB )
/data/web_v2/CORE/Lib/Behavior/WriteHtmlCacheBehavior.class.php ( 1.41 KB )
/data/web_v2/CORE/Lib/Behavior/ShowRuntimeBehavior.class.php ( 3.59 KB )
/data/web_v2/CORE/Lib/Behavior/ShowPageTraceBehavior.class.php ( 5.52 KB )

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1 [ SQL语句 ] : SELECT `b2c_grade` FROM `lzh_members` WHERE ( id= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.debt_uid= ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND d.buy_time > 0 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status IN (2,3,4,5) ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1 [ SQL语句 ] : SELECT `user_phone` FROM `lzh_members` WHERE ( id= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.debt_uid= ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND d.buy_time > 0 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status IN (2,3,4,5) ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc' at line 1 [ SQL语句 ] : SELECT d.transfer_price,b.guarantor,IF(d.status=2,d.status,0) AS order_status,d.status,d.money,d.total_period,d.period,d.valid,d.id as debt_id,d.debt_rate,i.id as invest_id,d.buy_time,i.investor_capital,i.receive_interest,i.reward_money,i.investor_uid,i.deadline,b.id,b.borrow_name,b.repayment_type,b.borrow_type,b.borrow_interest_rate_show,b.add_award,b.borrow_info,b.borrow_interest_rate,b.borrow_status,b.borrow_duration,(b.borrow_interest_rate_show+b.add_award) as borrow_interest_a_rate_show,IF(d.status=2,IF(unix_timestamp() < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(unix_timestamp()),FROM_UNIXTIME(i.deadline))/1440),0),IF(d.status=1 || d.status=4,IF(d.buy_time < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(d.buy_time),FROM_UNIXTIME(i.deadline))/1440),0),0)) as lefttimeStr FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor i ON d.invest_id=i.id LEFT JOIN lzh_borrow_info b ON i.borrow_id = b.id WHERE ( d.status IN ('2') ) AND ( (d.debt_rate BETWEEN '0' AND '100' ) ) AND ( b.detb_range = 0 ) AND ( (d.is_inter=0 OR (d.is_inter=1 AND d.sell_uid=)) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc,d.debt_rate desc, d.update_time desc LIMIT 0,5
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.debt_uid= ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND d.buy_time > 0 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status IN (2,3,4,5) ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc' at line 1 [ SQL语句 ] : SELECT d.transfer_price,b.guarantor,IF(d.status=2,d.status,0) AS order_status,d.status,d.money,d.total_period,d.period,d.valid,d.id as debt_id,d.debt_rate,i.id as invest_id,d.buy_time,i.investor_capital,i.receive_interest,i.reward_money,i.investor_uid,i.deadline,b.id,b.borrow_name,b.repayment_type,b.borrow_type,b.borrow_interest_rate_show,b.add_award,b.borrow_info,b.borrow_interest_rate,b.borrow_status,b.borrow_duration,(b.borrow_interest_rate_show+b.add_award) as borrow_interest_a_rate_show,IF(d.status=2,IF(unix_timestamp() < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(unix_timestamp()),FROM_UNIXTIME(i.deadline))/1440),0),IF(d.status=1 || d.status=4,IF(d.buy_time < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(d.buy_time),FROM_UNIXTIME(i.deadline))/1440),0),0)) as lefttimeStr FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor i ON d.invest_id=i.id LEFT JOIN lzh_borrow_info b ON i.borrow_id = b.id WHERE ( d.status IN ('1','4') ) AND ( (d.debt_rate BETWEEN '0' AND '100' ) ) AND ( b.detb_range = 0 ) AND ( (d.is_inter=0 OR (d.is_inter=1 AND d.sell_uid=)) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc, d.update_time desc LIMIT 0,4
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.debt_uid= ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND d.buy_time > 0 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status IN (2,3,4,5) ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND r.debt_uid= ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND d.buy_time > 0 ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status IN (2,3,4,5) ) LIMIT 1' at line 1 [ SQL语句 ] : SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1 [ SQL语句 ] : SELECT `user_phone` FROM `lzh_members` WHERE ( id= ) LIMIT 1

SHOW COLUMNS FROM `lzh_area` [ RunTime:0.001190s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_area' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000883s ]
SELECT `id`,`reid`,`name`,`sort_order`,`is_open`,`domain` FROM `lzh_area` WHERE ( `is_open` = 1 ) [ RunTime:0.000304s ]
SHOW COLUMNS FROM `lzh_user_coupon` [ RunTime:0.000902s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_user_coupon' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000711s ]
SELECT COUNT(id) AS tp_count FROM `lzh_user_coupon` WHERE ( `status` = 0 ) AND ( `user_id` = null ) LIMIT 1 [ RunTime:0.000295s ]
SHOW COLUMNS FROM `lzh_deduction_coupons` [ RunTime:0.000825s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_deduction_coupons' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000678s ]
SELECT COUNT(id) AS tp_count FROM `lzh_deduction_coupons` WHERE ( `status` = 0 ) AND ( `user_id` = null ) LIMIT 1 [ RunTime:0.000533s ]
SHOW COLUMNS FROM `lzh_user_practice` [ RunTime:0.000782s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_user_practice' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000722s ]
SELECT COUNT(id) AS tp_count FROM `lzh_user_practice` WHERE ( `status` = 0 ) AND ( `user_id` = null ) LIMIT 1 [ RunTime:0.000337s ]
SHOW COLUMNS FROM `lzh_user_practice_invest` [ RunTime:0.000758s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_user_practice_invest' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000718s ]
SELECT COUNT(id) AS tp_count FROM `lzh_user_practice_invest` WHERE ( `status` = 0 ) AND ( `user_id` = null ) LIMIT 1 [ RunTime:0.000327s ]
SHOW COLUMNS FROM `lzh_invest_pledge` [ RunTime:0.000994s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_invest_pledge' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000646s ]
SELECT COUNT(*) AS tp_count FROM `lzh_invest_pledge` LIMIT 1 [ RunTime:0.000360s ]
SHOW COLUMNS FROM `lzh_members` [ RunTime:0.001769s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_members' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.001130s ]
SELECT `b2c_grade` FROM `lzh_members` WHERE ( id= ) LIMIT 1 [ RunTime:0.000484s ]
SHOW COLUMNS FROM `lzh_type` [ RunTime:0.000904s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_type' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000770s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'b2c_grade_list' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 439 and status = 1 ) ORDER BY sort desc [ RunTime:0.000322s ]
SHOW COLUMNS FROM `lzh_member_vip` [ RunTime:0.000880s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_member_vip' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000759s ]
SELECT * FROM `lzh_member_vip` WHERE ( uid = '' ) LIMIT 1 [ RunTime:0.000359s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'list_show_rule' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 457 and status = 1 ) ORDER BY sort desc [ RunTime:0.000328s ]
SHOW COLUMNS FROM `lzh_borrow_investor` [ RunTime:0.001072s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_borrow_investor' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000724s ]
SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1 [ RunTime:0.000350s ]
SHOW COLUMNS FROM `lzh_invest_detb` [ RunTime:0.000964s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_invest_detb' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000669s ]
SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1 [ RunTime:0.000381s ]
SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1 [ RunTime:0.000356s ]
SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1 [ RunTime:0.000325s ]
SHOW COLUMNS FROM `lzh_fund_invs` [ RunTime:0.000772s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_fund_invs' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000667s ]
SELECT SUM(investor_capital) AS tp_sum FROM `lzh_fund_invs` WHERE ( `owner_uid` = null ) AND ( `status` > '3' ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `user_phone` FROM `lzh_members` WHERE ( id= ) LIMIT 1 [ RunTime:0.000299s ]
SHOW COLUMNS FROM `lzh_relas` [ RunTime:0.000692s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_relas' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000654s ]
SELECT * FROM `lzh_relas` WHERE ( rela_phone='' ) LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000760s ]
select sum(has_borrow) as tmoney from lzh_borrow_info where borrow_status in (6,7); [ RunTime:0.000414s ]
select sum(transfer_price) as dmoney from lzh_invest_detb where status = 1 or status = 4 [ RunTime:0.000299s ]
SELECT COUNT(*) AS tp_count FROM `lzh_members` LIMIT 1 [ RunTime:0.000309s ]
SHOW COLUMNS FROM `lzh_borrow_offline` [ RunTime:0.000807s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_borrow_offline' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000681s ]
SELECT SUM(invest_capital) AS tp_sum FROM `lzh_borrow_offline` WHERE ( `borrow_status` >= 6 ) AND ( `verify_status` = 1 ) LIMIT 1 [ RunTime:0.000311s ]
SHOW COLUMNS FROM `lzh_inst` [ RunTime:0.000692s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_inst' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000691s ]
SELECT SUM(inst_price) AS tp_sum FROM `lzh_inst` WHERE ( inst_status>=1 and inst_type=1 ) LIMIT 1 [ RunTime:0.000320s ]
SELECT `inst_status`,`inst_price` FROM `lzh_inst` WHERE ( inst_status>=1 and inst_type=2 ) [ RunTime:0.001541s ]
SHOW COLUMNS FROM `lzh_assets` [ RunTime:0.000758s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_assets' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000687s ]
SELECT SUM(com_price) AS tp_sum FROM `lzh_assets` WHERE ( project_status=2 and status=2 ) LIMIT 1 [ RunTime:0.000328s ]
SHOW COLUMNS FROM `lzh_company` [ RunTime:0.000823s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_company' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000637s ]
SELECT COUNT(*) AS tp_count FROM `lzh_company` WHERE ( flag_status=1 ) LIMIT 1 [ RunTime:0.000320s ]
SHOW COLUMNS FROM `lzh_article` [ RunTime:0.000705s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_article' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000679s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 402 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000505s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 444 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000571s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info`,`art_content` FROM `lzh_article` WHERE ( type_id=444 ) ORDER BY id DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 402 ) ORDER BY id DESC LIMIT 15 [ RunTime:0.000340s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 445 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000310s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info`,`art_content` FROM `lzh_article` WHERE ( type_id=445 ) ORDER BY id DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 338 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000319s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info`,`art_content` FROM `lzh_article` WHERE ( type_id=338 ) ORDER BY id DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info` FROM `lzh_article` WHERE ( `type_id` = 442 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000430s ]
SELECT `id`,`title`,`art_set`,`art_time`,`art_url`,`art_info`,`art_content` FROM `lzh_article` WHERE ( type_id=442 ) ORDER BY id DESC LIMIT 1 [ RunTime:0.000338s ]
SHOW COLUMNS FROM `lzh_borrow_info` [ RunTime:0.001572s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_borrow_info' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000650s ]
SELECT `id`,`borrow_name`,`borrow_status`,(borrow_interest_rate_show+add_award) as borrow_interest_rate_show,`has_borrow`,`borrow_duration`,TRUNCATE(has_borrow/borrow_money*100,0) AS progress,TRUNCATE(borrow_money/10000,2) AS borrow_money,`is_tuijian`,`add_award`,`borrow_min`,`borrow_status`,schedular_time>NOW() AS is_openning,`b2c_grade`,`is_floating` FROM `lzh_borrow_info` WHERE ( FIND_IN_SET('0',show_range) AND borrow_status IN (2,4,5,6) AND is_beginner=1 AND borrow_type<>6 AND jiaxi_days=0 AND borrow_type<>6 AND is_pass = 0 AND sp_name='' AND is_pilot_only=0 AND is_staff_only = 0 AND b2c_grade=0 ) ORDER BY borrow_status ASC,is_tuijian DESC,id DESC LIMIT 1 [ RunTime:0.023836s ]
SELECT `id`,`borrow_name`,`borrow_status`,(borrow_interest_rate_show+add_award) as borrow_interest_rate_show,`has_borrow`,`borrow_duration`,TRUNCATE(has_borrow/borrow_money*100,0) AS progress,TRUNCATE(borrow_money/10000,2) AS borrow_money,(borrow_money-has_borrow) AS rest,`borrow_min`,`is_tuijian`,`add_award`,`borrow_status`,schedular_time>NOW() AS is_openning,`is_order`,`schedular_time`,`b2c_grade`,`is_floating` FROM `lzh_borrow_info` WHERE ( FIND_IN_SET('0',show_range) AND borrow_status IN (2,4,6,7) AND is_beginner=0 AND id>1000 AND borrow_type<>6 AND jiaxi_days=0 AND borrow_type<>6 AND is_pass = 0 AND sp_name='' AND is_pilot_only=0 AND is_staff_only = 0 AND b2c_grade=0 ) ORDER BY borrow_status ASC,is_tuijian DESC,id DESC LIMIT 5 [ RunTime:0.036726s ]
SHOW COLUMNS FROM `lzh_fund_info` [ RunTime:0.001225s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_fund_info' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000778s ]
SELECT * FROM `lzh_fund_info` WHERE ( fund_status=2 AND fund_till>=1652745810 ) ORDER BY is_tuijian DESC,fund_till ASC,id ASC LIMIT 1 [ RunTime:0.000681s ]
SELECT * FROM `lzh_fund_info` WHERE ( `fund_status` IN ('2','4','5','6','7') ) ORDER BY id DESC LIMIT 1 [ RunTime:0.000536s ]
SHOW COLUMNS FROM `lzh_invest_detb` [ RunTime:0.000982s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_invest_detb' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000649s ]
SELECT `id`,`user_phone` FROM `lzh_members` LIMIT 1 [ RunTime:0.000327s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'debt_config' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000285s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 469 and status = 1 ) ORDER BY sort desc [ RunTime:0.000307s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'list_show_rule' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 457 and status = 1 ) ORDER BY sort desc [ RunTime:0.000347s ]
SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1 [ RunTime:0.000369s ]
SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1 [ RunTime:0.000369s ]
SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1 [ RunTime:0.000459s ]
SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1 [ RunTime:0.000278s ]
SELECT SUM(investor_capital) AS tp_sum FROM `lzh_fund_invs` WHERE ( `owner_uid` = null ) AND ( `status` > '3' ) LIMIT 1 [ RunTime:0.000410s ]
SELECT COUNT(*) AS tp_count FROM `lzh_invest_detb` WHERE ( status=1 AND buy_time>0 ) LIMIT 1 [ RunTime:0.000377s ]
SELECT d.transfer_price,b.guarantor,IF(d.status=2,d.status,0) AS order_status,d.status,d.money,d.total_period,d.period,d.valid,d.id as debt_id,d.debt_rate,i.id as invest_id,d.buy_time,i.investor_capital,i.receive_interest,i.reward_money,i.investor_uid,i.deadline,b.id,b.borrow_name,b.repayment_type,b.borrow_type,b.borrow_interest_rate_show,b.add_award,b.borrow_info,b.borrow_interest_rate,b.borrow_status,b.borrow_duration,(b.borrow_interest_rate_show+b.add_award) as borrow_interest_a_rate_show,IF(d.status=2,IF(unix_timestamp() < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(unix_timestamp()),FROM_UNIXTIME(i.deadline))/1440),0),IF(d.status=1 || d.status=4,IF(d.buy_time < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(d.buy_time),FROM_UNIXTIME(i.deadline))/1440),0),0)) as lefttimeStr FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor i ON d.invest_id=i.id LEFT JOIN lzh_borrow_info b ON i.borrow_id = b.id WHERE ( d.status IN ('2') ) AND ( (d.debt_rate BETWEEN '0' AND '100' ) ) AND ( b.detb_range = 0 ) AND ( (d.is_inter=0 OR (d.is_inter=1 AND d.sell_uid=)) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc,d.debt_rate desc, d.update_time desc LIMIT 0,5 [ RunTime:0.000534s ]
SELECT `id`,`user_phone` FROM `lzh_members` LIMIT 1 [ RunTime:0.000317s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'debt_config' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 469 and status = 1 ) ORDER BY sort desc [ RunTime:0.000311s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'list_show_rule' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000284s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 457 and status = 1 ) ORDER BY sort desc [ RunTime:0.000325s ]
SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1 [ RunTime:0.000326s ]
SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1 [ RunTime:0.000370s ]
SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1 [ RunTime:0.000310s ]
SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1 [ RunTime:0.000337s ]
SELECT SUM(investor_capital) AS tp_sum FROM `lzh_fund_invs` WHERE ( `owner_uid` = null ) AND ( `status` > '3' ) LIMIT 1 [ RunTime:0.000316s ]
SELECT COUNT(*) AS tp_count FROM `lzh_invest_detb` WHERE ( status=1 AND buy_time>0 ) LIMIT 1 [ RunTime:0.000307s ]
SELECT d.transfer_price,b.guarantor,IF(d.status=2,d.status,0) AS order_status,d.status,d.money,d.total_period,d.period,d.valid,d.id as debt_id,d.debt_rate,i.id as invest_id,d.buy_time,i.investor_capital,i.receive_interest,i.reward_money,i.investor_uid,i.deadline,b.id,b.borrow_name,b.repayment_type,b.borrow_type,b.borrow_interest_rate_show,b.add_award,b.borrow_info,b.borrow_interest_rate,b.borrow_status,b.borrow_duration,(b.borrow_interest_rate_show+b.add_award) as borrow_interest_a_rate_show,IF(d.status=2,IF(unix_timestamp() < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(unix_timestamp()),FROM_UNIXTIME(i.deadline))/1440),0),IF(d.status=1 || d.status=4,IF(d.buy_time < i.deadline,ceil(TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(d.buy_time),FROM_UNIXTIME(i.deadline))/1440),0),0)) as lefttimeStr FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor i ON d.invest_id=i.id LEFT JOIN lzh_borrow_info b ON i.borrow_id = b.id WHERE ( d.status IN ('1','4') ) AND ( (d.debt_rate BETWEEN '0' AND '100' ) ) AND ( b.detb_range = 0 ) AND ( (d.is_inter=0 OR (d.is_inter=1 AND d.sell_uid=)) AND d.buy_time > 0 AND d.buy_time<='1522857600' ) ORDER BY order_status desc, d.update_time desc LIMIT 0,4 [ RunTime:0.000376s ]
SELECT `id`,`inst_name`,`inst_type`,`inst_status`,`inst_price`,`inst_desc`,`inst_img`,`inst_intro`,`inst_time`,`inst_done_time`,`inst_cash_time`,`add_time`,`inst_level`,`inst_duration`,`inst_rate`,`inst_duration_type`,`add_by` FROM `lzh_inst` WHERE ( inst_type=1 ) ORDER BY inst_status asc,inst_time desc LIMIT 1 [ RunTime:0.000449s ]
SHOW COLUMNS FROM `lzh_assets` [ RunTime:0.000702s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_assets' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000674s ]
SELECT a.id,a.name,a.succ_time,a.com_price,a.status,`project_status` FROM lzh_assets a WHERE ( com_price>0 AND status=2 AND project_status=2 ) ORDER BY a.id DESC LIMIT 2 [ RunTime:0.000391s ]
SHOW COLUMNS FROM `lzh_ad` [ RunTime:0.000654s ]
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_NAME='lzh_ad' AND CONSTRAINT_SCHEMA='hjs2015db' [ RunTime:0.000735s ]
SELECT `content` FROM `lzh_ad` WHERE ( ad_key='banner_anonymous' ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'list_show_rule' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 457 and status = 1 ) ORDER BY sort desc [ RunTime:0.001064s ]
SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1 [ RunTime:0.000545s ]
SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1 [ RunTime:0.000635s ]
SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1 [ RunTime:0.000820s ]
SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1 [ RunTime:0.000770s ]
SELECT SUM(investor_capital) AS tp_sum FROM `lzh_fund_invs` WHERE ( `owner_uid` = null ) AND ( `status` > '3' ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `lzh_type` WHERE ( `code` = 'list_show_rule' ) AND ( `status` = 1 ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id`,`name`,`code` FROM `lzh_type` WHERE ( pid = 457 and status = 1 ) ORDER BY sort desc [ RunTime:0.000472s ]
SELECT SUM(investor_capital) AS tp_sum FROM lzh_borrow_investor i LEFT JOIN lzh_borrow_info b ON b.id=i.borrow_id WHERE ( i.investor_uid= AND i.debt_uid=0 AND b.borrow_status>5 ) LIMIT 1 [ RunTime:0.000650s ]
SELECT SUM(transfer_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.buy_uid= AND r.debt_uid= ) LIMIT 1 [ RunTime:0.000437s ]
SELECT SUM(ori_price) AS tp_sum FROM lzh_invest_detb d LEFT JOIN lzh_borrow_investor r ON d.invest_id=r.id WHERE ( d.sell_uid= AND d.buy_time > 0 ) LIMIT 1 [ RunTime:0.000381s ]
SELECT SUM(pledge_amount) AS tp_sum FROM `lzh_invest_pledge` WHERE ( invest_uid= AND status IN (2,3,4,5) ) LIMIT 1 [ RunTime:0.000300s ]
SELECT SUM(investor_capital) AS tp_sum FROM `lzh_fund_invs` WHERE ( `owner_uid` = null ) AND ( `status` > '3' ) LIMIT 1 [ RunTime:0.000329s ]
SELECT `user_phone` FROM `lzh_members` WHERE ( id= ) LIMIT 1 [ RunTime:0.000346s ]
SELECT * FROM `lzh_relas` WHERE ( rela_phone='' ) LIMIT 1 [ RunTime:0.000313s ]

个人登录

欢迎下载

合作机构

收益计算器