Symfony Profiler

Query Metrics

676 Database Queries

101 Different statements

282.74 ms Query time

0 Invalid entities

Queries


SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
SELECT id,domains FROM sites
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
SELECT id FROM redirects WHERE active = 1 AND regex = 1  ORDER BY `priority` DESC
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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_link.*, tree_locks.locked FROM documents
            LEFT JOIN documents_link ON documents.id = documents_link.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 id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
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_CAR WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63'
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_CAR WHERE oo_id = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
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_CAR WHERE oo_id = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
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_MA WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_relations_MA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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 website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
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_EF_OSTC WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_collection_TaxEntry_EF_OSTC WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? AND `index` = ?
SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? AND `index` = ?
SELECT * FROM object_relations_EF_OSTC WHERE src_id = ?
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
SHOW COLUMNS FROM ecommerceframework_pricing_rule
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
SELECT id FROM objects 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_AP WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_classificationstore_groups_AP WHERE id = 438 AND fieldname = 'technicalAttributes'
SELECT * FROM object_classificationstore_data_AP WHERE id = 438 AND fieldname = 'technicalAttributes'
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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 object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
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_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_classificationstore_groups_AP WHERE id = 428 AND fieldname = 'technicalAttributes'
SELECT * FROM object_classificationstore_data_AP WHERE id = 428 AND fieldname = 'technicalAttributes'
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
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_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_classificationstore_groups_AP WHERE id = 429 AND fieldname = 'technicalAttributes'
SELECT * FROM object_classificationstore_data_AP WHERE id = 429 AND fieldname = 'technicalAttributes'
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
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_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_classificationstore_groups_AP WHERE id = 433 AND fieldname = 'technicalAttributes'
SELECT * FROM object_classificationstore_data_AP WHERE id = 433 AND fieldname = 'technicalAttributes'
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
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_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_classificationstore_groups_AP WHERE id = 435 AND fieldname = 'technicalAttributes'
SELECT * FROM object_classificationstore_data_AP WHERE id = 435 AND fieldname = 'technicalAttributes'
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT * FROM classificationstore_keys WHERE id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 `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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 `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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 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_link.*, tree_locks.locked FROM documents
            LEFT JOIN documents_link ON documents.id = documents_link.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 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.*, 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 = ?
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 = ?
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 = ?
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,3) 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 * FROM properties WHERE
                             (
                                 (cid IN (1,45,3) 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,45,3) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
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_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) 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 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 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,46,3) 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,46,3) 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,46,3) 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,46,3) 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,46,3) 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,46,3) 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,46,3) 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,3) 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,3) 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,3) 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_link.*, tree_locks.locked FROM documents
            LEFT JOIN documents_link ON documents.id = documents_link.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 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,47,3) 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,53,47,3) 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,53,47,3) 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,53,47,3) 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,53,47,3) 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,47,3) 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 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 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 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_link.*, tree_locks.locked FROM documents
            LEFT JOIN documents_link ON documents.id = documents_link.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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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.*, 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 = ?
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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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_hardlink.*, tree_locks.locked FROM documents
            LEFT JOIN documents_hardlink ON documents.id = documents_hardlink.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,121,58,47,3) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT * FROM properties WHERE 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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,58,47,3) 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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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,58,47,3) 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,47,3) 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 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,94,47,3) 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,94,47,3) 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,94,47,3) 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,94,47,3) 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,94,47,3) 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,47,3) 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,3) 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.*, 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 = ?
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 = ?
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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,10,3) 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 * FROM properties WHERE
                             (
                                 (cid IN (1,11,10,3) 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,10,3) 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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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,3) 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 * FROM properties WHERE
                             (
                                 (cid IN (1,3) 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_newsletter.*, tree_locks.locked FROM documents
            LEFT JOIN documents_newsletter ON documents.id = documents_newsletter.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,3) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages WHERE language = ?
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
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 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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 id FROM documents d WHERE parentId = ?  AND published = 1 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 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 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 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 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 settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
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_BS WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_BS WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_BS WHERE src_id = ?
SELECT * FROM quantityvalue_units ORDER BY `baseunit` ASC, `factor` ASC, `abbreviation` ASC
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin WHERE language = ?
SELECT COUNT(*) FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
SELECT COUNT(*) FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '428'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '429'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '433'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '435'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 = ?

#▲	Time	Info
1	0.89 ms	SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ? Parameters: [`"pimcoredemo.edelsau.uber.space" "%"pimcoredemo.edelsau.uber.space"%"`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ? SELECT * FROM sites WHERE mainDomain = 'pimcoredemo.edelsau.uber.space' OR domains LIKE '%\"pimcoredemo.edelsau.uber.space\"%';
2	0.58 ms	SELECT id,domains FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id, domains FROM sites SELECT id,domains FROM sites;
3	0.44 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
4	0.40 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';
5	0.92 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: [`"/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63" "path" "auto_create" "/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63" "path_query" "https://pimcoredemo.edelsau.uber.space/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63" "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 = '/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63' AND `type` = 'path_query') OR (source = 'https://pimcoredemo.edelsau.uber.space/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63' 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;
6	5.86 ms	INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300) Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0="`] View formatted query View runnable query Explain query INSERT INTO lock_keys ( key_id, key_token, key_expiration ) VALUES ( ?, ?, UNIX_TIMESTAMP() + 300 ) INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071', 'M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=', UNIX_TIMESTAMP() + 300);
7	4.17 ms	UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP()) Parameters: [`300.0 "M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=" "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0="`] View formatted query View runnable query Explain query UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND ( key_token = ? OR key_expiration <= UNIX_TIMESTAMP() ) UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=' WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND (key_token = 'M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=' OR key_expiration <= UNIX_TIMESTAMP());
8	0.81 ms	SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC;
9	3.59 ms	DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0="`] View formatted query View runnable query Explain query DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? DELETE FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=';
10	0.47 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() SELECT 1 FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'M881LV6IoXRFOFj5XopsVtfy+WJgt/xK+O/eYA0shO0=' AND key_expiration > UNIX_TIMESTAMP();
11	0.33 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';
12	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
13	0.41 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/shop/Products/Cars/Luxury-Cars/" "Chevrolet-Bel-Air~p63"`] 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 '/en/shop/Products/Cars/Luxury-Cars/' AND `key` = BINARY 'Chevrolet-Bel-Air~p63';
14	0.38 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars/Luxury-Cars/Chevrolet-Bel-Air~p63';
15	0.28 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/shop/Products/Cars/" "Luxury-Cars"`] 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 '/en/shop/Products/Cars/' AND `key` = BINARY 'Luxury-Cars';
16	0.30 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/shop/Products/Cars/Luxury-Cars"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars/Luxury-Cars';
17	0.29 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/shop/Products/" "Cars"`] 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 '/en/shop/Products/' AND `key` = BINARY 'Cars';
18	0.28 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/shop/Products/Cars"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars';
19	0.28 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/shop/" "Products"`] 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 '/en/shop/' AND `key` = BINARY 'Products';
20	0.31 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/shop/Products"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products';
21	0.25 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "shop"`] 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 '/en/' AND `key` = BINARY 'shop';
22	0.29 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/shop';
23	0.28 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "en"`] 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 'en';
24	0.48 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: [`3`] 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 = 3;
25	0.54 ms	SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 3;
26	0.55 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: [`1`] 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 = 1;
27	0.46 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: [`1`] 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 = 1;
28	0.42 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) 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(`path`) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;
29	0.51 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`3`] 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 = 3 ) AND ctype='document';
30	0.60 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`63`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 63;
31	0.77 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: [`63`] 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 = 63;
32	0.42 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`63`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 63;
33	0.35 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CAR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CAR';
34	0.43 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
35	0.68 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`63`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 63 AND language IN ('en','de','fr');
36	0.58 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`49`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 49;
37	0.47 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`49`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 49;
38	0.49 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`49`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 49;
39	0.93 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`49`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 49;
40	0.65 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 51;
41	0.43 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 51;
42	0.43 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 51;
43	0.35 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 51;
44	0.54 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? Parameters: [`63 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = 63 AND fieldname = 'attributes';
45	0.33 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? Parameters: [`63 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE id = 63 AND fieldname = 'attributes';
46	0.38 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? Parameters: [`63 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = 63 AND fieldname = 'attributes';
47	0.41 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? Parameters: [`63 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE id = 63 AND fieldname = 'attributes';
48	0.31 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? Parameters: [`63 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = 63 AND fieldname = 'saleInformation';
49	0.33 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`63`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 63;
50	0.44 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63';
51	0.33 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`62`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 62;
52	0.44 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: [`62`] 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 = 62;
53	0.28 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`62`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 62;
54	0.41 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`62`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 62 AND language IN ('en','de','fr');
55	0.29 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? Parameters: [`62 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = 62 AND fieldname = 'attributes';
56	0.38 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? Parameters: [`62 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE id = 62 AND fieldname = 'attributes';
57	0.36 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? Parameters: [`62 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = 62 AND fieldname = 'attributes';
58	0.35 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? Parameters: [`62 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE id = 62 AND fieldname = 'attributes';
59	0.39 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? Parameters: [`62 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = 62 AND fieldname = 'saleInformation';
60	0.38 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`62`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 62;
61	0.39 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`61`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 61;
62	0.47 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: [`61`] 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 = 61;
63	0.32 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`61`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 61;
64	0.49 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`61`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 61 AND language IN ('en','de','fr');
65	0.41 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 46;
66	0.29 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 46;
67	0.39 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 46;
68	0.27 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 46;
69	0.38 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`47`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 47;
70	0.31 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`47`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 47;
71	0.36 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`47`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 47;
72	0.38 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`47`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 47;
73	0.36 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 48;
74	0.37 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 48;
75	0.40 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 48;
76	0.35 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 48;
77	0.43 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? Parameters: [`61 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = 61 AND fieldname = 'attributes';
78	0.32 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? Parameters: [`61 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE id = 61 AND fieldname = 'attributes';
79	0.31 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? Parameters: [`61 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = 61 AND fieldname = 'attributes';
80	0.42 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? Parameters: [`61 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE id = 61 AND fieldname = 'attributes';
81	0.39 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? Parameters: [`61 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = 61 AND fieldname = 'saleInformation';
82	0.42 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`61`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 61;
83	0.34 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 59;
84	0.39 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: [`59`] 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 = 59;
85	0.28 ms	SELECT * FROM object_store_MA WHERE oo_id = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT * FROM object_store_MA WHERE oo_id = ? SELECT * FROM object_store_MA WHERE oo_id = 59;
86	0.32 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';
87	0.44 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`296`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 296;
88	0.43 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`296`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 296;
89	0.30 ms	SELECT * FROM object_relations_MA WHERE src_id = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT * FROM object_relations_MA WHERE src_id = ? SELECT * FROM object_relations_MA WHERE src_id = 59;
90	0.32 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`552`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 552;
91	0.42 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: [`552`] 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 = 552;
92	0.29 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`552`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 552;
93	0.28 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';
94	0.53 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`552`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 552 AND language IN ('en','de','fr');
95	0.31 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`552`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 552;
96	0.35 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`546`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 546;
97	0.39 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: [`546`] 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 = 546;
98	0.24 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`546`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 546;
99	0.37 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`546`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 546 AND language IN ('en','de','fr');
100	0.30 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`546`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 546;
101	0.30 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 390;
102	0.35 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: [`390`] 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 = 390;
103	0.25 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 390;
104	0.34 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 390 AND language IN ('en','de','fr');
105	0.32 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 390;
106	0.28 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 564;
107	0.34 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: [`564`] 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 = 564;
108	0.24 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 564;
109	0.32 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 564 AND language IN ('en','de','fr');
110	0.30 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 564;
111	0.33 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`389`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 389;
112	0.33 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: [`389`] 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 = 389;
113	1.22 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultTaxClass" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultTaxClass' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
114	0.39 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;
115	0.33 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`693`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 693;
116	0.37 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: [`693`] 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 = 693;
117	0.29 ms	SELECT * FROM object_store_EF_OSTC WHERE oo_id = ? Parameters: [`693`] View formatted query View runnable query Explain query SELECT * FROM object_store_EF_OSTC WHERE oo_id = ? SELECT * FROM object_store_EF_OSTC WHERE oo_id = 693;
118	0.32 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSTC"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSTC';
119	0.46 ms	SELECT * FROM object_collection_TaxEntry_EF_OSTC WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`693 "taxEntries"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_TaxEntry_EF_OSTC WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_TaxEntry_EF_OSTC WHERE id = 693 AND fieldname = 'taxEntries' ORDER BY `index` ASC;
120	0.65 ms	SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? AND `index` = ? Parameters: [`693 "taxEntries" 0`] View formatted query View runnable query Explain query SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = 693 AND language IN ('en','de','fr') AND `fieldname` = 'taxEntries' AND `index` = 0;
121	0.47 ms	SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? AND `index` = ? Parameters: [`693 "taxEntries" 1`] View formatted query View runnable query Explain query SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_TaxEntry_localized_EF_OSTC WHERE ooo_id = 693 AND language IN ('en','de','fr') AND `fieldname` = 'taxEntries' AND `index` = 1;
122	0.38 ms	SELECT * FROM object_relations_EF_OSTC WHERE src_id = ? Parameters: [`693`] View formatted query View runnable query Explain query SELECT * FROM object_relations_EF_OSTC WHERE src_id = ? SELECT * FROM object_relations_EF_OSTC WHERE src_id = 693;
123	0.40 ms	SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC;
124	2.30 ms	SHOW COLUMNS FROM ecommerceframework_pricing_rule Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM ecommerceframework_pricing_rule SHOW COLUMNS FROM ecommerceframework_pricing_rule;
125	0.34 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='9' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '9' SELECT * FROM ecommerceframework_pricing_rule WHERE id='9';
126	0.29 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 559;
127	0.94 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: [`559`] 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 = 559;
128	0.36 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 559;
129	0.45 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 559 AND language IN ('en','de','fr');
130	0.34 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 559;
131	0.35 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='10' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '10' SELECT * FROM ecommerceframework_pricing_rule WHERE id='10';
132	0.36 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`556`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 556;
133	0.35 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: [`556`] 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 = 556;
134	0.32 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`556`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 556;
135	0.44 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`556`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 556 AND language IN ('en','de','fr');
136	0.39 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`556`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 556;
137	0.33 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='8' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '8' SELECT * FROM ecommerceframework_pricing_rule WHERE id='8';
138	0.34 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Product Data/Accessories/lights/head lights/" "citroen-2cv-head lights"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Product Data/Accessories/lights/head lights/' AND `key` = BINARY 'citroen-2cv-head lights';
139	0.29 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`438`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 438;
140	0.37 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: [`438`] 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 = 438;
141	0.28 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`438`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 438;
142	0.29 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AP"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AP';
143	0.45 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`438`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 438 AND language IN ('en','de','fr');
144	0.40 ms	SELECT * FROM object_classificationstore_groups_AP WHERE id = 438 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_AP WHERE id = 438 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_groups_AP WHERE id = 438 AND fieldname = 'technicalAttributes';
145	0.40 ms	SELECT * FROM object_classificationstore_data_AP WHERE id = 438 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_AP WHERE id = 438 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_data_AP WHERE id = 438 AND fieldname = 'technicalAttributes';
146	0.45 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 1;
147	0.31 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 2;
148	0.39 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 3;
149	0.31 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 4;
150	0.55 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 7;
151	0.73 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 60;
152	0.31 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 60;
153	0.36 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 60;
154	0.32 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 60;
155	0.34 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? Parameters: [`438 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = 438 AND fieldname = 'saleInformation';
156	0.36 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`438`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 438;
157	0.30 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='6' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '6' SELECT * FROM ecommerceframework_pricing_rule WHERE id='6';
158	0.29 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='7' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '7' SELECT * FROM ecommerceframework_pricing_rule WHERE id='7';
159	0.37 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`399`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 399;
160	0.42 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: [`399`] 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 = 399;
161	0.23 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`399`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 399;
162	0.43 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`399`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 399 AND language IN ('en','de','fr');
163	0.27 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`399`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 399;
164	0.26 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 873;
165	0.34 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: [`873`] 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 = 873;
166	0.22 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 873;
167	0.32 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`873`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 873 AND language IN ('en','de','fr');
168	0.27 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 873;
169	0.23 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 60;
170	0.42 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: [`60`] 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 = 60;
171	1.29 ms	SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE ( compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND object_localized_AP_en.type IN ('object', 'variant', 'folder') ) AND object_localized_AP_en.published = 1 SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,63,%" OR compatibleTo LIKE "%,62,%" OR compatibleTo LIKE "%,61,%" AND object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1;
172	0.28 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`428`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 428;
173	0.45 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: [`428`] 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 = 428;
174	0.27 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`428`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 428;
175	0.49 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`428`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 428 AND language IN ('en','de','fr');
176	0.45 ms	SELECT * FROM object_classificationstore_groups_AP WHERE id = 428 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_AP WHERE id = 428 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_groups_AP WHERE id = 428 AND fieldname = 'technicalAttributes';
177	0.35 ms	SELECT * FROM object_classificationstore_data_AP WHERE id = 428 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_AP WHERE id = 428 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_data_AP WHERE id = 428 AND fieldname = 'technicalAttributes';
178	0.50 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? Parameters: [`428 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = 428 AND fieldname = 'saleInformation';
179	0.44 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`428`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 428;
180	0.41 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`429`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 429;
181	0.52 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: [`429`] 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 = 429;
182	0.34 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`429`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 429;
183	0.74 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`429`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 429 AND language IN ('en','de','fr');
184	0.84 ms	SELECT * FROM object_classificationstore_groups_AP WHERE id = 429 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_AP WHERE id = 429 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_groups_AP WHERE id = 429 AND fieldname = 'technicalAttributes';
185	0.61 ms	SELECT * FROM object_classificationstore_data_AP WHERE id = 429 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_AP WHERE id = 429 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_data_AP WHERE id = 429 AND fieldname = 'technicalAttributes';
186	0.44 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? Parameters: [`429 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = 429 AND fieldname = 'saleInformation';
187	0.61 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`429`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 429;
188	0.49 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`433`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 433;
189	0.53 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: [`433`] 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 = 433;
190	0.42 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`433`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 433;
191	0.52 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`433`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 433 AND language IN ('en','de','fr');
192	0.61 ms	SELECT * FROM object_classificationstore_groups_AP WHERE id = 433 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_AP WHERE id = 433 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_groups_AP WHERE id = 433 AND fieldname = 'technicalAttributes';
193	0.57 ms	SELECT * FROM object_classificationstore_data_AP WHERE id = 433 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_AP WHERE id = 433 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_data_AP WHERE id = 433 AND fieldname = 'technicalAttributes';
194	0.49 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 54;
195	0.35 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 54;
196	0.43 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 54;
197	0.36 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 54;
198	0.44 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? Parameters: [`433 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = 433 AND fieldname = 'saleInformation';
199	0.37 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`433`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 433;
200	0.28 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`435`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 435;
201	0.38 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: [`435`] 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 = 435;
202	0.28 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`435`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 435;
203	0.38 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`435`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 435 AND language IN ('en','de','fr');
204	0.42 ms	SELECT * FROM object_classificationstore_groups_AP WHERE id = 435 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_AP WHERE id = 435 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_groups_AP WHERE id = 435 AND fieldname = 'technicalAttributes';
205	0.35 ms	SELECT * FROM object_classificationstore_data_AP WHERE id = 435 AND fieldname = 'technicalAttributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_AP WHERE id = 435 AND fieldname = 'technicalAttributes' SELECT * FROM object_classificationstore_data_AP WHERE id = 435 AND fieldname = 'technicalAttributes';
206	0.33 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 5;
207	0.32 ms	SELECT * FROM classificationstore_keys WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE id = ? SELECT * FROM classificationstore_keys WHERE id = 6;
208	0.40 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 53;
209	0.37 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 53;
210	0.34 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 53;
211	0.29 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 53;
212	0.30 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? Parameters: [`435 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = 435 AND fieldname = 'saleInformation';
213	0.31 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`435`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 435;
214	0.32 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`394`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 394;
215	0.37 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: [`394`] 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 = 394;
216	0.26 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`394`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 394;
217	0.48 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`394`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 394 AND language IN ('en','de','fr');
218	0.31 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`394`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 394;
219	0.28 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
220	0.42 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
221	0.45 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`364`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 364;
222	0.43 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: [`364`] 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 = 364;
223	0.31 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`396`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 396;
224	0.38 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: [`396`] 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 = 396;
225	0.27 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`396`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 396;
226	0.91 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`396`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 396 AND language IN ('en','de','fr');
227	0.43 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`396`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 396;
228	0.35 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
229	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
230	0.46 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`366`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 366;
231	0.56 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: [`366`] 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 = 366;
232	0.29 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
233	0.24 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
234	0.25 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`365`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 365;
235	0.32 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: [`365`] 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 = 365;
236	0.25 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`397`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 397;
237	0.33 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: [`397`] 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 = 397;
238	0.22 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`397`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 397;
239	0.32 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`397`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 397 AND language IN ('en','de','fr');
240	0.30 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`397`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 397;
241	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
242	0.32 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
243	0.24 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`362`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 362;
244	0.29 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: [`362`] 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 = 362;
245	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = 1 ) AND ctype='document';
246	0.53 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`3`] 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 = 3 AND published = 1 LIMIT 1;
247	0.48 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`3`] 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 = 3) AND published = 1 ORDER BY `index` ASC ;
248	0.34 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: [`45`] 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 = 45;
249	0.44 ms	SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 45;
250	0.34 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: [`46`] 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 = 46;
251	0.41 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: [`46`] 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 = 46;
252	0.38 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: [`65`] 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 = 65;
253	0.36 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: [`65`] 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 = 65;
254	0.30 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: [`200`] 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 = 200;
255	0.39 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: [`200`] 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 = 200;
256	0.32 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: [`47`] 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 = 47;
257	0.35 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: [`47`] 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 = 47;
258	0.33 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: [`10`] 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 = 10;
259	0.31 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: [`10`] 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 = 10;
260	0.32 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: [`59`] 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 = 59;
261	0.41 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: [`59`] 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 = 59;
262	0.33 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: [`108`] 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 = 108;
263	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: [`108`] 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 = 108;
264	0.36 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: [`198`] 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 = 198;
265	0.47 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: [`198`] 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 = 198;
266	0.45 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`45`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 45 ) AND ctype='document';
267	0.42 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`45`] 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 = 45 AND published = 1 LIMIT 1;
268	0.42 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`45`] 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 = 45) AND published = 1 ORDER BY `index` ASC ;
269	0.39 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: [`74`] 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 = 74;
270	0.41 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: [`74`] 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 = 74;
271	0.40 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: [`97`] 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 = 97;
272	0.35 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: [`97`] 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 = 97;
273	0.54 ms	SELECT * FROM properties WHERE ( (cid IN (1,45,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`74`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 45, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,45,3) AND inheritable = 1) OR cid = 74 ) AND ctype='document';
274	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`74`] 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 = 74 AND published = 1 LIMIT 1;
275	0.45 ms	SELECT * FROM properties WHERE ( (cid IN (1,45,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`97`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 45, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,45,3) AND inheritable = 1) OR cid = 97 ) AND ctype='document';
276	0.37 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`97`] 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 = 97 AND published = 1 LIMIT 1;
277	0.47 ms	SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC Parameters: [`564`] View formatted query View runnable query Explain query SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( parentId = ? AND objects.type IN ('object', 'variant', 'folder') ) AND objects.published = 1 ORDER BY `key` ASC SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 564 AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC ;
278	0.32 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`392`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 392;
279	0.32 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: [`392`] 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 = 392;
280	0.67 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`392`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 392;
281	0.44 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`392`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 392 AND language IN ('en','de','fr');
282	0.30 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`392`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 392;
283	0.56 ms	SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC Parameters: [`390`] View formatted query View runnable query Explain query SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( parentId = ? AND objects.type IN ('object', 'variant', 'folder') ) AND objects.published = 1 ORDER BY `key` ASC SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 390 AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC ;
284	0.37 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`547`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 547;
285	0.43 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: [`547`] 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 = 547;
286	0.26 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`547`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 547;
287	0.49 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`547`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 547 AND language IN ('en','de','fr');
288	0.33 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`547`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 547;
289	0.39 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 545;
290	0.45 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: [`545`] 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 = 545;
291	0.29 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 545;
292	0.43 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 545 AND language IN ('en','de','fr');
293	0.33 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 545;
294	1.09 ms	SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC Parameters: [`392`] View formatted query View runnable query Explain query SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( parentId = ? AND objects.type IN ('object', 'variant', 'folder') ) AND objects.published = 1 ORDER BY `key` ASC SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 392 AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC ;
295	0.28 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`409`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 409;
296	0.38 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: [`409`] 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 = 409;
297	0.31 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`409`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 409;
298	0.37 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`409`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 409 AND language IN ('en','de','fr');
299	0.29 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`409`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 409;
300	0.26 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`393`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 393;
301	0.42 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: [`393`] 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 = 393;
302	0.27 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`393`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 393;
303	0.38 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`393`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 393 AND language IN ('en','de','fr');
304	0.36 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`393`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 393;
305	0.26 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`407`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 407;
306	0.33 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: [`407`] 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 = 407;
307	0.22 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`407`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 407;
308	0.38 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`407`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 407 AND language IN ('en','de','fr');
309	0.32 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`407`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 407;
310	0.54 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`46`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 46 ) AND ctype='document';
311	0.39 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`46`] 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 = 46 AND published = 1 LIMIT 1;
312	0.37 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`46`] 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 = 46) AND published = 1 ORDER BY `index` ASC ;
313	0.36 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: [`99`] 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 = 99;
314	0.42 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: [`99`] 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 = 99;
315	0.38 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: [`100`] 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 = 100;
316	0.47 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: [`100`] 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 = 100;
317	0.41 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: [`101`] 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 = 101;
318	0.53 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: [`101`] 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 = 101;
319	0.30 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: [`102`] 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 = 102;
320	0.43 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: [`102`] 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 = 102;
321	0.37 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: [`103`] 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 = 103;
322	0.39 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: [`103`] 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 = 103;
323	0.37 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: [`104`] 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 = 104;
324	0.38 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: [`104`] 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 = 104;
325	0.34 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: [`123`] 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 = 123;
326	0.40 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: [`123`] 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 = 123;
327	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`99`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 99 ) AND ctype='document';
328	0.32 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`99`] 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 = 99 AND published = 1 LIMIT 1;
329	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`100`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 100 ) AND ctype='document';
330	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`100`] 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 = 100 AND published = 1 LIMIT 1;
331	0.45 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`101`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 101 ) AND ctype='document';
332	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`101`] 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 = 101 AND published = 1 LIMIT 1;
333	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`102`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 102 ) AND ctype='document';
334	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`102`] 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 = 102 AND published = 1 LIMIT 1;
335	0.47 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`103`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 103 ) AND ctype='document';
336	0.36 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`103`] 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 = 103 AND published = 1 LIMIT 1;
337	0.50 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`104`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 104 ) AND ctype='document';
338	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`104`] 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 = 104 AND published = 1 LIMIT 1;
339	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`123`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 46, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,46,3) AND inheritable = 1) OR cid = 123 ) AND ctype='document';
340	0.31 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`123`] 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 = 123 AND published = 1 LIMIT 1;
341	0.48 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`65`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 65 ) AND ctype='document';
342	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`65`] 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 = 65 AND published = 1 LIMIT 1;
343	0.50 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`200`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 200 ) AND ctype='document';
344	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`200`] 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 = 200 AND published = 1 LIMIT 1;
345	0.44 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`47`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 47 ) AND ctype='document';
346	0.39 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`47`] 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 = 47 AND published = 1 LIMIT 1;
347	0.37 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`47`] 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 = 47) AND published = 1 ORDER BY `index` ASC ;
348	0.38 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: [`53`] 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 = 53;
349	0.34 ms	SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 53;
350	0.31 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: [`54`] 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 = 54;
351	0.32 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: [`54`] 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 = 54;
352	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: [`58`] 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 = 58;
353	0.35 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: [`58`] 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 = 58;
354	0.30 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: [`94`] 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 = 94;
355	0.39 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: [`94`] 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 = 94;
356	0.32 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: [`88`] 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 = 88;
357	0.38 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: [`88`] 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 = 88;
358	0.63 ms	SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`53`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = 53 ) AND ctype='document';
359	0.47 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`53`] 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 = 53 AND published = 1 LIMIT 1;
360	0.44 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`53`] 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 = 53) AND published = 1 ORDER BY `index` ASC ;
361	0.31 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: [`55`] 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 = 55;
362	0.38 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: [`55`] 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 = 55;
363	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: [`56`] 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 = 56;
364	0.44 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: [`56`] 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 = 56;
365	0.37 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: [`57`] 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 = 57;
366	0.45 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: [`57`] 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 = 57;
367	0.70 ms	SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`54`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 53, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = 54 ) AND ctype='document';
368	0.36 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`54`] 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 = 54 AND published = 1 LIMIT 1;
369	0.54 ms	SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`55`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 53, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = 55 ) AND ctype='document';
370	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`55`] 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 = 55 AND published = 1 LIMIT 1;
371	0.67 ms	SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`56`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 53, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = 56 ) AND ctype='document';
372	0.41 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`56`] 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 = 56 AND published = 1 LIMIT 1;
373	0.67 ms	SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`57`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 53, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,53,47,3) AND inheritable = 1) OR cid = 57 ) AND ctype='document';
374	0.33 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`57`] 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 = 57 AND published = 1 LIMIT 1;
375	0.64 ms	SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`58`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = 58 ) AND ctype='document';
376	0.45 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`58`] 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 = 58 AND published = 1 LIMIT 1;
377	0.39 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`58`] 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 = 58) AND published = 1 ORDER BY `index` ASC ;
378	0.40 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: [`48`] 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 = 48;
379	0.42 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: [`48`] 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 = 48;
380	0.34 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: [`52`] 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 = 52;
381	0.43 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: [`52`] 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 = 52;
382	0.39 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: [`112`] 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 = 112;
383	0.39 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: [`112`] 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 = 112;
384	0.33 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: [`49`] 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 = 49;
385	0.37 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: [`49`] 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 = 49;
386	0.34 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: [`113`] 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 = 113;
387	0.36 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: [`113`] 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 = 113;
388	0.36 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: [`39`] 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 = 39;
389	0.37 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: [`39`] 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 = 39;
390	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: [`121`] 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 = 121;
391	0.33 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: [`121`] 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 = 121;
392	0.38 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: [`50`] 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 = 50;
393	0.35 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: [`50`] 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 = 50;
394	0.34 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;
395	0.36 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;
396	0.39 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: [`51`] 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 = 51;
397	0.33 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: [`51`] 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 = 51;
398	0.32 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: [`118`] 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 = 118;
399	0.33 ms	SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`118`] View formatted query View runnable query Explain query SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_link., tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 118;
400	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: [`114`] 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 = 114;
401	0.33 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`114`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 114;
402	0.28 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: [`115`] 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 = 115;
403	0.26 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: [`115`] 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 = 115;
404	0.46 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: [`199`] 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 = 199;
405	0.42 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: [`199`] 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 = 199;
406	0.56 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`48`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 48 ) AND ctype='document';
407	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`48`] 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 = 48 AND published = 1 LIMIT 1;
408	0.56 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`52`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 52 ) AND ctype='document';
409	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`52`] 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 = 52 AND published = 1 LIMIT 1;
410	0.53 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`112`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 112 ) AND ctype='document';
411	0.28 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`112`] 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 = 112 AND published = 1 LIMIT 1;
412	0.45 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`49`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 49 ) AND ctype='document';
413	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`49`] 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 = 49 AND published = 1 LIMIT 1;
414	0.45 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`113`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 113 ) AND ctype='document';
415	0.27 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`113`] 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 = 113 AND published = 1 LIMIT 1;
416	0.52 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`39`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 39 ) AND ctype='document';
417	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`39`] 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 = 39 AND published = 1 LIMIT 1;
418	0.62 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`121`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 121 ) AND ctype='document';
419	0.31 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`121`] 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 = 121 AND published = 1 LIMIT 1;
420	0.39 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`121`] 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 = 121) AND published = 1 ORDER BY `index` ASC ;
421	0.45 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: [`122`] 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 = 122;
422	0.46 ms	SELECT documents., documents_hardlink., tree_locks.locked FROM documents LEFT JOIN documents_hardlink ON documents.id = documents_hardlink.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`122`] View formatted query View runnable query Explain query SELECT documents., documents_hardlink., tree_locks.locked FROM documents LEFT JOIN documents_hardlink ON documents.id = documents_hardlink.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_hardlink., tree_locks.locked FROM documents LEFT JOIN documents_hardlink ON documents.id = documents_hardlink.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 122;
423	0.52 ms	SELECT * FROM properties WHERE ( (cid IN (1,121,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`122`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 121, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,121,58,47,3) AND inheritable = 1) OR cid = 122 ) AND ctype='document';
424	0.33 ms	SELECT * FROM properties WHERE cid = ? AND ctype='document' Parameters: [`46`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE cid = ? AND ctype = 'document' SELECT * FROM properties WHERE cid = 46 AND ctype='document';
425	0.43 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`46`] 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 = 46 AND published = 1 LIMIT 1;
426	0.34 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`46`] 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 = 46) AND published = 1 ORDER BY `index` ASC ;
427	0.37 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`99`] 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 = 99 AND published = 1 LIMIT 1;
428	0.36 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`100`] 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 = 100 AND published = 1 LIMIT 1;
429	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`101`] 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 = 101 AND published = 1 LIMIT 1;
430	0.29 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`102`] 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 = 102 AND published = 1 LIMIT 1;
431	0.27 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`103`] 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 = 103 AND published = 1 LIMIT 1;
432	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`104`] 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 = 104 AND published = 1 LIMIT 1;
433	0.25 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`123`] 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 = 123 AND published = 1 LIMIT 1;
434	0.53 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`50`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 50 ) AND ctype='document';
435	0.40 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`50`] 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 = 50 AND published = 1 LIMIT 1;
436	0.58 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) 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, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 38 ) AND ctype='document';
437	0.28 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;
438	0.53 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 51 ) AND ctype='document';
439	0.28 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`51`] 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 = 51 AND published = 1 LIMIT 1;
440	0.54 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`118`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 118 ) AND ctype='document';
441	0.31 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`118`] 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 = 118 AND published = 1 LIMIT 1;
442	0.48 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`115`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 115 ) AND ctype='document';
443	0.43 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`115`] 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 = 115 AND published = 1 LIMIT 1;
444	0.33 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`115`] 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 = 115) AND published = 1 ORDER BY `index` ASC ;
445	0.33 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: [`116`] 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 = 116;
446	0.41 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`116`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 116;
447	0.34 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: [`117`] 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 = 117;
448	0.33 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`117`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 117;
449	0.73 ms	SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 58, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,58,47,3) AND inheritable = 1) OR cid = 199 ) AND ctype='document';
450	0.34 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`199`] 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 = 199 AND published = 1 LIMIT 1;
451	0.69 ms	SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`94`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = 94 ) AND ctype='document';
452	0.51 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`94`] 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 = 94 AND published = 1 LIMIT 1;
453	0.34 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`94`] 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 = 94) AND published = 1 ORDER BY `index` ASC ;
454	0.31 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: [`95`] 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 = 95;
455	0.37 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: [`95`] 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 = 95;
456	0.30 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: [`110`] 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 = 110;
457	0.38 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: [`110`] 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 = 110;
458	0.33 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: [`193`] 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 = 193;
459	0.36 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: [`193`] 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 = 193;
460	0.38 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: [`194`] 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 = 194;
461	0.38 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: [`194`] 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 = 194;
462	0.38 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: [`195`] 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 = 195;
463	0.46 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: [`195`] 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 = 195;
464	0.60 ms	SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`95`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 94, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = 95 ) AND ctype='document';
465	0.44 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`95`] 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 = 95 AND published = 1 LIMIT 1;
466	0.71 ms	SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`110`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 94, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = 110 ) AND ctype='document';
467	0.38 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`110`] 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 = 110 AND published = 1 LIMIT 1;
468	0.69 ms	SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`193`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 94, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = 193 ) AND ctype='document';
469	0.38 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`193`] 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 = 193 AND published = 1 LIMIT 1;
470	0.79 ms	SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`194`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 94, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = 194 ) AND ctype='document';
471	0.38 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`194`] 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 = 194 AND published = 1 LIMIT 1;
472	0.64 ms	SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`195`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 94, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,94,47,3) AND inheritable = 1) OR cid = 195 ) AND ctype='document';
473	0.35 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`195`] 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 = 195 AND published = 1 LIMIT 1;
474	0.48 ms	SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`88`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 47, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,47,3) AND inheritable = 1) OR cid = 88 ) AND ctype='document';
475	0.45 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`88`] 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 = 88 AND published = 1 LIMIT 1;
476	0.40 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 10 ) AND ctype='document';
477	0.40 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`10`] 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 = 10 AND published = 1 LIMIT 1;
478	0.36 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`10`] 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 = 10) AND published = 1 ORDER BY `index` ASC ;
479	0.42 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: [`11`] 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 = 11;
480	0.32 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: [`11`] 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 = 11;
481	0.34 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: [`30`] 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 = 30;
482	0.32 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: [`30`] 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 = 30;
483	0.31 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: [`36`] 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 = 36;
484	0.35 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 36;
485	0.41 ms	SELECT * FROM properties WHERE ( (cid IN (1,10,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 10, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,10,3) AND inheritable = 1) OR cid = 11 ) AND ctype='document';
486	0.30 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;
487	0.33 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`11`] 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 = 11) AND published = 1 ORDER BY `index` ASC ;
488	0.37 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;
489	0.44 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;
490	0.43 ms	SELECT * FROM properties WHERE ( (cid IN (1,11,10,3) 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, 11, 10, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,11,10,3) AND inheritable = 1) OR cid = 12 ) AND ctype='document';
491	0.32 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;
492	0.41 ms	SELECT * FROM properties WHERE ( (cid IN (1,10,3) 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, 10, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,10,3) AND inheritable = 1) OR cid = 30 ) AND ctype='document';
493	0.46 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;
494	0.32 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 ;
495	0.30 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;
496	0.37 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 33;
497	0.36 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;
498	0.38 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.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_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 35;
499	0.45 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: [`106`] 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 = 106;
500	0.38 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`106`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 106;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://pimcoredemo.edelsau.uber.space/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAc…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping