Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.89 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.38 ms

SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_archived AS is_archived_3, t0.price AS price_4, t0.expiration AS expiration_5, t0.__id AS __id_6, t0.permissions_max_users AS permissions_max_users_7, t0.permissions_max_common_meetings AS permissions_max_common_meetings_8, t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9, t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10, t0.permissions_max_participants AS permissions_max_participants_11, t0.permissions_max_duration AS permissions_max_duration_12, t0.permissions_presentation_allowed AS permissions_presentation_allowed_13, t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14, t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15, t0.permissions_polls_allowed AS permissions_polls_allowed_16, t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17, t0.permissions_record_allowed AS permissions_record_allowed_18 FROM tariffs_for_organizations t0 WHERE t0.is_default = ? AND t0.is_archived = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.is_default AS is_default_2,
  t0.is_archived AS is_archived_3,
  t0.price AS price_4,
  t0.expiration AS expiration_5,
  t0.__id AS __id_6,
  t0.permissions_max_users AS permissions_max_users_7,
  t0.permissions_max_common_meetings AS permissions_max_common_meetings_8,
  t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9,
  t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10,
  t0.permissions_max_participants AS permissions_max_participants_11,
  t0.permissions_max_duration AS permissions_max_duration_12,
  t0.permissions_presentation_allowed AS permissions_presentation_allowed_13,
  t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14,
  t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15,
  t0.permissions_polls_allowed AS permissions_polls_allowed_16,
  t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17,
  t0.permissions_record_allowed AS permissions_record_allowed_18
FROM
  tariffs_for_organizations t0
WHERE
  t0.is_default = ?
  AND t0.is_archived = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_archived AS is_archived_3, t0.price AS price_4, t0.expiration AS expiration_5, t0.__id AS __id_6, t0.permissions_max_users AS permissions_max_users_7, t0.permissions_max_common_meetings AS permissions_max_common_meetings_8, t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9, t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10, t0.permissions_max_participants AS permissions_max_participants_11, t0.permissions_max_duration AS permissions_max_duration_12, t0.permissions_presentation_allowed AS permissions_presentation_allowed_13, t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14, t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15, t0.permissions_polls_allowed AS permissions_polls_allowed_16, t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17, t0.permissions_record_allowed AS permissions_record_allowed_18 FROM tariffs_for_organizations t0 WHERE t0.is_default = 1 AND t0.is_archived = 0 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	App\Tariff\Repository\TariffForOrganizationRepository->findOneDefaultTariff (line 29)
5	App\Tariff\Controller\TariffsController->__invoke (line 26)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.51 ms

SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_archived AS is_archived_3, t0.price AS price_4, t0.expiration AS expiration_5, t0.__id AS __id_6, t0.permissions_max_users AS permissions_max_users_7, t0.permissions_max_common_meetings AS permissions_max_common_meetings_8, t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9, t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10, t0.permissions_max_participants AS permissions_max_participants_11, t0.permissions_max_duration AS permissions_max_duration_12, t0.permissions_presentation_allowed AS permissions_presentation_allowed_13, t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14, t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15, t0.permissions_polls_allowed AS permissions_polls_allowed_16, t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17, t0.permissions_record_allowed AS permissions_record_allowed_18 FROM tariffs_for_organizations t0 WHERE t0.is_default = ? AND t0.is_archived = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.is_default AS is_default_2,
  t0.is_archived AS is_archived_3,
  t0.price AS price_4,
  t0.expiration AS expiration_5,
  t0.__id AS __id_6,
  t0.permissions_max_users AS permissions_max_users_7,
  t0.permissions_max_common_meetings AS permissions_max_common_meetings_8,
  t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9,
  t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10,
  t0.permissions_max_participants AS permissions_max_participants_11,
  t0.permissions_max_duration AS permissions_max_duration_12,
  t0.permissions_presentation_allowed AS permissions_presentation_allowed_13,
  t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14,
  t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15,
  t0.permissions_polls_allowed AS permissions_polls_allowed_16,
  t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17,
  t0.permissions_record_allowed AS permissions_record_allowed_18
FROM
  tariffs_for_organizations t0
WHERE
  t0.is_default = ?
  AND t0.is_archived = ?

SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_archived AS is_archived_3, t0.price AS price_4, t0.expiration AS expiration_5, t0.__id AS __id_6, t0.permissions_max_users AS permissions_max_users_7, t0.permissions_max_common_meetings AS permissions_max_common_meetings_8, t0.permissions_personal_meetings_allowed AS permissions_personal_meetings_allowed_9, t0.permissions_max_scheduled_meetings AS permissions_max_scheduled_meetings_10, t0.permissions_max_participants AS permissions_max_participants_11, t0.permissions_max_duration AS permissions_max_duration_12, t0.permissions_presentation_allowed AS permissions_presentation_allowed_13, t0.permissions_screenshare_allowed AS permissions_screenshare_allowed_14, t0.permissions_virtual_backgrounds_allowed AS permissions_virtual_backgrounds_allowed_15, t0.permissions_polls_allowed AS permissions_polls_allowed_16, t0.permissions_breakout_rooms_allowed AS permissions_breakout_rooms_allowed_17, t0.permissions_record_allowed AS permissions_record_allowed_18 FROM tariffs_for_organizations t0 WHERE t0.is_default = 0 AND t0.is_archived = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Tariff\Repository\TariffForOrganizationRepository->findNotDefaultTariffs (line 37)
5	App\Tariff\Controller\TariffsController->__invoke (line 28)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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\Tariff\Entity\TariffForOrganization	4

Entities Mapping

Class	Mapping errors
App\Tariff\Entity\TariffForOrganizationPermissions	No errors.
App\Tariff\Entity\TariffForOrganization	No errors.
App\Tariff\Entity\TariffForOrganizationLogEntry	No errors.

Symfony Profiler

GET https://pre.meethub.sprintf.ru/tariffs

Configuration Settings

Theme

Page Width