https://devapimeteoksa.centricdxb.com/api/ncm/device/regions

Query Metrics

98 Database Queries
26 Different statements
19.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.22 ms
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters:
[
  "devapimeteoksa.centricdxb.com"
  "%"devapimeteoksa.centricdxb.com"%"
]
2 0.06 ms
SELECT id,domains FROM sites
Parameters:
[]
3 0.28 ms
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/regions"
  "sourcePathQuery" => "/api/ncm/device/regions"
  "sourceEntireUri" => "https://devapimeteoksa.centricdxb.com/api/ncm/device/regions"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
4 4.80 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[
  "8af919885c2e7d00208f20a73f7e59633bfda4068dbf95b87e58f8120e60fd64"
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
]
5 0.12 ms
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
Parameters:
[
  300.0
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
  "8af919885c2e7d00208f20a73f7e59633bfda4068dbf95b87e58f8120e60fd64"
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
]
6 0.07 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[
  "8af919885c2e7d00208f20a73f7e59633bfda4068dbf95b87e58f8120e60fd64"
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
]
7 0.09 ms
SELECT id FROM redirects WHERE active = 1 AND regex = 1  ORDER BY `priority` DESC
Parameters:
[]
8 2.15 ms
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[
  "8af919885c2e7d00208f20a73f7e59633bfda4068dbf95b87e58f8120e60fd64"
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
]
9 0.18 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[
  "8af919885c2e7d00208f20a73f7e59633bfda4068dbf95b87e58f8120e60fd64"
  "njn1xBO2kTOjIEm3p5Oti5V1U0gGgzNY90E2FaQifqw="
]
10 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
11 0.12 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "regions"
  "path" => "/api/ncm/device/"
]
12 0.07 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/api/ncm/device/regions"
]
13 0.06 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "device"
  "path" => "/api/ncm/"
]
14 0.05 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/api/ncm/device"
]
15 0.05 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "ncm"
  "path" => "/api/"
]
16 0.06 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/api/ncm"
]
17 0.06 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "api"
  "path" => "/"
]
18 0.04 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/api"
]
19 0.06 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
20 0.10 ms
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
Parameters:
[
  1
]
21 0.09 ms
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
Parameters:
[
  1
]
22 0.10 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  1
]
23 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "customer"
]
24 0.36 ms
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:
[]
25 0.08 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  488780
]
26 0.08 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  488780
]
27 0.12 ms
SELECT * FROM object_store_customer WHERE oo_id = ?
Parameters:
[
  488780
]
28 0.09 ms
SELECT * FROM object_relations_customer WHERE src_id = ?
Parameters:
[
  488780
]
29 0.07 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
30 0.05 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
31 6.15 ms
SELECT * FROM translations_messages WHERE language = ?
Parameters:
[
  "en"
]
32 0.32 ms
SELECT object_localized_region_en.o_id as o_id, object_localized_region_en.o_type as o_type FROM object_localized_region_en WHERE ( object_localized_region_en.o_type IN ('object','folder')) AND object_localized_region_en.o_published = 1
Parameters:
[]
33 0.08 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  726
]
34 0.08 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  726
]
35 0.05 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "region"
]
36 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  726
]
37 0.09 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  726
]
38 0.07 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  726
]
39 0.06 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  727
]
40 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  727
]
41 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  727
]
42 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  727
]
43 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  727
]
44 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  728
]
45 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  728
]
46 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  728
]
47 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  728
]
48 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  728
]
49 0.06 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  729
]
50 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  729
]
51 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  729
]
52 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  729
]
53 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  729
]
54 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  730
]
55 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  730
]
56 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  730
]
57 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  730
]
58 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  730
]
59 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  731
]
60 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  731
]
61 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  731
]
62 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  731
]
63 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  731
]
64 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  732
]
65 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  732
]
66 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  732
]
67 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  732
]
68 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  732
]
69 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  733
]
70 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  733
]
71 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  733
]
72 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  733
]
73 0.06 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  733
]
74 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  734
]
75 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  734
]
76 0.04 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  734
]
77 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  734
]
78 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  734
]
79 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  735
]
80 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  735
]
81 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  735
]
82 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  735
]
83 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  735
]
84 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  736
]
85 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  736
]
86 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  736
]
87 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  736
]
88 0.06 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  736
]
89 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  737
]
90 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  737
]
91 0.04 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  737
]
92 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  737
]
93 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  737
]
94 0.05 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  738
]
95 0.06 ms
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  738
]
96 0.05 ms
SELECT * FROM object_store_region WHERE oo_id = ?
Parameters:
[
  738
]
97 0.06 ms
SELECT * FROM object_localized_data_region WHERE ooo_id = ? AND language IN ('en','ar')
Parameters:
[
  738
]
98 0.05 ms
SELECT * FROM object_relations_region WHERE src_id = ?
Parameters:
[
  738
]

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.