Query Metrics
27
Database Queries
8
Different statements
83.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.52 ms (38.93%) |
1 |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.creator AS creator_2, n0_.name AS name_3, n0_.description AS description_4, n0_.image_url AS image_url_5, n0_.wear AS wear_6, n0_.score AS score_7, n0_.grade AS grade_8, n0_.mint AS mint_9, n0_.stat_square AS stat_square_10, n0_.stat_circle AS stat_circle_11, n0_.stat_diamond AS stat_diamond_12, n0_.stat_triangle AS stat_triangle_13, n0_.stat_rectangle AS stat_rectangle_14, n0_.stat_star AS stat_star_15, n0_.stat_heart AS stat_heart_16, n0_.stat_octagon AS stat_octagon_17, n0_.weight AS weight_18, n1_.id AS id_19, n1_.ipfs_url AS ipfs_url_20, n1_.price AS price_21, n1_.is_minted AS is_minted_22, n1_.signature AS signature_23, n1_.is_confirmed AS is_confirmed_24, n1_.script_mint AS script_mint_25, m2_.id AS id_26, m2_.offer_id AS offer_id_27, m2_.price AS price_28, m2_.is_accepted AS is_accepted_29, m2_.is_canceled AS is_canceled_30, m2_.created_at AS created_at_31, m2_.updated_at AS updated_at_32, m2_.notification_read AS notification_read_33, m2_.seller_payout AS seller_payout_34, m2_.fee AS fee_35, m2_.tx AS tx_36, m3_.id AS id_37, m3_.item_id AS item_id_38, m3_.price AS price_39, m3_.is_sold AS is_sold_40, m3_.is_canceled AS is_canceled_41, m3_.created_at AS created_at_42, m3_.updated_at AS updated_at_43, m3_.notification_read AS notification_read_44, m3_.seller_payout AS seller_payout_45, m3_.fee AS fee_46, m3_.tx AS tx_47, n0_.nft_collection_id AS nft_collection_id_48, n0_.template_id AS template_id_49, n0_.nft_metadata_quest_id AS nft_metadata_quest_id_50, n0_.school_of_magic_id AS school_of_magic_id_51, n1_.nft_contract_id AS nft_contract_id_52, n1_.nft_metadata_id AS nft_metadata_id_53, n1_.theta_wallet_id AS theta_wallet_id_54, n1_.crate_action_log_id AS crate_action_log_id_55, n1_.parent_id AS parent_id_56, m2_.nft_contract_id AS nft_contract_id_57, m2_.market_contract_id AS market_contract_id_58, m2_.nft_hub_id AS nft_hub_id_59, m2_.bidder_id AS bidder_id_60, m2_.seller_id AS seller_id_61, m3_.nft_contract_id AS nft_contract_id_62, m3_.market_contract_id AS market_contract_id_63, m3_.buyer_id AS buyer_id_64, m3_.seller_id AS seller_id_65, m3_.nft_hub_id AS nft_hub_id_66 FROM nft_metadata n0_ INNER JOIN nft_hub n1_ ON n0_.id = n1_.nft_metadata_id LEFT JOIN market_offer m2_ ON n1_.id = m2_.nft_hub_id LEFT JOIN market_item m3_ ON n1_.id = m3_.nft_hub_id WHERE n0_.nft_collection_id = ? AND n1_.is_minted = 1 ORDER BY n0_.score DESC
Parameters:
[
1
]
|
|
19.83 ms (23.74%) |
17 |
SELECT t0.id AS id_1, t0.address AS address_2, t0.is_approved_for_all_market AS is_approved_for_all_market_3, t0.is_approved_for_all_market2 AS is_approved_for_all_market2_4, t0.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.game_token AS game_token_11, t6.wallet AS wallet_12, t6.google_id AS google_id_13, t6.username AS username_14, t6.wallet_extension AS wallet_extension_15, t6.config AS config_16, t6.last_recipe_hint AS last_recipe_hint_17, t6.experience AS experience_18, t6.shadow_ban_until AS shadow_ban_until_19, t6.shinies AS shinies_20, t6.game_token2 AS game_token2_21, t6.active_wallet_id AS active_wallet_id_22, t6.catchable_queue_id AS catchable_queue_id_23, t6.act_progression_id AS act_progression_id_24, t6.theta_drop_wallet_id AS theta_drop_wallet_id_25 FROM theta_wallet t0 LEFT JOIN user t6 ON t6.active_wallet_id = t0.id WHERE t0.id = ?
Parameters:
[
48
]
|
|
10.91 ms (13.06%) |
1 |
SELECT t0.id AS id_1, t0.progress AS progress_2, t0.goal AS goal_3, t0.stat_square_mod AS stat_square_mod_4, t0.stat_circle_mod AS stat_circle_mod_5, t0.stat_diamond_mod AS stat_diamond_mod_6, t0.stat_triangle_mod AS stat_triangle_mod_7, t0.stat_rectangle_mod AS stat_rectangle_mod_8, t0.stat_star_mod AS stat_star_mod_9, t0.stat_heart_mod AS stat_heart_mod_10, t0.stat_octagon_mod AS stat_octagon_mod_11, t0.quest_id AS quest_id_12 FROM nft_metadata_quest t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1459 1184 750 1105 1100 680 1402 875 778 1038 1422 1431 991 747 711 1346 1092 1393 893 1183 1122 726 693 1356 694 853 951 1007 1374 1110 1130 774 1017 699 953 731 1073 829 709 1413 1365 718 1027 946 681 1049 712 1338 1434 1021 847 1079 930 845 919 675 727 1096 866 674 867 1416 923 1446 1057 1403 1358 1405 1070 1388 935 1003 1018 1376 926 1067 1124 891 772 1056 863 944 1131 714 1120 1118 1091 1351 670 1036 1060 931 1125 1058 737 1350 736 749 848 1074 783 992 955 1355 740 1421 684 1443 751 1030 1089 1359 787 915 830 929 724 1023 1111 1093 1039 667 1366 779 781 777 722 1037 768 922 1444 1016 1046 687 1389 904 683 997 1415 682 697 994 861 927 996 850 713 1115 1014 1116 835 952 828 872 685 1357 920 775 1185 878 1068 677 763 998 1052 954 843 910 1034 1347 916 761 789 1363 1372 752 1107 925 937 695 1418 885 1436 855 880 1369 723 941 701 1383 700 757 1439 911 886 936 691 759 852 1112 1114 881 895 671 1109 706 1400 851 1020 1044 874 1072 1133 1432 999 868 780 1075 1051 871 924 945 1009 1121 1354 1083 1102 1396 720 746 725 1104 1364 1385 721 689 1031 766 1381 1386 1011 703 1059 1128 760 770 1370 735 756 1085 1360 1373 1339 1391 1063 1367 1380 903 1132 748 1426 666 1001 1401 1032 1404 1054 884 950 1349 1414 826 708 1440 888 1390 869 858 1375 849 728 729 1344 1040 1119 1353 1048 676 717 842 899 940 1424 1428 993 1013 1135 1129 902 1412 840 873 1029 1071 730 710 1055 785 1377 1384 1445 1078 877 755 1053 846 908 933 1441 784 995 1002 1437 742 1127 1006 1368 1438 1098 862 1004 1342 1025 882 702 1065 1134 1379 1420 1433 1005 1000 857 754 1408 1425 1026 1429 1341 1084 1097 905 1041 782 1081 668 769 767 906 1340 705 883 716 900 686 1392 892 918 1387 1108 1012 1015 913 1406 707 1113 1361 1398 901 928 1086 734 743 704 1069 1008 917 773 1126 837 898 745 894 938 762 771 1101 1343 1076 896 1047 1050 1411 942 1028 914 738 1371 1427 665 1099 1106 831 860 678 1399 1348 1362 1410 943 1394 948 664 741 1087 854 1345 765 744 1430 673 776 1062 1397 864 870 688 753 887 696 876 890 1035 1090 907 838 1352 956 764 1082 833 1094 949 1080 663 827 836 1095 1417 939 825 1043 879 758 1435 912 672 698 1077 1019 856 921 715 1395 1409 844 788 841 932 692 786 1024 839 1022 1419 1423 1442 739 947 679 865 834 1066 1033 690 719 1382 1407 1447 832 859 1088 909 1103 934 1061 1064 1117 669 1010 889 1123 1045 897 733 1378 1555 1556 365 366 438 1292 1264 1265 1165 1042 449 362 732 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1157 1158 1281 569 1166 1261 1180 600 641 544 543 1288 1300 1159 1276 1282 553 563 546 646 1262 598 1284 627 632 545 555 633 1283 547 1302 1259 651 1175 625 589 568 572 650 561 570 593 607 645 657 1275 1299 1153 1174 1305 1178 549 609 1272 1289 1161 1173 558 604 618 565 594 642 1267 1151 548 559 648 566 658 614 1260 1304 621 644 1269 1273 1170 639 640 656 1156 564 590 615 617 1293 638 1163 647 1266 562 574 595 655 1303 1167 554 612 1287 573 611 616 1298 601 610 649 1286 556 560 591 1277 1291 596 630 634 1295 1164 1169 542 602 1268 1274 1278 567 652 1294 1270 1155 1168 592 613 654 1307 626 1279 557 571 1171 550 588 1162 1285 599 629 635 1150 653 1263 1280 1172 631 1290 1152 608 1301 636 1271 1297 1160 1177 551 620 552 603 623 605 628 637 597 622 619 1179 606 1306 1149 1154 1296 643 1176 341 334 292 266 258 349 229 234 291 237 215 287 344 300 268 273 336 259 318 343 223 253 233 325 320 255 339 260 345 218 330 213 257 276 302 346 294 286 293 322 231 270 279 290 342 228 355 354 271 220 225 337 232 262 356 289 227 235 335 340 239 319 238 351 226 338 288 269 1218 479 1200 433 807 1228 361 808 523 1229 1230 1207 1203 525 1221 432 1209 1217 1194 491 514 533 518 512 1199 1202 475 484 486 537 815 1193 439 1237 1231 476 489 1236 1224 444 481 488 522 508 519 812 1248 446 816 1245 1220 530 814 1254 1213 1235 437 538 441 822 1215 531 474 485 1232 436 539 482 810 820 1243 1251 817 1247 1249 1257 1206 1212 1238 430 536 819 1211 431 535 440 1233 528 443 480 490 513 526 478 483 510 511 524 806 1256 1225 520 1242 1226 492 516 811 813 1250 1234 1197 1198 1204 428 447 1246 1255 1222 532 1252 427 534 442 487 1205 1196 434 435 529 521 1240 540 1227 1195 1201 821 1210 426 509 517 1192 1239 1214 1216 445 515 1241 809 1208 1219 1253 1223 429 507 818 477 1244 267 274 313 281 314 357 324 348 217 333 321 251 282 203 305 359 277 353 275 347 280 352 326 350 303 358 295 983 973 459 461 977 586 458 463 469 472 970 976 980 964 965 966 587 453 454 462 468 971 982 968 580 581 585 451 452 460 464 466 473 975 985 448 467 470 979 984 584 455 471 972 978 981 967 969 582 450 457 465 579 583 456 974 261 214 245 219 315 224 306 206 216 323 308 298 307 272 283 316 312 331 254 284 332 304 246 247 248 252 309 250 202 360 205 285 296 301 310 222 230 317 256 263 311 221 410 381 391 420 504 1456 367 373 377 383 390 6 89 374 378 385 394 396 401 413 419 424 364 369 371 375 376 382 402 407 495 497 500 1454 93 173 249 108 154 31 105 363 379 392 398 404 406 416 422 493 496 498 499 503 1455 1457 61 100 147 207 157 208 24 66 150 30 60 119 170 39 83 95 79 130 142 370 372 395 397 405 412 423 494 501 13 15 22 29 40 122 134 172 36 54 58 64 110 121 139 5 98 135 18 42 107 160 176 196 242 59 70 91 131 161 180 198 211 8 38 63 166 182 380 393 403 414 418 502 505 1458 16 25 46 67 80 99 109 188 200 244 1 49 116 132 169 187 201 20 35 47 111 137 159 183 204 243 34 112 149 181 4 7 19 78 125 141 175 241 56 84 96 106 114 133 145 199 384 389 399 400 408 409 417 421 2 33 75 129 138 158 178 278 17 26 43 77 90 94 103 164 197 9 62 72 101 189 52 82 86 128 185 327 37 51 120 140 155 167 191 21 27 44 126 171 192 212 411 415 87 152 194 297 23 143 168 28 50 74 81 88 174 184 209 10 97 118 124 153 190 11 73 104 165 193 265 299 328 53 69 151 162 240 329 368 163 65 68 3 41 123 127 45 136 210 55 144 12 57 92 32 48 115 14 85 146 179 117 71 102 264 113 148 186 156 236 195 76 177 ] |
|
10.81 ms (12.94%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.game_token AS game_token_4, u0_.wallet AS wallet_5, u0_.google_id AS google_id_6, u0_.username AS username_7, u0_.wallet_extension AS wallet_extension_8, u0_.config AS config_9, u0_.last_recipe_hint AS last_recipe_hint_10, u0_.experience AS experience_11, u0_.shadow_ban_until AS shadow_ban_until_12, u0_.shinies AS shinies_13, u0_.game_token2 AS game_token2_14, SUM(n1_.score) AS sclr_15, u0_.active_wallet_id AS active_wallet_id_16, u0_.catchable_queue_id AS catchable_queue_id_17, u0_.act_progression_id AS act_progression_id_18, u0_.theta_drop_wallet_id AS theta_drop_wallet_id_19 FROM user u0_ INNER JOIN user_gear u2_ ON u0_.id = u2_.user_id INNER JOIN nft_metadata n1_ ON u2_.nft_metadata_id = n1_.id GROUP BY u0_.id, u0_.email, u0_.roles, u0_.password, u0_.game_token, u0_.wallet, u0_.google_id, u0_.username, u0_.wallet_extension, u0_.config, u0_.last_recipe_hint, u0_.experience, u0_.shadow_ban_until, u0_.shinies, u0_.game_token2, u0_.active_wallet_id, u0_.catchable_queue_id, u0_.act_progression_id, u0_.theta_drop_wallet_id ORDER BY sclr_15 DESC LIMIT 25
Parameters:
[] |
|
3.65 ms (4.37%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
3.27 ms (3.91%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.game_token AS game_token_5, t0.wallet AS wallet_6, t0.google_id AS google_id_7, t0.username AS username_8, t0.wallet_extension AS wallet_extension_9, t0.config AS config_10, t0.last_recipe_hint AS last_recipe_hint_11, t0.experience AS experience_12, t0.shadow_ban_until AS shadow_ban_until_13, t0.shinies AS shinies_14, t0.game_token2 AS game_token2_15, t0.active_wallet_id AS active_wallet_id_16, t0.catchable_queue_id AS catchable_queue_id_17, t0.act_progression_id AS act_progression_id_18, t0.theta_drop_wallet_id AS theta_drop_wallet_id_19 FROM user t0 ORDER BY t0.experience DESC LIMIT 10
Parameters:
[] |
|
1.63 ms (1.95%) |
1 |
SELECT t0.id AS id_1, t0.is_catchable AS is_catchable_2, t0.name AS name_3, t0.description AS description_4, t0.image_url AS image_url_5, t0.tier AS tier_6, t0.min_stat AS min_stat_7, t0.max_stat AS max_stat_8, t0.min_weight AS min_weight_9, t0.max_weight AS max_weight_10, t0.aux_data AS aux_data_11, t0.buy_price AS buy_price_12, t0.shop_inventory AS shop_inventory_13, t0.release_at AS release_at_14, t0.max_editions AS max_editions_15, t0.lootable AS lootable_16, t0.genus_id AS genus_id_17, t0.category_id AS category_id_18, t0.recipe_id AS recipe_id_19, t0.nft_game_id AS nft_game_id_20, t0.non_nft_game_id AS non_nft_game_id_21 FROM template t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 59 58 57 54 55 56 61 60 51 50 52 53 48 22 21 25 20 40 45 41 42 38 46 43 44 39 16 17 19 14 35 33 37 34 36 13 8 12 11 9 10 29 28 30 31 32 4 2 3 5 6 1 ] |
|
0.91 ms (1.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.series AS series_3, t0.image_url AS image_url_4, t0.created_date AS created_date_5, t0.background_folder AS background_folder_6, t0.border_folder AS border_folder_7 FROM nft_collection t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\NftMetadata | No errors. |
| App\Entity\NftHub | No errors. |
| App\Entity\MarketOffer | No errors. |
| App\Entity\MarketItem | No errors. |
| App\Entity\NftCollection | No errors. |
| App\Entity\Template | No errors. |
| App\Entity\NftMetadataQuest | No errors. |
| App\Entity\SchoolOfMagic | No errors. |
| App\Entity\NftContract | No errors. |
| App\Entity\ThetaWallet | No errors. |
| App\Entity\CrateActionLog | No errors. |
| App\Entity\NftTransfer | No errors. |
| App\Entity\TemplateGenus | No errors. |
| App\Entity\TemplateCategory | No errors. |
| App\Entity\Recipe | No errors. |
| App\Entity\Game | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\TemplateMaterialProbability | No errors. |
| App\Entity\Quest | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CatchableQueue | No errors. |
| App\Entity\ActProgression | No errors. |
| App\Entity\InventoryEquipment | No errors. |
| App\Entity\InventoryCatchable | No errors. |
| App\Entity\UserGear | No errors. |
| App\Entity\UserRecord | No errors. |
| App\Entity\InventoryMaterial | No errors. |
| App\Entity\SalvageQueue | No errors. |
| App\Entity\ShopItemPurchases | No errors. |
| App\Entity\WithdrawalLog | No errors. |