Symfony Profiler

Query Metrics

124 Database Queries

21 Different statements

14.18 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 (?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
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 (?)
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id FROM settings_store WHERE scope = ?
SELECT id FROM settings_store WHERE scope = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
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 (?)
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM translations_admin LIMIT 1;
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT name FROM classes WHERE LOWER(name) NOT LIKE ? ORDER BY name ASC
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id, name
            FROM classes
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT object_etim2_release.id as id, object_etim2_release.type as `type` FROM object_etim2_release WHERE  object_etim2_release.type IN ('object','variant','folder')
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
SELECT object_bmecat_filter.id as id, object_bmecat_filter.type as `type` FROM object_bmecat_filter WHERE  object_bmecat_filter.type IN ('object','variant','folder')
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 (?)
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 (?, ?)
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT id, name
            FROM classes
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT * FROM users_permission_definitions WHERE `key`=?  LIMIT 1
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT * FROM users_permission_definitions WHERE `key`=?  LIMIT 1
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT id, name FROM classes
SELECT `id`, `name` FROM classes WHERE name = ?
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 (?)
SELECT * FROM translations_admin LIMIT 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 (?)
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 (?, ?, ?)

#▲	Time	Info
1	0.22 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
2	0.16 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: [`1779109933 "maintenance_mode"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
3	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\AdminBundle\\PimcoreAdminBundle' AND scope = 'pimcore';
4	0.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\ApplicationLoggerBundle\PimcoreApplicationLoggerBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\ApplicationLoggerBundle\\PimcoreApplicationLoggerBundle' AND scope = 'pimcore';
5	0.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\CustomReportsBundle\PimcoreCustomReportsBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\CustomReportsBundle\\PimcoreCustomReportsBundle' AND scope = 'pimcore';
6	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\GlossaryBundle\PimcoreGlossaryBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\GlossaryBundle\\PimcoreGlossaryBundle' AND scope = 'pimcore';
7	0.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
8	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SimpleBackendSearchBundle\PimcoreSimpleBackendSearchBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SimpleBackendSearchBundle\\PimcoreSimpleBackendSearchBundle' AND scope = 'pimcore';
9	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\StaticRoutesBundle\PimcoreStaticRoutesBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\StaticRoutesBundle\\PimcoreStaticRoutesBundle' AND scope = 'pimcore';
10	0.12 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\UuidBundle\PimcoreUuidBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\UuidBundle\\PimcoreUuidBundle' AND scope = 'pimcore';
11	0.10 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\WordExportBundle\PimcoreWordExportBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\WordExportBundle\\PimcoreWordExportBundle' AND scope = 'pimcore';
12	0.10 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\XliffBundle\PimcoreXliffBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\XliffBundle\\PimcoreXliffBundle' AND scope = 'pimcore';
13	0.12 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\GenericExecutionEngineBundle\PimcoreGenericExecutionEngineBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\GenericExecutionEngineBundle\\PimcoreGenericExecutionEngineBundle' AND scope = 'pimcore';
14	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\PerspectiveEditorBundle\PimcorePerspectiveEditorBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\PerspectiveEditorBundle\\PimcorePerspectiveEditorBundle' AND scope = 'pimcore';
15	0.13 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Category' ;
16	0.14 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"LevelTree"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'LevelTree' ;
17	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"PriceList"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'PriceList' ;
18	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Product' ;
19	0.11 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Tree"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Tree' ;
20	0.18 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
21	0.10 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: [`1779109933 "system\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags');
22	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SelectOptions"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SelectOptions' ;
23	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SelectOptions"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SelectOptions' ;
24	0.14 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_object_custom_layout"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_object_custom_layout';
25	0.12 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_object_custom_layout"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_object_custom_layout';
26	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ConnectionConfigurationObject"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ConnectionConfigurationObject' ;
27	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"AiConfigurationPrompt"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'AiConfigurationPrompt' ;
28	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"GenerativePrompt"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'GenerativePrompt' ;
29	0.14 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
30	0.13 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"MassiveAi"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'MassiveAi' ;
31	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"TranslationPrompt"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'TranslationPrompt' ;
32	0.12 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
33	0.12 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
34	0.24 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"ai_bundle_default_configuration_prompt_generative" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'ai_bundle_default_configuration_prompt_generative' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
35	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 3;
36	0.15 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"ai_bundle_default_configuration_prompt_translation" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'ai_bundle_default_configuration_prompt_translation' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
37	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 4;
38	0.12 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
39	0.11 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Release"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Release' ;
40	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Language"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Language' ;
41	0.12 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
42	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Configuration"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Configuration' ;
43	0.11 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
44	0.14 ms	SELECT name FROM classes WHERE LOWER(name) NOT LIKE ? ORDER BY name ASC Parameters: [`"%etim%"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE LOWER(name) NOT LIKE ? ORDER BY name ASC SELECT name FROM classes WHERE LOWER(name) NOT LIKE '%etim%' ORDER BY name ASC;
45	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Group"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Group' ;
46	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Class"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Class' ;
47	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Feature"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Feature' ;
48	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Value"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Value' ;
49	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Unit"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Unit' ;
50	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Type"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Type' ;
51	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Connection"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Connection' ;
52	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Etim2Mapping"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Etim2Mapping' ;
53	0.13 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/ETIM/" "Configuration"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/ETIM/' AND `key` = BINARY 'Configuration';
54	0.14 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: [`1779109933 "object_40"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_40');
55	0.14 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: [`1779109933 "object_40\x01tags\x01" "class_etim2_config\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_40tags', 'class_etim2_configtags');
56	0.12 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/ETIM/" "Releases"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/ETIM/' AND `key` = BINARY 'Releases';
57	0.10 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: [`1779109933 "object_41"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_41');
58	0.09 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: [`1779109933 "object_41\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_41tags');
59	0.09 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/ETIM/" "Languages"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/ETIM/' AND `key` = BINARY 'Languages';
60	0.09 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: [`1779109933 "object_49"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49');
61	0.08 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: [`1779109933 "object_49\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49tags');
62	0.12 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SchemaOrgAttribute"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SchemaOrgAttribute' ;
63	0.11 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SchemaOrgRoot"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SchemaOrgRoot' ;
64	0.11 ms	SELECT id, name FROM classes Parameters: [] View formatted query View runnable query Explain query SELECT id, name FROM classes SELECT id, name FROM classes ;
65	0.10 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "Schema.org"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/' AND `key` = BINARY 'Schema.org';
66	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Gmde\AdvancedDataImportBundle\AdvancedDataImportBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Gmde\\AdvancedDataImportBundle\\AdvancedDataImportBundle' AND scope = 'pimcore';
67	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ApiKey"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ApiKey' ;
68	0.16 ms	SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id, type FROM users WHERE id > 0 AND `type` IN ('user', 'userfolder') ORDER BY `name` ASC SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC;
69	0.14 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"userfolder" 9`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'userfolder' AND id = 9;
70	0.12 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 10`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 10;
71	0.10 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 10;
72	0.09 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 10;
73	0.09 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 10;
74	0.11 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 2`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 2;
75	0.09 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 2;
76	0.08 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 2;
77	0.09 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 2;
78	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"catalogoBmecat"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'catalogoBmecat' ;
79	0.13 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
80	0.29 ms	SELECT object_etim2_release.id as id, object_etim2_release.type as `type` FROM object_etim2_release WHERE object_etim2_release.type IN ('object','variant','folder') Parameters: [] View formatted query View runnable query Explain query SELECT object_etim2_release.id as id, object_etim2_release.type as `type` FROM object_etim2_release WHERE object_etim2_release.type IN ('object', 'variant', 'folder') SELECT object_etim2_release.id as id, object_etim2_release.type as `type` FROM object_etim2_release WHERE object_etim2_release.type IN ('object','variant','folder');
81	0.12 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: [`1779109933 "object_48"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_48');
82	0.11 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: [`1779109933 "object_48\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_48tags', 'class_etim2_releasetags');
83	0.08 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: [`1779109933 "object_42"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_42');
84	0.09 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: [`1779109933 "object_42\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_42tags', 'class_etim2_releasetags');
85	0.09 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: [`1779109933 "object_43"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_43');
86	0.10 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: [`1779109933 "object_43\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_43tags', 'class_etim2_releasetags');
87	0.08 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: [`1779109933 "object_44"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_44');
88	0.08 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: [`1779109933 "object_44\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_44tags', 'class_etim2_releasetags');
89	0.09 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: [`1779109933 "object_45"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_45');
90	0.08 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: [`1779109933 "object_45\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_45tags', 'class_etim2_releasetags');
91	0.10 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: [`1779109933 "object_46"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_46');
92	0.12 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: [`1779109933 "object_46\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_46tags', 'class_etim2_releasetags');
93	0.10 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: [`1779109933 "object_47"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47');
94	0.09 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: [`1779109933 "object_47\x01tags\x01" "class_etim2_release\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47tags', 'class_etim2_releasetags');
95	0.26 ms	SELECT object_bmecat_filter.id as id, object_bmecat_filter.type as `type` FROM object_bmecat_filter WHERE object_bmecat_filter.type IN ('object','variant','folder') Parameters: [] View formatted query View runnable query Explain query SELECT object_bmecat_filter.id as id, object_bmecat_filter.type as `type` FROM object_bmecat_filter WHERE object_bmecat_filter.type IN ('object', 'variant', 'folder') SELECT object_bmecat_filter.id as id, object_bmecat_filter.type as `type` FROM object_bmecat_filter WHERE object_bmecat_filter.type IN ('object','variant','folder');
96	0.11 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: [`1779109933 "object_1955"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1955');
97	0.10 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: [`1779109933 "object_1955\x01tags\x01" "class_bmecat_filter\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1955tags', 'class_bmecat_filtertags');
98	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"fieldNode"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'fieldNode' ;
99	0.11 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/BMECAT/CONFIG/" "BMECAT"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/BMECAT/CONFIG/' AND `key` = BINARY 'BMECAT';
100	0.09 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: [`1779109933 "object_1746"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1746');
101	0.10 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: [`1779109933 "object_1746\x01tags\x01" "class_bmecat_main_root\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1746tags', 'class_bmecat_main_roottags');
102	0.10 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/BMECAT/CONFIG/" "BMECAT"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/BMECAT/CONFIG/' AND `key` = BINARY 'BMECAT';
103	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"filterBmecat"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'filterBmecat' ;
104	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"mainRoot"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'mainRoot' ;
105	0.09 ms	SELECT id, name FROM classes Parameters: [] View formatted query View runnable query Explain query SELECT id, name FROM classes SELECT id, name FROM classes ;
106	0.08 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/BMECAT/CONFIG/" "BMECAT"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/BMECAT/CONFIG/' AND `key` = BINARY 'BMECAT';
107	0.10 ms	SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1 Parameters: [`"bmecat_permission"`] View formatted query View runnable query Explain query SELECT * FROM users_permission_definitions WHERE `key` = ? LIMIT 1 SELECT * FROM users_permission_definitions WHERE `key`='bmecat_permission' LIMIT 1;
108	0.10 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "BMECAT"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/' AND `key` = BINARY 'BMECAT';
109	0.09 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: [`1779109933 "object_1744"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1744');
110	0.09 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: [`1779109933 "object_1744\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1744tags');
111	0.09 ms	SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1 Parameters: [`"get_xml_catalogs"`] View formatted query View runnable query Explain query SELECT * FROM users_permission_definitions WHERE `key` = ? LIMIT 1 SELECT * FROM users_permission_definitions WHERE `key`='get_xml_catalogs' LIMIT 1;
112	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"StandardApiConfigurationEntity"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'StandardApiConfigurationEntity' ;
113	0.11 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CmsEntryPointConfiguration"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CmsEntryPointConfiguration' ;
114	0.13 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
115	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CmsStyleConfiguration"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CmsStyleConfiguration' ;
116	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Faq"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Faq' ;
117	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"News"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'News' ;
118	0.12 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
119	0.11 ms	SELECT id, name FROM classes Parameters: [] View formatted query View runnable query Explain query SELECT id, name FROM classes SELECT id, name FROM classes;
120	0.10 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"StandardApiEntryPoint"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'StandardApiEntryPoint' ;
121	0.12 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: [`1779109933 "system_supported_locales_en"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
122	0.15 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
123	0.18 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: [`1779109933 "translation_data_2e364d315ad5ad984609e7f4beedf0f7"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_2e364d315ad5ad984609e7f4beedf0f7');
124	0.16 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: [`1779109933 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1779109933 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://pimcoremodules.gmde.it/admin/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping