GET https://pimcoredemo.edelsau.uber.space/admin/login

Query Metrics

38 Database Queries
12 Different statements
5930.22 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 38.02 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
2 18.04 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
3 383.60 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/admin/login"
  "path"
  "auto_create"
  "/admin/login"
  "path_query"
  "https://pimcoredemo.edelsau.uber.space/admin/login"
  "entire_uri"
]
4 9.90 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
5 13.29 ms
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
Parameters:
[
  300
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
6 1.20 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
7 2169.37 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
8 179.77 ms
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
Parameters:
[
  300.0
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
9 1.01 ms
SELECT id FROM redirects WHERE active = 1 AND regex = 1  ORDER BY `priority` DESC
Parameters:
[]
10 18.54 ms
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
11 3.42 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[
  "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071"
  "cjlPuPUWiZbd6cj2tG0A+qqzBxGylHSIqKbmYMGJNHg="
]
12 7.79 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
13 26.53 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "admin_system_settings"
  "pimcore_admin_system_settings"
]
14 43.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle"
  "pimcore"
]
15 5.57 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\CustomReportsBundle\PimcoreCustomReportsBundle"
  "pimcore"
]
16 285.04 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\PersonalizationBundle\PimcorePersonalizationBundle"
  "pimcore"
]
17 18.18 ms
SELECT `key` FROM users_permission_definitions WHERE `key` = ?
Parameters:
[
  "bundle_ecommerce_pricing_rules"
]
18 5.66 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\ApplicationLoggerBundle\PimcoreApplicationLoggerBundle"
  "pimcore"
]
19 9.86 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\GoogleMarketingBundle\PimcoreGoogleMarketingBundle"
  "pimcore"
]
20 6.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__CustomerManagementFrameworkBundle\PimcoreCustomerManagementFrameworkBundle"
  "pimcore"
]
21 8.25 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\NewsletterBundle\PimcoreNewsletterBundle"
  "pimcore"
]
22 27.92 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\GlossaryBundle\PimcoreGlossaryBundle"
  "pimcore"
]
23 3.96 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
24 1.50 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SimpleBackendSearchBundle\PimcoreSimpleBackendSearchBundle"
  "pimcore"
]
25 3.79 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle"
  "pimcore"
]
26 0.88 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle"
  "pimcore"
]
27 134.57 ms
SELECT `id` FROM bundle_outputdataconfigtoolkit_outputdefinition LIMIT 1;
Parameters:
[]
28 15.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Web2PrintToolsBundle\Web2PrintToolsBundle"
  "pimcore"
]
29 17.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\WebToPrintBundle\PimcoreWebToPrintBundle"
  "pimcore"
]
30 14.57 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\TinymceBundle\PimcoreTinymceBundle"
  "pimcore"
]
31 2.92 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\StaticRoutesBundle\PimcoreStaticRoutesBundle"
  "pimcore"
]
32 2.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\WordExportBundle\PimcoreWordExportBundle"
  "pimcore"
]
33 177.65 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\XliffBundle\PimcoreXliffBundle"
  "pimcore"
]
34 11.80 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\GenericExecutionEngineBundle\PimcoreGenericExecutionEngineBundle"
  "pimcore"
]
35 1.61 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "admin_system_settings"
  "pimcore_admin_system_settings"
]
36 66.48 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
37 7.27 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
38 2187.92 ms
SELECT * FROM translations_admin WHERE language = ?
Parameters:
[
  "en"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
pimcore doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.