Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

80 Database Queries

22 Different statements

104.95 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 id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
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 * FROM object_url_slugs WHERE slug = '/product/detail/E-VGAM-5BNCF-6' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE 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 id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT item_id, CASE 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 properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 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 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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_Measurements_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1
SELECT * FROM object_collection_ProductCollateral_2 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_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1
SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ?
SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ?
SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (ASSEMBLY_LINE = ? AND  object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 ORDER BY `Assembly_Length`
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27583
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27584
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27585
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27587
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27588
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27586
SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27589

#▲	Time	Info
1	1.07 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: [`1741807907 [ "\x00tags\x00site_domain_daeba7eeddae4bec3e842438cfa5b96a" "site_domain_daeba7eeddae4bec3e842438cfa5b96a" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_daeba7eeddae4bec3e842438cfa5b96a', 'site_domain_daeba7eeddae4bec3e842438cfa5b96a');
2	1.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: [`1741807907 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_daeba7eeddae4bec3e842438cfa5b96a\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_daeba7eeddae4bec3e842438cfa5b96a\0tags\0');
3	1.04 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" => "/product/detail/E-VGAM-5BNCF-6" "sourcePathQuery" => "/product/detail/E-VGAM-5BNCF-6" "sourceEntireUri" => "http://pim.libertyav.io/product/detail/E-VGAM-5BNCF-6" "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 = '/product/detail/E-VGAM-5BNCF-6' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/product/detail/E-VGAM-5BNCF-6' AND `type` = 'path_query') OR (source = 'http://pim.libertyav.io/product/detail/E-VGAM-5BNCF-6' 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.90 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: [`1741807907 [ "\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	1.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: [`1741807907 [ "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 > 1741807907 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	1.56 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	2.04 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "E-VGAM-5BNCF-6" "path" => "/product/detail/"`] 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 '/product/detail/' AND `key` = BINARY 'E-VGAM-5BNCF-6';
8	0.87 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product/detail/E-VGAM-5BNCF-6"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product/detail/E-VGAM-5BNCF-6';
9	1.51 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "E-VGAM-5BNCF-6" "path" => "/product/detail/"`] 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 '/product/detail/' AND `key` = BINARY 'E-VGAM-5BNCF-6';
10	1.15 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product/detail/E-VGAM-5BNCF-6"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product/detail/E-VGAM-5BNCF-6';
11	1.27 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "detail" "path" => "/product/"`] 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 '/product/' AND `key` = BINARY 'detail';
12	1.43 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product/detail"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product/detail';
13	1.41 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "product" "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 'product';
14	1.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product';
15	1.88 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "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 '';
16	1.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: [`1741807907 [ "\x00tags\x00document_1" "document_1" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
17	0.89 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: [`1741807907 [ "document_1\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
18	1.22 ms	SELECT * FROM object_url_slugs WHERE slug = '/product/detail/E-VGAM-5BNCF-6' 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 = '/product/detail/E-VGAM-5BNCF-6' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/product/detail/E-VGAM-5BNCF-6' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
19	1.15 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
20	1.37 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "134991b8-37a7-4850-9b50-d3062d3aeb60" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '134991b8-37a7-4850-9b50-d3062d3aeb60' AND scope = 'pimcore_staticroutes';
21	0.93 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "3ae98299-ff30-4e17-a360-1e100ef5e53c" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '3ae98299-ff30-4e17-a360-1e100ef5e53c' AND scope = 'pimcore_staticroutes';
22	2.20 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5333966b-5c27-42cc-9ee3-cc95affdd8ca" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5333966b-5c27-42cc-9ee3-cc95affdd8ca' AND scope = 'pimcore_staticroutes';
23	1.34 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "5a581dfb-2aeb-4e26-b03c-0645873f5354" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '5a581dfb-2aeb-4e26-b03c-0645873f5354' AND scope = 'pimcore_staticroutes';
24	0.96 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "a0a78834-414b-4cfa-882a-3dbc509eb591" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'a0a78834-414b-4cfa-882a-3dbc509eb591' AND scope = 'pimcore_staticroutes';
25	0.91 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "cd8d969d-e217-447c-8063-8cd4e4068573" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'cd8d969d-e217-447c-8063-8cd4e4068573' AND scope = 'pimcore_staticroutes';
26	0.99 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "dd8930ba-1f75-4346-ac10-4c965969034e" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'dd8930ba-1f75-4346-ac10-4c965969034e' AND scope = 'pimcore_staticroutes';
27	0.85 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "e27b6db3-b1b7-4657-8f2e-94677b680363" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'e27b6db3-b1b7-4657-8f2e-94677b680363' AND scope = 'pimcore_staticroutes';
28	0.94 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "f9e72f11-4cdc-4816-9154-44c6ca2cdb07" "scope" => "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'f9e72f11-4cdc-4816-9154-44c6ca2cdb07' AND scope = 'pimcore_staticroutes';
29	1.36 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "E-VGAM-5BNCF-6" "path" => "/product/detail/"`] 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 '/product/detail/' AND `key` = BINARY 'E-VGAM-5BNCF-6';
30	0.85 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product/detail/E-VGAM-5BNCF-6"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product/detail/E-VGAM-5BNCF-6';
31	1.00 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "detail" "path" => "/product/"`] 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 '/product/' AND `key` = BINARY 'detail';
32	1.32 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product/detail"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product/detail';
33	1.08 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "product" "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 'product';
34	0.86 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/product"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/product';
35	0.89 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: [`1741807907 [ "\x00tags\x00document_properties_1" "document_properties_1" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
36	1.00 ms	SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = 1 ) AND ctype='document';
37	2.31 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;
38	2.89 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 Parameters: [`"E-VGAM-5BNCF-6"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE 'E-VGAM-5BNCF-6' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1;
39	1.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: [`1741807907 [ "\x00tags\x00object_27586" "object_27586" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27586', 'object_27586');
40	1.68 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: [`1741807907 [ "object_27586\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27586\0tags\0', 'class_2\0tags\0');
41	0.88 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '2';
42	2.00 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: [`1741807907 [ "\x00tags\x00object_27583" "object_27583" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27583', 'object_27583');
43	1.57 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: [`1741807907 [ "object_27583\x00tags\x00" "class_2\x00tags\x00" "asset_1604\x00tags\x00" "asset_1605\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27583\0tags\0', 'class_2\0tags\0', 'asset_1604\0tags\0', 'asset_1605\0tags\0');
44	1.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: [`1741807907 [ "\x00tags\x00object_1" "object_1" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');
45	1.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: [`1741807907 [ "object_1\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
46	0.98 ms	SELECT * FROM object_collection_Measurements_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27586 "ProductMeasurements"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Measurements_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_Measurements_2 WHERE o_id = 27586 AND fieldname = 'ProductMeasurements' ORDER BY `index` ASC;
47	0.92 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27586 "ProductCollateral"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27586 AND fieldname = 'ProductCollateral' ORDER BY `index` ASC;
48	2.03 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 Parameters: [`"E-VGAM-5BNCF"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE 'E-VGAM-5BNCF' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1;
49	1.01 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27583 "ProductCollateral"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27583 AND fieldname = 'ProductCollateral' ORDER BY `index` ASC;
50	1.61 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: [`1741807907 [ "\x00tags\x00asset_3043" "asset_3043" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_3043', 'asset_3043');
51	1.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: [`1741807907 [ "asset_3043\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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_3043\0tags\0');
52	1.56 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27586 "Software"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27586 AND fieldname = 'Software' ORDER BY `index` ASC;
53	1.72 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 Parameters: [`"E-VGAM-5BNCF"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE 'E-VGAM-5BNCF' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1;
54	1.00 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27583 "Software"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27583 AND fieldname = 'Software' ORDER BY `index` ASC;
55	1.48 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27586 "Firmware"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27586 AND fieldname = 'Firmware' ORDER BY `index` ASC;
56	1.87 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 Parameters: [`"E-VGAM-5BNCF"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE 'E-VGAM-5BNCF' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1;
57	0.95 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27583 "Firmware"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27583 AND fieldname = 'Firmware' ORDER BY `index` ASC;
58	0.93 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27586 "Diagram"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27586 AND fieldname = 'Diagram' ORDER BY `index` ASC;
59	1.61 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 Parameters: [`"E-VGAM-5BNCF"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( item_nbr LIKE ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (item_nbr LIKE 'E-VGAM-5BNCF' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1;
60	1.04 ms	SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`27583 "Diagram"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ProductCollateral_2 WHERE o_id = 27583 AND fieldname = 'Diagram' ORDER BY `index` ASC;
61	1.18 ms	SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ? Parameters: [`27586 "object"`] View formatted query View runnable query Explain query SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ? SELECT tagid FROM tags_assignment WHERE cid = 27586 AND ctype = 'object';
62	0.97 ms	SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ? Parameters: [`27583 "object"`] View formatted query View runnable query Explain query SELECT tagid FROM tags_assignment WHERE cid = ? AND ctype = ? SELECT tagid FROM tags_assignment WHERE cid = 27583 AND ctype = 'object';
63	2.84 ms	SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (ASSEMBLY_LINE = ? AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 ORDER BY `Assembly_Length` Parameters: [`"E-VGAM-5BNCF"`] View formatted query View runnable query Explain query SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE ( ASSEMBLY_LINE = ? AND object_localized_2_en.o_type IN ('variant', 'object') ) AND object_localized_2_en.o_published = 1 ORDER BY `Assembly_Length` SELECT object_localized_2_en.o_id as o_id, object_localized_2_en.o_type as o_type FROM object_localized_2_en WHERE (ASSEMBLY_LINE = 'E-VGAM-5BNCF' AND object_localized_2_en.o_type IN ('variant','object')) AND object_localized_2_en.o_published = 1 ORDER BY `Assembly_Length` ;
64	1.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: [`1741807907 [ "\x00tags\x00object_27584" "object_27584" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27584', 'object_27584');
65	2.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: [`1741807907 [ "object_27584\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27584\0tags\0', 'class_2\0tags\0');
66	1.04 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: [`1741807907 [ "\x00tags\x00object_27585" "object_27585" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27585', 'object_27585');
67	1.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: [`1741807907 [ "object_27585\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27585\0tags\0', 'class_2\0tags\0');
68	1.05 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: [`1741807907 [ "\x00tags\x00object_27587" "object_27587" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27587', 'object_27587');
69	0.89 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: [`1741807907 [ "object_27587\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27587\0tags\0', 'class_2\0tags\0');
70	1.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: [`1741807907 [ "\x00tags\x00object_27588" "object_27588" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27588', 'object_27588');
71	0.86 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: [`1741807907 [ "object_27588\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27588\0tags\0', 'class_2\0tags\0');
72	1.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: [`1741807907 [ "\x00tags\x00object_27589" "object_27589" ]`] 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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_27589', 'object_27589');
73	1.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: [`1741807907 [ "object_27589\x00tags\x00" "class_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 > 1741807907 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_27589\0tags\0', 'class_2\0tags\0');
74	1.67 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27583 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27583 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27583;
75	1.17 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27584 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27584 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27584;
76	0.87 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27585 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27585 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27585;
77	0.88 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27587 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27587 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27587;
78	0.84 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27588 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27588 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27588;
79	2.07 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27586 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27586 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27586;
80	1.57 ms	SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27589 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27589 SELECT * FROM tags_assignment ta INNER JOIN tags t ON t.id = ta.tagid WHERE ta.cid = 27589;

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

http://pim.libertyav.io/product/detail/E-VGAM-5BNCF-6

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache