Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

79 Database Queries

14 Different statements

24.32 ms Query time

0 Invalid entities

Queries

Group similar statements


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 redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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 * FROM object_url_slugs WHERE slug = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules 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 (?)
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 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 = ?
                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 id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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 * FROM translations_messages 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 (?)
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 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 * FROM documents_editables WHERE documentId = ?
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 * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
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 assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
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 documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
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 (?)

#▲	Time	Info
1	1.25 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: [`1768260641 [ "\x00tags\x00site_domain_1000577e2e53972d13eee5af5648e472" "site_domain_1000577e2e53972d13eee5af5648e472" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_1000577e2e53972d13eee5af5648e472', 'site_domain_1000577e2e53972d13eee5af5648e472');
2	0.25 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: [`1768260641 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_1000577e2e53972d13eee5af5648e472\x00tags\x00" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_1000577e2e53972d13eee5af5648e472\0tags\0');
3	0.50 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/nl/Zeilen/Zeilkampen/Zomerkampen" "sourcePathQuery" => "/nl/Zeilen/Zeilkampen/Zomerkampen" "sourceEntireUri" => "https://zsg.ultinova.be/nl/Zeilen/Zeilkampen/Zomerkampen" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND `type` = 'path_query') OR (source = 'https://zsg.ultinova.be/nl/Zeilen/Zeilkampen/Zomerkampen' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
4	0.24 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: [`1768260641 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	0.21 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: [`1768260641 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
6	0.25 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
7	0.28 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Zomerkampen" "path" => "/nl/Zeilen/Zeilkampen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/nl/Zeilen/Zeilkampen/' AND `key` = BINARY 'Zomerkampen';
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: [`1768260641 [ "\x00tags\x00document_177" "document_177" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_177', 'document_177');
9	0.66 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: [`1768260641 [ "document_177\x00tags\x00" "asset_141\x00tags\x00" "asset_93\x00tags\x00" "asset_216\x00tags\x00" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_177\0tags\0', 'asset_141\0tags\0', 'asset_93\0tags\0', 'asset_216\0tags\0');
10	0.32 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: [`1768260641 [ "\x00tags\x00document_properties_177" "document_properties_177" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_177', 'document_properties_177');
11	0.25 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: [`1768260641 [ "document_properties\x00tags\x00" "document_177\x00tags\x00" "document_properties_177\x00tags\x00" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_177\0tags\0', 'document_properties_177\0tags\0');
12	0.27 ms	SELECT * FROM object_url_slugs WHERE slug = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/nl/Zeilen/Zeilkampen/Zomerkampen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
13	0.29 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.47 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: [`1768260641 [ "\x00tags\x00website_config" "website_config" ]`] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
15	0.39 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: [1768260641 [ "website_config\x00tags\x00" "system\x00tags\x00" "config\x00tags\x00" "output\x00tags\x00" "asset_25\x00tags\x00" "asset_37\x00tags\x00" "document_35\x00tags\x00" "document_14\x00tags\x00" "document_65\x00tags\x00" "document_149\x00tags\x00" "document_150\x00tags\x00" "document_290\x00tags\x00" "asset_36\x00tags\x00" "document_75\x00tags\x00" "document_77\x00tags\x00" "document_79\x00tags\x00" "document_190\x00tags\x00" "document_155\x00tags\x00" "document_26\x00tags\x00" "document_291\x00tags\x00" "document_318\x00tags\x00" "document_320\x00tags\x00" "document_319\x00tags\x00" "document_29\x00tags\x00" "document_93\x00tags\x00" "object_2298\x00tags\x00" "document_447\x00tags\x00" ]] 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 > 1768260641 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config\0tags\0', 'system\0tags\0', 'config\0tags\0', 'output\0tags\0', 'asset_25\0tags\0', 'asset_37\0tags\0', 'document_35\0tags\0', 'document_14\0tags\0', 'document_65\0tags\0', 'document_149\0tags\0', 'document_150\0tags\0', 'document_290\0tags\0', 'asset_36\0tags\0', 'document_75\0tags\0', 'document_77\0tags\0', 'document_79\0tags\0', 'document_190\0tags\0', 'document_155\0tags\0', 'document_26\0tags\0', 'document_291\0tags\0', 'document_318\0tags\0', 'document_320\0tags\0', 'document_319\0tags\0', 'document_29\0tags\0', 'document_93\0tags\0', 'object_2298\0tags\0', 'document_447\0tags\0');
16	0.48 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: [`"favicon_asset" null "nl"`] 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 = 'favicon_asset' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = 'nl' ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
17	0.17 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
18	0.25 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: [`"site_title" null "nl"`] 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 = 'site_title' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = 'nl' ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
19	0.14 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;
20	0.25 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: [`"favicon_asset" 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 = 'favicon_asset' 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;
21	0.25 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: [`"generateNewFavicon" 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 = 'generateNewFavicon' 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;
22	0.13 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;
23	0.35 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "nl" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'nl';
24	0.26 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: [`1768260643 [ "\x00tags\x00document_2" "document_2" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_2', 'document_2');
25	0.19 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: [`1768260643 [ "document_2\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2\0tags\0');
26	0.33 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: [`1768260643 [ "\x00tags\x00nav_7dd9e2b35c346827d38a9ce2a5df352d" "nav_7dd9e2b35c346827d38a9ce2a5df352d" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_7dd9e2b35c346827d38a9ce2a5df352d', 'nav_7dd9e2b35c346827d38a9ce2a5df352d');
27	1.01 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: [1768260643 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_5\x00tags\x00" "document_8\x00tags\x00" "document_457\x00tags\x00" "document_456\x00tags\x00" "document_448\x00tags\x00" "document_175\x00tags\x00" "document_413\x00tags\x00" "document_205\x00tags\x00" "document_244\x00tags\x00" "document_265\x00tags\x00" "document_105\x00tags\x00" "document_247\x00tags\x00" "document_177\x00tags\x00" "document_198\x00tags\x00" "document_185\x00tags\x00" "document_230\x00tags\x00" "document_251\x00tags\x00" "document_108\x00tags\x00" "document_204\x00tags\x00" "document_329\x00tags\x00" "document_403\x00tags\x00" "document_410\x00tags\x00" "document_106\x00tags\x00" "document_109\x00tags\x00" "document_310\x00tags\x00" "document_311\x00tags\x00" "document_317\x00tags\x00" "document_243\x00tags\x00" "document_107\x00tags\x00" "document_112\x00tags\x00" "document_170\x00tags\x00" "document_385\x00tags\x00" "document_278\x00tags\x00" "document_75\x00tags\x00" "document_127\x00tags\x00" "document_184\x00tags\x00" "document_125\x00tags\x00" "document_401\x00tags\x00" "document_325\x00tags\x00" "document_128\x00tags\x00" "document_129\x00tags\x00" "document_263\x00tags\x00" "document_123\x00tags\x00" "document_267\x00tags\x00" "document_298\x00tags\x00" "document_219\x00tags\x00" "document_460\x00tags\x00" "document_266\x00tags\x00" "document_131\x00tags\x00" "document_132\x00tags\x00" "document_328\x00tags\x00" "document_412\x00tags\x00" "document_130\x00tags\x00" "document_118\x00tags\x00" "document_315\x00tags\x00" "document_117\x00tags\x00" "document_203\x00tags\x00" "document_121\x00tags\x00" "document_387\x00tags\x00" "document_386\x00tags\x00" "document_77\x00tags\x00" "document_364\x00tags\x00" "document_365\x00tags\x00" "document_363\x00tags\x00" "document_259\x00tags\x00" "document_336\x00tags\x00" "document_335\x00tags\x00" "document_141\x00tags\x00" "document_142\x00tags\x00" "document_140\x00tags\x00" "document_144\x00tags\x00" "document_143\x00tags\x00" "document_371\x00tags\x00" "document_376\x00tags\x00" "document_377\x00tags\x00" "document_378\x00tags\x00" "document_379\x00tags\x00" "document_368\x00tags\x00" "document_79\x00tags\x00" "document_53\x00tags\x00" "document_197\x00tags\x00" "document_458\x00tags\x00" "document_360\x00tags\x00" "document_395\x00tags\x00" "document_443\x00tags\x00" "document_444\x00tags\x00" "document_446\x00tags\x00" "document_453\x00tags\x00" "document_459\x00tags\x00" "document_14\x00tags\x00" "document_221\x00tags\x00" "document_229\x00tags\x00" "document_237\x00tags\x00" "document_261\x00tags\x00" "document_274\x00tags\x00" "document_292\x00tags\x00" "document_342\x00tags\x00" "document_351\x00tags\x00" "document_466\x00tags\x00" "document_190\x00tags\x00" "document_73\x00tags\x00" "document_71\x00tags\x00" "document_20\x00tags\x00" "document_318\x00tags\x00" "document_290\x00tags\x00" "document_23\x00tags\x00" "document_65\x00tags\x00" "document_95\x00tags\x00" "document_93\x00tags\x00" "document_89\x00tags\x00" "document_87\x00tags\x00" "document_85\x00tags\x00" "document_35\x00tags\x00" "document_174\x00tags\x00" "document_297\x00tags\x00" "document_322\x00tags\x00" "document_155\x00tags\x00" "nav_7dd9e2b35c346827d38a9ce2a5df352d\x00tags\x00" ]] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_5\0tags\0', 'document_8\0tags\0', 'document_457\0tags\0', 'document_456\0tags\0', 'document_448\0tags\0', 'document_175\0tags\0', 'document_413\0tags\0', 'document_205\0tags\0', 'document_244\0tags\0', 'document_265\0tags\0', 'document_105\0tags\0', 'document_247\0tags\0', 'document_177\0tags\0', 'document_198\0tags\0', 'document_185\0tags\0', 'document_230\0tags\0', 'document_251\0tags\0', 'document_108\0tags\0', 'document_204\0tags\0', 'document_329\0tags\0', 'document_403\0tags\0', 'document_410\0tags\0', 'document_106\0tags\0', 'document_109\0tags\0', 'document_310\0tags\0', 'document_311\0tags\0', 'document_317\0tags\0', 'document_243\0tags\0', 'document_107\0tags\0', 'document_112\0tags\0', 'document_170\0tags\0', 'document_385\0tags\0', 'document_278\0tags\0', 'document_75\0tags\0', 'document_127\0tags\0', 'document_184\0tags\0', 'document_125\0tags\0', 'document_401\0tags\0', 'document_325\0tags\0', 'document_128\0tags\0', 'document_129\0tags\0', 'document_263\0tags\0', 'document_123\0tags\0', 'document_267\0tags\0', 'document_298\0tags\0', 'document_219\0tags\0', 'document_460\0tags\0', 'document_266\0tags\0', 'document_131\0tags\0', 'document_132\0tags\0', 'document_328\0tags\0', 'document_412\0tags\0', 'document_130\0tags\0', 'document_118\0tags\0', 'document_315\0tags\0', 'document_117\0tags\0', 'document_203\0tags\0', 'document_121\0tags\0', 'document_387\0tags\0', 'document_386\0tags\0', 'document_77\0tags\0', 'document_364\0tags\0', 'document_365\0tags\0', 'document_363\0tags\0', 'document_259\0tags\0', 'document_336\0tags\0', 'document_335\0tags\0', 'document_141\0tags\0', 'document_142\0tags\0', 'document_140\0tags\0', 'document_144\0tags\0', 'document_143\0tags\0', 'document_371\0tags\0', 'document_376\0tags\0', 'document_377\0tags\0', 'document_378\0tags\0', 'document_379\0tags\0', 'document_368\0tags\0', 'document_79\0tags\0', 'document_53\0tags\0', 'document_197\0tags\0', 'document_458\0tags\0', 'document_360\0tags\0', 'document_395\0tags\0', 'document_443\0tags\0', 'document_444\0tags\0', 'document_446\0tags\0', 'document_453\0tags\0', 'document_459\0tags\0', 'document_14\0tags\0', 'document_221\0tags\0', 'document_229\0tags\0', 'document_237\0tags\0', 'document_261\0tags\0', 'document_274\0tags\0', 'document_292\0tags\0', 'document_342\0tags\0', 'document_351\0tags\0', 'document_466\0tags\0', 'document_190\0tags\0', 'document_73\0tags\0', 'document_71\0tags\0', 'document_20\0tags\0', 'document_318\0tags\0', 'document_290\0tags\0', 'document_23\0tags\0', 'document_65\0tags\0', 'document_95\0tags\0', 'document_93\0tags\0', 'document_89\0tags\0', 'document_87\0tags\0', 'document_85\0tags\0', 'document_35\0tags\0', 'document_174\0tags\0', 'document_297\0tags\0', 'document_322\0tags\0', 'document_155\0tags\0', 'nav_7dd9e2b35c346827d38a9ce2a5df352d\0tags\0');
28	0.25 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
29	0.32 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: [`1768260643 [ "\x00tags\x00translation_data_2b0562963ad619f7386bc0e9856ed713" "translation_data_2b0562963ad619f7386bc0e9856ed713" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2b0562963ad619f7386bc0e9856ed713', 'translation_data_2b0562963ad619f7386bc0e9856ed713');
30	0.21 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: [`1768260643 [ "translator\x00tags\x00" "translator_website\x00tags\x00" "translate\x00tags\x00" "translation_data_2b0562963ad619f7386bc0e9856ed713\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator\0tags\0', 'translator_website\0tags\0', 'translate\0tags\0', 'translation_data_2b0562963ad619f7386bc0e9856ed713\0tags\0');
31	0.28 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: [`1768260643 [ "\x00tags\x00document_5" "document_5" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_5', 'document_5');
32	0.33 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: [`1768260643 [ "document_5\x00tags\x00" "asset_256\x00tags\x00" "asset_254\x00tags\x00" "asset_269\x00tags\x00" "asset_202\x00tags\x00" "asset_244\x00tags\x00" "asset_196\x00tags\x00" "asset_201\x00tags\x00" "asset_199\x00tags\x00" "asset_200\x00tags\x00" "asset_43\x00tags\x00" "asset_232\x00tags\x00" "asset_44\x00tags\x00" "asset_42\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_5\0tags\0', 'asset_256\0tags\0', 'asset_254\0tags\0', 'asset_269\0tags\0', 'asset_202\0tags\0', 'asset_244\0tags\0', 'asset_196\0tags\0', 'asset_201\0tags\0', 'asset_199\0tags\0', 'asset_200\0tags\0', 'asset_43\0tags\0', 'asset_232\0tags\0', 'asset_44\0tags\0', 'asset_42\0tags\0');
33	0.21 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: [`1768260643 [ "\x00tags\x00document_properties_5" "document_properties_5" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_5', 'document_properties_5');
34	0.24 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: [`1768260643 [ "document_properties\x00tags\x00" "document_5\x00tags\x00" "document_properties_5\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_5\0tags\0', 'document_properties_5\0tags\0');
35	0.23 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: [`1768260643 [ "\x00tags\x00document_8" "document_8" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_8', 'document_8');
36	0.21 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: [`1768260643 [ "document_8\x00tags\x00" "asset_304\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_8\0tags\0', 'asset_304\0tags\0');
37	0.22 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: [`1768260643 [ "\x00tags\x00document_properties_8" "document_properties_8" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_8', 'document_properties_8');
38	0.26 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: [`1768260643 [ "document_properties\x00tags\x00" "document_8\x00tags\x00" "document_properties_8\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_8\0tags\0', 'document_properties_8\0tags\0');
39	0.19 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: [`1768260643 [ "\x00tags\x00document_448" "document_448" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_448', 'document_448');
40	0.19 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: [`1768260643 [ "\x00tags\x00document_properties_448" "document_properties_448" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_448', 'document_properties_448');
41	0.20 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: [`1768260643 [ "document_properties\x00tags\x00" "document_448\x00tags\x00" "document_properties_448\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_448\0tags\0', 'document_properties_448\0tags\0');
42	0.19 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: [`1768260643 [ "\x00tags\x00document_73" "document_73" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_73', 'document_73');
43	0.20 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: [`1768260643 [ "document_73\x00tags\x00" "asset_112\x00tags\x00" "asset_113\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_73\0tags\0', 'asset_112\0tags\0', 'asset_113\0tags\0');
44	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: [`1768260643 [ "\x00tags\x00document_properties_73" "document_properties_73" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_73', 'document_properties_73');
45	0.19 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: [`1768260643 [ "document_properties\x00tags\x00" "document_73\x00tags\x00" "document_properties_73\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_73\0tags\0', 'document_properties_73\0tags\0');
46	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: [`1768260643 [ "\x00tags\x00document_71" "document_71" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_71', 'document_71');
47	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: [`1768260643 [ "\x00tags\x00document_properties_71" "document_properties_71" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_71', 'document_properties_71');
48	0.20 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: [`1768260643 [ "document_properties\x00tags\x00" "document_71\x00tags\x00" "document_properties_71\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_71\0tags\0', 'document_properties_71\0tags\0');
49	0.21 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: [`1768260643 [ "\x00tags\x00document_20" "document_20" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_20', 'document_20');
50	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: [`1768260643 [ "\x00tags\x00document_properties_20" "document_properties_20" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_20', 'document_properties_20');
51	0.20 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: [`1768260643 [ "document_properties\x00tags\x00" "document_20\x00tags\x00" "document_properties_20\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_20\0tags\0', 'document_properties_20\0tags\0');
52	0.90 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`177`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 177;
53	0.29 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: [`1768260643 [ "\x00tags\x00asset_141" "asset_141" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_141', 'asset_141');
54	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: [`1768260643 [ "asset_141\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_141\0tags\0');
55	0.23 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: [`1768260643 [ "\x00tags\x00asset_93" "asset_93" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_93', 'asset_93');
56	0.17 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: [`1768260643 [ "asset_93\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_93\0tags\0');
57	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 93`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 93;
58	0.22 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_da3f8c50e3a4c17917fb9bbb51699885" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'auto_da3f8c50e3a4c17917fb9bbb51699885' AND scope = 'pimcore_image_thumbnails';
59	0.20 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_93__cc6c8fceceed05ae660e0016c5f193f1"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_93__cc6c8fceceed05ae660e0016c5f193f1';
60	1.13 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_93__cc6c8fceceed05ae660e0016c5f193f1" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";s:3:"400";s:6:"height";s:3:"534";}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_da3f8c50e3a4c17917fb9bbb51699885";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:85;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1768260643 ":col4" => 1768865443 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
61	0.23 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 141`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 141;
62	0.16 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_73f07721963da77e898e3016ee68ec5d" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'auto_73f07721963da77e898e3016ee68ec5d' AND scope = 'pimcore_image_thumbnails';
63	0.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_141__82f8cb68c4cf05d7112cb918444543e7"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_141__82f8cb68c4cf05d7112cb918444543e7';
64	0.87 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_141__82f8cb68c4cf05d7112cb918444543e7" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";s:3:"400";s:11:"forceResize";b:0;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_73f07721963da77e898e3016ee68ec5d";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:85;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1768260643 ":col4" => 1768865443 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
65	0.28 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: [`1768260643 [ "\x00tags\x00asset_216" "asset_216" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_216', 'asset_216');
66	0.17 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: [`1768260643 [ "asset_216\x00tags\x00" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_216\0tags\0');
67	0.19 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 216`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 216;
68	0.17 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "auto_6f51280e272b9849d8af2ed6255aa312" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'auto_6f51280e272b9849d8af2ed6255aa312' AND scope = 'pimcore_image_thumbnails';
69	0.14 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_216__418a948471a88c0e33f0f779a4058959"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_216__418a948471a88c0e33f0f779a4058959';
70	0.86 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_216__418a948471a88c0e33f0f779a4058959" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:6:"resize";s:9:"arguments";a:2:{s:5:"width";s:3:"400";s:6:"height";s:3:"266";}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:37:"auto_6f51280e272b9849d8af2ed6255aa312";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:6:"SOURCE";s:10:"\x00\x00quality";i:85;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1768260643 ":col4" => 1768865443 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
71	0.41 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: [`1768260643 [ "\x00tags\x00nav_7dd9e2b35c346827d38a9ce2a5df352d" "nav_7dd9e2b35c346827d38a9ce2a5df352d" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_7dd9e2b35c346827d38a9ce2a5df352d', 'nav_7dd9e2b35c346827d38a9ce2a5df352d');
72	0.50 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`155`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 155) AND published = 1 ORDER BY `index` ASC ;
73	0.26 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: [`1768260643 [ "\x00tags\x00document_95" "document_95" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_95', 'document_95');
74	0.20 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: [`1768260643 [ "\x00tags\x00document_89" "document_89" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_89', 'document_89');
75	0.28 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: [`1768260643 [ "\x00tags\x00document_87" "document_87" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_87', 'document_87');
76	0.28 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: [`1768260643 [ "\x00tags\x00document_85" "document_85" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_85', 'document_85');
77	0.20 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: [`1768260643 [ "\x00tags\x00document_174" "document_174" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_174', 'document_174');
78	0.21 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: [`1768260643 [ "\x00tags\x00document_297" "document_297" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_297', 'document_297');
79	0.19 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: [`1768260643 [ "\x00tags\x00document_322" "document_322" ]`] 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 > 1768260643 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_322', 'document_322');

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.

Entities Mapping

Class	Mapping errors
FormBuilderBundle\Model\FormDefinition	No errors.

Symfony Profiler

https://zsg.ultinova.be/nl/Zeilen/Zeilkampen/Zomerkampen

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping