Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.83 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.43 ms
(52.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_street AS address_street_3, t0.address_city AS address_city_4, t0.address_state AS address_state_5, t0.address_country AS address_country_6, t0.address_zip AS address_zip_7, t0.phone AS phone_8, t0.website AS website_9, t0.point_of_contact_firstname AS point_of_contact_firstname_10, t0.point_of_contact_lastname AS point_of_contact_lastname_11, t0.point_of_contact_email AS point_of_contact_email_12, t0.point_of_contact_phone AS point_of_contact_phone_13, t0.enabled AS enabled_14, t0.controller_url AS controller_url_15, t0.pod_name AS pod_name_16, t0.tier_two_key AS tier_two_key_17, t0.price_lvl0 AS price_lvl0_18, t0.price_lvl1 AS price_lvl1_19, t0.price_lvl2 AS price_lvl2_20, t0.price_lvl3 AS price_lvl3_21, t0.price_lvl4 AS price_lvl4_22, t0.price_lvl5 AS price_lvl5_23, t0.price_lvl6 AS price_lvl6_24, t0.price_lvl7 AS price_lvl7_25, t0.price_lvl8 AS price_lvl8_26, t0.price_lvl9 AS price_lvl9_27, t0.stripe_customer_id AS stripe_customer_id_28, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_29, t0.stripe_pm_status AS stripe_pm_status_30, t0.billing_consent_at AS billing_consent_at_31, t0.status AS status_32, t0.t2_internal_auth_type AS t2_internal_auth_type_33, t0.tier_one_id AS tier_one_id_34 FROM tier_two t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address_street AS address_street_3,
  t0.address_city AS address_city_4,
  t0.address_state AS address_state_5,
  t0.address_country AS address_country_6,
  t0.address_zip AS address_zip_7,
  t0.phone AS phone_8,
  t0.website AS website_9,
  t0.point_of_contact_firstname AS point_of_contact_firstname_10,
  t0.point_of_contact_lastname AS point_of_contact_lastname_11,
  t0.point_of_contact_email AS point_of_contact_email_12,
  t0.point_of_contact_phone AS point_of_contact_phone_13,
  t0.enabled AS enabled_14,
  t0.controller_url AS controller_url_15,
  t0.pod_name AS pod_name_16,
  t0.tier_two_key AS tier_two_key_17,
  t0.price_lvl0 AS price_lvl0_18,
  t0.price_lvl1 AS price_lvl1_19,
  t0.price_lvl2 AS price_lvl2_20,
  t0.price_lvl3 AS price_lvl3_21,
  t0.price_lvl4 AS price_lvl4_22,
  t0.price_lvl5 AS price_lvl5_23,
  t0.price_lvl6 AS price_lvl6_24,
  t0.price_lvl7 AS price_lvl7_25,
  t0.price_lvl8 AS price_lvl8_26,
  t0.price_lvl9 AS price_lvl9_27,
  t0.stripe_customer_id AS stripe_customer_id_28,
  t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_29,
  t0.stripe_pm_status AS stripe_pm_status_30,
  t0.billing_consent_at AS billing_consent_at_31,
  t0.status AS status_32,
  t0.t2_internal_auth_type AS t2_internal_auth_type_33,
  t0.tier_one_id AS tier_one_id_34
FROM
  tier_two t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_street AS address_street_3, t0.address_city AS address_city_4, t0.address_state AS address_state_5, t0.address_country AS address_country_6, t0.address_zip AS address_zip_7, t0.phone AS phone_8, t0.website AS website_9, t0.point_of_contact_firstname AS point_of_contact_firstname_10, t0.point_of_contact_lastname AS point_of_contact_lastname_11, t0.point_of_contact_email AS point_of_contact_email_12, t0.point_of_contact_phone AS point_of_contact_phone_13, t0.enabled AS enabled_14, t0.controller_url AS controller_url_15, t0.pod_name AS pod_name_16, t0.tier_two_key AS tier_two_key_17, t0.price_lvl0 AS price_lvl0_18, t0.price_lvl1 AS price_lvl1_19, t0.price_lvl2 AS price_lvl2_20, t0.price_lvl3 AS price_lvl3_21, t0.price_lvl4 AS price_lvl4_22, t0.price_lvl5 AS price_lvl5_23, t0.price_lvl6 AS price_lvl6_24, t0.price_lvl7 AS price_lvl7_25, t0.price_lvl8 AS price_lvl8_26, t0.price_lvl9 AS price_lvl9_27, t0.stripe_customer_id AS stripe_customer_id_28, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_29, t0.stripe_pm_status AS stripe_pm_status_30, t0.billing_consent_at AS billing_consent_at_31, t0.status AS status_32, t0.t2_internal_auth_type AS t2_internal_auth_type_33, t0.tier_one_id AS tier_one_id_34 FROM tier_two t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\TierTwo\TierTwoController->sysopGetAllTierTwos (line 216)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.39 ms
(47.71%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_key = ? AND t0.revoked_at IS NULL LIMIT 1

Parameters:

[
  "7ed91564-2836-4662-870c-097e629d613d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.identifier AS identifier_3,
  t0.api_name AS api_name_4,
  t0.created_at AS created_at_5,
  t0.revoked_at AS revoked_at_6,
  t0.type AS type_7,
  t0.url AS url_8
FROM
  api_keys t0
WHERE
  t0.api_key = ?
  AND t0.revoked_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_key = '7ed91564-2836-4662-870c-097e629d613d' AND t0.revoked_at IS NULL 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	LoremIpsumDev\LoremAuthBundle\Service\ApiKeyManager->validateApiKey (line 58)
5	App\Controller\TierTwo\TierTwoController->sysopGetAllTierTwos (line 206)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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\Entity\TierTwo	5
LoremIpsumDev\LoremAuthBundle\Entity\ApiKey	1
App\Entity\TierOne	1

Entities Mapping

Class	Mapping errors
LoremIpsumDev\LoremAuthBundle\Entity\ApiKey	No errors.
App\Entity\TierTwo	No errors.
App\Entity\TierOne	No errors.
App\Entity\Pod	No errors.
App\Entity\TierTwoSetting	No errors.

Symfony Profiler

GET https://zadfxwtk.ap2t.ing/sysop/tierTwo/all

Configuration Settings

Theme

Page Width