Query Metrics
18
Database Queries
16
Different statements
5.03 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.00 ms (19.90%) |
2 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
0.52 ms (10.29%) |
1 |
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:
[ 1765813094 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.46 ms (9.14%) |
1 |
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/misc/ping" "path" "auto_create" "/admin/misc/ping?_dc=1765813093118" "path_query" "https://plateform.lab.fortesting2.fr/admin/misc/ping?_dc=1765813093118" "entire_uri" ] |
|
0.45 ms (8.89%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
0.44 ms (8.73%) |
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:
[ 1765813094 "system_route_redirect" ] |
|
0.37 ms (7.28%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.36 ms (7.21%) |
1 |
UPDATE users SET id = ?, parentId = ?, name = ?, type = ?, permissions = ?, classes = ?, docTypes = ?, perspectives = ?, websiteTranslationLanguagesView = ?, websiteTranslationLanguagesEdit = ?, password = ?, passwordRecoveryToken = ?, firstname = ?, lastname = ?, email = ?, language = ?, datetimeLocale = ?, admin = ?, active = ?, roles = ?, welcomescreen = ?, closeWarning = ?, memorizeTabs = ?, allowDirtyClose = ?, contentLanguages = ?, activePerspective = ?, lastLogin = ?, keyBindings = ?, twoFactorAuthentication = ?, provider = ? WHERE id = ?
Parameters:
[ 2 0 "codeway" "user" "admin_translations,application_logging,assets,asset_metadata,bundle_ecommerce_back-office_order,bundle_ecommerce_pricing_rules,bundle_outputDataConfigToolkit,classes,classificationstore,clear_cache,clear_fullpage_cache,clear_temp_files,dashboards,documents,document_types,emails,fieldcollections,gdpr_data_extractor,gee_job_run_permission,gee_see_all_job_runs_permission,glossary,google_marketing,http_errors,newsletters,notes_events,notifications,notifications_send,objectbricks,objects,plugins,plugin_cmf_perm_activityview,plugin_cmf_perm_customerview,plugin_cmf_perm_customerview_admin,plugin_cmf_perm_customer_automation_rules,plugin_cmf_perm_newsletter_enqueue_all_customers,plugin_datahub_adapter_graphql,plugin_datahub_admin,plugin_datahub_config,predefined_properties,qr_codes,quantityValueUnits,recyclebin,redirects,reports,reports_config,robots.txt,routes,seemode,selectoptions,seo_document_editor,share_configurations,system_appearance_settings,system_settings,tags_assignment,tags_configuration,tags_search,targeting,thumbnails,translations,users,web2print_settings,web2print_web2print_favourite_output_channels,website_settings,word_export,workflow_details,xliff_import_export" "" "" "" "" "" "$2y$10$Y179vGRvWPCbgK3CC0MrXuW7f.seAO7dY80YljjhqMDZUk1X.8x76" null "Florent" "BERNARD" "contact@codeway.fr" "fr" "" 1 1 "" 0 0 0 1 "en,fr" "default" 1765812316 "[{"key":83,"action":"save","ctrl":true,"alt":false,"shift":false},{"key":80,"action":"publish","ctrl":true,"shift":true,"alt":false},{"key":85,"action":"unpublish","ctrl":true,"shift":true,"alt":false},{"key":82,"action":"rename","alt":true,"shift":true,"ctrl":false},{"key":116,"action":"refresh","alt":false,"ctrl":false,"shift":false},{"key":68,"action":"openDocument","ctrl":true,"shift":true,"alt":false},{"key":65,"action":"openAsset","ctrl":true,"shift":true,"alt":false},{"key":79,"action":"openObject","ctrl":true,"shift":true,"alt":false},{"key":67,"action":"openClassEditor","ctrl":true,"shift":true,"alt":false},{"key":76,"action":"openInTree","ctrl":true,"shift":true,"alt":false},{"key":73,"action":"showMetaInfo","alt":true,"ctrl":false,"shift":false},{"key":87,"action":"searchDocument","alt":true,"ctrl":false,"shift":false},{"key":65,"action":"searchAsset","alt":true,"ctrl":false,"shift":false},{"key":79,"action":"searchObject","alt":true,"ctrl":false,"shift":false},{"key":72,"action":"showElementHistory","alt":true,"ctrl":false,"shift":false},{"key":84,"action":"closeAllTabs","alt":true,"ctrl":false,"shift":false},{"key":83,"action":"searchAndReplaceAssignments","alt":true,"ctrl":false,"shift":false},{"key":82,"action":"redirects","ctrl":false,"alt":true,"shift":false},{"key":84,"action":"sharedTranslations","ctrl":true,"alt":true,"shift":false},{"key":82,"action":"recycleBin","ctrl":true,"alt":true,"shift":false},{"key":78,"action":"notesEvents","ctrl":true,"alt":true,"shift":false},{"key":72,"action":"tagManager","ctrl":true,"alt":true,"shift":false},{"key":78,"action":"tagConfiguration","ctrl":true,"alt":true,"shift":false},{"key":85,"action":"users","ctrl":true,"alt":true,"shift":false},{"key":80,"action":"roles","ctrl":true,"alt":true,"shift":false},{"key":81,"action":"clearAllCaches","ctrl":false,"alt":true,"shift":false},{"key":67,"action":"clearDataCache","ctrl":false,"alt":true,"shift":false},{"key":67,"action":"customReports","ctrl":true,"alt":true,"shift":false},{"key":77,"action":"reports","ctrl":true,"alt":true,"shift":false},{"key":76,"action":"applicationLogger","ctrl":true,"alt":true,"shift":false},{"key":71,"action":"glossary","alt":true,"shift":true,"ctrl":false},{"key":83,"action":"seoDocumentEditor","ctrl":true,"alt":true,"shift":false},{"key":74,"action":"robots","ctrl":true,"alt":true,"shift":false},{"key":79,"action":"httpErrorLog","ctrl":true,"alt":true,"shift":false},{"key":70,"action":"quickSearch","ctrl":true,"shift":true,"alt":false}]" "{"required":false,"enabled":false,"secret":"","type":""}" null 2 ] |
|
0.29 ms (5.71%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.25 ms (4.99%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.22 ms (4.41%) |
1 |
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:
[ 1765813094 "system\x01tags\x01" "resource\x01tags\x01" ] |
|
0.18 ms (3.52%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
|
0.12 ms (2.41%) |
1 |
DELETE FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.11 ms (2.15%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.10 ms (1.99%) |
1 |
DELETE FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.10 ms (1.93%) |
1 |
DELETE FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
|
0.07 ms (1.47%) |
1 |
"COMMIT"
Parameters:
[] |
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.
Managed Entities
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.