List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'SELECT class, username, value, lastUsed AS last_used FROM rememberme_token WHERE series=:series' | 1 |
|
| 'DELETE FROM rememberme_token WHERE series=:series' | 1 |
|
| 'UPDATE rememberme_token SET value=:value, lastUsed=:lastUsed WHERE series=:series' | 1 |
|
| 'INSERT INTO rememberme_token (class, username, series, value, lastUsed) VALUES (:class, :username, :series, :value, :lastUsed)' | 1 |
|
| 'SELECT * FROM table3' | 1 |
|
| <<<EOT INSERT INTO products(name, price, stock, picture, tags, created_at) VALUES (?, ?, ?, ?, ?, ?) EOT | 1 |
|
| <<<EOT INSERT INTO products(name, price, stock, picture, tags) VALUES (?, ?, ?, ?, ?) EOT | 1 |
|
| 'SELECT 1' | 1 |
|
| 'Show deprecations as errors' | 1 |
|
| 'Show a list of twig functions, filters, globals and tests' | 1 |
|
| 'Show details for all entries matching this filter' | 1 |
|
| 'Show all classes even if they have no validation constraints' | 1 |
|
| 'SELECT COUNT(*) FROM cache_items' | 1 |
|
| 'SELECT 1 FROM cache_items WHERE item_id LIKE :id' | 1 |
|
| 'SELECT 1 FROM cache_items WHERE item_id LIKE ?' | 1 |
|
| "DELETE FROM $this->table WHERE $this->lifetimeCol + $this->timeCol <= :time" | 1 |
|
| "SELECT $this->idCol, CASE WHEN $this->lifetimeCol IS NULL OR $this->lifetimeCol + $this->timeCol > ? THEN $this->dataCol ELSE NULL END FROM $this->table WHERE $this->idCol IN ($sql)" | 1 |
|
| "DELETE FROM $this->table WHERE $this->lifetimeCol + $this->timeCol <= ? AND $this->idCol IN ($sql)" | 1 |
|
| "SELECT 1 FROM $this->table WHERE $this->idCol = :id AND ($this->lifetimeCol IS NULL OR $this->lifetimeCol + $this->timeCol > :time)" | 1 |
|
| "DELETE FROM $this->table" | 1 |
|
| "DELETE FROM $this->table WHERE $this->idCol IN ($sql)" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, :data, :lifetime, :time)" | 1 |
|
| "UPDATE $this->table SET $this->dataCol = :data, $this->lifetimeCol = :lifetime, $this->timeCol = :time WHERE $this->idCol = :id" | 1 |
|
| "DELETE FROM $this->table WHERE $this->lifetimeCol + $this->timeCol <= ?" | 1 |
|
| "SELECT $this->idCol, CASE WHEN $this->lifetimeCol IS NULL OR $this->lifetimeCol + $this->timeCol > ? THEN $this->dataCol ELSE NULL END FROM $this->table WHERE $this->idCol IN (?)" | 1 |
|
| "DELETE FROM $this->table WHERE $this->lifetimeCol + $this->timeCol <= ? AND $this->idCol IN (?)" | 1 |
|
| "SELECT 1 FROM $this->table WHERE $this->idCol = ? AND ($this->lifetimeCol IS NULL OR $this->lifetimeCol + $this->timeCol > ?)" | 1 |
|
| "DELETE FROM $this->table WHERE $this->idCol IN (?)" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (?, ?, ?, ?)" | 1 |
|
| "UPDATE $this->table SET $this->dataCol = ?, $this->lifetimeCol = ?, $this->timeCol = ? WHERE $this->idCol = ?" | 1 |
|
| 'delete key one' | 1 |
|
| 'delete key two' | 1 |
|
| 'Delete translations available on provider but not locally.' | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->tokenCol, $this->expirationCol) VALUES (:id, :token, {$this->getCurrentTimestampStatement( )} + $this->initialTtl)" | 1 |
|
| "UPDATE $this->table SET $this->expirationCol = {$this->getCurrentTimestampStatement( )} + $ttl, $this->tokenCol = :token1 WHERE $this->idCol = :id AND ($this->tokenCol = :token2 OR $this->expirationCol <= {$this->getCurrentTimestampStatement( )})" | 1 |
|
| "DELETE FROM $this->table WHERE $this->idCol = :id AND $this->tokenCol = :token" | 1 |
|
| "SELECT 1 FROM $this->table WHERE $this->idCol = :id AND $this->tokenCol = :token AND $this->expirationCol > {$this->getCurrentTimestampStatement( )}" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->tokenCol, $this->expirationCol) VALUES (?, ?, {$this->getCurrentTimestampStatement( )} + $this->initialTtl)" | 1 |
|
| "UPDATE $this->table SET $this->expirationCol = {$this->getCurrentTimestampStatement( )} + ?, $this->tokenCol = ? WHERE $this->idCol = ? AND ($this->tokenCol = ? OR $this->expirationCol <= {$this->getCurrentTimestampStatement( )})" | 1 |
|
| "SELECT 1 FROM $this->table WHERE $this->idCol = ? AND $this->tokenCol = ? AND $this->expirationCol > {$this->getCurrentTimestampStatement( )}" | 1 |
|
| 'SELECT a.* FROM' | 1 |
|
| 'SELECT a.id FROM' | 1 |
|
| 'SELECT FOR UPDATE' | 1 |
|
| 'SELECT m.* FROM messenger_messages m WITH (UPDLOCK, ROWLOCK) WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY ' | 1 |
|
| 'SELECT w.id AS "id", w.body AS "body", w.headers AS "headers", w.queue_name AS "queue_name", w.created_at AS "created_at", w.available_at AS "available_at", w.delivered_at AS "delivered_at" FROM messenger_messages w WHERE w.id IN (SELECT m.id FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC FETCH NEXT 1 ROWS ONLY) FOR UPDATE' | 1 |
|
| 'SELECT w.id AS "id", w.body AS "body", w.headers AS "headers", w.queue_name AS "queue_name", w.created_at AS "created_at", w.available_at AS "available_at", w.delivered_at AS "delivered_at" FROM messenger_messages w WHERE w.id IN (SELECT a.id FROM (SELECT m.id FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC) a WHERE ROWNUM <= 1) FOR UPDATE' | 1 |
|
| 'SELECT m.* FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY' | 1 |
|
| 'SELECT m.id AS "id", m.body AS "body", m.headers AS "headers", m.queue_name AS "queue_name", m.created_at AS "created_at", m.available_at AS "available_at", m.delivered_at AS "delivered_at" FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) FETCH NEXT 50 ROWS ONLY' | 1 |
|
| 'SELECT a.* FROM (SELECT m.id AS "id", m.body AS "body", m.headers AS "headers", m.queue_name AS "queue_name", m.created_at AS "created_at", m.available_at AS "available_at", m.delivered_at AS "delivered_at" FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?)) a WHERE ROWNUM <= 50' | 1 |
|
| 'Select receivers to consume:' | 1 |
|
| 'Select failed transport:' | 1 |
|
| 'Show one or more messages from the failure transport' | 1 |
|
| 'Show the message count for one or more transports' | 1 |
|
| 'Update JavaScript packages to their latest versions' | 1 |
|
| 'SELECT sess_lifetime FROM sessions' | 1 |
|
| "DELETE FROM $this->table WHERE $this->idCol = :id" | 1 |
|
| "UPDATE $this->table SET $this->lifetimeCol = :expiry, $this->timeCol = :time WHERE $this->idCol = :id" | 1 |
|
| "DELETE FROM $this->table WHERE $this->lifetimeCol < :time" | 1 |
|
| 'SELECT GET_LOCK(:key, 50)' | 1 |
|
| 'SELECT pg_advisory_lock(:key1, :key2)' | 1 |
|
| 'SELECT pg_advisory_unlock(:key1, :key2)' | 1 |
|
| 'SELECT pg_advisory_unlock(:key)' | 1 |
|
| "SELECT $this->dataCol, $this->lifetimeCol FROM $this->table WHERE $this->idCol = :id FOR UPDATE" | 1 |
|
| "SELECT $this->dataCol, $this->lifetimeCol FROM $this->table WITH (UPDLOCK, ROWLOCK) WHERE $this->idCol = :id" | 1 |
|
| "SELECT $this->dataCol, $this->lifetimeCol FROM $this->table WHERE $this->idCol = :id" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, EMPTY_BLOB(), :expiry, :time) RETURNING $this->dataCol into :data" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, :data, :expiry, :time)" | 1 |
|
| "UPDATE $this->table SET $this->dataCol = EMPTY_BLOB(), $this->lifetimeCol = :expiry, $this->timeCol = :time WHERE $this->idCol = :id RETURNING $this->dataCol into :data" | 1 |
|
| "UPDATE $this->table SET $this->dataCol = :data, $this->lifetimeCol = :expiry, $this->timeCol = :time WHERE $this->idCol = :id" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, :data, :expiry, :time) " . "ON DUPLICATE KEY UPDATE $this->dataCol = VALUES($this->dataCol), $this->lifetimeCol = VALUES($this->lifetimeCol), $this->timeCol = VALUES($this->timeCol)" | 1 |
|
| "INSERT OR REPLACE INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, :data, :expiry, :time)" | 1 |
|
| "INSERT INTO $this->table ($this->idCol, $this->dataCol, $this->lifetimeCol, $this->timeCol) VALUES (:id, :data, :expiry, :time) " . "ON CONFLICT ($this->idCol) DO UPDATE SET ($this->dataCol, $this->lifetimeCol, $this->timeCol) = (EXCLUDED.$this->dataCol, EXCLUDED.$this->lifetimeCol, EXCLUDED.$this->timeCol)" | 1 |
|
| 'select "0" choice by key' | 1 |
|
| 'select "0" choice by value' | 1 |
|
| 'select by key' | 1 |
|
| 'select by value' | 1 |
|
| 'select by key, with numeric key' | 1 |
|
| 'select by value, with numeric key' | 1 |
|
| 'select by key, with string object value' | 1 |
|
| 'select by value, with string object value' | 1 |
|
| 'Show assigned controllers in overview' | 1 |
|
| 'Show aliases in overview' | 1 |
|
| 'Select one of the matching routes' | 1 |
|
| 'Show also services that are not aliased' | 1 |
|
| 'Show arguments in services' | 1 |
|
| 'Show hidden (internal) services' | 1 |
|
| 'Show all services with a specific tag' | 1 |
|
| 'Select one of the following services to display its information' | 1 |
|
| 'Delete an item from a cache pool' | 1 |
|
| 'Select which Transition events should be dispatched for this Workflow' | 1 |
|
| 'SELECT * FROM table1 WHERE field1 = ?1' | 2 |
|
| 'INSERT INTO products(name, price, stock) VALUES ("product2", 15.5, 12)' | 2 |
|
| 'SELECT * FROM products' | 2 |
|
| 'SELECT c FROM ' . self::ENTITY_CLASS . ' c' | 2 |
|
| "DELETE FROM $this->table WHERE $this->idCol LIKE '$namespace%'" | 2 |
|
| 'INSERT OR REPLACE' . substr($insertSql, 6) | 2 |
|
| 'delete this,erroneous:key' | 2 |
|
| 'SELECT pg_try_advisory_lock(:key)' | 2 |
|
| 'SELECT pg_try_advisory_lock_shared(:key)' | 2 |
|
| "SELECT count(*) FROM pg_locks WHERE locktype='advisory' AND objid=:key AND pid=pg_backend_pid()" | 2 |
|
| 'SELECT pg_advisory_lock_shared(:key)' | 2 |
|
| "SELECT pg_advisory_unlock(objid::bigint) FROM pg_locks WHERE locktype='advisory' AND mode='ExclusiveLock' AND objid=:key AND pid=pg_backend_pid()" | 2 |
|
| "SELECT pg_advisory_unlock_shared(objid::bigint) FROM pg_locks WHERE locktype='advisory' AND mode='ShareLock' AND objid=:key AND pid=pg_backend_pid()" | 2 |
|
| "DELETE FROM $this->table WHERE $this->expirationCol <= {$this->getCurrentTimestampStatement( )}" | 2 |
|
| 'SELECT m.* FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC LIMIT 1 FOR UPDATE' | 2 |
|
| 'SELECT m.* FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) LIMIT 50' | 2 |
|
| 'Select one of the matching routes:' | 2 |
|
| 'Select one of the following tags to display its information' | 2 |
|
| 'SELECT * FROM table2' | 3 |
|
| 'SELECT pg_advisory_lock(:key)' | 3 |
|
| 'Update the local vault.' | 3 |
|
| 'INSERT INTO products(name, price, stock) VALUES ("product1", 12.5, 5)' | 4 |
|
| 'Select an option' | 4 |
|
| 'SELECT COUNT(*) FROM sessions' | 4 |
|
| 'INSERT INTO' | 6 |
|
| 'SELECT * FROM table1' | 9 |
|