Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1323.14 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1302.49 ms
(98.44%)

SELECT e.active_collab_task_id, e.active_collab_assignee_name
            FROM error_log e
            LEFT JOIN error_project ep ON e.error_project_id = ep.id
            WHERE e.active_collab_task_id IS NOT NULL
            AND MD5(CONCAT(e.message, COALESCE(e.exception_class, ''), COALESCE(ep.id, 'no_project'))) = ?
            LIMIT 1

Parameters:

[
  "51d790ae0f778749e7a4d3d4e71c1ab2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e.active_collab_task_id,
  e.active_collab_assignee_name
FROM
  error_log e
  LEFT JOIN error_project ep ON e.error_project_id = ep.id
WHERE
  e.active_collab_task_id IS NOT NULL
  AND MD5(
    CONCAT(
      e.message,
      COALESCE(e.exception_class, ''),
      COALESCE(ep.id, 'no_project')
    )
  ) = ?
LIMIT
  1

SELECT e.active_collab_task_id, e.active_collab_assignee_name
            FROM error_log e
            LEFT JOIN error_project ep ON e.error_project_id = ep.id
            WHERE e.active_collab_task_id IS NOT NULL
            AND MD5(CONCAT(e.message, COALESCE(e.exception_class, ''), COALESCE(ep.id, 'no_project'))) = '51d790ae0f778749e7a4d3d4e71c1ab2'
            LIMIT 1
        ;

#	File/Call
1	Dellarocreative\ErrorTrackerBundle\Feature\Storage\Repository\ErrorLogRepository->findActiveCollabTaskInfoByHash (line 854)
2	Dellarocreative\ErrorTrackerBundle\State\ErrorLogProcessor->process (line 67)
3	ApiPlatform\State\CallableProcessor->process (line 52)
4	ApiPlatform\State\Processor\WriteProcessor->process (line 58)
5	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
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)

11.83 ms
(0.89%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.active_collab_id AS active_collab_id_2, e0_.base_url AS base_url_3, e0_.api_key AS api_key_4, e0_.project_key AS project_key_5, e0_.health_check_interval AS health_check_interval_6, e0_.last_health_check AS last_health_check_7, e0_.last_health_check_status AS last_health_check_status_8, e0_.symfony_version AS symfony_version_9, e0_.node_version AS node_version_10, e0_.npm_version AS npm_version_11, e0_.yarn_version AS yarn_version_12, e0_.php_version AS php_version_13, e0_.bootstrap_version AS bootstrap_version_14 FROM error_project e0_ WHERE e0_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.active_collab_id AS active_collab_id_2,
  e0_.base_url AS base_url_3,
  e0_.api_key AS api_key_4,
  e0_.project_key AS project_key_5,
  e0_.health_check_interval AS health_check_interval_6,
  e0_.last_health_check AS last_health_check_7,
  e0_.last_health_check_status AS last_health_check_status_8,
  e0_.symfony_version AS symfony_version_9,
  e0_.node_version AS node_version_10,
  e0_.npm_version AS npm_version_11,
  e0_.yarn_version AS yarn_version_12,
  e0_.php_version AS php_version_13,
  e0_.bootstrap_version AS bootstrap_version_14
FROM
  error_project e0_
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.active_collab_id AS active_collab_id_2, e0_.base_url AS base_url_3, e0_.api_key AS api_key_4, e0_.project_key AS project_key_5, e0_.health_check_interval AS health_check_interval_6, e0_.last_health_check AS last_health_check_7, e0_.last_health_check_status AS last_health_check_status_8, e0_.symfony_version AS symfony_version_9, e0_.node_version AS node_version_10, e0_.npm_version AS npm_version_11, e0_.yarn_version AS yarn_version_12, e0_.php_version AS php_version_13, e0_.bootstrap_version AS bootstrap_version_14 FROM error_project e0_ WHERE e0_.id = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 89)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 107)
9	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 704)
10	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 1200)
11	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 1110)
12	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 559)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 410)
14	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 291)
15	ApiPlatform\JsonLd\Serializer\ItemNormalizer->denormalize (line 239)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 76)
17	Symfony\Component\Serializer\Serializer->denormalize (line 240)
18	Symfony\Component\Serializer\Serializer->deserialize (line 145)
19	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 59)
20	ApiPlatform\State\Provider\DeserializeProvider->provide (line 103)
21	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
22	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
23	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
24	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
25	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
26	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
27	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

5.32 ms
(0.40%)

INSERT INTO error_log (url, user, occurred_at, category, level, message, exception_class, stack_trace, request_data, ip_address, user_agent, resolved, resolved_at, resolved_by, active_collab_task_id, active_collab_assignee_name, slack_channel, slack_ts, error_project_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "https://www.dellarocreative.ch/son1.php"
  null
  "2026-04-18 15:01:21"
  "request"
  "error"
  "No route found for "GET https://www.dellarocreative.ch/son1.php""
  "Symfony\Component\HttpKernel\Exception\NotFoundHttpException"
  """
    Symfony\Component\HttpKernel\Exception\NotFoundHttpException: No route found for "GET https://www.dellarocreative.ch/son1.php" in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/EventListener/RouterListener.php:127\n
    #0 Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:260\n
    #1 Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:220\n
    #2 Symfony\Component\EventDispatcher\EventDispatcher->callListeners() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:56\n
    #3 Symfony\Component\EventDispatcher\EventDispatcher->dispatch() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:157\n
    #4 Symfony\Component\HttpKernel\HttpKernel->handleRaw() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:76\n
    #5 Symfony\Component\HttpKernel\HttpKernel->handle() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/Kernel.php:197\n
    #6 Symfony\Component\HttpKernel\Kernel->handle() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35\n
    #7 Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/autoload_runtime.php:29\n
    #8 require_once() in /var/www/vhosts/dellarocreative.ch/httpdocs/public/index.php:5
    """
  "{"method":"GET","query":[],"request":[],"headers":{"accept-encoding":["gzip, br"],"x-forwarded-proto":["https"],"cf-visitor":["{\"scheme\":\"https\"}"],"cf-ipcountry":["SE"],"cf-connecting-ip":["4.223.172.220"],"cdn-loop":["cloudflare; loops=1"],"cf-ray":["9ee3db937d68c8c4-ARN"],"connection":["close"],"x-accel-internal":["\/internal-nginx-static-location"],"x-forwarded-for":["4.223.172.220"],"x-real-ip":["104.23.221.163"],"host":["www.dellarocreative.ch"],"x-php-ob-level":["0"]}}"
  "104.23.221.163"
  null
  0
  null
  null
  null
  null
  null
  null
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO error_log (
  url, user, occurred_at, category, level,
  message, exception_class, stack_trace,
  request_data, ip_address, user_agent,
  resolved, resolved_at, resolved_by,
  active_collab_task_id, active_collab_assignee_name,
  slack_channel, slack_ts, error_project_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO error_log (url, user, occurred_at, category, level, message, exception_class, stack_trace, request_data, ip_address, user_agent, resolved, resolved_at, resolved_by, active_collab_task_id, active_collab_assignee_name, slack_channel, slack_ts, error_project_id) VALUES ('https://www.dellarocreative.ch/son1.php', NULL, '2026-04-18 15:01:21', 'request', 'error', 'No route found for \"GET https://www.dellarocreative.ch/son1.php\"', 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException', 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException: No route found for \"GET https://www.dellarocreative.ch/son1.php\" in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/EventListener/RouterListener.php:127
#0 Symfony\\Component\\HttpKernel\\EventListener\\RouterListener->onKernelRequest() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:260
#1 Symfony\\Component\\EventDispatcher\\EventDispatcher::Symfony\\Component\\EventDispatcher\\{closure}() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:220
#2 Symfony\\Component\\EventDispatcher\\EventDispatcher->callListeners() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:56
#3 Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:157
#4 Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:76
#5 Symfony\\Component\\HttpKernel\\HttpKernel->handle() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/http-kernel/Kernel.php:197
#6 Symfony\\Component\\HttpKernel\\Kernel->handle() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35
#7 Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run() in /var/www/vhosts/dellarocreative.ch/httpdocs/vendor/autoload_runtime.php:29
#8 require_once() in /var/www/vhosts/dellarocreative.ch/httpdocs/public/index.php:5', '{\"method\":\"GET\",\"query\":[],\"request\":[],\"headers\":{\"accept-encoding\":[\"gzip, br\"],\"x-forwarded-proto\":[\"https\"],\"cf-visitor\":[\"{\\\"scheme\\\":\\\"https\\\"}\"],\"cf-ipcountry\":[\"SE\"],\"cf-connecting-ip\":[\"4.223.172.220\"],\"cdn-loop\":[\"cloudflare; loops=1\"],\"cf-ray\":[\"9ee3db937d68c8c4-ARN\"],\"connection\":[\"close\"],\"x-accel-internal\":[\"\\/internal-nginx-static-location\"],\"x-forwarded-for\":[\"4.223.172.220\"],\"x-real-ip\":[\"104.23.221.163\"],\"host\":[\"www.dellarocreative.ch\"],\"x-php-ob-level\":[\"0\"]}}', '104.23.221.163', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Dellarocreative\ErrorTrackerBundle\State\ErrorLogProcessor->process (line 77)
7	ApiPlatform\State\CallableProcessor->process (line 52)
8	ApiPlatform\State\Processor\WriteProcessor->process (line 58)
9	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.04 ms
(0.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_collab_id AS active_collab_id_3, t0.base_url AS base_url_4, t0.api_key AS api_key_5, t0.project_key AS project_key_6, t0.health_check_interval AS health_check_interval_7, t0.last_health_check AS last_health_check_8, t0.last_health_check_status AS last_health_check_status_9, t0.symfony_version AS symfony_version_10, t0.node_version AS node_version_11, t0.npm_version AS npm_version_12, t0.yarn_version AS yarn_version_13, t0.php_version AS php_version_14, t0.bootstrap_version AS bootstrap_version_15 FROM error_project t0 WHERE t0.project_key = ? LIMIT 1

Parameters:

[
  "dellarocreative"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active_collab_id AS active_collab_id_3,
  t0.base_url AS base_url_4,
  t0.api_key AS api_key_5,
  t0.project_key AS project_key_6,
  t0.health_check_interval AS health_check_interval_7,
  t0.last_health_check AS last_health_check_8,
  t0.last_health_check_status AS last_health_check_status_9,
  t0.symfony_version AS symfony_version_10,
  t0.node_version AS node_version_11,
  t0.npm_version AS npm_version_12,
  t0.yarn_version AS yarn_version_13,
  t0.php_version AS php_version_14,
  t0.bootstrap_version AS bootstrap_version_15
FROM
  error_project t0
WHERE
  t0.project_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active_collab_id AS active_collab_id_3, t0.base_url AS base_url_4, t0.api_key AS api_key_5, t0.project_key AS project_key_6, t0.health_check_interval AS health_check_interval_7, t0.last_health_check AS last_health_check_8, t0.last_health_check_status AS last_health_check_status_9, t0.symfony_version AS symfony_version_10, t0.node_version AS node_version_11, t0.npm_version AS npm_version_12, t0.yarn_version AS yarn_version_13, t0.php_version AS php_version_14, t0.bootstrap_version AS bootstrap_version_15 FROM error_project t0 WHERE t0.project_key = 'dellarocreative' 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	Dellarocreative\ErrorTrackerBundle\Repository\ErrorProjectRepository->findOneByProjectKey (line 47)
5	Dellarocreative\ErrorTrackerBundle\Security\ApiKeyAuthenticator->validateGlobalMode (line 100)
6	Dellarocreative\ErrorTrackerBundle\Security\ApiKeyAuthenticator->onKernelRequest (line 73)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.15 ms
(0.09%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Dellarocreative\ErrorTrackerBundle\State\ErrorLogProcessor->process (line 77)
4	ApiPlatform\State\CallableProcessor->process (line 52)
5	ApiPlatform\State\Processor\WriteProcessor->process (line 58)
6	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.31 ms
(0.02%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Dellarocreative\ErrorTrackerBundle\State\ErrorLogProcessor->process (line 77)
4	ApiPlatform\State\CallableProcessor->process (line 52)
5	ApiPlatform\State\Processor\WriteProcessor->process (line 58)
6	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
wpmain	doctrine.dbal.wpmain_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
wpmain	doctrine.orm.wpmain_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Dellarocreative\ErrorTrackerBundle\Shared\Entity\ErrorProject	1
Dellarocreative\ErrorTrackerBundle\Shared\Entity\ErrorLog	1

wpmain entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
Dellarocreative\ErrorTrackerBundle\Shared\Entity\ErrorLog	No errors.
Dellarocreative\ErrorTrackerBundle\Shared\Entity\ErrorProject	No errors.

wpmain entity manager

No loaded entities.

Symfony Profiler

POST https://manager.dellarocreative.ch/api/error_logs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

wpmain entity manager

Entities Mapping

default entity manager

wpmain entity manager