Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

57 Database Queries

8 Different statements

12.65 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 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 COUNT(*) AS `totalCount` FROM `object_localized_ST_vi` WHERE (( (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores'
                AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
        ) AND  ( ((`object_localized_ST_vi`.`tenant__id` = '2214') )  AND  ((`object_localized_ST_vi`.`code` = 'UNDEFINED') )  )  AND  object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1)
SELECT object_localized_ST_vi.o_id as o_id, `object_localized_ST_vi`.`o_type` FROM `object_localized_ST_vi` WHERE (( (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores'
                AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
        ) AND  ( ((`object_localized_ST_vi`.`tenant__id` = '2214') )  AND  ((`object_localized_ST_vi`.`code` = 'UNDEFINED') )  )  AND  object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1)

#▲	Time	Info
1	0.79 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/QN-stores" "sourcePathQuery" => "/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b" "sourceEntireUri" => "http://103.160.88.228:8085/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b" "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/QN-stores' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b' AND `type` = 'path_query') OR (source = 'http://103.160.88.228:8085/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b' 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.43 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "QN-stores" "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` = 'QN-stores';
3	0.32 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/pimcore-graphql-webservices/QN-stores"`] 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/QN-stores';
4	0.22 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.23 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.23 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.68 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.27 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AREA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AREA';
9	0.21 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BANK"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BANK';
10	0.21 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BANKACCOUNT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BANKACCOUNT';
11	0.18 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';
12	0.27 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CL"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CL';
13	0.18 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.17 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.17 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.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"FLOOR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'FLOOR';
17	0.14 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';
18	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PAYMENT_METHOD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PAYMENT_METHOD';
19	0.13 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';
20	0.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"RE"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'RE';
21	0.14 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';
22	0.15 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';
23	0.16 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';
24	0.13 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';
25	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"STORE_PAYMENT_METHOD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'STORE_PAYMENT_METHOD';
26	0.18 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';
27	0.18 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';
28	0.18 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';
29	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';
30	0.15 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';
31	0.16 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';
32	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Area"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Area';
33	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Bank"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Bank';
34	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"BankStoreAccount"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'BankStoreAccount';
35	0.19 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';
36	0.22 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Cluster"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Cluster';
37	0.16 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';
38	0.14 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';
39	0.13 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';
40	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Floor"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Floor';
41	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';
42	0.11 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"PaymentMethod"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'PaymentMethod';
43	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';
44	0.20 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Region"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Region';
45	0.18 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';
46	0.14 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';
47	0.13 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';
48	0.13 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';
49	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"StorePaymentMethod"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'StorePaymentMethod';
50	0.14 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';
51	0.13 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';
52	0.11 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';
53	0.11 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';
54	0.11 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';
55	0.11 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';
56	1.49 ms	SELECT COUNT() AS `totalCount` FROM `object_localized_ST_vi` WHERE (( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND ( ((`object_localized_ST_vi`.`tenant__id` = '2214') ) AND ((`object_localized_ST_vi`.`code` = 'UNDEFINED') ) ) AND object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_localized_ST_vi` WHERE ( ( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE( CONCAT( `object_localized_ST_vi`.o_path, `object_localized_ST_vi`.o_key ), `plugin_datahub_workspaces_object`.cpath )= 1 ORDER BY LENGTH( `plugin_datahub_workspaces_object`.cpath ) DESC LIMIT 1 ) = 1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE( `plugin_datahub_workspaces_object`.cpath, CONCAT( `object_localized_ST_vi`.o_path, `object_localized_ST_vi`.o_key ) )= 1 ORDER BY LENGTH( `plugin_datahub_workspaces_object`.cpath ) DESC LIMIT 1 ) = 1 ) AND ( ( ( `object_localized_ST_vi`.`tenant__id` = '2214' ) ) AND ( ( `object_localized_ST_vi`.`code` = 'UNDEFINED' ) ) ) AND object_localized_ST_vi.o_type IN ('object', 'folder', 'variant') ) AND object_localized_ST_vi.o_published = 1 ) SELECT COUNT(*) AS `totalCount` FROM `object_localized_ST_vi` WHERE (( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND ( ((`object_localized_ST_vi`.`tenant__id` = '2214') ) AND ((`object_localized_ST_vi`.`code` = 'UNDEFINED') ) ) AND object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1);
57	0.73 ms	SELECT object_localized_ST_vi.o_id as o_id, `object_localized_ST_vi`.`o_type` FROM `object_localized_ST_vi` WHERE (( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND ( ((`object_localized_ST_vi`.`tenant__id` = '2214') ) AND ((`object_localized_ST_vi`.`code` = 'UNDEFINED') ) ) AND object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_ST_vi.o_id as o_id, `object_localized_ST_vi`.`o_type` FROM `object_localized_ST_vi` WHERE ( ( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE( CONCAT( `object_localized_ST_vi`.o_path, `object_localized_ST_vi`.o_key ), `plugin_datahub_workspaces_object`.cpath )= 1 ORDER BY LENGTH( `plugin_datahub_workspaces_object`.cpath ) DESC LIMIT 1 ) = 1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE( `plugin_datahub_workspaces_object`.cpath, CONCAT( `object_localized_ST_vi`.o_path, `object_localized_ST_vi`.o_key ) )= 1 ORDER BY LENGTH( `plugin_datahub_workspaces_object`.cpath ) DESC LIMIT 1 ) = 1 ) AND ( ( ( `object_localized_ST_vi`.`tenant__id` = '2214' ) ) AND ( ( `object_localized_ST_vi`.`code` = 'UNDEFINED' ) ) ) AND object_localized_ST_vi.o_type IN ('object', 'folder', 'variant') ) AND object_localized_ST_vi.o_published = 1 ) SELECT object_localized_ST_vi.o_id as o_id, `object_localized_ST_vi`.`o_type` FROM `object_localized_ST_vi` WHERE (( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key),`plugin_datahub_workspaces_object`.cpath)=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'QN-stores' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_ST_vi`.o_path,`object_localized_ST_vi`.o_key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND ( ((`object_localized_ST_vi`.`tenant__id` = '2214') ) AND ((`object_localized_ST_vi`.`code` = 'UNDEFINED') ) ) AND object_localized_ST_vi.o_type IN ('object','folder','variant')) AND object_localized_ST_vi.o_published = 1);

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

http://103.160.88.228:8085/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

http://103.160.88.228:8085/pimcore-graphql-webservices/QN-stores?apikey=7bc749caeff0921d46ac6436c2a46d1b

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping