Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

5.42 ms Query time

2 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.85 ms
(34.14%)

"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\GoogleCalendarTools->getClientForUser (line 100)
5	App\Services\GoogleCalendarTools->listEvents (line 190)
6	App\Services\CalendarTools->refreshCalendarGoogle (line 152)
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)

1.14 ms
(20.97%)

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_0c47dd403acc76ec8d4c487480e9fa95"
  "MNE-KcqCfapMEVDT1YfND4obUHU"
]

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_0c47dd403acc76ec8d4c487480e9fa95' AND t0.google_channel_resource_id = 'MNE-KcqCfapMEVDT1YfND4obUHU' 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.95 ms
(17.48%)

"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\GoogleCalendarTools->getClientForUser (line 100)
4	App\Services\GoogleCalendarTools->listEvents (line 190)
5	App\Services\CalendarTools->refreshCalendarGoogle (line 152)
6	App\Controller\CalendarController->googleWebhook (line 248)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.90 ms
(16.63%)

UPDATE dm_site_admin_user SET google_api_access_token = ?, google_api_expires_at = ? WHERE id = ?

Parameters:

[
  "{"access_token":"ya29.a0AX07Cms9UQPZus0sP4QD2wQq-NoBCTBpJGnJHWYVf5sr6qpIbmR17JR3ee0xYCxMpblZ871OOpx4Htz7sItLv_x1LpTwpi15bcqMdM8J7-FF2lHIKHALTNm6ga1C271gHpcnCNNB-5xDUHeLma9bbsf4goRoU890vZOMyNXjylOvKeKTm9x7NWOHrDMEru7cgKH6EjfKdQaCgYKAR8SARQSFQHGX2MiZfRrve36OHnErT23Sgxr6A0209","expires_in":3599,"scope":"openid https:\/\/www.googleapis.com\/auth\/calendar https:\/\/www.googleapis.com\/auth\/userinfo.email","token_type":"Bearer","id_token":"eyJhbGciOiJSUzI1NiIsImtpZCI6ImYxMGY4NzQwNWE5NzljMWRmMzZkZjI2NjA2NzM0ZjMzY2Q4NWMyNzEiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI0MjI5NDgyNDcyMjItNTRrN2FrdWE4bmlicGZyMWxkdjdlN2JtazllanRyaWQuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI0MjI5NDgyNDcyMjItNTRrN2FrdWE4bmlicGZyMWxkdjdlN2JtazllanRyaWQuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMDI0NzE3ODY0NjU3NDgwOTUwMzciLCJlbWFpbCI6Imp1bGllQHN1Ym90YWkuZnIiLCJlbWFpbF92ZXJpZmllZCI6dHJ1ZSwiYXRfaGFzaCI6IkN3OXh2VGp3UkpfQWlKSkxwcTRxUVEiLCJpYXQiOjE3OTA2NzI3NzcsImV4cCI6MTc5MDY3NjM3N30.W7OrptPGIYjRW4aYDBWiInnbunWgCWRm16ld75lV35rwLLLc3Ex0Xvofq8Flm5AGq7KJGPS_vTunyIlWkySWT9G3v79dcZor3x67OH-pun6VV6xJUCN9JHrwl9tvP3BimXI1Iz_0F2lUQaXySzdQxCu8fnwYsxPA0rUwzqN8swOKouspbQqOi0XOkOsDEE_wj7XVIaRHx2hSGveG8VJ26RNUX-VMG0p0pPB2dSnstSWG9t4XZ7fBCRxzecZq4rvXopNNjI851XVa94SfWTgCt5wg7x60kmfm_nE0-qCV4palpe_RGmy55-1F2U-j4nlGfveKZFtIBSPtzTvJ5Pphng","created":1790672746,"refresh_token":"1\/\/03kgC4QD7VUshCgYIARAAGAMSNwF-L9IrR5HixnZ6SL8YA1s7jadNQAHjgNYOqEN4yvwzJzmalWENMTqacoLjmp8V2F1llJ8egBc"}"
  "2026-09-29 12:05:45"
  4
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  dm_site_admin_user
SET
  google_api_access_token = ?,
  google_api_expires_at = ?
WHERE
  id = ?

UPDATE dm_site_admin_user SET google_api_access_token = '{\"access_token\":\"ya29.a0AX07Cms9UQPZus0sP4QD2wQq-NoBCTBpJGnJHWYVf5sr6qpIbmR17JR3ee0xYCxMpblZ871OOpx4Htz7sItLv_x1LpTwpi15bcqMdM8J7-FF2lHIKHALTNm6ga1C271gHpcnCNNB-5xDUHeLma9bbsf4goRoU890vZOMyNXjylOvKeKTm9x7NWOHrDMEru7cgKH6EjfKdQaCgYKAR8SARQSFQHGX2MiZfRrve36OHnErT23Sgxr6A0209\",\"expires_in\":3599,\"scope\":\"openid https:\\/\\/www.googleapis.com\\/auth\\/calendar https:\\/\\/www.googleapis.com\\/auth\\/userinfo.email\",\"token_type\":\"Bearer\",\"id_token\":\"eyJhbGciOiJSUzI1NiIsImtpZCI6ImYxMGY4NzQwNWE5NzljMWRmMzZkZjI2NjA2NzM0ZjMzY2Q4NWMyNzEiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI0MjI5NDgyNDcyMjItNTRrN2FrdWE4bmlicGZyMWxkdjdlN2JtazllanRyaWQuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI0MjI5NDgyNDcyMjItNTRrN2FrdWE4bmlicGZyMWxkdjdlN2JtazllanRyaWQuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMDI0NzE3ODY0NjU3NDgwOTUwMzciLCJlbWFpbCI6Imp1bGllQHN1Ym90YWkuZnIiLCJlbWFpbF92ZXJpZmllZCI6dHJ1ZSwiYXRfaGFzaCI6IkN3OXh2VGp3UkpfQWlKSkxwcTRxUVEiLCJpYXQiOjE3OTA2NzI3NzcsImV4cCI6MTc5MDY3NjM3N30.W7OrptPGIYjRW4aYDBWiInnbunWgCWRm16ld75lV35rwLLLc3Ex0Xvofq8Flm5AGq7KJGPS_vTunyIlWkySWT9G3v79dcZor3x67OH-pun6VV6xJUCN9JHrwl9tvP3BimXI1Iz_0F2lUQaXySzdQxCu8fnwYsxPA0rUwzqN8swOKouspbQqOi0XOkOsDEE_wj7XVIaRHx2hSGveG8VJ26RNUX-VMG0p0pPB2dSnstSWG9t4XZ7fBCRxzecZq4rvXopNNjI851XVa94SfWTgCt5wg7x60kmfm_nE0-qCV4palpe_RGmy55-1F2U-j4nlGfveKZFtIBSPtzTvJ5Pphng\",\"created\":1790672746,\"refresh_token\":\"1\\/\\/03kgC4QD7VUshCgYIARAAGAMSNwF-L9IrR5HixnZ6SL8YA1s7jadNQAHjgNYOqEN4yvwzJzmalWENMTqacoLjmp8V2F1llJ8egBc\"}', google_api_expires_at = '2026-09-29 12:05:45' WHERE id = 4;

#	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\GoogleCalendarTools->getClientForUser (line 100)
7	App\Services\GoogleCalendarTools->listEvents (line 190)
8	App\Services\CalendarTools->refreshCalendarGoogle (line 152)
9	App\Controller\CalendarController->googleWebhook (line 248)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.58 ms
(10.77%)

UPDATE dm_site_admin_user SET google_last_sync = ? WHERE id = ?

Parameters:

[
  "2026-09-29 11:05:47"
  4
]

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-09-29 11:05:47' WHERE id = 4;

#	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)

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