http://112.124.42.80:63435/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DAppBundle%253ADefault%253Adefault

Query Metrics

40 Database Queries
10 Different statements
18.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.32 ms
(77.54%)
27
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727665621
  [
    "site_domain_2b6ac0ff7c07b4b131ad10c3d97a3b0b"
  ]
]
1.75 ms
(9.48%)
1
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters:
[
  "112.124.42.80"
  "%"112.124.42.80"%"
]
0.77 ms
(4.15%)
3
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
0.60 ms
(3.24%)
3
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  1
]
0.23 ms
(1.24%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  1
  1
  1
]
0.20 ms
(1.06%)
1
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/es"
]
0.16 ms
(0.87%)
1
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:
[
  3
]
0.16 ms
(0.85%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.84%)
1
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CAR"
]
0.13 ms
(0.73%)
1
SELECT id,domains FROM sites
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.

Entities Mapping