Symfony Profiler

Query Metrics

196 Database Queries

44 Different statements

157.17 ms Query time

0 Invalid entities

Queries


SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM tmp_store WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_vcloud_tour WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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 id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages LIMIT 1;
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,2) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
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 dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  0
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  0
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  0
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  1
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  1
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  1
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  2
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  2
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  2
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  3
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  3
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  3
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  4
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  4
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  4
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  5
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  5
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  5
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ?
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  6
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  6
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4814 and fieldname = 'contentblocks' and `index` =  6
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
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 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 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 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 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 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 customSettings FROM assets WHERE id = ?
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 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 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 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 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 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 dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'

#▲	Time	Info
1	0.45 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "rundweg-trantrauas_vc4814"`] 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 'rundweg-trantrauas_vc4814';
2	0.36 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/rundweg-trantrauas_vc4814"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/rundweg-trantrauas_vc4814';
3	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';
4	1.04 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 2;
5	0.50 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';
6	0.70 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/rundweg-trantrauas_vc4814" "path" "auto_create" "/en/rundweg-trantrauas_vc4814" "path_query" "https://montafon-staging.conecto.rocks/en/rundweg-trantrauas_vc4814" "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/rundweg-trantrauas_vc4814' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/rundweg-trantrauas_vc4814' AND `type` = 'path_query') OR (source = 'https://montafon-staging.conecto.rocks/en/rundweg-trantrauas_vc4814' 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;
7	1.04 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';
8	2.82 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "rundweg-trantrauas_vc4814"`] 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 'rundweg-trantrauas_vc4814';
9	0.59 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/rundweg-trantrauas_vc4814"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/rundweg-trantrauas_vc4814';
10	1.79 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"vcloud_tour"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'vcloud_tour';
11	0.63 ms	SELECT * FROM object_relations_vcloud_tour WHERE src_id = ? Parameters: [`4814`] View formatted query View runnable query Explain query SELECT * FROM object_relations_vcloud_tour WHERE src_id = ? SELECT * FROM object_relations_vcloud_tour WHERE src_id = 4814;
12	0.31 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"vcloud_concept"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'vcloud_concept';
13	0.61 ms	SELECT * FROM object_relations_vcloud_concept WHERE src_id = ? Parameters: [`7124`] View formatted query View runnable query Explain query SELECT * FROM object_relations_vcloud_concept WHERE src_id = ? SELECT * FROM object_relations_vcloud_concept WHERE src_id = 7124;
14	0.32 ms	SELECT * FROM object_relations_vcloud_concept WHERE src_id = ? Parameters: [`7145`] View formatted query View runnable query Explain query SELECT * FROM object_relations_vcloud_concept WHERE src_id = ? SELECT * FROM object_relations_vcloud_concept WHERE src_id = 7145;
15	0.66 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19;
16	0.45 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`58799`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 58799;
17	0.43 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`58799`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 58799;
18	0.32 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 19;
19	0.47 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`19 19 19`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(19, 19) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 19;
20	0.30 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "de"`] 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 'de';
21	0.28 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "nl"`] 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 'nl';
22	1.75 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
23	0.53 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
24	0.50 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 8;
25	0.72 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8;
26	0.44 ms	SELECT * FROM properties WHERE ( (cid IN (1,2) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 2) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,2) AND inheritable = 1) OR cid = 8 ) AND ctype='asset';
27	0.36 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 19;
28	0.44 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`19 19 19`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(19, 19) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 19;
29	0.86 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename Parameters: [`4814 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 4814 AND dependencies.sourcetype = 'object' ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename;
30	0.48 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 4814`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 4814 ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename ;
31	0.61 ms	SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`4814 "contentblocks"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = 4814 AND fieldname = 'contentblocks' ORDER BY `index` ASC;
32	0.54 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 0`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 0;
33	0.27 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0;
34	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0;
35	0.26 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 0;
36	0.49 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 1`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 1;
37	0.27 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1;
38	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1;
39	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 1;
40	0.49 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 2`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 2;
41	0.25 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2;
42	0.24 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2;
43	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 2;
44	0.46 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 3`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 3;
45	0.27 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3;
46	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3;
47	0.22 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 3;
48	0.49 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 4`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 4;
49	0.26 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4;
50	0.33 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4;
51	0.24 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 4;
52	0.77 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 5`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 5;
53	0.56 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5;
54	0.52 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5;
55	0.47 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 5;
56	0.89 ms	SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = ? AND `index` = ? Parameters: [`4814 "contentblocks" 6`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ( 'de', 'en', 'nl', 'de', 'en', 'nl', 'de', 'en', 'nl' ) AND `fieldname` = ? AND `index` = ? SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = 4814 AND language IN ('de','en','nl','de','en','nl','de','en','nl') AND `fieldname` = 'contentblocks' AND `index` = 6;
57	0.26 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6;
58	0.23 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6;
59	0.24 ms	select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 Parameters: [] View formatted query View runnable query Explain query select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6 select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and ooo_id = 4814 and fieldname = 'contentblocks' and `index` = 6;
60	0.24 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"vcloud_safety_tip"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'vcloud_safety_tip';
61	0.35 ms	SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`7161 "externalLinks"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = 7161 AND fieldname = 'externalLinks' ORDER BY `index` ASC;
62	0.30 ms	SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`4814 "externalLinks"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = 4814 AND fieldname = 'externalLinks' ORDER BY `index` ASC;
63	0.42 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
64	3.33 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__928590e13f390c71592290a8a9bff4fc"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__928590e13f390c71592290a8a9bff4fc';
65	0.43 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
66	0.78 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__431745b39907241b997714ed66dc0b26"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__431745b39907241b997714ed66dc0b26';
67	0.33 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
68	0.65 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__1642163b672088517dc8e34cdec188fc"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__1642163b672088517dc8e34cdec188fc';
69	0.28 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
70	2.92 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__c4b33c32db94095bf6db5e91ba0ee076"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__c4b33c32db94095bf6db5e91ba0ee076';
71	0.36 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
72	0.38 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__a32ad5c6c03cf41a2a4c9769e2e5dd5d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__a32ad5c6c03cf41a2a4c9769e2e5dd5d';
73	0.39 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
74	0.93 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__ec5e6b421513ff6b389f63150897a6d3"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__ec5e6b421513ff6b389f63150897a6d3';
75	0.36 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
76	0.78 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__d0a012eb9321ea7c600bd1605f5268d0"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__d0a012eb9321ea7c600bd1605f5268d0';
77	2.84 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
78	1.00 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__27bc5fd440961b2ca3bf205098357758"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__27bc5fd440961b2ca3bf205098357758';
79	0.43 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
80	0.36 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__324b4719d33e7f2a04775155ae114ff4"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__324b4719d33e7f2a04775155ae114ff4';
81	0.39 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
82	2.34 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__e9a6148db50a021ccc672bfd8958fe70"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__e9a6148db50a021ccc672bfd8958fe70';
83	0.44 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
84	0.40 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__1f55ef0672f5e8b99d0b41b7ef65016e"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__1f55ef0672f5e8b99d0b41b7ef65016e';
85	0.38 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
86	0.36 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__f82df5f1fc10e4116bdebf7edd3de24d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__f82df5f1fc10e4116bdebf7edd3de24d';
87	4.46 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
88	0.56 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__4434f8da715549349391fada0c393335"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__4434f8da715549349391fada0c393335';
89	2.01 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
90	0.42 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__4b9cb545b3b331e732e3acc5ab1faf00"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__4b9cb545b3b331e732e3acc5ab1faf00';
91	0.34 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
92	0.36 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__bb71dac5bc6c9ee40cb0414f22ab6501"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__bb71dac5bc6c9ee40cb0414f22ab6501';
93	0.40 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
94	0.28 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__47f46873923fbecbabbb3070c320c85a"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__47f46873923fbecbabbb3070c320c85a';
95	0.26 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
96	0.28 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__0c4f0c303f84269f75b0eb18ab50f74a"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__0c4f0c303f84269f75b0eb18ab50f74a';
97	0.28 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
98	0.27 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__224effe37de86b047da5ad1c2b990060"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__224effe37de86b047da5ad1c2b990060';
99	0.22 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
100	3.37 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__d9b1d6f217a94d4ae170e423f8bbe798"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__d9b1d6f217a94d4ae170e423f8bbe798';
101	0.39 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
102	0.31 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__2a9f1b2e78f75e785a278b19614ad3b0"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__2a9f1b2e78f75e785a278b19614ad3b0';
103	0.24 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
104	0.27 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__df820592884e27a760b816a8b1242326"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__df820592884e27a760b816a8b1242326';
105	0.23 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
106	0.27 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__42f724c51c00a91225bd22e4a2cbe1ed"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__42f724c51c00a91225bd22e4a2cbe1ed';
107	0.22 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
108	0.28 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__abc7c08eb3b828222064477ce42d8bae"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__abc7c08eb3b828222064477ce42d8bae';
109	1.59 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
110	0.98 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__820614e2aeb65ba97fda59cb35c32841"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__820614e2aeb65ba97fda59cb35c32841';
111	2.40 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
112	0.42 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__b95e0eef196c9258877335a620fbe9f3"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__b95e0eef196c9258877335a620fbe9f3';
113	0.32 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
114	0.29 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__927a585d51a956cd500ddbe60071d6b6"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__927a585d51a956cd500ddbe60071d6b6';
115	0.29 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
116	0.28 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__34b2d8da45faaaec41b89cb8c722c96c"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__34b2d8da45faaaec41b89cb8c722c96c';
117	1.79 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
118	0.37 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__927a585d51a956cd500ddbe60071d6b6"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__927a585d51a956cd500ddbe60071d6b6';
119	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
120	2.54 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58799__b95e0eef196c9258877335a620fbe9f3"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58799__b95e0eef196c9258877335a620fbe9f3';
121	0.46 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`58801`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 58801;
122	0.43 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`58801`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 58801;
123	0.48 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
124	1.84 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__6e42968379916d013f036659fdc97e8c"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__6e42968379916d013f036659fdc97e8c';
125	0.81 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
126	4.75 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__3ed184ec68575d9592cd4c220b9f1451"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__3ed184ec68575d9592cd4c220b9f1451';
127	0.53 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
128	0.34 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__1b203cf2f2e55c6e8721cfe11d8b649d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__1b203cf2f2e55c6e8721cfe11d8b649d';
129	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
130	0.79 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__cc6b8f072952a3b44a77e7f11f17ca84"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__cc6b8f072952a3b44a77e7f11f17ca84';
131	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
132	1.91 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__a94579742de087fb8138a88b66193f95"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__a94579742de087fb8138a88b66193f95';
133	0.36 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
134	0.35 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__3ba09e72685e0ea5ea95f78e0ee76a95"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__3ba09e72685e0ea5ea95f78e0ee76a95';
135	0.32 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
136	1.95 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__82b301016d11368387312e9ac74a05c7"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__82b301016d11368387312e9ac74a05c7';
137	0.35 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
138	0.35 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__37b325f23f132b58914ac3da79caf48d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__37b325f23f132b58914ac3da79caf48d';
139	1.69 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
140	0.64 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__69d3a9b7a74b71e6ad1329a3af970993"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__69d3a9b7a74b71e6ad1329a3af970993';
141	2.57 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
142	0.45 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__9a506d48a2784ea1ab8dc62cfaff8201"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__9a506d48a2784ea1ab8dc62cfaff8201';
143	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
144	0.88 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__5f1bebc0467087179c6a8a031d4da5d5"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__5f1bebc0467087179c6a8a031d4da5d5';
145	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
146	1.88 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__60a9497b31ae77213f67d32e7db15056"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__60a9497b31ae77213f67d32e7db15056';
147	0.37 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
148	0.50 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__ce00989b6ae971484b923448b5168a7c"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__ce00989b6ae971484b923448b5168a7c';
149	0.35 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
150	1.76 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__ceb8f6280bc44d2dae71ca98bf7758d2"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__ceb8f6280bc44d2dae71ca98bf7758d2';
151	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
152	0.32 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__7383421289893e361d3bd48a14e62a72"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__7383421289893e361d3bd48a14e62a72';
153	2.48 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
154	0.43 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__8cdd1119c8f05395f127a79a81b66e17"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__8cdd1119c8f05395f127a79a81b66e17';
155	0.32 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
156	0.32 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__f714f3813c887ec8f055e4af986b6f9d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__f714f3813c887ec8f055e4af986b6f9d';
157	0.27 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
158	2.53 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__94a56043c95766d1eb5b034f250d2920"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__94a56043c95766d1eb5b034f250d2920';
159	0.44 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
160	0.34 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__b30197a680dba447b43193ae493bb586"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__b30197a680dba447b43193ae493bb586';
161	0.37 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
162	0.30 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__32442ba4b67440074c4ec2ddd2d95780"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__32442ba4b67440074c4ec2ddd2d95780';
163	2.16 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
164	0.88 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__45872e4c3586f55bb43d2e332beda7a4"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__45872e4c3586f55bb43d2e332beda7a4';
165	0.27 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
166	0.64 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__f949ed14aa82eec1bf61228c08ad296e"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__f949ed14aa82eec1bf61228c08ad296e';
167	2.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
168	2.17 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__54d514a00125ef81872953f9e86b7dc6"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__54d514a00125ef81872953f9e86b7dc6';
169	0.33 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
170	0.32 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__a94cac52e8dce13a87983838a308a4c0"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__a94cac52e8dce13a87983838a308a4c0';
171	2.99 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
172	0.49 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__d0ac3cd3e9b774bd0d1bbe5c0a4d2ed3"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__d0ac3cd3e9b774bd0d1bbe5c0a4d2ed3';
173	0.43 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
174	0.45 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__b1baac855f3bccc411298736f42df6a9"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__b1baac855f3bccc411298736f42df6a9';
175	0.36 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
176	0.33 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__1faa66c2f8eb41e25e8acce30902c919"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__1faa66c2f8eb41e25e8acce30902c919';
177	2.10 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
178	0.37 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__b1baac855f3bccc411298736f42df6a9"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__b1baac855f3bccc411298736f42df6a9';
179	0.28 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"textMedia_1-33_3" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'textMedia_1-33_3' AND scope = 'pimcore_image_thumbnails';
180	2.51 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_58801__d0ac3cd3e9b774bd0d1bbe5c0a4d2ed3"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_58801__d0ac3cd3e9b774bd0d1bbe5c0a4d2ed3';
181	0.83 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 4814`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 4814 ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename ;
182	0.39 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/snippets/" "footer"`] 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/snippets/' AND `key` = BINARY 'footer';
183	1.74 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';
184	2.56 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction" "path_query" "https://montafon-staging.conecto.rocks/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction' AND `type` = 'path_query') OR (source = 'https://montafon-staging.conecto.rocks/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction' 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;
185	0.59 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 23;
186	2.30 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 7;
187	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: [`2521`] 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 = 2521;
188	0.48 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5;
189	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5;
190	2.96 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 5 ) AND ctype='asset';
191	1.62 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`149`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 149;
192	2.80 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`149`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 149;
193	0.48 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`149`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 149 ) AND ctype='asset';
194	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`145`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 145;
195	2.40 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`145`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 145;
196	0.46 ms	SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`145`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = 145 ) AND ctype='asset';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
FormBuilderBundle\Model\OutputWorkflow	No errors.
FormBuilderBundle\Model\FormDefinition	No errors.
FormBuilderBundle\Model\OutputWorkflowChannel	No errors.

Symfony Profiler

GET https://montafon-staging.conecto.rocks/en/rundweg-trantrauas_vc4814

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping