Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.57 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(100.00%)

SELECT t0.mint AS mint_1, t0.signature AS signature_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.description AS description_5, t0.image_uri AS image_uri_6, t0.metadata_uri AS metadata_uri_7, t0.twitter AS twitter_8, t0.telegram AS telegram_9, t0.bonding_curve AS bonding_curve_10, t0.associated_bonding_curve AS associated_bonding_curve_11, t0.creator AS creator_12, t0.created_timestamp AS created_timestamp_13, t0.raydium_pool AS raydium_pool_14, t0.complete AS complete_15, t0.virtual_sol_reserves AS virtual_sol_reserves_16, t0.virtual_token_reserves AS virtual_token_reserves_17, t0.total_supply AS total_supply_18, t0.website AS website_19, t0.show_name AS show_name_20, t0.king_of_the_hill_timestamp AS king_of_the_hill_timestamp_21, t0.market_cap AS market_cap_22, t0.reply_count AS reply_count_23, t0.last_reply AS last_reply_24, t0.nsfw AS nsfw_25, t0.market_id AS market_id_26, t0.inverted AS inverted_27, t0.is_currently_live AS is_currently_live_28, t0.username AS username_29, t0.profile_image AS profile_image_30, t0.usd_market_cap AS usd_market_cap_31, t0.CreatedAt AS CreatedAt_32, t0.UpdatedAt AS UpdatedAt_33 FROM PumpTokenDetails t0 ORDER BY t0.CreatedAt DESC LIMIT 200

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.mint AS mint_1,
  t0.signature AS signature_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.description AS description_5,
  t0.image_uri AS image_uri_6,
  t0.metadata_uri AS metadata_uri_7,
  t0.twitter AS twitter_8,
  t0.telegram AS telegram_9,
  t0.bonding_curve AS bonding_curve_10,
  t0.associated_bonding_curve AS associated_bonding_curve_11,
  t0.creator AS creator_12,
  t0.created_timestamp AS created_timestamp_13,
  t0.raydium_pool AS raydium_pool_14,
  t0.complete AS complete_15,
  t0.virtual_sol_reserves AS virtual_sol_reserves_16,
  t0.virtual_token_reserves AS virtual_token_reserves_17,
  t0.total_supply AS total_supply_18,
  t0.website AS website_19,
  t0.show_name AS show_name_20,
  t0.king_of_the_hill_timestamp AS king_of_the_hill_timestamp_21,
  t0.market_cap AS market_cap_22,
  t0.reply_count AS reply_count_23,
  t0.last_reply AS last_reply_24,
  t0.nsfw AS nsfw_25,
  t0.market_id AS market_id_26,
  t0.inverted AS inverted_27,
  t0.is_currently_live AS is_currently_live_28,
  t0.username AS username_29,
  t0.profile_image AS profile_image_30,
  t0.usd_market_cap AS usd_market_cap_31,
  t0.CreatedAt AS CreatedAt_32,
  t0.UpdatedAt AS UpdatedAt_33
FROM
  PumpTokenDetails t0
ORDER BY
  t0.CreatedAt DESC
LIMIT
  200

SELECT t0.mint AS mint_1, t0.signature AS signature_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.description AS description_5, t0.image_uri AS image_uri_6, t0.metadata_uri AS metadata_uri_7, t0.twitter AS twitter_8, t0.telegram AS telegram_9, t0.bonding_curve AS bonding_curve_10, t0.associated_bonding_curve AS associated_bonding_curve_11, t0.creator AS creator_12, t0.created_timestamp AS created_timestamp_13, t0.raydium_pool AS raydium_pool_14, t0.complete AS complete_15, t0.virtual_sol_reserves AS virtual_sol_reserves_16, t0.virtual_token_reserves AS virtual_token_reserves_17, t0.total_supply AS total_supply_18, t0.website AS website_19, t0.show_name AS show_name_20, t0.king_of_the_hill_timestamp AS king_of_the_hill_timestamp_21, t0.market_cap AS market_cap_22, t0.reply_count AS reply_count_23, t0.last_reply AS last_reply_24, t0.nsfw AS nsfw_25, t0.market_id AS market_id_26, t0.inverted AS inverted_27, t0.is_currently_live AS is_currently_live_28, t0.username AS username_29, t0.profile_image AS profile_image_30, t0.usd_market_cap AS usd_market_cap_31, t0.CreatedAt AS CreatedAt_32, t0.UpdatedAt AS UpdatedAt_33 FROM PumpTokenDetails t0 ORDER BY t0.CreatedAt DESC LIMIT 200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 26)
5	App\Controller\TokenController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\PumpTokenDetails	The field 'App\Entity\PumpTokenDetails#totalSupply' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\PumpTokenDetails#marketCap' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\PumpTokenDetails#usdMarketCap' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Class

Mapping errors

App\Entity\PumpTokenDetails

The field 'App\Entity\PumpTokenDetails#totalSupply' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
The field 'App\Entity\PumpTokenDetails#marketCap' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
The field 'App\Entity\PumpTokenDetails#usdMarketCap' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://princevega.com/tokens

Configuration Settings

Theme

Page Width