List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'SELECT modified, content FROM output_cache WHERE id = :id' | 1 |
|
| 'SELECT modified FROM output_cache WHERE id = :id' | 1 |
|
| 'DELETE FROM output_cache WHERE ' . join(' AND ', $where) | 1 |
|
| 'SELECT modified FROM templates WHERE name = :name' | 1 |
|
| " SELECT opportunity.id AS 'opportunityId', contact.id AS `contactId` FROM `opportunity` JOIN contact_opportunity ON contact_opportunity.opportunity_id = opportunity.id AND contact_opportunity.deleted = 0 JOIN contact ON contact.id = contact_opportunity.contact_id AND contact.deleted = 0 WHERE contact.id IN ( SELECT MIN(contact.id) FROM `opportunity` JOIN contact_opportunity ON contact_opportunity.opportunity_id = opportunity.id AND contact_opportunity.deleted = 0 JOIN contact ON contact.id = contact_opportunity.contact_id AND contact.deleted = 0 GROUP BY opportunity.id ) AND opportunity.contact_id IS NULL AND opportunity.deleted = 0 " | 1 |
|
| " UPDATE `opportunity` SET contact_id = " . $pdo->quote($cId) . " WHERE id = " . $pdo->quote($oId) . " " | 1 |
|
| "SHOW INDEX FROM `note`" | 1 |
|
| "SHOW FULL COLUMNS FROM `" . $tableName . "` WHERE `Collation` <> 'utf8mb4_unicode_ci'" | 1 |
|
| "UPDATE `email_account` SET email_account.security = '' WHERE email_account.ssl = 0" | 1 |
|
| "UPDATE `inbound_email` SET inbound_email.security = '' WHERE inbound_email.ssl = 0" | 1 |
|
| " SELECT TABLE_NAME as tableName FROM information_schema.TABLES WHERE TABLE_SCHEMA = '" . $databaseInfo['dbname'] . "' AND ENGINE = 'MyISAM' " | 1 |
|
| "SHOW TABLES LIKE '{$table}'" | 1 |
|
| "SELECT indexdef FROM pg_indexes WHERE indexname = '{$key}'" | 1 |
|
| "SHOW {$name}" | 1 |
|
| "SHOW VARIABLES LIKE :param" | 1 |
|
| "SHOW TABLE STATUS WHERE Engine = 'MyISAM'" | 1 |
|
| "SHOW FULL COLUMNS FROM `" . $tableName . "` WHERE Field = " . $pdo->quote($columnName) | 1 |
|
| 'Delete package process [' . $processId . ']: start run.' | 1 |
|
| 'Delete package package ID was not specified.' | 1 |
|
| 'Delete package process [' . $processId . ']: end run.' | 1 |
|
| "select should be array." | 1 |
|
| "select has non-string item." | 1 |
|
| "Update params: Missing 'in'." | 1 |
|
| "Update params: Bad or missing 'set' parameter." | 1 |
|
| "INSERT INTO " . $this->quoteIdentifier($table) . " ($columnsPart) $valuesPart" | 1 |
|
| "DELETE " | 1 |
|
| "UPDATE " . $this->quoteIdentifier($table) | 1 |
|
| "INSERT INTO " . $this->quoteIdentifier($table) . " ($columns) $values" | 1 |
|
| 'Show Message' | 1 |
|
| 'SELECT modified, source FROM templates WHERE name = :name' | 2 |
|
| " UPDATE email_account SET port = NULL WHERE port = '' " | 2 |
|
| " UPDATE inbound_email SET port = NULL WHERE port = '' " | 2 |
|
| "select version()" | 2 |
|
| "Select params: Missing 'from'." | 2 |
|