Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.56 ms Query time

2 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.36 ms
(38.19%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Services\CalendarTools->refreshCalendarGoogle (line 207)
5	App\Controller\CalendarController->googleWebhook (line 248)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.91 ms
(25.47%)

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_type AS entity_type_3, t0.name AS name_4, t0.login AS login_5, t0.passwd AS passwd_6, t0.profile AS profile_7, t0.notification_mail AS notification_mail_8, t0.view_support AS view_support_9, t0.phone AS phone_10, t0.profile_color AS profile_color_11, t0.date_start AS date_start_12, t0.date_end AS date_end_13, t0.active AS active_14, t0.passwd_reset_code AS passwd_reset_code_15, t0.google_api_access_token AS google_api_access_token_16, t0.google_api_refresh_token AS google_api_refresh_token_17, t0.google_api_expires_at AS google_api_expires_at_18, t0.google_calendar_id AS google_calendar_id_19, t0.google_user_email AS google_user_email_20, t0.google_channel_id AS google_channel_id_21, t0.google_channel_resource_id AS google_channel_resource_id_22, t0.google_channel_expires_at AS google_channel_expires_at_23, t0.google_last_sync AS google_last_sync_24, t0.purchaser_id AS purchaser_id_25 FROM dm_site_admin_user t0 WHERE t0.google_channel_id = ? AND t0.google_channel_resource_id = ? LIMIT 1

Parameters:

[
  "ch_8b731c45513e85f42578c0c1301c8e97"
  "yPY9xF3DjgR1MDUE1rZ54Fap1FM"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.entity_type AS entity_type_3,
  t0.name AS name_4,
  t0.login AS login_5,
  t0.passwd AS passwd_6,
  t0.profile AS profile_7,
  t0.notification_mail AS notification_mail_8,
  t0.view_support AS view_support_9,
  t0.phone AS phone_10,
  t0.profile_color AS profile_color_11,
  t0.date_start AS date_start_12,
  t0.date_end AS date_end_13,
  t0.active AS active_14,
  t0.passwd_reset_code AS passwd_reset_code_15,
  t0.google_api_access_token AS google_api_access_token_16,
  t0.google_api_refresh_token AS google_api_refresh_token_17,
  t0.google_api_expires_at AS google_api_expires_at_18,
  t0.google_calendar_id AS google_calendar_id_19,
  t0.google_user_email AS google_user_email_20,
  t0.google_channel_id AS google_channel_id_21,
  t0.google_channel_resource_id AS google_channel_resource_id_22,
  t0.google_channel_expires_at AS google_channel_expires_at_23,
  t0.google_last_sync AS google_last_sync_24,
  t0.purchaser_id AS purchaser_id_25
FROM
  dm_site_admin_user t0
WHERE
  t0.google_channel_id = ?
  AND t0.google_channel_resource_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.entity_type AS entity_type_3, t0.name AS name_4, t0.login AS login_5, t0.passwd AS passwd_6, t0.profile AS profile_7, t0.notification_mail AS notification_mail_8, t0.view_support AS view_support_9, t0.phone AS phone_10, t0.profile_color AS profile_color_11, t0.date_start AS date_start_12, t0.date_end AS date_end_13, t0.active AS active_14, t0.passwd_reset_code AS passwd_reset_code_15, t0.google_api_access_token AS google_api_access_token_16, t0.google_api_refresh_token AS google_api_refresh_token_17, t0.google_api_expires_at AS google_api_expires_at_18, t0.google_calendar_id AS google_calendar_id_19, t0.google_user_email AS google_user_email_20, t0.google_channel_id AS google_channel_id_21, t0.google_channel_resource_id AS google_channel_resource_id_22, t0.google_channel_expires_at AS google_channel_expires_at_23, t0.google_last_sync AS google_last_sync_24, t0.purchaser_id AS purchaser_id_25 FROM dm_site_admin_user t0 WHERE t0.google_channel_id = 'ch_8b731c45513e85f42578c0c1301c8e97' AND t0.google_channel_resource_id = 'yPY9xF3DjgR1MDUE1rZ54Fap1FM' 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	App\Controller\CalendarController->googleWebhook (line 233)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.73 ms
(20.42%)

UPDATE dm_site_admin_user SET google_last_sync = ? WHERE id = ?

Parameters:

[
  "2026-04-17 14:54:44"
  6
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  dm_site_admin_user
SET
  google_last_sync = ?
WHERE
  id = ?

UPDATE dm_site_admin_user SET google_last_sync = '2026-04-17 14:54:44' WHERE id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Services\CalendarTools->refreshCalendarGoogle (line 207)
7	App\Controller\CalendarController->googleWebhook (line 248)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.57 ms
(15.93%)

"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	App\Services\CalendarTools->refreshCalendarGoogle (line 207)
4	App\Controller\CalendarController->googleWebhook (line 248)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\SiteAdminUser	1
App\Entity\LibPurchaser	1

Entities Mapping

Class	Mapping errors
App\Entity\SiteAdminUser	No errors.
App\Entity\LibPurchaser	No errors.
App\Entity\ConfigManager	No errors.
App\Entity\SitePage	No errors.
App\Entity\LibCompanyContact	No errors.
App\Entity\LibCompany	The association App\Entity\LibCompany#billing_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist. The association App\Entity\LibCompany#shipping_country refers to the inverse side field App\Entity\LibCountry#libCompanies which does not exist.
App\Entity\FormQuotationInvoice	No errors.
App\Entity\FormLicence	The association App\Entity\FormLicence#licence_expires refers to the inverse side field App\Entity\LibLicenceExpires#formLicenses which does not exist.
App\Entity\LibCompanyDocument	No errors.
App\Entity\LibPurchaserDocument	No errors.
App\Entity\FormTask	No errors.
App\Entity\FormProject	No errors.
App\Entity\FormNotificationUser	No errors.

Symfony Profiler

POST https://oomai.app/manager/calendar/google/webhook

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping