List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'delete * from `t_ipgap` where `gap` = ?' | 1 |
|
| 'select a.`id`, a.`search` from `t_search` as a where a.`search` like ? limit 0,' | 1 |
|
| 'update `t_ip` set `domain` = ?, `ip` = ?, `ipgap_id` where `id` = ?' | 1 |
|
| 'select `id`, `domain`, `ip` from `t_ip` where `` = ?' | 1 |
|
| 'delete from `t_ip` where `id` = %d' | 1 |
|
| 'select b.`id`, b.`gap` from `t_ipgap` as b where b.`search_id` = ? order by b.`id` desc' | 1 |
|
| 'delete from `t_ipgap` where `id` = %d' | 1 |
|
| 'update `t_search` set `dt` = now() where `id` = ?' | 1 |
|
| 'select `id`, `search` from `t_search` limit %d,%d' | 1 |
|
| 'select `id`, `search` from `t_search` where datediff(curdate(), `dt`) > %d limit %d,%d' | 1 |
|
| 'select a.`id`, a.`domain`, a.`ip` from `t_ip` as a where a.`ipgap_id` = ?' | 1 |
|
| 'select b.`domain`, b.`ip` from `t_ipgap` as a left join `t_ip` as b on a.`id` = b.`ipgap_id` where a.`gap` = ?' | 1 |
|
| 'update `t_ip` set `ip` = ?, `ipgap_id` = ? where `id` = ?' | 1 |
|
| 'insert into `t_search`(`search`) values(?)' | 1 |
|
| 'select `id`, `search` from `t_search` where `search` = ?' | 1 |
|
| 'select b.`id`, b.`gap` from `t_search` as a left join `t_ipgap` as b on a.`id` = b.`search_id` where a.`search` = ?' | 1 |
|
| 'insert into `t_ip`(`domain`, `ip`, `ipgap_id`) values (?, ?, ?)' | 2 |
|
| 'select `id` from `t_whois` where `ip_id` = ?' | 2 |
|
| 'update `t_whois` set %s=? where `id` = ?' | 2 |
|
| 'insert into `t_whois`( %s, `ip_id` ) values ( %s )' | 2 |
|
| 'select b.`gap`, a.`search` from `t_search` as a left join `t_ipgap` as b on a.`id` = b.`search_id` where a.`search` like ?' | 2 |
|
| 'select * from `t_whois` where `ip_id` = ?' | 2 |
|
| 'insert into `t_ipgap`(`gap`, `search_id`) values (?, ?)' | 3 |
|
| 'update `t_ipgap` set `gap` = ?, `search_id` = ? where `id` = ?' | 3 |
|
| 'select id, name from `t_fields`' | 4 |
|
| 'select `id`, `gap` from `t_ipgap` where `gap` = ?' | 4 |
|
| 'select `id`, `domain` from `t_ip` where `domain` = ?' | 5 |
|