Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 20
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Debug
• E-mails
• Notifications
• Configuration

Query Metrics

Queries

Group similar statements

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

[
  "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 = ?
LIMIT
  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 = '1' 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, count(n1_.id) AS sclr_16 FROM nft_metadata n1_ LEFT JOIN template t0_ ON (n1_.template_id = t0_.id) INNER JOIN nft_hub n2_ ON n1_.id = n2_.nft_metadata_id WHERE n1_.nft_collection_id = ? AND n2_.is_minted = 1 GROUP BY t0_.id, t0_.is_catchable, t0_.name, t0_.description, t0_.image_url, t0_.tier, t0_.min_stat, t0_.max_stat, t0_.min_weight, t0_.max_weight, t0_.aux_data, t0_.buy_price, t0_.shop_inventory, t0_.release_at, t0_.max_editions, t0_.lootable, t0_.genus_id, t0_.category_id, t0_.recipe_id, t0_.nft_game_id, t0_.non_nft_game_id ORDER BY t0_.genus_id DESC, t0_.tier DESC

[
  "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,
  count(n1_.id) AS sclr_16
FROM
  nft_metadata n1_
  LEFT JOIN template t0_ ON (n1_.template_id = t0_.id)
  INNER JOIN nft_hub n2_ ON n1_.id = n2_.nft_metadata_id
WHERE
  n1_.nft_collection_id = ?
  AND n2_.is_minted = 1
GROUP BY
  t0_.id,
  t0_.is_catchable,
  t0_.name,
  t0_.description,
  t0_.image_url,
  t0_.tier,
  t0_.min_stat,
  t0_.max_stat,
  t0_.min_weight,
  t0_.max_weight,
  t0_.aux_data,
  t0_.buy_price,
  t0_.shop_inventory,
  t0_.release_at,
  t0_.max_editions,
  t0_.lootable,
  t0_.genus_id,
  t0_.category_id,
  t0_.recipe_id,
  t0_.nft_game_id,
  t0_.non_nft_game_id
ORDER BY
  t0_.genus_id DESC,
  t0_.tier DESC

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, count(n1_.id) AS sclr_16 FROM nft_metadata n1_ LEFT JOIN template t0_ ON (n1_.template_id = t0_.id) INNER JOIN nft_hub n2_ ON n1_.id = n2_.nft_metadata_id WHERE n1_.nft_collection_id = '1' AND n2_.is_minted = 1 GROUP BY t0_.id, t0_.is_catchable, t0_.name, t0_.description, t0_.image_url, t0_.tier, t0_.min_stat, t0_.max_stat, t0_.min_weight, t0_.max_weight, t0_.aux_data, t0_.buy_price, t0_.shop_inventory, t0_.release_at, t0_.max_editions, t0_.lootable, t0_.genus_id, t0_.category_id, t0_.recipe_id, t0_.nft_game_id, t0_.non_nft_game_id ORDER BY t0_.genus_id DESC, t0_.tier DESC;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping