Биллинговая система Nodeny

# Только для отладки
$ses::debug = 0;

	Type/sec	Sub	Debug
+	0.087843	
95 Db.pm::connect
	Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.02476 sec
+	0.088686	
321 Db.pm::sql
	SELECT *, UNIX_TIMESTAMP() AS t FROM config ORDER BY time DESC LIMIT 1
Строк: 1. Время выполнения sql: 0.0005 сек
+	0.091793	
224 calls.pm
	

Текущие cookies: 
  noses  = 'ipE9QNcbFRjRddtkNnM9Kw'

+	0.092479	
321 Db.pm::sql
	SELECT * FROM websessions s LEFT JOIN admin a ON (s.uid=a.id AND s.role='admin') WHERE BINARY ses='ipE9QNcbFRjRddtkNnM9Kw' AND uid>0 LIMIT 1
Строк: 0. Время выполнения sql: 0.0004 сек
+	0.092618	
275 calls.pm
	Сессии `ipE9QNcbFRjRddtkNnM9Kw` нет в БД. Скорее всего удалена по таймауту.
+	0.093106	
1091 calls.pm::Require_mod
	require /usr/local/nodeny/web/cap/_main.pl
+	0.094078	
1091 calls.pm::Require_mod
	require /usr/local/nodeny/web/lang/RU_cap.pl
+	0.106536	
321 Db.pm::sql
	SELECT
IF(a.start IS NULL AND u.lstate = 0,0,1) AS auth,
EXISTS( SELECT uid FROM users_services
WHERE uid=u.id AND tags LIKE '%,inet,%') AS inet,
i.uid, INET_NTOA(i.ip) AS ip, u.state
FROM ip_pool i
LEFT JOIN auth_now a ON INET_NTOA(i.ip)=a.ip
LEFT JOIN users u ON i.uid=u.id
WHERE INET_NTOA(i.ip)='172.20.110.7'

Строк: 1. Время выполнения sql: 0.0120 сек
+	0.108759	
383 calls.pm::Render
	Elapsed time: 0.108604 sec

rm -fR /usr/local/www/apache22/cgi-bin
rm -fR /usr/local/www/apache22/data
ln -s /usr/local/nodeny/cgi-bin/ /usr/local/www/apache22/cgi-bin
ln -s /usr/local/nodeny/htdocs/ /usr/local/www/apache22/data

	Type/sec	Sub	Debug
+	0.069744	
95 Db.pm::connect
	Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.023635 sec
+	0.070488	
321 Db.pm::sql
	SELECT *, UNIX_TIMESTAMP() AS t FROM config ORDER BY time DESC LIMIT 1
Строк: 1. Время выполнения sql: 0.0005 сек
+	0.073426	
224 calls.pm
	

Текущие cookies: 
  cols   = 'iauth,uinfo,uid,iip,ufio,d_adr_street,d_adr_house,d_adr_room,d_adr_block,d_adr_telefon,sservice_id,utraf,ubalance,ulimit_balance'
  noses  = 'ZsM9hLRSNN57vrbL435sQA'

+	0.073812	
321 Db.pm::sql
	SELECT * FROM websessions s LEFT JOIN admin a ON (s.uid=a.id AND s.role='admin') WHERE BINARY ses='ZsM9hLRSNN57vrbL435sQA' AND uid>0 LIMIT 1
Строк: 0. Время выполнения sql: 0.0002 сек
+	0.073951	
275 calls.pm
	Сессии `ZsM9hLRSNN57vrbL435sQA` нет в БД. Скорее всего удалена по таймауту.
+	0.074385	
1091 calls.pm::Require_mod
	require /usr/local/nodeny/web/cap/_main.pl
+	0.075327	
1091 calls.pm::Require_mod
	require /usr/local/nodeny/web/lang/RU_cap.pl
+	0.087921	
321 Db.pm::sql
	SELECT
IF(a.start IS NULL AND u.lstate = 0,0,1) AS auth,
EXISTS( SELECT uid FROM users_services
WHERE uid=u.id AND tags LIKE '%,inet,%') AS inet,
i.uid, INET_NTOA(i.ip) AS ip, u.state
FROM ip_pool i
LEFT JOIN auth_now a ON INET_NTOA(i.ip)=a.ip
LEFT JOIN users u ON i.uid=u.id
WHERE INET_NTOA(i.ip)='172.20.120.122'

Строк: 1. Время выполнения sql: 0.0121 сек
+	0.088346	
321 Db.pm::sql
	SELECT * FROM pays WHERE category=424 AND mid='219'
Строк: 0. Время выполнения sql: 0.0001 сек
+	0.090584	
383 calls.pm::Render
	Elapsed time: 0.090431 sec