Query Metrics
8
Database Queries
4
Different statements
18.32 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.43 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle" "scope" => "pimcore" ] |
2 | 0.23 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle" "scope" => "pimcore" ] |
3 | 0.22 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataImporterBundle\PimcoreDataImporterBundle" "scope" => "pimcore" ] |
4 | 0.21 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__AdvancedObjectSearchBundle\AdvancedObjectSearchBundle" "scope" => "pimcore" ] |
5 | 15.84 ms |
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:
[] |
6 | 0.40 ms |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
7 | 0.68 ms |
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:
[ 1734845136 [ "\x00tags\x00translation_data_2e364d315ad5ad984609e7f4beedf0f7" "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ] ] |
8 | 0.31 ms |
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:
[ 1734845136 [ "translator\x00tags\x00" "translator_website\x00tags\x00" "translate\x00tags\x00" "translation_data_2e364d315ad5ad984609e7f4beedf0f7\x00tags\x00" ] ] |
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.