Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

131 Database Queries

15 Different statements

26.25 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/producten/magnecaps-memory-concentration' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
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 sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT item_id, 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 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 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 item_id, 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 sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT item_id, 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 sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT item_id, 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 name FROM classes WHERE id = ?
SELECT item_id, 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 * FROM object_collection_Pharmacies_3 WHERE o_id = ? AND fieldname = ? 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 * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT item_id, 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_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :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 item_id, 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 settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :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 item_id, 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 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 item_id, 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 documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?

#▲	Time	Info
1	0.77 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: [`1731605129 [ "\x00tags\x00site_domain_d6b308cb779faaa54a6a309fe081eca7" "site_domain_d6b308cb779faaa54a6a309fe081eca7" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_d6b308cb779faaa54a6a309fe081eca7', 'site_domain_d6b308cb779faaa54a6a309fe081eca7');
2	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: [`1731605129 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_d6b308cb779faaa54a6a309fe081eca7\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_d6b308cb779faaa54a6a309fe081eca7\0tags\0');
3	0.36 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/producten/magnecaps-memory-concentration" "sourcePathQuery" => "/nl/producten/magnecaps-memory-concentration" "sourceEntireUri" => "https://magnecapsv2.atypic-pp.be/nl/producten/magnecaps-memory-concentration" "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/producten/magnecaps-memory-concentration' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/producten/magnecaps-memory-concentration' AND `type` = 'path_query') OR (source = 'https://magnecapsv2.atypic-pp.be/nl/producten/magnecaps-memory-concentration' 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.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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	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: [`1731605129 [ "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 > 1731605129 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.16 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.25 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "magnecaps-memory-concentration" "path" => "/nl/producten/"`] 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/producten/' AND `key` = BINARY 'magnecaps-memory-concentration';
8	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: [`1731605129 [ "\x00tags\x00document_77" "document_77" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_77', 'document_77');
9	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: [`1731605129 [ "document_77\x00tags\x00" "asset_70\x00tags\x00" "asset_150\x00tags\x00" "asset_91\x00tags\x00" "asset_93\x00tags\x00" "asset_130\x00tags\x00" "asset_123\x00tags\x00" "asset_101\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_77\0tags\0', 'asset_70\0tags\0', 'asset_150\0tags\0', 'asset_91\0tags\0', 'asset_93\0tags\0', 'asset_130\0tags\0', 'asset_123\0tags\0', 'asset_101\0tags\0');
10	2.76 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: [`1731605129 [ "\x00tags\x00document_properties_77" "document_properties_77" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_77', 'document_properties_77');
11	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: [`1731605129 [ "document_properties\x00tags\x00" "document_77\x00tags\x00" "document_properties_77\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_77\0tags\0', 'document_properties_77\0tags\0');
12	0.19 ms	SELECT * FROM object_url_slugs WHERE slug = '/nl/producten/magnecaps-memory-concentration' AND (siteId = 0 OR 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/producten/magnecaps-memory-concentration' AND ( siteId = 0 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/nl/producten/magnecaps-memory-concentration' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
13	0.24 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.30 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;;
15	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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2b0562963ad619f7386bc0e9856ed713', 'translation_data_2b0562963ad619f7386bc0e9856ed713');
16	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: [`1731605129 [ "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 > 1731605129 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');
17	0.22 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`77`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 77;
18	0.28 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(43, 77) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
19	0.21 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 77 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
20	0.21 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 43`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 43 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 43;
21	0.15 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: [`1731605129 [ "\x00tags\x00document_43" "document_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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_43', 'document_43');
22	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: [`1731605129 [ "document_43\x00tags\x00" "asset_70\x00tags\x00" "asset_150\x00tags\x00" "asset_91\x00tags\x00" "asset_93\x00tags\x00" "asset_130\x00tags\x00" "asset_87\x00tags\x00" "asset_80\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_43\0tags\0', 'asset_70\0tags\0', 'asset_150\0tags\0', 'asset_91\0tags\0', 'asset_93\0tags\0', 'asset_130\0tags\0', 'asset_87\0tags\0', 'asset_80\0tags\0');
23	0.15 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: [`1731605129 [ "\x00tags\x00document_properties_43" "document_properties_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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_43', 'document_properties_43');
24	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: [`1731605129 [ "document_properties\x00tags\x00" "document_43\x00tags\x00" "document_properties_43\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_43\0tags\0', 'document_properties_43\0tags\0');
25	0.20 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "fr" "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 'fr';
26	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: [`1731605129 [ "\x00tags\x00document_37" "document_37" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_37', 'document_37');
27	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: [`1731605129 [ "document_37\x00tags\x00" "document_1\x00tags\x00" "asset_68\x00tags\x00" "asset_76\x00tags\x00" "asset_72\x00tags\x00" "asset_87\x00tags\x00" "asset_69\x00tags\x00" "asset_90\x00tags\x00" "asset_71\x00tags\x00" "asset_80\x00tags\x00" "asset_132\x00tags\x00" "asset_134\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_37\0tags\0', 'document_1\0tags\0', 'asset_68\0tags\0', 'asset_76\0tags\0', 'asset_72\0tags\0', 'asset_87\0tags\0', 'asset_69\0tags\0', 'asset_90\0tags\0', 'asset_71\0tags\0', 'asset_80\0tags\0', 'asset_132\0tags\0', 'asset_134\0tags\0');
28	0.14 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';
29	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: [`1731605129 [ "\x00tags\x00document_38" "document_38" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_38', 'document_38');
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: [`1731605129 [ "document_38\x00tags\x00" "asset_68\x00tags\x00" "asset_76\x00tags\x00" "asset_72\x00tags\x00" "asset_123\x00tags\x00" "asset_69\x00tags\x00" "asset_105\x00tags\x00" "asset_71\x00tags\x00" "asset_101\x00tags\x00" "asset_133\x00tags\x00" "asset_134\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_38\0tags\0', 'asset_68\0tags\0', 'asset_76\0tags\0', 'asset_72\0tags\0', 'asset_123\0tags\0', 'asset_69\0tags\0', 'asset_105\0tags\0', 'asset_71\0tags\0', 'asset_101\0tags\0', 'asset_133\0tags\0', 'asset_134\0tags\0');
31	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: [`1731605129 [ "\x00tags\x00nav_f8e38ec16ec6b284311f50929859572f" "nav_f8e38ec16ec6b284311f50929859572f" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f8e38ec16ec6b284311f50929859572f', 'nav_f8e38ec16ec6b284311f50929859572f');
32	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: [`1731605129 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_71\x00tags\x00" "document_75\x00tags\x00" "document_76\x00tags\x00" "document_77\x00tags\x00" "document_74\x00tags\x00" "document_79\x00tags\x00" "document_86\x00tags\x00" "nav_f8e38ec16ec6b284311f50929859572f\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_71\0tags\0', 'document_75\0tags\0', 'document_76\0tags\0', 'document_77\0tags\0', 'document_74\0tags\0', 'document_79\0tags\0', 'document_86\0tags\0', 'nav_f8e38ec16ec6b284311f50929859572f\0tags\0');
33	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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
34	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: [`1731605129 [ "website_config\x00tags\x00" "system\x00tags\x00" "config\x00tags\x00" "output\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 > 1731605129 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');
35	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: [`1731605129 [ "\x00tags\x00document_75" "document_75" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_75', 'document_75');
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: [`1731605129 [ "document_75\x00tags\x00" "asset_67\x00tags\x00" "asset_152\x00tags\x00" "asset_86\x00tags\x00" "asset_88\x00tags\x00" "asset_101\x00tags\x00" "asset_105\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_75\0tags\0', 'asset_67\0tags\0', 'asset_152\0tags\0', 'asset_86\0tags\0', 'asset_88\0tags\0', 'asset_101\0tags\0', 'asset_105\0tags\0');
37	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: [`1731605129 [ "\x00tags\x00document_properties_75" "document_properties_75" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_75', 'document_properties_75');
38	0.15 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: [`1731605129 [ "document_properties\x00tags\x00" "document_75\x00tags\x00" "document_properties_75\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_75\0tags\0', 'document_properties_75\0tags\0');
39	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: [`1731605129 [ "\x00tags\x00document_76" "document_76" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_76', 'document_76');
40	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: [`1731605129 [ "document_76\x00tags\x00" "asset_66\x00tags\x00" "asset_151\x00tags\x00" "asset_123\x00tags\x00" "asset_105\x00tags\x00" "asset_79\x00tags\x00" "asset_129\x00tags\x00" "asset_127\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_76\0tags\0', 'asset_66\0tags\0', 'asset_151\0tags\0', 'asset_123\0tags\0', 'asset_105\0tags\0', 'asset_79\0tags\0', 'asset_129\0tags\0', 'asset_127\0tags\0');
41	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: [`1731605129 [ "\x00tags\x00document_properties_76" "document_properties_76" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_76', 'document_properties_76');
42	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: [`1731605129 [ "document_properties\x00tags\x00" "document_76\x00tags\x00" "document_properties_76\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_76\0tags\0', 'document_properties_76\0tags\0');
43	0.04 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`77`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 77;
44	0.09 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(43, 77) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
45	0.10 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 77 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
46	0.10 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 43`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 43 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 43;
47	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: [`1731605129 [ "\x00tags\x00asset_76" "asset_76" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_76', 'asset_76');
48	0.05 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`77`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 77;
49	0.04 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(43, 77) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
50	0.03 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`77 77`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 77 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 77;
51	0.03 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`43 43`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 43 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 43;
52	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: [`1731605129 [ "\x00tags\x00nav_f8e38ec16ec6b284311f50929859572f" "nav_f8e38ec16ec6b284311f50929859572f" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f8e38ec16ec6b284311f50929859572f', 'nav_f8e38ec16ec6b284311f50929859572f');
53	0.55 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`77`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 77;
54	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: [`1731605129 [ "\x00tags\x00object_3367" "object_3367" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3367', 'object_3367');
55	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: [`1731605129 [ "object_3367\x00tags\x00" "class_3\x00tags\x00" "asset_90\x00tags\x00" "asset_105\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3367\0tags\0', 'class_3\0tags\0', 'asset_90\0tags\0', 'asset_105\0tags\0');
56	0.49 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '3';
57	0.35 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: [`1731605129 [ "\x00tags\x00asset_196" "asset_196" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_196', 'asset_196');
58	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: [`1731605129 [ "asset_196\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_196\0tags\0');
59	0.19 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
60	0.66 ms	SELECT * FROM object_collection_Pharmacies_3 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`3367 "lienPharmacies"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_3 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_Pharmacies_3 WHERE o_id = 3367 AND fieldname = 'lienPharmacies' ORDER BY `index` ASC;
61	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: [`1731605129 [ "\x00tags\x00asset_189" "asset_189" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_189', 'asset_189');
62	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: [`1731605129 [ "asset_189\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_189\0tags\0');
63	1.10 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 0`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 0;
64	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: [`1731605129 [ "\x00tags\x00asset_188" "asset_188" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_188', 'asset_188');
65	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: [`1731605129 [ "asset_188\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_188\0tags\0');
66	0.26 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 1`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 1;
67	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: [`1731605129 [ "\x00tags\x00asset_199" "asset_199" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_199', 'asset_199');
68	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: [`1731605129 [ "asset_199\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_199\0tags\0');
69	0.26 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 2`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 2;
70	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: [`1731605129 [ "\x00tags\x00asset_190" "asset_190" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_190', 'asset_190');
71	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: [`1731605129 [ "asset_190\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_190\0tags\0');
72	0.19 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 3`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 3;
73	0.15 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: [`1731605129 [ "\x00tags\x00asset_193" "asset_193" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_193', 'asset_193');
74	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: [`1731605129 [ "asset_193\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_193\0tags\0');
75	0.19 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 4`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 4;
76	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: [`1731605129 [ "\x00tags\x00asset_187" "asset_187" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_187', 'asset_187');
77	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: [`1731605129 [ "asset_187\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_187\0tags\0');
78	0.16 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 5`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 5;
79	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: [`1731605129 [ "\x00tags\x00asset_194" "asset_194" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_194', 'asset_194');
80	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: [`1731605129 [ "asset_194\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_194\0tags\0');
81	0.19 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 6`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 6;
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: [`1731605129 [ "\x00tags\x00asset_191" "asset_191" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_191', 'asset_191');
83	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: [`1731605129 [ "asset_191\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_191\0tags\0');
84	0.16 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 7`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 7;
85	0.15 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: [`1731605129 [ "\x00tags\x00asset_186" "asset_186" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_186', 'asset_186');
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: [`1731605129 [ "asset_186\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_186\0tags\0');
87	0.16 ms	SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`3367 "lienPharmacies" 8`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = ? AND language IN ('fr', 'nl') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_Pharmacies_localized_3 WHERE ooo_id = 3367 AND language IN ('fr','nl') AND `fieldname` = 'lienPharmacies' AND `index` = 8;
88	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
89	0.05 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
90	0.06 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
91	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
92	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
93	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
94	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
95	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
96	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
97	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: [`1731605129 [ "\x00tags\x00asset_70" "asset_70" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_70', 'asset_70');
98	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: [`1731605129 [ "\x00tags\x00imagick_format_avif" "imagick_format_avif" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_avif', 'imagick_format_avif');
99	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: [`1731605129 [ "imagick_format_avif\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif\0tags\0');
100	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: [`1731605129 [ "\x00tags\x00imagick_format_webp" "imagick_format_webp" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp', 'imagick_format_webp');
101	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: [`1731605129 [ "imagick_format_webp\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');
102	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: [`1731605129 [ "\x00tags\x00asset_150" "asset_150" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_150', 'asset_150');
103	0.34 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
104	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
105	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
106	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
107	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
108	0.10 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
109	0.08 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
110	0.06 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
111	0.04 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
112	0.07 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "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 = '' AND scope = 'pimcore_image_thumbnails';
113	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: [`1731605129 [ "\x00tags\x00asset_121" "asset_121" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_121', 'asset_121');
114	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: [`1731605129 [ "asset_121\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_121\0tags\0');
115	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: [`1731605129 [ "\x00tags\x00asset_91" "asset_91" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_91', 'asset_91');
116	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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_93', 'asset_93');
117	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: [`1731605129 [ "\x00tags\x00asset_130" "asset_130" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_130', 'asset_130');
118	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: [`1731605129 [ "\x00tags\x00asset_123" "asset_123" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_123', 'asset_123');
119	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: [`1731605129 [ "\x00tags\x00asset_101" "asset_101" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_101', 'asset_101');
120	0.16 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "footer" "path" => "/nl/Snippets/"`] 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/Snippets/' AND `key` = BINARY 'footer';
121	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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_73', 'document_73');
122	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: [`1731605129 [ "document_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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_73\0tags\0');
123	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: [`1731605129 [ "\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_73', 'document_properties_73');
124	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: [`1731605129 [ "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 > 1731605129 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');
125	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: [`1731605129 [ "\x00tags\x00asset_75" "asset_75" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_75', 'asset_75');
126	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: [`1731605129 [ "asset_75\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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_75\0tags\0');
127	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`73`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 73;
128	0.15 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: [`1731605129 [ "\x00tags\x00document_79" "document_79" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_79', 'document_79');
129	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: [`1731605129 [ "\x00tags\x00document_74" "document_74" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_74', 'document_74');
130	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: [`1731605129 [ "\x00tags\x00document_78" "document_78" ]`] 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 > 1731605129 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_78', 'document_78');
131	0.15 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`78`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 78;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://magnecapsv2.atypic-pp.be/_fragment?_path=_locale%3Dnl%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache