POST https://pim.binder-gruppe.de/pimcore-graphql-webservices/News

Query Metrics

87 Database Queries
9 Different statements
9.41 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
2 0.16 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "News"
]
3 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/News"
]
4 0.09 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "pimcore-graphql-webservices"
]
5 0.08 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices"
]
6 0.08 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  ""
]
7 0.10 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  1
]
8 0.17 ms
SELECT id, name FROM classes
Parameters:
[]
9 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Bild"
]
10 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "15"
]
11 0.11 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "binderKategorien"
]
12 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "17"
]
13 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "binderKollektionen"
]
14 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "binder_kollektionen"
]
15 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "binderProduktarten"
]
16 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "binder_produktarten"
]
17 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "binderProdukte"
]
18 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "binder_produkte"
]
19 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "egfKategorien"
]
20 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "egf_kategorien"
]
21 0.09 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "egfKollektionen"
]
22 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "12"
]
23 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "egfListingstoerer"
]
24 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "egf_listingstoerer"
]
25 0.15 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "egfProduktarten"
]
26 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "egf_produktarten"
]
27 0.08 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "egfProdukte"
]
28 0.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "egf_produkte"
]
29 0.11 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Haendler"
]
30 0.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "haendler"
]
31 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Messen"
]
32 0.06 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "11"
]
33 0.09 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "News"
]
34 0.13 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "13"
]
35 0.08 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Presse"
]
36 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "10"
]
37 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Soziales"
]
38 0.12 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "soziales"
]
39 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Tag"
]
40 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "14"
]
41 0.10 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "test"
]
42 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "16"
]
43 0.11 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "News"
]
44 0.17 ms
SELECT object_13.id as id, object_13.type as `type` FROM object_13 WHERE ( (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'News'
                AND LOCATE(CONCAT(`object_13`.path,`object_13`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'News'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_13`.path,`object_13`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_13`.`firma` LIKE '%egf%') )  AND  object_13.type IN ('object','folder','variant')) AND object_13.published = 1 ORDER BY `voedatum` DESC
Parameters:
[]
45 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  7539
]
46 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6986
]
47 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6735
]
48 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6981
]
49 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4726
]
50 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4729
]
51 0.14 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4732
]
52 0.13 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4725
]
53 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5105
]
54 0.13 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6738
]
55 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4719
]
56 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4713
]
57 0.07 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4710
]
58 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6884
]
59 0.08 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6745
]
60 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6754
]
61 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6760
]
62 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6761
]
63 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6765
]
64 0.13 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6771
]
65 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6778
]
66 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6780
]
67 0.14 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6784
]
68 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6787
]
69 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6795
]
70 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6798
]
71 0.13 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6802
]
72 0.14 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6808
]
73 0.14 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6814
]
74 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6817
]
75 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6822
]
76 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6826
]
77 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6830
]
78 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6834
]
79 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6841
]
80 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6845
]
81 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6849
]
82 0.12 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6856
]
83 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6865
]
84 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6867
]
85 0.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6874
]
86 0.10 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6876
]
87 0.09 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  6880
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.