Symfony Profiler

Query Metrics

573 Database Queries

31 Different statements

108.66 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Time▼	Count	Info
29.99 ms (27.60%)	217	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
28.83 ms (26.54%)	215	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
9.88 ms (9.09%)	13	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`85`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 85;
5.16 ms (4.75%)	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`] View formatted query View runnable query Explain query 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 SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 3903 AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC ;
3.88 ms (3.57%)	1	SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = ?) AND (`active` = ?) AND object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1 Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ( (`published` = ?) AND (`active` = ?) AND object_localized_ft_poi_en.type IN ('object', 'variant', 'folder') ) AND object_localized_ft_poi_en.published = 1 SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = 1) AND (`active` = 1) AND object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1;
3.46 ms (3.18%)	18	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`888`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 888;
3.45 ms (3.18%)	15	SELECT * FROM object_relations_ft_poiFilter WHERE src_id = ? Parameters: [`4988`] View formatted query View runnable query Explain query SELECT * FROM object_relations_ft_poiFilter WHERE src_id = ? SELECT * FROM object_relations_ft_poiFilter WHERE src_id = 4988;
3.08 ms (2.83%)	1	SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = ?) AND (`active` = ?) AND (object_localized_ft_poi_en.oo_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1 ORDER BY `object_localized_ft_poi_en`.`name` ASC Parameters: [1 1 1328 1356 1358 1359 1360 1361 1362 1363 1365 1366 1367 1368 1369 1376 1379 1380 1383 1384 1385 1386 1388 1394 1397 1399 1400 1401 1403 1404 1408 1409 1410 1411 1416 1418 1419 1420 1422 1423 1425 1426 1427 1428 1430 1432 1433 1435 1438 1442 1450 1451 1453 1455 1456 1457 1459 1460 1463 1464 1466 1467 1468 1469 1470 1471 1473 1474 1475 1476 1477 1481 1485 1486 1488 1492 1493 1494 1495 1496 1497 1498 1499 1500 1503 1506 1508 1511 1515 1516 1517 1518 1519 1522 1523 1525 1526 1528 1530 1534 1535 1538 1539 1540 1541 1542 1543 1544 1545 1547 1548 1550 1557 1561 1566 1567 1570 1572 1574 1575 1578 1580 1582 1583 1584 1585 1588 1590 1591 1593 1594 1597 1598 1599 1600 1602 1603 1604 1605 1606 1607 1608 1611 1613 1615 1616 1617 1622 1623 1624 1626 1629 1630 1631 1632 1633 1634 1637 1638 1639 1640 1643 1644 1646 1647 1648 1650 1651 1653 1654 1657 1661 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1676 1677 1678 1679 1680 1682 1683 1684 1685 1687 1688 1689 1691 1694 1696 1699 1700 1701 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1714 1716 1717 1718 1722 1723 1724 1725 1726 1727 1735 1736 1738 1744 1745 1747 1748 1753 1755 1756 1758 1760 1761 1762 1763 1764 1766 1767 1769 1770 1771 1774 1777 1781 1782 1786 1787 1789 1793 1796 1799 1801 1803 1805 1806 1807 1808 1810 1813 1814 1815 1818 1822 1826 1829 1830 1831 1832 1833 1834 1836 1837 1838 1842 1843 1845 1846 1849 1852 1854 1856 1858 1860 1862 1863 4981 4982 4983 4984 4985 6151 6152 6153 6155 6156] View formatted query View runnable query Explain query SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ( (`published` = ?) AND (`active` = ?) AND ( object_localized_ft_poi_en.oo_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND object_localized_ft_poi_en.type IN ('object', 'variant', 'folder') ) AND object_localized_ft_poi_en.published = 1 ORDER BY `object_localized_ft_poi_en`.`name` ASC SELECT object_localized_ft_poi_en.id as id, object_localized_ft_poi_en.type as `type` FROM object_localized_ft_poi_en WHERE ((`published` = 1) AND (`active` = 1) AND (object_localized_ft_poi_en.oo_id IN (1328, 1356, 1358, 1359, 1360, 1361, 1362, 1363, 1365, 1366, 1367, 1368, 1369, 1376, 1379, 1380, 1383, 1384, 1385, 1386, 1388, 1394, 1397, 1399, 1400, 1401, 1403, 1404, 1408, 1409, 1410, 1411, 1416, 1418, 1419, 1420, 1422, 1423, 1425, 1426, 1427, 1428, 1430, 1432, 1433, 1435, 1438, 1442, 1450, 1451, 1453, 1455, 1456, 1457, 1459, 1460, 1463, 1464, 1466, 1467, 1468, 1469, 1470, 1471, 1473, 1474, 1475, 1476, 1477, 1481, 1485, 1486, 1488, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1503, 1506, 1508, 1511, 1515, 1516, 1517, 1518, 1519, 1522, 1523, 1525, 1526, 1528, 1530, 1534, 1535, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1547, 1548, 1550, 1557, 1561, 1566, 1567, 1570, 1572, 1574, 1575, 1578, 1580, 1582, 1583, 1584, 1585, 1588, 1590, 1591, 1593, 1594, 1597, 1598, 1599, 1600, 1602, 1603, 1604, 1605, 1606, 1607, 1608, 1611, 1613, 1615, 1616, 1617, 1622, 1623, 1624, 1626, 1629, 1630, 1631, 1632, 1633, 1634, 1637, 1638, 1639, 1640, 1643, 1644, 1646, 1647, 1648, 1650, 1651, 1653, 1654, 1657, 1661, 1663, 1664, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1672, 1673, 1676, 1677, 1678, 1679, 1680, 1682, 1683, 1684, 1685, 1687, 1688, 1689, 1691, 1694, 1696, 1699, 1700, 1701, 1703, 1704, 1705, 1706, 1707, 1708, 1709, 1710, 1711, 1712, 1714, 1716, 1717, 1718, 1722, 1723, 1724, 1725, 1726, 1727, 1735, 1736, 1738, 1744, 1745, 1747, 1748, 1753, 1755, 1756, 1758, 1760, 1761, 1762, 1763, 1764, 1766, 1767, 1769, 1770, 1771, 1774, 1777, 1781, 1782, 1786, 1787, 1789, 1793, 1796, 1799, 1801, 1803, 1805, 1806, 1807, 1808, 1810, 1813, 1814, 1815, 1818, 1822, 1826, 1829, 1830, 1831, 1832, 1833, 1834, 1836, 1837, 1838, 1842, 1843, 1845, 1846, 1849, 1852, 1854, 1856, 1858, 1860, 1862, 1863, 4981, 4982, 4983, 4984, 4985, 6151, 6152, 6153, 6155, 6156)) AND object_localized_ft_poi_en.type IN ('object','variant','folder')) AND object_localized_ft_poi_en.published = 1 ORDER BY `object_localized_ft_poi_en`.`name` ASC ;
2.86 ms (2.63%)	18	SELECT customSettings FROM assets WHERE id = ? Parameters: [`888`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 888;
2.47 ms (2.28%)	3	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: [`"/en/kleinwalsertal-live/currently-open-restaurants" "path" "auto_create" "/en/kleinwalsertal-live/currently-open-restaurants?page=5" "path_query" "https://partnerinfo.kleinwalsertal-dev.conecto.rocks/en/kleinwalsertal-live/currently-open-restaurants?page=5" "entire_uri"`] View formatted query View runnable query Explain query 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 SELECT * FROM redirects WHERE ( (source = '/en/kleinwalsertal-live/currently-open-restaurants' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/kleinwalsertal-live/currently-open-restaurants?page=5' AND `type` = 'path_query') OR (source = 'https://partnerinfo.kleinwalsertal-dev.conecto.rocks/en/kleinwalsertal-live/currently-open-restaurants?page=5' AND `type` = 'entire_uri') ) 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;
1.59 ms (1.47%)	11	SELECT name FROM classes WHERE id = ? Parameters: [`"REPORT_REGION"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'REPORT_REGION';
1.32 ms (1.21%)	6	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`550 550`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 550 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 550;
1.26 ms (1.16%)	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"`] View formatted query View runnable query Explain query 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 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 = 'object') AND (objects.className = 'ReportFacility') AND (REPORT_FACILITY.oo_id IN (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)) AND (REPORT_FACILITY.season IN ('both', 'w')) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_FACILITY.isOpen = 0 ASC, REPORT_FACILITY.name ASC;
0.99 ms (0.91%)	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"] View formatted query View runnable query Explain query 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 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 = 'object') AND (objects.className = 'ReportSlope') AND (REPORT_SLOPE.oo_id IN (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)) AND (REPORT_SLOPE.season IN ('both', 'w')) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_SLOPE.isOpen = 0 ASC, REPORT_SLOPE.name ASC;
0.98 ms (0.90%)	3	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`85 550 550`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(85, 550) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 550;
0.96 ms (0.88%)	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`] View formatted query View runnable query Explain query 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 SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_FACILITY REPORT_FACILITY ON objects.id = REPORT_FACILITY.oo_id WHERE ((objects.type = 'object') AND (objects.className = 'ReportFacility') AND (REPORT_FACILITY.oo_id IN (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)) AND (REPORT_FACILITY.season IN ('both', 'w')) AND (REPORT_FACILITY.isOpen = 1) AND objects.type IN ('object','variant','folder')) AND objects.published = 1;
0.95 ms (0.87%)	4	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/kleinwalsertal-live/" "currently-open-restaurants"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/en/kleinwalsertal-live/' AND `key` = BINARY 'currently-open-restaurants';
0.92 ms (0.85%)	1	SELECT * FROM object_relations_REPORT_REGION WHERE src_id = ? Parameters: [`5009`] View formatted query View runnable query Explain query SELECT * FROM object_relations_REPORT_REGION WHERE src_id = ? SELECT * FROM object_relations_REPORT_REGION WHERE src_id = 5009;
0.76 ms (0.70%)	3	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`] View formatted query View runnable query Explain query 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 SELECT * FROM website_settings WHERE name = 'weather.default_valley_station' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
0.74 ms (0.68%)	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"`] View formatted query View runnable query Explain query 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 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 = 'object') AND (objects.className = 'ReportLift') AND (REPORT_LIFT.oo_id IN (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)) AND (REPORT_LIFT.season IN ('both', 'w')) AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY REPORT_LIFT.isOpen = 0 ASC, REPORT_LIFT.name ASC;
0.63 ms (0.58%)	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`] View formatted query View runnable query Explain query 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 SELECT object_CN_WEATHERSTATION.id as id, object_CN_WEATHERSTATION.type as `type` FROM object_CN_WEATHERSTATION WHERE (( id = NULL OR id = NULL) AND object_CN_WEATHERSTATION.type IN ('object','variant','folder')) AND object_CN_WEATHERSTATION.published = 1 ORDER BY `altitude` LIMIT 2;
0.61 ms (0.56%)	4	SELECT id FROM classes WHERE name = ? Parameters: [`"ReportLift"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ReportLift';
0.58 ms (0.53%)	3	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`550`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 550;
0.56 ms (0.52%)	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`] View formatted query View runnable query Explain query 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 SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_LIFT REPORT_LIFT ON objects.id = REPORT_LIFT.oo_id WHERE ((objects.type = 'object') AND (objects.className = 'ReportLift') AND (REPORT_LIFT.oo_id IN (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)) AND (REPORT_LIFT.season IN ('both', 'w')) AND (REPORT_LIFT.isOpen = 1) AND objects.type IN ('object','variant','folder')) AND objects.published = 1;
0.52 ms (0.48%)	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] View formatted query View runnable query Explain query 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 SELECT COUNT(*) FROM objects LEFT JOIN object_REPORT_SLOPE REPORT_SLOPE ON objects.id = REPORT_SLOPE.oo_id WHERE ((objects.type = 'object') AND (objects.className = 'ReportSlope') AND (REPORT_SLOPE.oo_id IN (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)) AND (REPORT_SLOPE.season IN ('both', 'w')) AND (REPORT_SLOPE.isOpen = 1) AND objects.type IN ('object','variant','folder')) AND objects.published = 1;
0.49 ms (0.45%)	2	SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = ? Parameters: [`3840`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = ? SELECT * FROM object_relations_CN_WEATHERSTATION WHERE src_id = 3840;
0.49 ms (0.45%)	3	SELECT * FROM website_settings WHERE id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 35;
0.40 ms (0.37%)	1	SELECT * FROM object_url_slugs WHERE slug = '/en/kleinwalsertal-live/currently-open-restaurants' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/en/kleinwalsertal-live/currently-open-restaurants' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/kleinwalsertal-live/currently-open-restaurants' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.32 ms (0.30%)	2	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
0.30 ms (0.28%)	1	SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`3901 "weatherData"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_Weather_CN_WEATHERDAY WHERE id = 3901 AND fieldname = 'weatherData' ORDER BY `index` ASC;
0.21 ms (0.19%)	1	SELECT mainValue, validTimePeriod, lowerBound, upperBound FROM object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT ORDER BY (upperBound IS NULL AND lowerBound IS NULL) ASC, upperBound DESC, lowerBound DESC; Parameters: [] View formatted query View runnable query Explain query SELECT mainValue, validTimePeriod, lowerBound, upperBound FROM object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT ORDER BY ( upperBound IS NULL AND lowerBound IS NULL ) ASC, upperBound DESC, lowerBound DESC; SELECT mainValue, validTimePeriod, lowerBound, upperBound FROM object_collection_AvalancheDangerRating_CN_AVALANCHEREPORT ORDER BY (upperBound IS NULL AND lowerBound IS NULL) ASC, upperBound DESC, lowerBound DESC; ;

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.

Symfony Profiler

GET https://partnerinfo.kleinwalsertal-dev.conecto.rocks/en/kleinwalsertal-live/currently-open-restaurants?page=5

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping