Symfony Profiler

Query Metrics

30 Database Queries

6 Different statements

9.82 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.62 ms
(77.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.origin AS origin_3, t0.wins AS wins_4, t0.loses AS loses_5, t0.category AS category_6, t0.ufc_page_link AS ufc_page_link_7, t0.nick_name AS nick_name_8, t0.draws AS draws_9 FROM fighter t0 WHERE t0.id = ?

Parameters:

[
  167
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.origin AS origin_3,
  t0.wins AS wins_4,
  t0.loses AS loses_5,
  t0.category AS category_6,
  t0.ufc_page_link AS ufc_page_link_7,
  t0.nick_name AS nick_name_8,
  t0.draws AS draws_9
FROM
  fighter t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.origin AS origin_3, t0.wins AS wins_4, t0.loses AS loses_5, t0.category AS category_6, t0.ufc_page_link AS ufc_page_link_7, t0.nick_name AS nick_name_8, t0.draws AS draws_9 FROM fighter t0 WHERE t0.id = 167;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Fighter::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Fighter->__get (line 99)
8	App\Entity\Fighter->getName (line 50)
9	App\Controller\EventFindByGroupController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.52 ms
(5.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.access_code AS access_code_5, t0.expirate_date AS expirate_date_6, t0.leader_id AS leader_id_7 FROM betting_group t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.creation_date AS creation_date_4,
  t0.access_code AS access_code_5,
  t0.expirate_date AS expirate_date_6,
  t0.leader_id AS leader_id_7
FROM
  betting_group t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.creation_date AS creation_date_4, t0.access_code AS access_code_5, t0.expirate_date AS expirate_date_6, t0.leader_id AS leader_id_7 FROM betting_group t0 WHERE t0.id = '7' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 17)
5	App\Controller\EventFindByGroupController->__invoke (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)

0.52 ms
(5.26%)

SELECT t0.id AS id_1, t0.decision AS decision_2, t0.total_round AS total_round_3, t0.odds_fighter_red AS odds_fighter_red_4, t0.odds_fighter_blue AS odds_fighter_blue_5, t0.odds_fighter_red_decimal AS odds_fighter_red_decimal_6, t0.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_7, t0.fighter_red_id AS fighter_red_id_8, t0.fighter_blue_id AS fighter_blue_id_9, t0.event_id AS event_id_10, t0.winner_id AS winner_id_11 FROM fights t0 WHERE t0.event_id = ?

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.decision AS decision_2,
  t0.total_round AS total_round_3,
  t0.odds_fighter_red AS odds_fighter_red_4,
  t0.odds_fighter_blue AS odds_fighter_blue_5,
  t0.odds_fighter_red_decimal AS odds_fighter_red_decimal_6,
  t0.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_7,
  t0.fighter_red_id AS fighter_red_id_8,
  t0.fighter_blue_id AS fighter_blue_id_9,
  t0.event_id AS event_id_10,
  t0.winner_id AS winner_id_11
FROM
  fights t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.decision AS decision_2, t0.total_round AS total_round_3, t0.odds_fighter_red AS odds_fighter_red_4, t0.odds_fighter_blue AS odds_fighter_blue_5, t0.odds_fighter_red_decimal AS odds_fighter_red_decimal_6, t0.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_7, t0.fighter_red_id AS fighter_red_id_8, t0.fighter_blue_id AS fighter_blue_id_9, t0.event_id AS event_id_10, t0.winner_id AS winner_id_11 FROM fights t0 WHERE t0.event_id = 89;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 45)
8	App\Controller\EventFindByGroupController->__invoke (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.44 ms
(4.45%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 INNER JOIN betting_group_user ON t0.id = betting_group_user.user_id WHERE betting_group_user.betting_group_id = ?

Parameters:

[
  7
]

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.google_id AS google_id_5,
  t0.full_name AS full_name_6,
  t0.nickname AS nickname_7,
  t0.avatar AS avatar_8
FROM
  user t0
  INNER JOIN betting_group_user ON t0.id = betting_group_user.user_id
WHERE
  betting_group_user.betting_group_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 INNER JOIN betting_group_user ON t0.id = betting_group_user.user_id WHERE betting_group_user.betting_group_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 27)
8	App\Controller\EventFindByGroupController->__invoke (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.37 ms
(3.73%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

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.google_id AS google_id_5,
  t0.full_name AS full_name_6,
  t0.nickname AS nickname_7,
  t0.avatar AS avatar_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\User->__get (line 189)
8	App\Entity\User->getFullName (line 21)
9	App\Controller\EventFindByGroupController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.37 ms
(3.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.date_string AS date_string_4, t0.link_ufc_site AS link_ufc_site_5, t0.location AS location_6 FROM event t0 INNER JOIN betting_group_event ON t0.id = betting_group_event.event_id WHERE betting_group_event.betting_group_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.date_string AS date_string_4,
  t0.link_ufc_site AS link_ufc_site_5,
  t0.location AS location_6
FROM
  event t0
  INNER JOIN betting_group_event ON t0.id = betting_group_event.event_id
WHERE
  betting_group_event.betting_group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.date_string AS date_string_4, t0.link_ufc_site AS link_ufc_site_5, t0.location AS location_6 FROM event t0 INNER JOIN betting_group_event ON t0.id = betting_group_event.event_id WHERE betting_group_event.betting_group_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 37)
8	App\Controller\EventFindByGroupController->__invoke (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
App\Entity\BettingGroup	No errors.
App\Entity\User	The association App\Entity\User#bettingGroupStats refers to the owning side field App\Entity\BettingGroupStats#User which does not exist.
App\Entity\Event	No errors.
App\Entity\Fights	No errors.
App\Entity\Bet	No errors.
App\Entity\BettingGroupStats	The mappings App\Entity\BettingGroupStats#user and App\Entity\User#bettingGroupStats are inconsistent with each other.
App\Entity\Images	No errors.
App\Entity\Fighter	No errors.

Symfony Profiler

GET https://api.mmafriend.com/api/eventFindByGroup/7

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping