Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.76 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(40.06%)

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > ?

Parameters:

[
  "2026-06-18 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  event e0_
  LEFT JOIN fights f1_ ON e0_.id = f1_.event_id
  LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id
  LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id
  LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id
WHERE
  e0_.date > ?

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > '2026-06-18 00:00:00';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 69)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

1.09 ms
(39.67%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.date AS date_2, e0_.date_string AS date_string_3, e0_.link_ufc_site AS link_ufc_site_4, e0_.location AS location_5, f1_.id AS id_6, f1_.decision AS decision_7, f1_.total_round AS total_round_8, f1_.odds_fighter_red AS odds_fighter_red_9, f1_.odds_fighter_blue AS odds_fighter_blue_10, f1_.odds_fighter_red_decimal AS odds_fighter_red_decimal_11, f1_.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_12, f1_.is_main_card AS is_main_card_13, f2_.id AS id_14, f2_.name AS name_15, f2_.origin AS origin_16, f2_.wins AS wins_17, f2_.loses AS loses_18, f2_.category AS category_19, f2_.ufc_page_link AS ufc_page_link_20, f2_.nick_name AS nick_name_21, f2_.draws AS draws_22, f3_.id AS id_23, f3_.name AS name_24, f3_.origin AS origin_25, f3_.wins AS wins_26, f3_.loses AS loses_27, f3_.category AS category_28, f3_.ufc_page_link AS ufc_page_link_29, f3_.nick_name AS nick_name_30, f3_.draws AS draws_31, f4_.id AS id_32, f4_.name AS name_33, f4_.origin AS origin_34, f4_.wins AS wins_35, f4_.loses AS loses_36, f4_.category AS category_37, f4_.ufc_page_link AS ufc_page_link_38, f4_.nick_name AS nick_name_39, f4_.draws AS draws_40, f1_.fighter_red_id AS fighter_red_id_41, f1_.fighter_blue_id AS fighter_blue_id_42, f1_.event_id AS event_id_43, f1_.winner_id AS winner_id_44 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > ? AND e0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY e0_.date ASC

Parameters:

[
  "2026-06-18 00:00:00"
  110
  111
  112
  113
  114
  115
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.date AS date_2,
  e0_.date_string AS date_string_3,
  e0_.link_ufc_site AS link_ufc_site_4,
  e0_.location AS location_5,
  f1_.id AS id_6,
  f1_.decision AS decision_7,
  f1_.total_round AS total_round_8,
  f1_.odds_fighter_red AS odds_fighter_red_9,
  f1_.odds_fighter_blue AS odds_fighter_blue_10,
  f1_.odds_fighter_red_decimal AS odds_fighter_red_decimal_11,
  f1_.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_12,
  f1_.is_main_card AS is_main_card_13,
  f2_.id AS id_14,
  f2_.name AS name_15,
  f2_.origin AS origin_16,
  f2_.wins AS wins_17,
  f2_.loses AS loses_18,
  f2_.category AS category_19,
  f2_.ufc_page_link AS ufc_page_link_20,
  f2_.nick_name AS nick_name_21,
  f2_.draws AS draws_22,
  f3_.id AS id_23,
  f3_.name AS name_24,
  f3_.origin AS origin_25,
  f3_.wins AS wins_26,
  f3_.loses AS loses_27,
  f3_.category AS category_28,
  f3_.ufc_page_link AS ufc_page_link_29,
  f3_.nick_name AS nick_name_30,
  f3_.draws AS draws_31,
  f4_.id AS id_32,
  f4_.name AS name_33,
  f4_.origin AS origin_34,
  f4_.wins AS wins_35,
  f4_.loses AS loses_36,
  f4_.category AS category_37,
  f4_.ufc_page_link AS ufc_page_link_38,
  f4_.nick_name AS nick_name_39,
  f4_.draws AS draws_40,
  f1_.fighter_red_id AS fighter_red_id_41,
  f1_.fighter_blue_id AS fighter_blue_id_42,
  f1_.event_id AS event_id_43,
  f1_.winner_id AS winner_id_44
FROM
  event e0_
  LEFT JOIN fights f1_ ON e0_.id = f1_.event_id
  LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id
  LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id
  LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id
WHERE
  e0_.date > ?
  AND e0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.date AS date_2, e0_.date_string AS date_string_3, e0_.link_ufc_site AS link_ufc_site_4, e0_.location AS location_5, f1_.id AS id_6, f1_.decision AS decision_7, f1_.total_round AS total_round_8, f1_.odds_fighter_red AS odds_fighter_red_9, f1_.odds_fighter_blue AS odds_fighter_blue_10, f1_.odds_fighter_red_decimal AS odds_fighter_red_decimal_11, f1_.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_12, f1_.is_main_card AS is_main_card_13, f2_.id AS id_14, f2_.name AS name_15, f2_.origin AS origin_16, f2_.wins AS wins_17, f2_.loses AS loses_18, f2_.category AS category_19, f2_.ufc_page_link AS ufc_page_link_20, f2_.nick_name AS nick_name_21, f2_.draws AS draws_22, f3_.id AS id_23, f3_.name AS name_24, f3_.origin AS origin_25, f3_.wins AS wins_26, f3_.loses AS loses_27, f3_.category AS category_28, f3_.ufc_page_link AS ufc_page_link_29, f3_.nick_name AS nick_name_30, f3_.draws AS draws_31, f4_.id AS id_32, f4_.name AS name_33, f4_.origin AS origin_34, f4_.wins AS wins_35, f4_.loses AS loses_36, f4_.category AS category_37, f4_.ufc_page_link AS ufc_page_link_38, f4_.nick_name AS nick_name_39, f4_.draws AS draws_40, f1_.fighter_red_id AS fighter_red_id_41, f1_.fighter_blue_id AS fighter_blue_id_42, f1_.event_id AS event_id_43, f1_.winner_id AS winner_id_44 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > '2026-06-18 00:00:00' AND e0_.id IN (110, 111, 112, 113, 114, 115) ORDER BY e0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 88)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.56 ms
(20.27%)

SELECT DISTINCT e0_.id AS id_0, e0_.date AS date_1 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > ? ORDER BY e0_.date ASC LIMIT 30

Parameters:

[
  "2026-06-18 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.date AS date_1
FROM
  event e0_
  LEFT JOIN fights f1_ ON e0_.id = f1_.event_id
  LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id
  LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id
  LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id
WHERE
  e0_.date > ?
ORDER BY
  e0_.date ASC
LIMIT
  30

SELECT DISTINCT e0_.id AS id_0, e0_.date AS date_1 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.date > '2026-06-18 00:00:00' ORDER BY e0_.date ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 88)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Event	No errors.
App\Entity\Fights	No errors.
App\Entity\Fighter	No errors.
App\Entity\Images	No errors.
App\Entity\BettingGroup	No errors.
App\Entity\Bet	No errors.

Symfony Profiler

GET https://api.mmafriend.com/api/events?date%5Bstrictly_after%5D=2026-06-18&itemsPerPage=1&order%5Bdate%5D=asc&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping