1
1.39 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters :
[
"system_settings "
"pimcore_system_settings "
]
SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings' ; Copy
2
1.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters :
[
"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle "
"pimcore "
]
SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore' ; Copy
3
1.59 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 OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC
Parameters :
[
"/pimcore-graphql-webservices/DocumentsRequest "
"path "
"auto_create "
"/pimcore-graphql-webservices/DocumentsRequest "
"path_query "
"https://pimcore-app.dev-pimcore.svc.cluster.local/pimcore-graphql-webservices/DocumentsRequest "
"entire_uri "
]
SELECT * FROM redirects WHERE
(
(source = '/pimcore-graphql-webservices/DocumentsRequest' AND (`type` = 'path' OR `type` = 'auto_create' )) OR
(source = '/pimcore-graphql-webservices/DocumentsRequest' AND `type` = 'path_query' ) OR
(source = 'https://pimcore-app.dev-pimcore.svc.cluster.local/pimcore-graphql-webservices/DocumentsRequest' 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 OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC ; Copy
4
1.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters :
[
"reports "
"pimcore "
]
SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore' ; Copy
5
1.47 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters :
[
"/pimcore-graphql-webservices/ "
"DocumentsRequest "
]
SELECT id FROM documents WHERE `path` = BINARY '/pimcore-graphql-webservices/' AND `key` = BINARY 'DocumentsRequest' ; Copy
6
1.45 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters :
[
"/pimcore-graphql-webservices/DocumentsRequest "
]
SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/DocumentsRequest' ; Copy
7
1.43 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters :
[
"/ "
"pimcore-graphql-webservices "
]
SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-graphql-webservices' ; Copy
8
1.44 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters :
[
"/pimcore-graphql-webservices "
]
SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices' ; Copy
9
1.41 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '' ; Copy
10
1.58 ms
SELECT * FROM properties WHERE
(
(cid IN (1 ) AND inheritable = 1 ) OR cid = ?
) AND ctype = 'document'
SELECT * FROM properties WHERE
(
(cid IN (1 ) AND inheritable = 1 ) OR cid = 1
) AND ctype = 'document' ; Copy
11
1.64 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters :
[
"DocumentsRequest "
"pimcore_data_hub "
]
SELECT * FROM settings_store WHERE id = 'DocumentsRequest' AND scope = 'pimcore_data_hub' ; Copy
12
1.44 ms
SELECT id , name FROM classes
SELECT id , name FROM classes ; Copy
13
1.39 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"ApplicationArea "
]
SELECT `id` , `name` FROM classes WHERE name = 'ApplicationArea' ; Copy
14
1.42 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Branche "
]
SELECT `id` , `name` FROM classes WHERE name = 'Branche' ; Copy
15
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Category "
]
SELECT `id` , `name` FROM classes WHERE name = 'Category' ; Copy
16
1.41 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'City' ; Copy
17
1.35 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Customer "
]
SELECT `id` , `name` FROM classes WHERE name = 'Customer' ; Copy
18
1.43 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"CustomerSegment "
]
SELECT `id` , `name` FROM classes WHERE name = 'CustomerSegment' ; Copy
19
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"CustomerSegmentGroup "
]
SELECT `id` , `name` FROM classes WHERE name = 'CustomerSegmentGroup' ; Copy
20
1.43 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'Event' ; Copy
21
1.37 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"EventCategory "
]
SELECT `id` , `name` FROM classes WHERE name = 'EventCategory' ; Copy
22
1.36 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'Filter' ; Copy
23
1.34 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"LinkActivityDefinition "
]
SELECT `id` , `name` FROM classes WHERE name = 'LinkActivityDefinition' ; Copy
24
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Location "
]
SELECT `id` , `name` FROM classes WHERE name = 'Location' ; Copy
25
1.55 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"NewsArticle "
]
SELECT `id` , `name` FROM classes WHERE name = 'NewsArticle' ; Copy
26
1.45 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"NewsTag "
]
SELECT `id` , `name` FROM classes WHERE name = 'NewsTag' ; Copy
27
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Partner "
]
SELECT `id` , `name` FROM classes WHERE name = 'Partner' ; Copy
28
1.39 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Product "
]
SELECT `id` , `name` FROM classes WHERE name = 'Product' ; Copy
29
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'Region' ; Copy
30
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"TermSegmentBuilderDefinition "
]
SELECT `id` , `name` FROM classes WHERE name = 'TermSegmentBuilderDefinition' ; Copy
31
1.46 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"NewsArticle "
]
SELECT `id` , `name` FROM classes WHERE name = 'NewsArticle' ; Copy
32
1.43 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"NewsTag "
]
SELECT `id` , `name` FROM classes WHERE name = 'NewsTag' ; Copy
33
1.46 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"ApplicationArea "
]
SELECT `id` , `name` FROM classes WHERE name = 'ApplicationArea' ; Copy
34
1.37 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Branche "
]
SELECT `id` , `name` FROM classes WHERE name = 'Branche' ; Copy
35
1.36 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'City' ; Copy
36
1.34 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Location "
]
SELECT `id` , `name` FROM classes WHERE name = 'Location' ; Copy
37
1.38 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"Partner "
]
SELECT `id` , `name` FROM classes WHERE name = 'Partner' ; Copy
38
1.36 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'Region' ; Copy
39
1.37 ms
SELECT `id` , `name` FROM classes WHERE name = ?
SELECT `id` , `name` FROM classes WHERE name = 'Event' ; Copy
40
1.43 ms
SELECT `id` , `name` FROM classes WHERE name = ?
Parameters :
[
"EventCategory "
]
SELECT `id` , `name` FROM classes WHERE name = 'EventCategory' ; Copy
41
1.59 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters :
[
"/www/ "
"de-de "
]
SELECT id FROM documents WHERE `path` = BINARY '/www/' AND `key` = BINARY 'de-de' ; Copy
42
1.48 ms
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = 4155 ; Copy
43
1.39 ms
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT sourceId FROM documents_translations WHERE id = 4155 ; Copy
44
1.49 ms
SELECT id , language FROM documents_translations WHERE sourceId IN (? , ? ) UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
3
4155
4155
]
SELECT id , language FROM documents_translations WHERE sourceId IN (3 , 4155 ) UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 4155 ; Copy
45
1.42 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
3540
3540
]
SELECT id , language FROM documents_translations WHERE sourceId = 3540 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 3540 ; Copy
46
1.42 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
2544
2544
]
SELECT id , language FROM documents_translations WHERE sourceId = 2544 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 2544 ; Copy
47
1.46 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
4155
4155
]
SELECT id , language FROM documents_translations WHERE sourceId = 4155 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 4155 ; Copy
48
1.47 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
1980
1980
]
SELECT id , language FROM documents_translations WHERE sourceId = 1980 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 1980 ; Copy
49
3.67 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
2206
2206
]
SELECT id , language FROM documents_translations WHERE sourceId = 2206 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 2206 ; Copy
50
1.50 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
3789
3789
]
SELECT id , language FROM documents_translations WHERE sourceId = 3789 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 3789 ; Copy
51
1.44 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
2793
2793
]
SELECT id , language FROM documents_translations WHERE sourceId = 2793 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 2793 ; Copy
52
1.44 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
3042
3042
]
SELECT id , language FROM documents_translations WHERE sourceId = 3042 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 3042 ; Copy
53
1.45 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
Parameters :
[
3291
3291
]
SELECT id , language FROM documents_translations WHERE sourceId = 3291 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 3291 ; Copy
54
1.42 ms
SELECT id , language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = ?
SELECT id , language FROM documents_translations WHERE sourceId = 3 UNION SELECT sourceId as id , "source" FROM documents_translations WHERE id = 3 ; Copy
55
1.62 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 = ?
SELECT documents . * , tree_locks . locked FROM documents
LEFT JOIN tree_locks ON documents . id = tree_locks . id AND tree_locks . type = 'document'
WHERE documents . id = 4155 ; Copy
56
1.47 ms
SELECT documents . * , documents_page . * , tree_locks . locked FROM documents
LEFT JOIN documents_page ON documents . id = documents_page . id
LEFT JOIN tree_locks ON documents . id = tree_locks . id AND tree_locks . type = 'document'
WHERE documents . id = ?
SELECT documents . * , documents_page . * , tree_locks . locked FROM documents
LEFT JOIN documents_page ON documents . id = documents_page . id
LEFT JOIN tree_locks ON documents . id = tree_locks . id AND tree_locks . type = 'document'
WHERE documents . id = 4155 ; Copy
57
1.43 ms
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = 4155 ; Copy
58
1.41 ms
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = 4161 ; Copy
59
2.80 ms
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = 2550 ; Copy
60
1.48 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 959 ; Copy
61
1.64 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 960 ; Copy
62
1.57 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 964 ; Copy
63
1.55 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 965 ; Copy
64
1.61 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 132 ; Copy
65
8.03 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 704 ; Copy
66
1.67 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 712 ; Copy
67
1.51 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 711 ; Copy
68
1.60 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 703 ; Copy
69
1.42 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 702 ; Copy
70
1.51 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 701 ; Copy
71
1.76 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 709 ; Copy
72
1.63 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 196 ; Copy
73
1.58 ms
SELECT customSettings FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = 707 ; Copy