×
×
Введите пароль для подтверждения изменений
A
A
BillS
Кабинет пользователя
Armenian
Azeri
English
French
Spain
Uzbek
Беларускi
Болгарська
Русский
Українська
Войти
Забыли пароль
Регистрация
A
BillS
Queries: 7
Queries:
1 =================================== SELECT 0, a.full_log, a.id AS a_login, a.disable, a.web_options, a.gid, a.position, a.domain_id, a.max_credit, a.max_rows, a.credit_days, a.expire, COUNT(ag.aid) AS gids_, COUNT(aa.aid) AS admin_access, a.aid, a.name AS a_fio FROM admins a LEFT JOIN admins_groups ag ON (a.aid=ag.aid) LEFT JOIN domains d ON (a.domain_id=d.id) LEFT JOIN admins_access aa ON (aa.aid=a.aid) WHERE a.aid= ? GROUP BY a.aid ORDER BY a.aid DESC LIMIT 1; 2 =================================== SELECT param, value FROM config WHERE domain_id = ? 3 =================================== SELECT c.user_name, c.framed_ip_address, c.uid,c.nas_id,c.acct_session_id,c.user_name FROM internet_online c LEFT JOIN users u ON (u.uid=c.uid) LEFT JOIN internet_main service ON (service.id = c.service_id) WHERE (c.framed_ip_address=INET_ATON('3.239.236.140')) AND ((c.status=1 OR c.status>=3) AND c.status<11) GROUP BY c.acct_session_id, c.uid, c.service_id ORDER BY 1 ; 4 =================================== SELECT param, value FROM config WHERE (param LIKE 'ifu%') and domain_id='0' ORDER BY 2 5 =================================== SELECT COUNT(*) AS total FROM config WHERE (param LIKE 'ifu%') and domain_id='0' 6 =================================== SELECT u.id AS login,internet.ip AS ip_num, u.uid, internet.tp_id, internet.id FROM users u INNER JOIN internet_main internet ON (u.uid=internet.uid) LEFT JOIN tarif_plans tp ON (tp.tp_id=internet.tp_id) WHERE u.deleted='0' AND (internet.ip=INET_ATON('3.239.236.140')) AND u.deleted=0 GROUP BY u.uid ORDER BY 1 LIMIT 0, 25; 7 =================================== SELECT COUNT( DISTINCT u.id) AS total, COUNT(u.id) AS total_services FROM users u INNER JOIN internet_main internet ON (u.uid=internet.uid) LEFT JOIN tarif_plans tp ON (tp.tp_id=internet.tp_id) WHERE u.deleted='0' AND (internet.ip=INET_ATON('3.239.236.140')) AND u.deleted=0