GET https://tkgstage.com/profile/130/sent-offers

Query Metrics

6 Database Queries
6 Different statements
4.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.98 ms
(21.19%)
1
SELECT t0.user_id AS user_id_1, t0.template_category_id AS template_category_id_2, t0.inventory_equipment_id AS inventory_equipment_id_3, t0.nft_metadata_id AS nft_metadata_id_4, t5.id AS id_6, t5.created_at AS created_at_7, t5.creator AS creator_8, t5.name AS name_9, t5.description AS description_10, t5.image_url AS image_url_11, t5.wear AS wear_12, t5.score AS score_13, t5.grade AS grade_14, t5.mint AS mint_15, t5.stat_square AS stat_square_16, t5.stat_circle AS stat_circle_17, t5.stat_diamond AS stat_diamond_18, t5.stat_triangle AS stat_triangle_19, t5.stat_rectangle AS stat_rectangle_20, t5.stat_star AS stat_star_21, t5.stat_heart AS stat_heart_22, t5.stat_octagon AS stat_octagon_23, t5.weight AS weight_24, t5.nft_collection_id AS nft_collection_id_25, t5.template_id AS template_id_26, t5.nft_metadata_quest_id AS nft_metadata_quest_id_27, t5.school_of_magic_id AS school_of_magic_id_28 FROM user_gear t0 LEFT JOIN nft_metadata t5 ON t0.nft_metadata_id = t5.id WHERE t0.user_id = ?
Parameters:
[
  130
]
0.83 ms
(17.99%)
1
SELECT SUM(u0_.caught_qty) AS sclr_0, SUM(u0_.salvage_qty) AS sclr_1, SUM(u0_.convert_nft_qty) AS sclr_2, SUM(u0_.craft_qty) AS sclr_3 FROM user_record u0_ WHERE u0_.user_id = ? GROUP BY u0_.user_id
Parameters:
[
  130
]
0.78 ms
(16.97%)
1
SELECT t0.id AS id_1, t0.offer_id AS offer_id_2, t0.price AS price_3, t0.is_accepted AS is_accepted_4, t0.is_canceled AS is_canceled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.notification_read AS notification_read_8, t0.seller_payout AS seller_payout_9, t0.fee AS fee_10, t0.tx AS tx_11, t0.nft_contract_id AS nft_contract_id_12, t0.market_contract_id AS market_contract_id_13, t0.nft_hub_id AS nft_hub_id_14, t0.bidder_id AS bidder_id_15, t0.seller_id AS seller_id_16 FROM market_offer t0 WHERE t0.bidder_id = ? AND t0.is_accepted = ?
Parameters:
[
  59
  0
]
0.71 ms
(15.34%)
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "130"
]
0.68 ms
(14.74%)
1
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:
[
  59
]
0.63 ms
(13.76%)
1
SELECT p0_.id AS id_0, p0_.required_exp AS required_exp_1, p0_.title AS title_2, p0_.perks AS perks_3 FROM player_rank p0_ WHERE p0_.required_exp <= ? ORDER BY p0_.required_exp DESC LIMIT 1
Parameters:
[
  "122"
]

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\User No errors.
App\Entity\ThetaWallet 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\Recipe No errors.
App\Entity\TemplateCategory No errors.
App\Entity\NftMetadata No errors.
App\Entity\NftCollection No errors.
App\Entity\Template No errors.
App\Entity\NftMetadataQuest No errors.
App\Entity\SchoolOfMagic No errors.
App\Entity\MarketOffer No errors.
App\Entity\NftContract No errors.
App\Entity\NftHub No errors.
App\Entity\PlayerRank No errors.
App\Entity\MarketItem No errors.
App\Entity\WithdrawalLog No errors.
App\Entity\CrateActionLog No errors.