List of all SQL mentioned in the code..
Value | Count | File:Line |
---|---|---|
"SELECT * FROM sqlite_master WHERE name = 'caches' AND type = 'table'" | 1 |
|
'SHOW TABLES LIKE ' . $this->quote($like) | 1 |
|
'UPDATE ' . $db->quote_table($this->_table) | 1 |
|
'DELETE FROM ' . $db->quote_table($this->_table) | 1 |
|
'INSERT INTO ' . $db->quote_table($this->_table) | 1 |
|
'INSERT INTO ... SELECT statements cannot be combined with INSERT INTO ... VALUES' | 1 |
|
'INSERT INTO syntax does not allow table aliasing' | 1 |
|
'SHOW FULL COLUMNS FROM ' . $table | 1 |
|
'SHOW FULL COLUMNS FROM ' . $table . ' LIKE ' . $this->quote($like) | 1 |
|
'SHOW TABLES' | 1 |
|
'SELECT COUNT(*) AS total_row_count FROM ' . $table | 1 |
|
'SELECT id, expiration, cache FROM caches WHERE id = :id LIMIT 0, 1' | 1 |
|
'SELECT id FROM caches WHERE id = :id' | 1 |
|
'DELETE FROM caches WHERE expiration < :expiration' | 1 |
|
'SELECT id, cache FROM caches WHERE tags LIKE :tag' | 1 |
|
'DELETE FROM caches WHERE tags LIKE :tag' | 1 |
|
'INSERT INTO caches (id, cache, expiration, tags) VALUES (:id, :cache, :expiration, :tags)' | 1 |
|
'UPDATE caches SET expiration = :expiration, cache = :cache, tags = :tags WHERE id = :id' | 1 |
|
'DELETE FROM caches' | 1 |
|
'DELETE FROM caches WHERE id = :id' | 1 |
|
'SELECT ' | 1 |
|