Query Metrics
867
Database Queries
12
Different statements
359.72 ms
Query time
0
Invalid entities
8320
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
337.79 ms (93.90%) |
841 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t6.id AS id_7, t6.content_type AS content_type_8, t6.status AS status_9, t6.created_at AS created_at_10, t6.modified_at AS modified_at_11, t6.published_at AS published_at_12, t6.depublished_at AS depublished_at_13, t6.title AS title_14, t6.list_format AS list_format_15, t6.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t6 ON t0.content_id = t6.id WHERE t0.content_id = ? AND t0.type IN ('generic', 'select', 'checkbox', 'slug', 'filelist', 'collection', 'markdown', 'file', 'email', 'text', 'date', 'block', 'number', 'hidden', 'imagelist', 'data', 'set', 'embed', 'image', 'templateselect', 'html', 'textarea', 'article', 'redactor') ORDER BY t0.sortorder ASC
Parameters:
[
1591
]
|
|
5.71 ms (1.59%) |
2 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[ "desa" "published" 1574 1573 1563 1562 1561 1560 1559 1558 1557 1555 1556 1552 1551 1550 1549 1548 1545 1546 1544 1542 1541 1539 1537 1535 1536 1534 1533 1532 1530 1529 1528 1527 1526 1525 1524 1523 1521 1522 1520 1519 1518 1517 1516 1515 1514 1513 1512 1511 1509 1510 1506 1505 1504 1502 1503 1500 1501 1498 1499 1497 1496 1495 1494 1492 1490 1491 1489 1488 1487 1486 1483 1484 1482 1479 1480 1477 1475 1474 1473 1472 1471 1470 1478 1469 1468 1466 1465 1463 1460 1457 1455 1454 1451 1450 1448 1443 1441 1440 1438 1435 1433 1432 1431 1429 1427 1425 1424 1422 1420 1416 1414 1413 1411 1409 1408 1405 1404 1403 1402 1399 1398 1396 1395 1394 1393 1391 1389 1387 1386 1384 1382 1381 1380 1379 1376 1375 1374 1371 1369 1368 1367 1365 1364 1363 1361 1360 1357 1358 1355 1354 1353 1351 1350 1349 1345 1344 1343 1341 1340 1337 1336 1335 1332 1331 1330 1329 1327 1326 1325 1322 1071 1070 1069 1068 1067 1066 1065 1064 1063 1062 1061 1060 1059 1058 1057 1056 1055 1054 1053 1052 1051 1050 1049 1048 1047 1046 1045 1044 1043 1042 1041 1040 1039 1038 1037 1036 1035 1034 1033 1032 1031 1030 1022 1020 1018 1017 1015 1012 902 888 886 883 882 881 880 877 875 874 872 871 866 865 862 861 859 857 856 854 852 849 848 847 845 844 841 839 838 836 804 803 802 801 800 799 798 797 796 795 794 793 790 789 788 787 786 785 784 783 782 781 780 779 778 777 776 775 774 773 772 771 770 769 768 767 766 765 764 763 762 761 760 759 758 757 756 755 754 753 751 750 749 748 747 746 745 744 743 742 741 740 739 738 737 736 735 734 733 732 731 730 729 728 727 726 725 724 721 714 ] |
|
5.30 ms (1.47%) |
7 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ?) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 1000
Parameters:
[ "wifi-desa" "published" ] |
|
4.02 ms (1.12%) |
7 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[ "wifi-desa" "published" ] |
|
2.24 ms (0.62%) |
1 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[ "wifi-desa" "published" 1591 1590 1589 1588 1587 1586 1572 1571 1569 1568 1567 1564 1565 1553 1554 1547 1543 1540 1538 1508 1485 1476 1462 1459 1453 1446 1442 1437 1423 1418 1415 1410 1406 1390 1385 1377 1373 1356 1348 1342 1339 1334 1328 1323 1321 1320 1312 1311 1310 1309 1308 1307 1306 1305 1304 1303 1302 1301 1300 1298 1297 1296 1295 1294 1293 1292 1291 1290 1289 1288 1287 1286 1284 1282 1280 1279 1278 1277 1276 1274 1273 1272 1270 1269 1268 1267 1263 1259 1256 1242 1235 1229 1223 1218 1211 1207 1202 1198 1194 1191 1184 1181 1178 1169 1164 1163 1155 1152 1148 1144 1141 1134 1124 1121 1117 1114 1112 1106 1099 1095 1091 1087 1083 1080 1076 1074 898 806 752 ] |
|
1.20 ms (0.33%) |
1 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[ "wisata-desa" "published" 1467 1464 1461 1458 1456 1452 1449 1444 1439 1434 1430 1428 1426 1421 1417 1412 1407 1401 1397 1392 1388 1383 1378 1370 1366 1362 1359 1352 1346 1347 1338 1319 1318 1317 1316 ] |
|
0.80 ms (0.22%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[ "pages" "published" ] |
|
0.73 ms (0.20%) |
2 |
SELECT t0.id AS id_1, t0.useragent AS useragent_2, t0.validity AS validity_3, t0.user_id AS user_id_4 FROM bolt_user_auth_token t0 WHERE t0.user_id = ?
Parameters:
[
1
]
|
|
0.68 ms (0.19%) |
1 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[ "kkdmp" "published" 1595 1594 1593 1592 1585 1584 1583 1582 1581 1580 1579 1578 1577 1576 1575 1531 1171 ] |
|
0.62 ms (0.17%) |
2 |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t0.about AS about_13 FROM bolt_user t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
|
0.36 ms (0.10%) |
1 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?, ?, ?) ORDER BY b0_.published_at DESC
Parameters:
[ "pasar-desa" "published" 1315 807 353 ] |
|
0.27 ms (0.08%) |
1 |
SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ WHERE b0_.content_type = ? AND b0_.status = ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters:
[ "bumdes" "published" 920 ] |
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 |
|---|---|
| Bolt\Entity\Field | 7210 |
| Bolt\Entity\Content | 841 |
| Bolt\Entity\UserAuthToken | 267 |
| Bolt\Entity\User | 2 |