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,
  t1_.id AS id_19,
  t1_.is_catchable AS is_catchable_20,
  t1_.name AS name_21,
  t1_.description AS description_22,
  t1_.image_url AS image_url_23,
  t1_.tier AS tier_24,
  t1_.min_stat AS min_stat_25,
  t1_.max_stat AS max_stat_26,
  t1_.min_weight AS min_weight_27,
  t1_.max_weight AS max_weight_28,
  t1_.aux_data AS aux_data_29,
  t1_.buy_price AS buy_price_30,
  t1_.shop_inventory AS shop_inventory_31,
  t1_.release_at AS release_at_32,
  t1_.max_editions AS max_editions_33,
  t1_.lootable AS lootable_34,
  n2_.id AS id_35,
  n2_.ipfs_url AS ipfs_url_36,
  n2_.price AS price_37,
  n2_.is_minted AS is_minted_38,
  n2_.signature AS signature_39,
  n2_.is_confirmed AS is_confirmed_40,
  n2_.script_mint AS script_mint_41,
  m3_.id AS id_42,
  m3_.offer_id AS offer_id_43,
  m3_.price AS price_44,
  m3_.is_accepted AS is_accepted_45,
  m3_.is_canceled AS is_canceled_46,
  m3_.created_at AS created_at_47,
  m3_.updated_at AS updated_at_48,
  m3_.notification_read AS notification_read_49,
  m3_.seller_payout AS seller_payout_50,
  m3_.fee AS fee_51,
  m3_.tx AS tx_52,
  m4_.id AS id_53,
  m4_.item_id AS item_id_54,
  m4_.price AS price_55,
  m4_.is_sold AS is_sold_56,
  m4_.is_canceled AS is_canceled_57,
  m4_.created_at AS created_at_58,
  m4_.updated_at AS updated_at_59,
  m4_.notification_read AS notification_read_60,
  m4_.seller_payout AS seller_payout_61,
  m4_.fee AS fee_62,
  m4_.tx AS tx_63,
  t5_.id AS id_64,
  t5_.address AS address_65,
  t5_.is_approved_for_all_market AS is_approved_for_all_market_66,
  t5_.is_approved_for_all_market2 AS is_approved_for_all_market2_67,
  t5_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_68,
  u6_.id AS id_69,
  u6_.email AS email_70,
  u6_.roles AS roles_71,
  u6_.password AS password_72,
  u6_.game_token AS game_token_73,
  u6_.wallet AS wallet_74,
  u6_.google_id AS google_id_75,
  u6_.username AS username_76,
  u6_.wallet_extension AS wallet_extension_77,
  u6_.config AS config_78,
  u6_.last_recipe_hint AS last_recipe_hint_79,
  u6_.experience AS experience_80,
  u6_.shadow_ban_until AS shadow_ban_until_81,
  u6_.shinies AS shinies_82,
  u6_.game_token2 AS game_token2_83,
  n0_.nft_collection_id AS nft_collection_id_84,
  n0_.template_id AS template_id_85,
  n0_.nft_metadata_quest_id AS nft_metadata_quest_id_86,
  n0_.school_of_magic_id AS school_of_magic_id_87,
  t1_.genus_id AS genus_id_88,
  t1_.category_id AS category_id_89,
  t1_.recipe_id AS recipe_id_90,
  t1_.nft_game_id AS nft_game_id_91,
  t1_.non_nft_game_id AS non_nft_game_id_92,
  n2_.nft_contract_id AS nft_contract_id_93,
  n2_.nft_metadata_id AS nft_metadata_id_94,
  n2_.theta_wallet_id AS theta_wallet_id_95,
  n2_.crate_action_log_id AS crate_action_log_id_96,
  n2_.parent_id AS parent_id_97,
  m3_.nft_contract_id AS nft_contract_id_98,
  m3_.market_contract_id AS market_contract_id_99,
  m3_.nft_hub_id AS nft_hub_id_100,
  m3_.bidder_id AS bidder_id_101,
  m3_.seller_id AS seller_id_102,
  m4_.nft_contract_id AS nft_contract_id_103,
  m4_.market_contract_id AS market_contract_id_104,
  m4_.buyer_id AS buyer_id_105,
  m4_.seller_id AS seller_id_106,
  m4_.nft_hub_id AS nft_hub_id_107,
  u6_.active_wallet_id AS active_wallet_id_108,
  u6_.catchable_queue_id AS catchable_queue_id_109,
  u6_.act_progression_id AS act_progression_id_110,
  u6_.theta_drop_wallet_id AS theta_drop_wallet_id_111
FROM
  nft_metadata n0_
  LEFT JOIN template t1_ ON n0_.template_id = t1_.id
  LEFT JOIN nft_hub n2_ ON n0_.id = n2_.nft_metadata_id
  LEFT JOIN market_offer m3_ ON n2_.id = m3_.nft_hub_id
  LEFT JOIN market_item m4_ ON n2_.id = m4_.nft_hub_id
  LEFT JOIN theta_wallet t5_ ON n2_.theta_wallet_id = t5_.id
  LEFT JOIN user u6_ ON t5_.id = u6_.active_wallet_id
WHERE
  n2_.is_minted = 1
ORDER BY
  n0_.created_at DESC
LIMIT
  4

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, t1_.id AS id_19, t1_.is_catchable AS is_catchable_20, t1_.name AS name_21, t1_.description AS description_22, t1_.image_url AS image_url_23, t1_.tier AS tier_24, t1_.min_stat AS min_stat_25, t1_.max_stat AS max_stat_26, t1_.min_weight AS min_weight_27, t1_.max_weight AS max_weight_28, t1_.aux_data AS aux_data_29, t1_.buy_price AS buy_price_30, t1_.shop_inventory AS shop_inventory_31, t1_.release_at AS release_at_32, t1_.max_editions AS max_editions_33, t1_.lootable AS lootable_34, n2_.id AS id_35, n2_.ipfs_url AS ipfs_url_36, n2_.price AS price_37, n2_.is_minted AS is_minted_38, n2_.signature AS signature_39, n2_.is_confirmed AS is_confirmed_40, n2_.script_mint AS script_mint_41, m3_.id AS id_42, m3_.offer_id AS offer_id_43, m3_.price AS price_44, m3_.is_accepted AS is_accepted_45, m3_.is_canceled AS is_canceled_46, m3_.created_at AS created_at_47, m3_.updated_at AS updated_at_48, m3_.notification_read AS notification_read_49, m3_.seller_payout AS seller_payout_50, m3_.fee AS fee_51, m3_.tx AS tx_52, m4_.id AS id_53, m4_.item_id AS item_id_54, m4_.price AS price_55, m4_.is_sold AS is_sold_56, m4_.is_canceled AS is_canceled_57, m4_.created_at AS created_at_58, m4_.updated_at AS updated_at_59, m4_.notification_read AS notification_read_60, m4_.seller_payout AS seller_payout_61, m4_.fee AS fee_62, m4_.tx AS tx_63, t5_.id AS id_64, t5_.address AS address_65, t5_.is_approved_for_all_market AS is_approved_for_all_market_66, t5_.is_approved_for_all_market2 AS is_approved_for_all_market2_67, t5_.is_approved_for_all_market_crate AS is_approved_for_all_market_crate_68, u6_.id AS id_69, u6_.email AS email_70, u6_.roles AS roles_71, u6_.password AS password_72, u6_.game_token AS game_token_73, u6_.wallet AS wallet_74, u6_.google_id AS google_id_75, u6_.username AS username_76, u6_.wallet_extension AS wallet_extension_77, u6_.config AS config_78, u6_.last_recipe_hint AS last_recipe_hint_79, u6_.experience AS experience_80, u6_.shadow_ban_until AS shadow_ban_until_81, u6_.shinies AS shinies_82, u6_.game_token2 AS game_token2_83, n0_.nft_collection_id AS nft_collection_id_84, n0_.template_id AS template_id_85, n0_.nft_metadata_quest_id AS nft_metadata_quest_id_86, n0_.school_of_magic_id AS school_of_magic_id_87, t1_.genus_id AS genus_id_88, t1_.category_id AS category_id_89, t1_.recipe_id AS recipe_id_90, t1_.nft_game_id AS nft_game_id_91, t1_.non_nft_game_id AS non_nft_game_id_92, n2_.nft_contract_id AS nft_contract_id_93, n2_.nft_metadata_id AS nft_metadata_id_94, n2_.theta_wallet_id AS theta_wallet_id_95, n2_.crate_action_log_id AS crate_action_log_id_96, n2_.parent_id AS parent_id_97, m3_.nft_contract_id AS nft_contract_id_98, m3_.market_contract_id AS market_contract_id_99, m3_.nft_hub_id AS nft_hub_id_100, m3_.bidder_id AS bidder_id_101, m3_.seller_id AS seller_id_102, m4_.nft_contract_id AS nft_contract_id_103, m4_.market_contract_id AS market_contract_id_104, m4_.buyer_id AS buyer_id_105, m4_.seller_id AS seller_id_106, m4_.nft_hub_id AS nft_hub_id_107, u6_.active_wallet_id AS active_wallet_id_108, u6_.catchable_queue_id AS catchable_queue_id_109, u6_.act_progression_id AS act_progression_id_110, u6_.theta_drop_wallet_id AS theta_drop_wallet_id_111 FROM nft_metadata n0_ LEFT JOIN template t1_ ON n0_.template_id = t1_.id LEFT JOIN nft_hub n2_ ON n0_.id = n2_.nft_metadata_id LEFT JOIN market_offer m3_ ON n2_.id = m3_.nft_hub_id LEFT JOIN market_item m4_ ON n2_.id = m4_.nft_hub_id LEFT JOIN theta_wallet t5_ ON n2_.theta_wallet_id = t5_.id LEFT JOIN user u6_ ON t5_.id = u6_.active_wallet_id WHERE n2_.is_minted = 1 ORDER BY n0_.created_at DESC LIMIT 4;

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

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 (7476, 7475, 7474, 7473);

SELECT
  t0_.tier AS tier_0,
  SUM(u1_.caught_qty) AS sclr_1,
  SUM(u1_.convert_nft_qty) AS sclr_2
FROM
  user_record u1_
  LEFT JOIN template t0_ ON (u1_.template_id = t0_.id)
GROUP BY
  t0_.tier
ORDER BY
  t0_.tier ASC

SELECT t0_.tier AS tier_0, SUM(u1_.caught_qty) AS sclr_1, SUM(u1_.convert_nft_qty) AS sclr_2 FROM user_record u1_ LEFT JOIN template t0_ ON (u1_.template_id = t0_.id) GROUP BY t0_.tier ORDER BY t0_.tier ASC;

SELECT
  SUM(u0_.caught_qty) AS sclr_0
FROM
  user_record u0_

SELECT SUM(u0_.caught_qty) AS sclr_0 FROM user_record u0_;

SELECT
  t0_.id AS id_0,
  t0_.is_catchable AS is_catchable_1,
  t0_.name AS name_2,
  t0_.description AS description_3,
  t0_.image_url AS image_url_4,
  t0_.tier AS tier_5,
  t0_.min_stat AS min_stat_6,
  t0_.max_stat AS max_stat_7,
  t0_.min_weight AS min_weight_8,
  t0_.max_weight AS max_weight_9,
  t0_.aux_data AS aux_data_10,
  t0_.buy_price AS buy_price_11,
  t0_.shop_inventory AS shop_inventory_12,
  t0_.release_at AS release_at_13,
  t0_.max_editions AS max_editions_14,
  t0_.lootable AS lootable_15,
  t0_.genus_id AS genus_id_16,
  t0_.category_id AS category_id_17,
  t0_.recipe_id AS recipe_id_18,
  t0_.nft_game_id AS nft_game_id_19,
  t0_.non_nft_game_id AS non_nft_game_id_20
FROM
  template t0_
WHERE
  t0_.is_catchable = 1
  AND t0_.release_at > CURRENT_TIMESTAMP
ORDER BY
  t0_.release_at ASC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.is_catchable AS is_catchable_1, t0_.name AS name_2, t0_.description AS description_3, t0_.image_url AS image_url_4, t0_.tier AS tier_5, t0_.min_stat AS min_stat_6, t0_.max_stat AS max_stat_7, t0_.min_weight AS min_weight_8, t0_.max_weight AS max_weight_9, t0_.aux_data AS aux_data_10, t0_.buy_price AS buy_price_11, t0_.shop_inventory AS shop_inventory_12, t0_.release_at AS release_at_13, t0_.max_editions AS max_editions_14, t0_.lootable AS lootable_15, t0_.genus_id AS genus_id_16, t0_.category_id AS category_id_17, t0_.recipe_id AS recipe_id_18, t0_.nft_game_id AS nft_game_id_19, t0_.non_nft_game_id AS non_nft_game_id_20 FROM template t0_ WHERE t0_.is_catchable = 1 AND t0_.release_at > CURRENT_TIMESTAMP ORDER BY t0_.release_at ASC LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.is_catchable AS is_catchable_1,
  t0_.name AS name_2,
  t0_.description AS description_3,
  t0_.image_url AS image_url_4,
  t0_.tier AS tier_5,
  t0_.min_stat AS min_stat_6,
  t0_.max_stat AS max_stat_7,
  t0_.min_weight AS min_weight_8,
  t0_.max_weight AS max_weight_9,
  t0_.aux_data AS aux_data_10,
  t0_.buy_price AS buy_price_11,
  t0_.shop_inventory AS shop_inventory_12,
  t0_.release_at AS release_at_13,
  t0_.max_editions AS max_editions_14,
  t0_.lootable AS lootable_15,
  t0_.genus_id AS genus_id_16,
  t0_.category_id AS category_id_17,
  t0_.recipe_id AS recipe_id_18,
  t0_.nft_game_id AS nft_game_id_19,
  t0_.non_nft_game_id AS non_nft_game_id_20
FROM
  template t0_
WHERE
  t0_.is_catchable = 1
  AND t0_.release_at < CURRENT_TIMESTAMP
ORDER BY
  t0_.release_at DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.is_catchable AS is_catchable_1, t0_.name AS name_2, t0_.description AS description_3, t0_.image_url AS image_url_4, t0_.tier AS tier_5, t0_.min_stat AS min_stat_6, t0_.max_stat AS max_stat_7, t0_.min_weight AS min_weight_8, t0_.max_weight AS max_weight_9, t0_.aux_data AS aux_data_10, t0_.buy_price AS buy_price_11, t0_.shop_inventory AS shop_inventory_12, t0_.release_at AS release_at_13, t0_.max_editions AS max_editions_14, t0_.lootable AS lootable_15, t0_.genus_id AS genus_id_16, t0_.category_id AS category_id_17, t0_.recipe_id AS recipe_id_18, t0_.nft_game_id AS nft_game_id_19, t0_.non_nft_game_id AS non_nft_game_id_20 FROM template t0_ WHERE t0_.is_catchable = 1 AND t0_.release_at < CURRENT_TIMESTAMP ORDER BY t0_.release_at DESC LIMIT 1;

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

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;