https://torq-web-pimcore-php-fpm-dev.whitemoss-be0ac878.canadacentral.azurecontainerapps.io/about-us

Query Metrics

61 Database Queries
19 Different statements
121.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.46 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" => "/about-us"
  "sourcePathQuery" => "/about-us"
  "sourceEntireUri" => "https://torq-web-pimcore-php-fpm-dev.whitemoss-be0ac878.canadacentral.azurecontainerapps.io/about-us"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
2 1.79 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
3 1.84 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "about-us"
  "path" => "/"
]
4 1.64 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/about-us"
]
5 2.15 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  6
]
6 1.87 ms
SELECT * FROM object_url_slugs WHERE slug = '/about-us' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
7 1.69 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
8 4.13 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  6
]
9 3.51 ms
SELECT object_staff_member.o_id as o_id, object_staff_member.o_type as o_type FROM object_staff_member WHERE ( object_staff_member.o_type IN ('object','folder')) AND object_staff_member.o_published = 1
Parameters:
[]
10 1.78 ms
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  7
]
11 2.03 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:
[
  7
]
12 2.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "staff_member"
]
13 1.93 ms
SELECT * FROM object_store_staff_member WHERE oo_id = ?
Parameters:
[
  7
]
14 1.84 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  68
]
15 1.78 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  68
]
16 1.93 ms
SELECT * FROM object_relations_staff_member WHERE src_id = ?
Parameters:
[
  7
]
17 2.07 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 67
]
18 1.84 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 68
]
19 2.87 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 65
]
20 2.52 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  247
]
21 2.16 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  70
]
22 1.85 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 70
]
23 1.78 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
24 1.64 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_70__0c7cd81336f817ae37e2ef2c95daeb78"
]
25 1.60 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
26 2.01 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_70__db584fd04095e873f32ee1d22133a8af"
]
27 1.69 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
28 1.70 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_70__9dd537bd5385125a47debd45994aaba8"
]
29 1.48 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
30 1.64 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_70__0c7cd81336f817ae37e2ef2c95daeb78"
]
31 1.81 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  69
]
32 1.88 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  69
]
33 1.95 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 69
]
34 2.46 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
35 2.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_69__73dc2d759632d466cb9776cd210e80be"
]
36 1.86 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
37 1.68 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_69__acbee016a3a96486905ff2fa35833cc6"
]
38 1.59 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
39 1.54 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_69__fe67c0c6f095f045db34a27f335465d1"
]
40 1.91 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
41 1.48 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_69__73dc2d759632d466cb9776cd210e80be"
]
42 1.81 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 71
]
43 1.92 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
44 1.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_71__b63255c94ec3cf4539dd7802338b1d9d"
]
45 1.73 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
46 1.61 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_71__760cd2ba80fc4df599417bf0af871f06"
]
47 1.87 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
48 1.87 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_71__1c8065f40b2800ba95ee1e3304ba2f27"
]
49 1.64 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
50 1.58 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_71__b63255c94ec3cf4539dd7802338b1d9d"
]
51 2.37 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  72
]
52 3.11 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 72
]
53 1.64 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
54 1.84 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_72__a49b2febf2b2346b0e5b7a5c92570069"
]
55 1.66 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
56 1.85 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_72__6bbc7825d619ba84031cffe73a277bf4"
]
57 1.76 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
58 2.16 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_72__fecaa5f80f03dcf0204c2532ae843ec9"
]
59 1.81 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "auto_6a500f12d4102244f461106d48fcb087"
  "scope" => "pimcore_image_thumbnails"
]
60 1.49 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_72__a49b2febf2b2346b0e5b7a5c92570069"
]
61 2.26 ms
SELECT object_case_study.o_id as o_id, object_case_study.o_type as o_type FROM object_case_study WHERE ( object_case_study.o_type IN ('object','folder')) AND object_case_study.o_published = 1 ORDER BY `o_index`
Parameters:
[]

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.