Symfony Profiler

Query Metrics

95 Database Queries

34 Different statements

44.23 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM tmp_store WHERE id = ?
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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CU WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_CU WHERE src_id = ?
SELECT object_Subscription.id as id, object_Subscription.type as `type` FROM object_Subscription WHERE (member__id = ? AND  object_Subscription.type IN ('object','variant','folder')) AND object_Subscription.published = 1 ORDER BY `oo_id` DESC
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_Subscription WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_Subscription WHERE src_id = ?
SELECT object_pricingPlan.id as id, object_pricingPlan.type as `type` FROM object_pricingPlan WHERE (planId = ? AND  object_pricingPlan.type IN ('object','variant','folder')) AND object_pricingPlan.published = 1
SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = ? AND  object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `oo_id` DESC
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_PaymentOrder WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_PaymentOrder WHERE src_id = ?
SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = ? AND  object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `createdTs` DESC
SELECT id FROM website_settings
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM translations_messages LIMIT 1;
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT object_Products.id as id, object_Products.type as `type` FROM object_Products WHERE ( object_Products.type IN ('object','variant','folder')) AND object_Products.published = 1 ORDER BY `orderId` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,24) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,24) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,24) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,24) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,36) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,36) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,36) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents
            LEFT JOIN documents_email ON documents.id = documents_email.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents
            LEFT JOIN documents_email ON documents.id = documents_email.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents
            LEFT JOIN documents_email ON documents.id = documents_email.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents
            LEFT JOIN documents_email ON documents.id = documents_email.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents
            LEFT JOIN documents_email ON documents.id = documents_email.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

#▲	Time	Info
1	0.83 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
2	0.30 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/membership-account" "path" "auto_create" "/membership-account" "path_query" "https://icantech.centricdxb.com/membership-account" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/membership-account' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/membership-account' AND `type` = 'path_query') OR (source = 'https://icantech.centricdxb.com/membership-account' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
3	0.43 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
4	0.27 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "membership-account"`] 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 'membership-account';
5	0.22 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/membership-account"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/membership-account';
6	0.16 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 '';
7	0.51 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`1038`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 1038;
8	0.30 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`1038`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 1038;
9	0.22 ms	SELECT * FROM object_store_CU WHERE oo_id = ? FOR UPDATE Parameters: [`1038`] View formatted query View runnable query Explain query SELECT * FROM object_store_CU WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_CU WHERE oo_id = 1038 FOR UPDATE;
10	0.24 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CU"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CU';
11	0.32 ms	SELECT * FROM object_relations_CU WHERE src_id = ? Parameters: [`1038`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CU WHERE src_id = ? SELECT * FROM object_relations_CU WHERE src_id = 1038;
12	0.55 ms	SELECT object_Subscription.id as id, object_Subscription.type as `type` FROM object_Subscription WHERE (member__id = ? AND object_Subscription.type IN ('object','variant','folder')) AND object_Subscription.published = 1 ORDER BY `oo_id` DESC Parameters: [`1038`] View formatted query View runnable query Explain query SELECT object_Subscription.id as id, object_Subscription.type as `type` FROM object_Subscription WHERE ( member__id = ? AND object_Subscription.type IN ('object', 'variant', 'folder') ) AND object_Subscription.published = 1 ORDER BY `oo_id` DESC SELECT object_Subscription.id as id, object_Subscription.type as `type` FROM object_Subscription WHERE (member__id = 1038 AND object_Subscription.type IN ('object','variant','folder')) AND object_Subscription.published = 1 ORDER BY `oo_id` DESC ;
13	0.14 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`1039`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 1039;
14	0.19 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`1039`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 1039;
15	0.15 ms	SELECT * FROM object_store_Subscription WHERE oo_id = ? FOR UPDATE Parameters: [`1039`] View formatted query View runnable query Explain query SELECT * FROM object_store_Subscription WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_Subscription WHERE oo_id = 1039 FOR UPDATE;
16	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"Subscription"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'Subscription';
17	0.21 ms	SELECT * FROM object_relations_Subscription WHERE src_id = ? Parameters: [`1039`] View formatted query View runnable query Explain query SELECT * FROM object_relations_Subscription WHERE src_id = ? SELECT * FROM object_relations_Subscription WHERE src_id = 1039;
18	0.73 ms	SELECT object_pricingPlan.id as id, object_pricingPlan.type as `type` FROM object_pricingPlan WHERE (planId = ? AND object_pricingPlan.type IN ('object','variant','folder')) AND object_pricingPlan.published = 1 Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT object_pricingPlan.id as id, object_pricingPlan.type as `type` FROM object_pricingPlan WHERE ( planId = ? AND object_pricingPlan.type IN ('object', 'variant', 'folder') ) AND object_pricingPlan.published = 1 SELECT object_pricingPlan.id as id, object_pricingPlan.type as `type` FROM object_pricingPlan WHERE (planId = '2' AND object_pricingPlan.type IN ('object','variant','folder')) AND object_pricingPlan.published = 1;
19	1.31 ms	SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = ? AND object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `oo_id` DESC Parameters: [`1038`] View formatted query View runnable query Explain query SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE ( member__id = ? AND object_PaymentOrder.type IN ('object', 'variant', 'folder') ) AND object_PaymentOrder.published = 1 ORDER BY `oo_id` DESC SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = 1038 AND object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `oo_id` DESC ;
20	0.14 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`1040`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 1040;
21	0.18 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`1040`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 1040;
22	0.19 ms	SELECT * FROM object_store_PaymentOrder WHERE oo_id = ? FOR UPDATE Parameters: [`1040`] View formatted query View runnable query Explain query SELECT * FROM object_store_PaymentOrder WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_PaymentOrder WHERE oo_id = 1040 FOR UPDATE;
23	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PaymentOrder"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PaymentOrder';
24	0.64 ms	SELECT * FROM object_relations_PaymentOrder WHERE src_id = ? Parameters: [`1040`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PaymentOrder WHERE src_id = ? SELECT * FROM object_relations_PaymentOrder WHERE src_id = 1040;
25	0.55 ms	SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = ? AND object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `createdTs` DESC Parameters: [`1038`] View formatted query View runnable query Explain query SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE ( member__id = ? AND object_PaymentOrder.type IN ('object', 'variant', 'folder') ) AND object_PaymentOrder.published = 1 ORDER BY `createdTs` DESC SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = 1038 AND object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1 ORDER BY `createdTs` DESC ;
26	0.57 ms	SELECT id FROM website_settings Parameters: [] View formatted query View runnable query Explain query SELECT id FROM website_settings SELECT id FROM website_settings;
27	0.41 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
28	0.19 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
29	0.98 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
30	1.03 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 1 AND published = 1 LIMIT 1;
31	0.86 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 1) AND published = 1 ORDER BY `index` ASC ;
32	0.57 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH( CONCAT(`path`, `key`) ) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC ;
33	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`2`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 2 AND published = 1 LIMIT 1;
34	0.21 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 2) AND published = 1 ORDER BY `index` ASC ;
35	0.48 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`4`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 4 AND published = 1 LIMIT 1;
36	0.51 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`6`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 6 AND published = 1 LIMIT 1;
37	6.86 ms	SELECT object_Products.id as id, object_Products.type as `type` FROM object_Products WHERE ( object_Products.type IN ('object','variant','folder')) AND object_Products.published = 1 ORDER BY `orderId` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_Products.id as id, object_Products.type as `type` FROM object_Products WHERE ( object_Products.type IN ('object', 'variant', 'folder') ) AND object_Products.published = 1 ORDER BY `orderId` ASC SELECT object_Products.id as id, object_Products.type as `type` FROM object_Products WHERE ( object_Products.type IN ('object','variant','folder')) AND object_Products.published = 1 ORDER BY `orderId` ASC ;
38	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`24`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 24 AND published = 1 LIMIT 1;
39	0.55 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`24`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 24) AND published = 1 ORDER BY `index` ASC ;
40	0.50 ms	SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`22`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 24) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = 22 ) AND ctype='document';
41	0.24 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`22`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 22 AND published = 1 LIMIT 1;
42	0.24 ms	SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 24) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = 21 ) AND ctype='document';
43	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`21`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 21 AND published = 1 LIMIT 1;
44	0.19 ms	SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 24) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = 23 ) AND ctype='document';
45	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`23`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 23 AND published = 1 LIMIT 1;
46	0.20 ms	SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 24) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,24) AND inheritable = 1) OR cid = 17 ) AND ctype='document';
47	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`17`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 17 AND published = 1 LIMIT 1;
48	0.18 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`36`] 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 = 36 ) AND ctype='document';
49	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`36`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 36 AND published = 1 LIMIT 1;
50	0.16 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`36`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 36) AND published = 1 ORDER BY `index` ASC ;
51	0.15 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 12;
52	3.01 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 12;
53	0.17 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`37`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 37;
54	0.20 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`37`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 37;
55	0.19 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 38;
56	0.18 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 38;
57	0.22 ms	SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 36) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = 12 ) AND ctype='document';
58	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`12`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 12 AND published = 1 LIMIT 1;
59	0.20 ms	SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`37`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 36) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = 37 ) AND ctype='document';
60	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`37`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 37 AND published = 1 LIMIT 1;
61	0.21 ms	SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`38`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 36) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,36) AND inheritable = 1) OR cid = 38 ) AND ctype='document';
62	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`38`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 38 AND published = 1 LIMIT 1;
63	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 11 AND published = 1 LIMIT 1;
64	0.18 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`13`] 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 = 13 ) AND ctype='document';
65	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`13`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 13 AND published = 1 LIMIT 1;
66	0.18 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`16`] 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 = 16 ) AND ctype='document';
67	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`16`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 16 AND published = 1 LIMIT 1;
68	0.25 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`18`] 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 = 18 ) AND ctype='document';
69	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`18`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 18 AND published = 1 LIMIT 1;
70	0.19 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`26`] 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 = 26 ) AND ctype='document';
71	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`26`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 26 AND published = 1 LIMIT 1;
72	0.19 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`27`] 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 = 27 ) AND ctype='document';
73	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`27`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 27 AND published = 1 LIMIT 1;
74	0.16 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`27`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 27) AND published = 1 ORDER BY `index` ASC ;
75	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`28`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 28 AND published = 1 LIMIT 1;
76	0.18 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`29`] 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 = 29 ) AND ctype='document';
77	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`29`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 29 AND published = 1 LIMIT 1;
78	0.17 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`30`] 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 = 30 ) AND ctype='document';
79	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`30`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 30 AND published = 1 LIMIT 1;
80	0.15 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`30`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 30) AND published = 1 ORDER BY `index` ASC ;
81	0.16 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 31;
82	5.62 ms	SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 31;
83	0.35 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 32;
84	0.37 ms	SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 32;
85	0.29 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 33;
86	0.28 ms	SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 33;
87	0.25 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`34`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 34;
88	0.28 ms	SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`34`] View formatted query View runnable query Explain query SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 34;
89	0.24 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 35;
90	0.23 ms	SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_email., tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 35;
91	0.23 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
92	0.38 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=en&_controller=App%5CController%5CContentController%3A%3AfooterAction" "path_query" "https://icantech.centricdxb.com/_fragment?_path=_format=html&_locale=en&_controller=App%5CController%5CContentController%3A%3AfooterAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_format=html&_locale=en&_controller=App%5CController%5CContentController%3A%3AfooterAction' AND `type` = 'path_query') OR (source = 'https://icantech.centricdxb.com/_fragment?_path=_format=html&_locale=en&_controller=App%5CController%5CContentController%3A%3AfooterAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
93	0.77 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 3;
94	0.76 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`263`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 263;
95	0.82 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`263`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 263;

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.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://icantech.centricdxb.com/membership-account

Configuration Settings

Theme

Page Width