Query Metrics
26
Database Queries
8
Different statements
31.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.83 ms (27.85%) |
16 |
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:
[
161
]
|
|
7.83 ms (24.70%) |
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:
[] |
|
6.99 ms (22.05%) |
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:
[
4
]
|
|
2.30 ms (7.24%) |
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.02 ms (6.37%) |
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:
[ 2144 2262 2336 2227 2357 2130 2164 2298 2340 2320 2279 2104 2100 2178 2250 2315 2331 2086 2325 2257 2317 2338 2078 2145 2306 7379 2341 2088 2190 2321 2080 2264 2134 2368 2176 2120 2322 2328 2139 2274 2249 2092 2242 2329 2063 2363 2226 2314 2174 2289 2230 2172 2179 2263 2327 2248 2165 2213 7377 2105 2183 2362 2077 2318 2136 2122 2316 2170 2192 2083 2358 2344 7378 2243 2182 2085 2210 2138 2319 2072 2194 2311 2191 2352 2061 2068 2326 7376 2334 2193 2146 2205 2360 2330 2173 2346 2180 2181 2175 2177 2108 2335 2211 2060 2125 2351 2337 2091 2124 2111 2089 2224 2218 2109 2128 2212 2071 2065 2126 2070 2079 2214 2069 2216 2064 2333 2066 2332 2219 2127 2261 2225 2222 2296 2220 2067 2291 2106 2221 2215 2129 2285 2284 2343 2075 2131 2223 2217 2189 2102 2207 2282 2367 2364 2350 2324 2373 2247 2267 2294 2278 2103 2268 2356 2266 2258 2137 2254 2253 2286 2349 2365 2229 2345 2297 2196 2342 2370 2293 2361 2133 2347 2353 2160 2097 2277 2116 2354 2093 2112 2204 2256 2301 2374 2233 2252 2094 2206 2246 2323 2209 2369 2272 2155 2372 2292 2309 2154 2300 2118 2237 2273 2148 2236 2157 2238 2295 2339 2271 2199 2152 2188 2161 2208 2113 2287 2159 2228 2276 2348 2232 2059 2203 2241 2140 2151 2163 2095 2312 2132 2359 7381 2090 2265 2117 2290 2149 2240 2169 2251 2123 2366 2110 2231 2195 2197 2114 2158 2234 2299 2275 2313 2185 2239 2269 2115 2171 2143 2280 2156 2082 2101 2288 2255 2081 2058 2184 2096 2186 2147 2270 2235 2150 2308 2200 2307 2187 2201 2107 2073 2202 2121 2076 2305 2062 2310 2074 2198 2087 2119 2302 2054 2052 2153 2057 2304 ] |
|
1.89 ms (5.98%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM school_of_magic t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
1.10 ms (3.48%) |
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 89 58 97 69 95 80 70 83 62 54 56 57 84 81 79 91 55 88 82 86 94 96 90 92 85 77 74 76 78 87 93 73 72 71 65 66 22 21 44 20 24 26 36 31 28 32 ] |
|
0.74 ms (2.34%) |
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:
[
4
]
|
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. |