Symfony Profiler

Query Metrics

42 Database Queries

7 Different statements

2.74 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id, name FROM classes
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?
SELECT `id`, `name` FROM classes WHERE name = ?

#▲	Time	Info
1	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: [`1794526525 "site_domain_e37bfcefbd37030e2b645fe0d9c6d661"`] 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 > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_e37bfcefbd37030e2b645fe0d9c6d661');
2	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: [`1794526525 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	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: [`1794526525 "maintenance_mode"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
4	0.12 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-graphql-webservices/" "artemis_datahub"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/pimcore-graphql-webservices/' AND `key` = BINARY 'artemis_datahub';
5	0.08 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-graphql-webservices/artemis_datahub"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/artemis_datahub';
6	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "pimcore-graphql-webservices"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-graphql-webservices';
7	0.06 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-graphql-webservices"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices';
8	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';
9	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: [`1794526525 "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 > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
10	0.08 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1794526525 "document_1\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
11	0.06 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: [`1794526525 "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 > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1');
12	0.06 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: [`1794526525 "\x00tags\x00document_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 > 1794526525 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1');
13	0.09 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';
14	0.10 ms	SELECT id, name FROM classes Parameters: [] View formatted query View runnable query Explain query SELECT id, name FROM classes SELECT id, name FROM classes;
15	0.07 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Appliance"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Appliance' ;
16	0.06 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Benefits"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Benefits' ;
17	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Benefits_group"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Benefits_group' ;
18	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Brand"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Brand' ;
19	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"DropAbsorbency"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'DropAbsorbency' ;
20	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Family"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Family' ;
21	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Group"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Group' ;
22	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"IncontinenceColor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'IncontinenceColor' ;
23	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Product' ;
24	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"product_template"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'product_template' ;
25	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Size"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Size' ;
26	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"VisualSearchCategory"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'VisualSearchCategory' ;
27	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Brand"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Brand' ;
28	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Group"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Group' ;
29	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Product' ;
30	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Family"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Family' ;
31	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"IncontinenceColor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'IncontinenceColor' ;
32	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Size"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Size' ;
33	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"DropAbsorbency"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'DropAbsorbency' ;
34	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Appliance"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Appliance' ;
35	0.04 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Benefits"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Benefits' ;
36	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Brand"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Brand' ;
37	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Group"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Group' ;
38	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Product' ;
39	0.05 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Family"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Family' ;
40	0.09 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"IncontinenceColor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'IncontinenceColor' ;
41	0.06 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Size"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Size' ;
42	0.08 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"DropAbsorbency"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'DropAbsorbency' ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

POST https://pimcore.ontex.staging.labsoft.fr/pimcore-graphql-webservices/artemis_datahub?apikey=3a880adf2a1a7f74ba016408cb84e2ff

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping