Query Metrics
8
Database Queries
4
Different statements
36.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.50 ms (48.19%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
16.74 ms (46.09%) |
1 |
CREATE TABLE IF NOT EXISTS `promemoria_shorturl` (`id` int(11) NOT NULL AUTO_INCREMENT, `jwtToken` text NOT NULL,`shortToken` varchar(16) NOT NULL,`insertDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
1.10 ms (3.03%) |
4 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle" "scope" => "pimcore" ] |
|
0.98 ms (2.69%) |
2 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773257040 [ "\x00tags\x00translation_data_2e364d315ad5ad984609e7f4beedf0f7" "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ] ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.