Query Metrics
25
Database Queries
8
Different statements
34.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.81 ms (28.31%) |
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:
[
3
]
|
|
8.09 ms (23.33%) |
15 |
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:
[
82
]
|
|
7.42 ms (21.40%) |
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:
[] |
|
2.88 ms (8.32%) |
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 25
Parameters:
[] |
|
2.70 ms (7.80%) |
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:
[ 1946 1952 1900 1932 1930 1923 1902 2007 1991 1956 2046 2033 1886 2003 1917 1985 1986 1984 1964 1953 1888 1951 1884 1937 1931 1821 1955 2013 1950 1966 1836 2028 1908 1975 1945 1898 1934 1962 1974 1872 1899 2036 1954 1941 1994 1958 1987 2001 1845 1939 2035 2008 1927 1910 1971 1965 2051 1913 1889 1960 1963 1922 1926 1948 1973 1936 1890 1909 2015 1995 1837 1852 1856 2038 1893 1911 2049 1957 2034 1891 2044 1938 1959 2026 1961 1942 2029 2018 1989 2037 1915 1977 1981 1982 1904 1858 1189 1822 1806 1859 1980 1933 1919 1849 1839 1191 1979 1810 1983 1824 1921 1842 1814 1187 2050 1885 1901 1988 1861 1920 1916 1847 1809 1978 1862 1801 1848 1843 1853 1616 1771 1846 1929 1815 797 798 1759 1743 1737 1794 1720 1739 795 1146 1647 1708 804 1605 1147 1453 1798 1612 1452 1742 963 1723 1578 1749 1699 1738 1736 1190 1741 1753 1752 1685 1792 1686 1188 1629 1701 1773 1726 1145 1598 1722 799 1607 1788 1664 1645 1693 1769 1695 1735 1744 805 801 1755 803 1698 1669 1582 1750 1682 800 1642 1732 1721 1615 1656 1781 1791 1719 1747 1772 1713 796 1611 1643 1148 1644 1622 802 1740 1696 1700 1816 1758 1614 1667 1751 1618 1702 1594 1619 1680 1716 1646 1762 794 1694 962 1654 1610 1746 1819 1731 1748 1683 1745 1757 1697 1990 1873 1969 1866 1871 1925 1992 2039 1867 2027 1869 1912 1976 1894 2017 1829 1855 1970 1897 2009 1896 1857 2045 1914 1826 1827 1864 1835 1817 2024 2040 1906 2022 1812 2041 1875 1876 1882 1825 1892 1813 1967 1944 1905 1834 1818 1918 1828 2047 1907 1808 1895 2020 1830 2025 2021 1878 1851 1820 1831 2002 1877 1887 1883 2043 1796 1870 1879 1860 1863 1833 1850 2030 2019 1793 1800 1799 1554 1681 1536 1665 1674 1711 1583 1865 2011 1659 1765 2016 2023 1553 1658 1760 1787 1627 1774 1652 1663 1778 1733 2010 1653 1840 1841 1640 1823 1868 1790 1968 1577 1599 1768 1715 1993 1949 1972 1579 1666 1880 1709 1785 1705 1838 1795 1766 1712 1717 1797 1854 1600 1576 1689 1947 1770 1943 1604 1613 1678 1761 1657 1756 1710 1603 1621 1671 1608 1780 1704 1998 1728 1606 1903 1940 1729 1595 1670 1617 1586 1620 1786 1775 1727 1763 2004 1655 1687 1730 1844 1631 1764 1609 1767 2014 1783 1703 1601 1928 1673 1789 1718 1997 1811 1584 1714 1668 1581 1648 1585 1258 1639 1779 1679 1776 1691 1597 1641 1684 1782 1724 1707 1628 1662 1677 1692 2006 1754 1935 1632 1672 1651 1999 1638 1676 1924 1592 1593 2031 1725 1706 2012 1624 1623 1688 1636 1626 1635 1996 1637 1649 1633 1807 1634 1661 1625 1690 1675 2000 1805 1660 1650 1596 1784 ] |
|
1.78 ms (5.15%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
1.28 ms (3.68%) |
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 80 69 81 79 57 62 70 54 55 56 82 76 77 52 74 75 78 73 49 51 47 72 71 68 65 53 50 66 48 25 22 20 24 23 21 41 38 40 39 64 45 27 67 26 16 18 19 17 15 14 35 63 12 9 10 11 8 13 29 28 1 ] |
|
0.70 ms (2.01%) |
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:
[
3
]
|
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. |