Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.68 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.44 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.last_login AS last_login_9, t0.phone AS phone_10, t0.enabled AS enabled_11, t0.avatar AS avatar_12, t0.deleted_at AS deleted_at_13, t0.banned_at AS banned_at_14, t0.token AS token_15, t0.snippet_email_sent_at AS snippet_email_sent_at_16, t0.totp_secret AS totp_secret_17, t0.is_two_factor_enabled AS is_two_factor_enabled_18, t0.backup_codes AS backup_codes_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.discord_id AS discord_id_22, t0.github_id AS github_id_23, t0.google_id AS google_id_24, t0.facebook_id AS facebook_id_25, t0.apple_id AS apple_id_26, t0.invited_by_id AS invited_by_id_27, t0.company_id AS company_id_28, t0.last_selected_project_id AS last_selected_project_id_29 FROM auth_user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "support@sublimanalytics.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.type AS type_5,
  t0.is_verified AS is_verified_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.last_login AS last_login_9,
  t0.phone AS phone_10,
  t0.enabled AS enabled_11,
  t0.avatar AS avatar_12,
  t0.deleted_at AS deleted_at_13,
  t0.banned_at AS banned_at_14,
  t0.token AS token_15,
  t0.snippet_email_sent_at AS snippet_email_sent_at_16,
  t0.totp_secret AS totp_secret_17,
  t0.is_two_factor_enabled AS is_two_factor_enabled_18,
  t0.backup_codes AS backup_codes_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.discord_id AS discord_id_22,
  t0.github_id AS github_id_23,
  t0.google_id AS google_id_24,
  t0.facebook_id AS facebook_id_25,
  t0.apple_id AS apple_id_26,
  t0.invited_by_id AS invited_by_id_27,
  t0.company_id AS company_id_28,
  t0.last_selected_project_id AS last_selected_project_id_29
FROM
  auth_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.last_login AS last_login_9, t0.phone AS phone_10, t0.enabled AS enabled_11, t0.avatar AS avatar_12, t0.deleted_at AS deleted_at_13, t0.banned_at AS banned_at_14, t0.token AS token_15, t0.snippet_email_sent_at AS snippet_email_sent_at_16, t0.totp_secret AS totp_secret_17, t0.is_two_factor_enabled AS is_two_factor_enabled_18, t0.backup_codes AS backup_codes_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.discord_id AS discord_id_22, t0.github_id AS github_id_23, t0.google_id AS google_id_24, t0.facebook_id AS facebook_id_25, t0.apple_id AS apple_id_26, t0.invited_by_id AS invited_by_id_27, t0.company_id AS company_id_28, t0.last_selected_project_id AS last_selected_project_id_29 FROM auth_user t0 WHERE t0.email = 'support@sublimanalytics.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 55)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

1.23 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line1 AS address_line1_3, t0.address_line2 AS address_line2_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.country AS country_7, t0.vat_number AS vat_number_8, t0.stripe_customer_id AS stripe_customer_id_9, t0.stripe_subscription_id AS stripe_subscription_id_10, t0.stripe_price_id AS stripe_price_id_11, t0.subscription_status AS subscription_status_12, t0.trial_ends_at AS trial_ends_at_13, t0.plan_slug AS plan_slug_14, t0.plan_tier AS plan_tier_15, t0.billing_cycle AS billing_cycle_16, t0.max_projects AS max_projects_17, t0.max_team_members AS max_team_members_18, t0.insights_credits AS insights_credits_19, t0.cancellation_reason AS cancellation_reason_20, t0.cancellation_comment AS cancellation_comment_21, t0.cancelled_at AS cancelled_at_22, t0.cancels_at AS cancels_at_23, t0.retention_discount_used_at AS retention_discount_used_at_24, t0.current_projects AS current_projects_25, t0.current_team_members AS current_team_members_26, t0.used_insights_credits AS used_insights_credits_27, t0.extra_sites AS extra_sites_28, t0.extra_users AS extra_users_29, t0.extra_insights AS extra_insights_30, t0.remove_logo AS remove_logo_31, t0.welcome_modal_seen AS welcome_modal_seen_32, t0.discovery_sources AS discovery_sources_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35 FROM billing_company t0 WHERE t0.id = ?

Parameters:

[
  "019d2b3a-2b17-752b-b348-566112a31873"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address_line1 AS address_line1_3,
  t0.address_line2 AS address_line2_4,
  t0.postal_code AS postal_code_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.vat_number AS vat_number_8,
  t0.stripe_customer_id AS stripe_customer_id_9,
  t0.stripe_subscription_id AS stripe_subscription_id_10,
  t0.stripe_price_id AS stripe_price_id_11,
  t0.subscription_status AS subscription_status_12,
  t0.trial_ends_at AS trial_ends_at_13,
  t0.plan_slug AS plan_slug_14,
  t0.plan_tier AS plan_tier_15,
  t0.billing_cycle AS billing_cycle_16,
  t0.max_projects AS max_projects_17,
  t0.max_team_members AS max_team_members_18,
  t0.insights_credits AS insights_credits_19,
  t0.cancellation_reason AS cancellation_reason_20,
  t0.cancellation_comment AS cancellation_comment_21,
  t0.cancelled_at AS cancelled_at_22,
  t0.cancels_at AS cancels_at_23,
  t0.retention_discount_used_at AS retention_discount_used_at_24,
  t0.current_projects AS current_projects_25,
  t0.current_team_members AS current_team_members_26,
  t0.used_insights_credits AS used_insights_credits_27,
  t0.extra_sites AS extra_sites_28,
  t0.extra_users AS extra_users_29,
  t0.extra_insights AS extra_insights_30,
  t0.remove_logo AS remove_logo_31,
  t0.welcome_modal_seen AS welcome_modal_seen_32,
  t0.discovery_sources AS discovery_sources_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35
FROM
  billing_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line1 AS address_line1_3, t0.address_line2 AS address_line2_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.country AS country_7, t0.vat_number AS vat_number_8, t0.stripe_customer_id AS stripe_customer_id_9, t0.stripe_subscription_id AS stripe_subscription_id_10, t0.stripe_price_id AS stripe_price_id_11, t0.subscription_status AS subscription_status_12, t0.trial_ends_at AS trial_ends_at_13, t0.plan_slug AS plan_slug_14, t0.plan_tier AS plan_tier_15, t0.billing_cycle AS billing_cycle_16, t0.max_projects AS max_projects_17, t0.max_team_members AS max_team_members_18, t0.insights_credits AS insights_credits_19, t0.cancellation_reason AS cancellation_reason_20, t0.cancellation_comment AS cancellation_comment_21, t0.cancelled_at AS cancelled_at_22, t0.cancels_at AS cancels_at_23, t0.retention_discount_used_at AS retention_discount_used_at_24, t0.current_projects AS current_projects_25, t0.current_team_members AS current_team_members_26, t0.used_insights_credits AS used_insights_credits_27, t0.extra_sites AS extra_sites_28, t0.extra_users AS extra_users_29, t0.extra_insights AS extra_insights_30, t0.remove_logo AS remove_logo_31, t0.welcome_modal_seen AS welcome_modal_seen_32, t0.discovery_sources AS discovery_sources_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35 FROM billing_company t0 WHERE t0.id = '019d2b3a-2b17-752b-b348-566112a31873';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Domain\Billing\Entity\Company::isWelcomeModalSeen (line 539)
5	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
6	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
7	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1006)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 197)
9	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 169)
10	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 141)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 1051)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 955)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 197)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 169)
17	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 141)
18	App\Domain\Auth\Serializer\UserNormalizer->normalize (line 25)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Serializer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->serialize (line 131)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
23	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
24	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 191)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	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
App\Domain\Auth\Entity\User	1
App\Domain\Billing\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Domain\Auth\Entity\User	No errors.
App\Domain\Billing\Entity\Company	No errors.
App\Domain\Project\Entity\ProjectSettings	No errors.
App\Domain\Project\Entity\CrawlerSettings	No errors.
App\Domain\Project\Entity\Project	No errors.
App\Domain\Auth\Entity\Connection	No errors.
App\Domain\Project\Entity\ProjectMember	No errors.
App\Domain\Workspace\Entity\Workspace	No errors.

Symfony Profiler

GET http://api.sublimanalytics.com/api/me

Configuration Settings

Theme

Page Width