https://ncmews.centricdxb.com/api/ncm/device/search-ews-notification

Query Metrics

316 Database Queries
123 Different statements
50.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.18 ms
(14.23%)
128
SELECT * FROM versions WHERE id = ?
Parameters:
[
  472571
]
6.07 ms
(12.03%)
40
SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype  AND autoSave = 0 ORDER BY `id` ASC
Parameters:
[
  "cid" => 309057
  "ctype" => "object"
]
4.68 ms
(9.28%)
1
SELECT object_localized_ews_notification_en.o_id as o_id, object_localized_ews_notification_en.o_type as o_type FROM object_localized_ews_notification_en WHERE ((((status = 'ended' AND AlertEndDate > 1788118622) OR (status != 'ended' AND endDate >= 1788205022)))  AND  object_localized_ews_notification_en.o_type IN ('object','folder')) AND object_localized_ews_notification_en.o_published = 1
Parameters:
[]
2.80 ms
(5.55%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '61'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
1.13 ms
(2.24%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '42'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
1.01 ms
(2.01%)
11
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "customer"
]
0.91 ms
(1.81%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '59'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.50 ms
(0.99%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '5'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.47 ms
(0.93%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/api/ncm/device/search-ews-notification"
  "sourcePathQuery" => "/api/ncm/device/search-ews-notification"
  "sourceEntireUri" => "https://ncmews.centricdxb.com/api/ncm/device/search-ews-notification"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.46 ms
(0.91%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '113'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.44 ms
(0.88%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '114'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.44 ms
(0.87%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '112'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.41 ms
(0.82%)
5
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "search-ews-notification"
  "path" => "/api/ncm/device/"
]
0.40 ms
(0.80%)
1
SELECT object_customer.o_id as o_id, object_customer.o_type as o_type FROM object_customer WHERE (`userId` = 'fc943d949744492c90986ece2efbe5ca1a7ee293'  AND  object_customer.o_type IN ('object','folder')) AND object_customer.o_published = 1 LIMIT 1
Parameters:
[]
0.40 ms
(0.79%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '10'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.37 ms
(0.74%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '116'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.36 ms
(0.72%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '13'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.36 ms
(0.72%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '120'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.35 ms
(0.69%)
2
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '119'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.30 ms
(0.60%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '109'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.28 ms
(0.55%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '48'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.27 ms
(0.54%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '11'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.27 ms
(0.54%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '51'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.27 ms
(0.54%)
2
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.26 ms
(0.52%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '126'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.26 ms
(0.52%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '17'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.26 ms
(0.52%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '83'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.26 ms
(0.51%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '18'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.26 ms
(0.51%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '128'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.26 ms
(0.51%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '102'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.50%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '8'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.50%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '19'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.50%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '137'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '85'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '134'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '62'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '131'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '91'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '80'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '111'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1310'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.25 ms
(0.49%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '75'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '110'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1468'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1292'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '210'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '84'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '6'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '129'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '90'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.48%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1369'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.47%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '753'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.47%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '121'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.47%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1289'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.24 ms
(0.47%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '142'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.23 ms
(0.46%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '138'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.23 ms
(0.46%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '93'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.23 ms
(0.46%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '132'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.23 ms
(0.45%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '135'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.22 ms
(0.44%)
1
SELECT object_localized_municipality_en.o_id as o_id, object_localized_municipality_en.o_type as o_type FROM object_localized_municipality_en WHERE (`municipalityid` = '1293'  AND  object_localized_municipality_en.o_type IN ('object','folder')) AND object_localized_municipality_en.o_published = 1 LIMIT 1
Parameters:
[]
0.22 ms
(0.44%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '213'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.22 ms
(0.44%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/api/ncm/device/search-ews-notification"
]
0.22 ms
(0.43%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '86'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '88'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '105'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '7'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '20'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '38'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '65'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.42%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '35'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.41%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '87'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.21 ms
(0.41%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '66'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.41%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '216'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '21'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '22'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '32'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '15'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '25'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.40%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '24'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.39%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '141'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.39%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '209'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.39%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '139'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.39%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '122'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.20 ms
(0.39%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '115'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '55'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '214'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '54'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '58'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '26'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '96'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.38%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '125'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.37%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '92'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.37%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '40'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.37%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '106'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.37%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '89'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.19 ms
(0.37%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '60'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.36%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '215'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.36%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '223'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.36%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '219'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.36%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '9'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '95'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '94'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.18 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '98'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '23'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '124'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.35%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '108'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.34%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '211'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.34%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '57'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.34%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '100'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.33%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '56'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.33%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '99'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.33%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '104'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.17 ms
(0.33%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '63'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.16 ms
(0.32%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '64'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.16 ms
(0.32%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '101'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.16 ms
(0.32%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '103'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.16 ms
(0.32%)
1
SELECT object_localized_governorate_en.o_id as o_id, object_localized_governorate_en.o_type as o_type FROM object_localized_governorate_en WHERE (`governoteId` = '107'  AND  object_localized_governorate_en.o_type IN ('object','folder')) AND object_localized_governorate_en.o_published = 1 LIMIT 1
Parameters:
[]
0.14 ms
(0.28%)
1
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.14 ms
(0.28%)
1
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  1
]
0.10 ms
(0.19%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  0
]
0.09 ms
(0.19%)
1
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  0
]
0.07 ms
(0.14%)
1
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  0
]
0.06 ms
(0.12%)
1
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  0
]

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.