Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

90 Database Queries

8 Different statements

15.26 ms Query time

0 Invalid entities

Queries

Group similar statements


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 id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
select id, name from classes
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT id FROM classes WHERE name = ?
SELECT object_localized_PR_en.o_id as o_id, `object_localized_PR_en`.`o_type` FROM `object_localized_PR_en` WHERE ((o_id =286305) AND  object_localized_PR_en.o_type IN ('object','folder','variant')) LIMIT 1
SELECT id FROM classes WHERE name = ?
SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_PVEN r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND o.o_id = r.src_id
            AND r.type='object'

            UNION SELECT r.src_id as dest_id, r.src_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_PVEN r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND a.id = r.src_id
            AND r.type='asset'

            UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_PVEN r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND d.id = r.src_id
            AND r.type='document'

            ORDER BY `index` ASC

#▲	Time	Info
1	0.44 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" => "/pimcore-graphql-webservices/mdm" "sourcePathQuery" => "/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882" "sourceEntireUri" => "http://quocnam-pimcore-qa.local:8085/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882" "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 = '/pimcore-graphql-webservices/mdm' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882' AND `type` = 'path_query') OR (source = 'http://quocnam-pimcore-qa.local:8085/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882' 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;
2	0.24 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "mdm" "path" => "/pimcore-graphql-webservices/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/pimcore-graphql-webservices/' AND `key` = 'mdm';
3	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/pimcore-graphql-webservices/mdm"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/mdm';
4	0.19 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "pimcore-graphql-webservices" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = 'pimcore-graphql-webservices';
5	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/pimcore-graphql-webservices"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices';
6	0.17 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = '';
7	0.44 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.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"ASS"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'ASS';
9	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CA';
10	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CI"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CI';
11	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"COLL"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'COLL';
12	0.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"COL"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'COL';
13	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CLI"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CLI';
14	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CO"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CO';
15	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"DI"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'DI';
16	0.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"LA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'LA';
17	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"MA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'MA';
18	0.19 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PR';
19	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PTEM"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PTEM';
20	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PVEN"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PVEN';
21	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"QU"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'QU';
22	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SALEC"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SALEC';
23	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PRC4SALE"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PRC4SALE';
24	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"ST"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'ST';
25	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"STOREBRAND"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'STOREBRAND';
26	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SL"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SL';
27	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"STOREMENUITEM"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'STOREMENUITEM';
28	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"STOREMENUGROUP"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'STOREMENUGROUP';
29	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"TE"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'TE';
30	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"UN"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'UN';
31	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"UnitExt"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'UnitExt';
32	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"UnitExtGroup"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'UnitExtGroup';
33	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"VA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'VA';
34	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"VEN"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'VEN';
35	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"WAR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'WAR';
36	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"WA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'WA';
37	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"WT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'WT';
38	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Associate"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Associate';
39	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Category';
40	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"City"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'City';
41	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Collection"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Collection';
42	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Color"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Color';
43	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"CommonList"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'CommonList';
44	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Country"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Country';
45	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"District"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'District';
46	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"LineActivity"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'LineActivity';
47	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Manufacturer"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Manufacturer';
48	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Product';
49	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ProductTemplate"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ProductTemplate';
50	0.11 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ProductVendor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ProductVendor';
51	0.11 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Quarter"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Quarter';
52	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"SalesChannel"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'SalesChannel';
53	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"SalesPrice"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'SalesPrice';
54	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Store"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Store';
55	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreBrand"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreBrand';
56	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreLine"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreLine';
57	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreProduct"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreProduct';
58	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreProductGroup"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreProductGroup';
59	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Tenant"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Tenant';
60	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Unit"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Unit';
61	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"UnitExt"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'UnitExt';
62	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"UnitExtGroup"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'UnitExtGroup';
63	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Variant"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Variant';
64	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Vendor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Vendor';
65	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Ward"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Ward';
66	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Warehouse"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Warehouse';
67	0.12 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"WarehouseType"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'WarehouseType';
68	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Associate"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Associate';
69	0.17 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Category';
70	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Collection"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Collection';
71	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Color"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Color';
72	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"CommonList"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'CommonList';
73	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"LineActivity"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'LineActivity';
74	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Manufacturer"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Manufacturer';
75	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Product';
76	0.17 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ProductTemplate"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ProductTemplate';
77	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ProductVendor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ProductVendor';
78	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"SalesChannel"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'SalesChannel';
79	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Store"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Store';
80	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreLine"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreLine';
81	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreProduct"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreProduct';
82	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StoreProductGroup"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StoreProductGroup';
83	0.20 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Unit"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Unit';
84	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"UnitExt"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'UnitExt';
85	0.17 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"UnitExtGroup"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'UnitExtGroup';
86	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Vendor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Vendor';
87	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Warehouse"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Warehouse';
88	0.80 ms	SELECT object_localized_PR_en.o_id as o_id, `object_localized_PR_en`.`o_type` FROM `object_localized_PR_en` WHERE ((o_id =286305) AND object_localized_PR_en.o_type IN ('object','folder','variant')) LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_PR_en.o_id as o_id, `object_localized_PR_en`.`o_type` FROM `object_localized_PR_en` WHERE ( (o_id = 286305) AND object_localized_PR_en.o_type IN ('object', 'folder', 'variant') ) LIMIT 1 SELECT object_localized_PR_en.o_id as o_id, `object_localized_PR_en`.`o_type` FROM `object_localized_PR_en` WHERE ((o_id =286305) AND object_localized_PR_en.o_type IN ('object','folder','variant')) LIMIT 1;
89	0.28 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ProductVendor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ProductVendor';
90	0.62 ms	SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_PVEN r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.o_id = r.src_id AND r.type='object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_PVEN r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_PVEN r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"productCode" 286305 "productCode" 286305 "productCode" 286305`] View formatted query View runnable query Explain query SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_PVEN r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.o_id = r.src_id AND r.type = 'object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_PVEN r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type = 'asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_PVEN r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_PVEN r WHERE r.fieldname= 'productCode' AND r.ownertype = 'object' AND r.dest_id = 286305 AND o.o_id = r.src_id AND r.type='object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_PVEN r WHERE r.fieldname= 'productCode' AND r.ownertype = 'object' AND r.dest_id = 286305 AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_PVEN r WHERE r.fieldname= 'productCode' AND r.ownertype = 'object' AND r.dest_id = 286305 AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

http://quocnam-pimcore-qa.local:8085/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882 Return to referer URL

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

http://quocnam-pimcore-qa.local:8085/pimcore-graphql-webservices/mdm?apikey=dbaf843f1b5499dac8a1bce159497882 Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping