Symfony Profiler

Query Metrics

47 Database Queries

7 Different statements

31.01 ms Query time

0 Invalid entities

0 Managed entities

Queries


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 * 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 = ?
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 COUNT(*) FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1
SELECT object_localized_1_es_MX.id as id, object_localized_1_es_MX.type as `type` FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1 LIMIT 200 OFFSET 1600

#▲	Time	Info
1	0.36 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-graphql-webservices/" "ecommerce"`] 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 'ecommerce';
2	0.22 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-graphql-webservices/ecommerce"`] 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/ecommerce';
3	0.27 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';
4	0.23 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';
5	0.23 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 '';
6	0.30 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';
7	0.30 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;
8	0.22 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' ;
9	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Category' ;
10	0.23 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Color"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Color' ;
11	0.22 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CommercialLabel"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CommercialLabel' ;
12	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Country"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Country' ;
13	0.21 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CustomService"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CustomService' ;
14	0.20 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' ;
15	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Funcion"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Funcion' ;
16	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Ink"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Ink' ;
17	0.21 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"KitComponent"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'KitComponent' ;
18	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Material"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Material' ;
19	0.19 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' ;
20	0.23 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductCategoryPosition"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductCategoryPosition' ;
21	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductCountryPriceCurrency"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductCountryPriceCurrency' ;
22	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductFeature"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductFeature' ;
23	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ServiceCountryProductVendor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ServiceCountryProductVendor' ;
24	0.20 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SubFamily"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SubFamily' ;
25	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Vendor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Vendor' ;
26	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"VendorService"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'VendorService' ;
27	0.24 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' ;
28	0.19 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' ;
29	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CommercialLabel"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CommercialLabel' ;
30	0.20 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.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"SubFamily"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'SubFamily' ;
32	0.17 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Funcion"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Funcion' ;
33	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Vendor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Vendor' ;
34	0.19 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Category' ;
35	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductCategoryPosition"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductCategoryPosition' ;
36	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductFeature"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductFeature' ;
37	0.17 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Color"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Color' ;
38	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Ink"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Ink' ;
39	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Material"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Material' ;
40	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ProductCountryPriceCurrency"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ProductCountryPriceCurrency' ;
41	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"ServiceCountryProductVendor"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'ServiceCountryProductVendor' ;
42	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"CustomService"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'CustomService' ;
43	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"Country"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'Country' ;
44	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"VendorService"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'VendorService' ;
45	0.18 ms	SELECT `id`, `name` FROM classes WHERE name = ? Parameters: [`"KitComponent"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE name = ? SELECT `id`, `name` FROM classes WHERE name = 'KitComponent' ;
46	10.94 ms	SELECT COUNT() FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object', 'folder', 'variant') ) AND object_localized_1_es_MX.published = 1 SELECT COUNT(*) FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1;
47	10.84 ms	SELECT object_localized_1_es_MX.id as id, object_localized_1_es_MX.type as `type` FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1 LIMIT 200 OFFSET 1600 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_1_es_MX.id as id, object_localized_1_es_MX.type as `type` FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object', 'folder', 'variant') ) AND object_localized_1_es_MX.published = 1 LIMIT 200 OFFSET 1600 SELECT object_localized_1_es_MX.id as id, object_localized_1_es_MX.type as `type` FROM object_localized_1_es_MX WHERE ( object_localized_1_es_MX.type IN ('object','folder','variant')) AND object_localized_1_es_MX.published = 1 LIMIT 200 OFFSET 1600;

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://dev.pim.stocksur.com/pimcore-graphql-webservices/ecommerce?apikey=bcd0e45d01b7e33bf90c71d2faaa388d

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping