Query Metrics
970
Database Queries
36
Different statements
211.99 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
33.38 ms (15.75%) |
234 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
33.14 ms (15.63%) |
233 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
25.09 ms (11.84%) |
163 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
156
]
|
|
24.80 ms (11.70%) |
54 |
DELETE FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_144459__a86c8135d5f056d3201506ee1fb8d43c"
]
|
|
24.18 ms (11.41%) |
54 |
INSERT INTO tmp_store (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "thumb_144459__a86c8135d5f056d3201506ee1fb8d43c" "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00*\x00items";a:1:{i:0;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";d:383;s:6:"height";d:383;s:11:"positioning";s:6:"center";s:11:"forceResize";b:1;}}}s:9:"\x00*\x00medias";a:4:{s:40:"(min-width: 576px)and (max-width: 768px)";a:1:{i:0;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";d:383;s:6:"height";d:383;s:11:"positioning";s:6:"center";s:11:"forceResize";b:1;}}}s:40:"(min-width: 768px)and (max-width: 992px)";a:1:{i:0;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";d:330;s:6:"height";d:330;s:11:"positioning";s:6:"center";s:11:"forceResize";b:1;}}}s:41:"(min-width: 992px)and (max-width: 1200px)";a:1:{i:0;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";d:299;s:6:"height";d:299;s:11:"positioning";s:6:"center";s:11:"forceResize";b:1;}}}s:19:"(min-width: 1200px)";a:1:{i:0;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";d:480;s:6:"height";d:480;s:11:"positioning";s:6:"center";s:11:"forceResize";b:1;}}}}s:7:"\x00*\x00name";s:16:"teaserDetail_1_4";s:14:"\x00*\x00description";s:0:"";s:8:"\x00*\x00group";s:0:"";s:9:"\x00*\x00format";s:6:"SOURCE";s:10:"\x00*\x00quality";i:85;s:17:"\x00*\x00highResolution";d:1;s:16:"\x00*\x00preserveColor";b:0;s:19:"\x00*\x00preserveMetaData";b:0;s:15:"\x00*\x00rasterizeSVG";b:0;s:15:"\x00*\x00downloadable";b:0;s:19:"\x00*\x00modificationDate";N;s:15:"\x00*\x00creationDate";N;s:17:"\x00*\x00filenameSuffix";s:22:"media--0c1badca--query";s:20:"\x00*\x00preserveAnimation";b:0;}" "thumbnail_deferred" 1765639695 1766244495 1 ] |
|
19.48 ms (9.19%) |
18 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
888
]
|
|
6.15 ms (2.90%) |
35 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
156
]
|
|
5.90 ms (2.78%) |
66 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
5.14 ms (2.42%) |
1 |
SELECT object_localized_ft_poi_de.id as id, object_localized_ft_poi_de.type as `type` FROM object_localized_ft_poi_de WHERE ((`published` = ?) AND (`active` = ?) AND (object_localized_ft_poi_de.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_ft_poi_de.type IN ('object','variant','folder')) AND object_localized_ft_poi_de.published = 1 ORDER BY `object_localized_ft_poi_de`.`name` ASC
Parameters:
[ 1 1 1356 1358 1359 1363 1366 1369 1376 1380 1383 1384 1386 1390 1394 1400 1403 1404 1409 1410 1411 1416 1418 1419 1420 1422 1423 1426 1427 1428 1430 1432 1433 1438 1442 1450 1453 1456 1457 1459 1463 1464 1466 1467 1468 1469 1470 1471 1473 1474 1475 1478 1485 1492 1493 1495 1496 1498 1499 1503 1508 1511 1515 1516 1517 1518 1519 1523 1524 1525 1526 1528 1532 1534 1541 1543 1544 1548 1550 1557 1561 1566 1570 1572 1575 1578 1580 1582 1583 1584 1590 1591 1593 1594 1597 1598 1600 1603 1604 1605 1606 1608 1611 1613 1615 1616 1617 1618 1622 1629 1630 1631 1632 1633 1634 1637 1638 1640 1643 1646 1648 1650 1651 1653 1654 1657 1661 1663 1664 1665 1666 1671 1672 1673 1676 1677 1679 1680 1682 1685 1688 1691 1694 1696 1700 1707 1708 1710 1711 1712 1714 1716 1722 1723 1727 1735 1736 1745 1747 1748 1753 1755 1756 1758 1760 1761 1762 1763 1764 1769 1770 1771 1782 1789 1793 1796 1799 1801 1803 1805 1806 1807 1810 1813 1814 1815 1816 1818 1826 1829 1830 1831 1833 1834 1836 1837 1838 1842 1843 1845 1854 1856 1860 1862 1863 4981 4982 4983 4984 4985 6152 6155 6156 ] |
|
3.68 ms (1.74%) |
1 |
SELECT object_localized_ft_poi_de.id as id, object_localized_ft_poi_de.type as `type` FROM object_localized_ft_poi_de WHERE ((`published` = ?) AND (`active` = ?) AND object_localized_ft_poi_de.type IN ('object','variant','folder')) AND object_localized_ft_poi_de.published = 1
Parameters:
[ 1 1 ] |
|
3.42 ms (1.61%) |
18 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
888
]
|
|
3.23 ms (1.52%) |
11 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
85
]
|
|
3.05 ms (1.44%) |
17 |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
3903
]
|
|
2.98 ms (1.41%) |
2 |
SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_FACILITY REPORT_FACILITY ON objects.id = REPORT_FACILITY.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_FACILITY.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_FACILITY.season IN (?, ?)) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_FACILITY.isOpen = 0 ASC, REPORT_FACILITY.name ASC
Parameters:
[ "object" "ReportFacility" 5116 5117 5118 5120 5122 5123 5124 5125 5127 5129 5130 5131 5132 5133 5134 5135 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 5149 5150 5151 5152 5153 5154 5257 5260 5261 5266 5267 5270 5272 5278 5281 5284 5290 5298 5303 5327 5328 5338 "both" "w" ] |
|
2.01 ms (0.95%) |
15 |
SELECT * FROM object_relations_ft_poiFilter WHERE src_id = ?
Parameters:
[
4988
]
|
|
1.77 ms (0.83%) |
2 |
SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_FACILITY REPORT_FACILITY ON objects.id = REPORT_FACILITY.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_FACILITY.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_FACILITY.season IN (?, ?)) AND (REPORT_FACILITY.isOpen = ?) AND objects.type IN ('object','variant','folder')) AND objects.published = 1
Parameters:
[ "object" "ReportFacility" 5116 5117 5118 5120 5122 5123 5124 5125 5127 5129 5130 5131 5132 5133 5134 5135 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 5149 5150 5151 5152 5153 5154 5257 5260 5261 5266 5267 5270 5272 5278 5281 5284 5290 5298 5303 5327 5328 5338 "both" "w" true ] |
|
1.73 ms (0.82%) |
11 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"REPORT_REGION"
]
|
|
1.58 ms (0.75%) |
2 |
SELECT object_CN_WEATHERSTATION.id as id, object_CN_WEATHERSTATION.type as `type` FROM object_CN_WEATHERSTATION WHERE (( id = ? OR id = ?) AND object_CN_WEATHERSTATION.type IN ('object','variant','folder')) AND object_CN_WEATHERSTATION.published = 1 ORDER BY `altitude` LIMIT 2
Parameters:
[ null null ] |
|
1.12 ms (0.53%) |
1 |
SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_SLOPE.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_SLOPE.season IN (?, ?)) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_SLOPE.isOpen = 0 ASC, REPORT_SLOPE.name ASC
Parameters:
[ "object" "ReportSlope" 6160 6161 6162 6163 6164 6165 6166 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6183 6184 6185 6186 6187 6188 6189 6190 6191 6192 6194 6195 6196 6197 6198 6199 6200 6201 6203 6204 6205 6206 6207 6208 6209 6210 6211 6213 6214 6215 6216 6217 6218 6219 6220 6221 6222 6223 6224 6226 6227 6228 6229 6230 6231 6232 6233 6234 6235 6236 6237 6238 6239 6240 6241 6242 6243 6244 6245 6246 6247 6248 6249 6250 6251 6252 6253 6254 6255 6256 6257 6258 6259 "both" "w" ] |
|
0.92 ms (0.43%) |
1 |
SELECT * FROM object_relations_REPORT_REGION WHERE src_id = ?
Parameters:
[
5009
]
|
|
0.92 ms (0.43%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/kleinwalsertal-live/" "aktuell-geoeffnete-lokale" ] |
|
0.91 ms (0.43%) |
1 |
SELECT objects.id as id, objects.type as `type` FROM objects LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_LIFT.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_LIFT.season IN (?, ?)) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_LIFT.isOpen = 0 ASC, REPORT_LIFT.name ASC
Parameters:
[ "object" "ReportLift" 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5026 5027 5028 5029 5030 5031 5032 5034 5035 5036 5037 5038 5040 5041 5042 5043 5045 5046 5047 5048 5049 5050 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064 "both" "w" ] |
|
0.86 ms (0.41%) |
3 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 85 85 85 ] |
|
0.74 ms (0.35%) |
2 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/kleinwalsertal-live/aktuell-geoeffnete-lokale" "path" "auto_create" "/de/kleinwalsertal-live/aktuell-geoeffnete-lokale?page=10" "path_query" "https://footprint.kleinwalsertal-dev.conecto.rocks/de/kleinwalsertal-live/aktuell-geoeffnete-lokale?page=10" "entire_uri" ] |
|
0.74 ms (0.35%) |
2 |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "weather.default_valley_station" null null ] |
|
0.72 ms (0.34%) |
4 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"ReportLift"
]
|
|
0.66 ms (0.31%) |
3 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 550 550 ] |
|
0.62 ms (0.29%) |
2 |
SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = ?
Parameters:
[
3840
]
|
|
0.59 ms (0.28%) |
3 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
85
]
|
|
0.58 ms (0.27%) |
1 |
SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_SLOPE.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_SLOPE.season IN (?, ?)) AND (REPORT_SLOPE.isOpen = ?) AND objects.type IN ('object','variant','folder')) AND objects.published = 1
Parameters:
[ "object" "ReportSlope" 6160 6161 6162 6163 6164 6165 6166 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6183 6184 6185 6186 6187 6188 6189 6190 6191 6192 6194 6195 6196 6197 6198 6199 6200 6201 6203 6204 6205 6206 6207 6208 6209 6210 6211 6213 6214 6215 6216 6217 6218 6219 6220 6221 6222 6223 6224 6226 6227 6228 6229 6230 6231 6232 6233 6234 6235 6236 6237 6238 6239 6240 6241 6242 6243 6244 6245 6246 6247 6248 6249 6250 6251 6252 6253 6254 6255 6256 6257 6258 6259 "both" "w" true ] |
|
0.54 ms (0.26%) |
1 |
SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id WHERE ((objects.type = ?) AND (objects.className = ?) AND (REPORT_LIFT.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (REPORT_LIFT.season IN (?, ?)) AND (REPORT_LIFT.isOpen = ?) AND objects.type IN ('object','variant','folder')) AND objects.published = 1
Parameters:
[ "object" "ReportLift" 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5026 5027 5028 5029 5030 5031 5032 5034 5035 5036 5037 5038 5040 5041 5042 5043 5045 5046 5047 5048 5049 5050 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064 "both" "w" true ] |
|
0.40 ms (0.19%) |
1 |
SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3901 "weatherData" ] |
|
0.38 ms (0.18%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/kleinwalsertal-live/aktuell-geoeffnete-lokale' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.24 ms (0.11%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.19 ms (0.09%) |
1 |
SELECT id FROM website_settings
Parameters:
[] |
|
0.15 ms (0.07%) |
1 |
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:
[
9
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| FormBuilderBundle\Model\OutputWorkflow | No errors. |
| FormBuilderBundle\Model\FormDefinition | No errors. |
| FormBuilderBundle\Model\DoubleOptInSession | No errors. |
| FormBuilderBundle\Model\OutputWorkflowChannel | No errors. |