Symfony Profiler

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

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 = 3 AND n1_.is_minted = 1 ORDER BY n0_.score DESC;

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 (?)

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 (3);

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

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 (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);

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 (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

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 (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);

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

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;

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

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  school_of_magic t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = 4;

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 = ?

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 = 82;