Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.78 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.78 ms	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.address = ? LIMIT 1 Parameters: [`"0xBea1Ab15Aa58782926867298278f3b15A70d0e83"`] View formatted query View runnable query Explain query 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.address = ? LIMIT 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.address = '0xBea1Ab15Aa58782926867298278f3b15A70d0e83' LIMIT 1;

#▲

Time

Info

0.78 ms

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.address = ? LIMIT 1

Parameters:

[
  "0xBea1Ab15Aa58782926867298278f3b15A70d0e83"
]

View formatted query View runnable query Explain query

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.address = ?
LIMIT
  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.address = '0xBea1Ab15Aa58782926867298278f3b15A70d0e83' LIMIT 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\ThetaWallet	No errors.
App\Entity\User	No errors.
App\Entity\CatchableQueue	No errors.
App\Entity\ActProgression	No errors.
App\Entity\NftHub	No errors.
App\Entity\MarketItem	No errors.
App\Entity\MarketOffer	No errors.
App\Entity\WithdrawalLog	No errors.
App\Entity\CrateActionLog	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.

Symfony Profiler

GET https://tkgstage.com/index.php/profile/wallet/0xBea1Ab15Aa58782926867298278f3b15A70d0e83

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping