Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

5.41 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

remote_db connection

Time▼

Count

Info

2.12 ms
(39.14%)

SELECT t0.pennylane_invoice_id AS pennylane_invoice_id_1, t0.pennylane_invoice_label AS pennylane_invoice_label_2, t0.pennylane_invoice_number AS pennylane_invoice_number_3, t0.pennylane_invoice_amount AS pennylane_invoice_amount_4, t0.pennylane_invoice_currency_amount AS pennylane_invoice_currency_amount_5, t0.pennylane_invoice_currency_amount_before_tax AS pennylane_invoice_currency_amount_before_tax_6, t0.pennylane_invoice_tax AS pennylane_invoice_tax_7, t0.pennylane_invoice_currency_tax AS pennylane_invoice_currency_tax_8, t0.pennylane_invoice_remaining_amount_with_tax AS pennylane_invoice_remaining_amount_with_tax_9, t0.pennylane_invoice_remaining_amount_without_tax AS pennylane_invoice_remaining_amount_without_tax_10, t0.pennylane_invoice_filename AS pennylane_invoice_filename_11, t0.pennylane_invoice_date AS pennylane_invoice_date_12, t0.pennylane_invoice_special_mention AS pennylane_invoice_special_mention_13, t0.pennylane_invoice_pdf_invoice_free_text AS pennylane_invoice_pdf_invoice_free_text_14, t0.pennylane_invoice_pdf_description AS pennylane_invoice_pdf_description_15, t0.pennylane_invoice_pdf_invoice_subject AS pennylane_invoice_pdf_invoice_subject_16, t0.pennylane_invoice_extrenal_reference AS pennylane_invoice_extrenal_reference_17, t0.pennylane_invoice_customer_invoice_template_id AS pennylane_invoice_customer_invoice_template_id_18, t0.vtiger_invoice_id AS vtiger_invoice_id_19, t0.vtiger_document_id AS vtiger_document_id_20, t0.vtiger_attachment_id AS vtiger_attachment_id_21, t0.generated AS generated_22, t0.token AS token_23, t0.pennylane_customer_id AS pennylane_customer_id_24 FROM invoices t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "6c779f378331f2ae4a03518571ad3321"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.pennylane_invoice_id AS pennylane_invoice_id_1,
  t0.pennylane_invoice_label AS pennylane_invoice_label_2,
  t0.pennylane_invoice_number AS pennylane_invoice_number_3,
  t0.pennylane_invoice_amount AS pennylane_invoice_amount_4,
  t0.pennylane_invoice_currency_amount AS pennylane_invoice_currency_amount_5,
  t0.pennylane_invoice_currency_amount_before_tax AS pennylane_invoice_currency_amount_before_tax_6,
  t0.pennylane_invoice_tax AS pennylane_invoice_tax_7,
  t0.pennylane_invoice_currency_tax AS pennylane_invoice_currency_tax_8,
  t0.pennylane_invoice_remaining_amount_with_tax AS pennylane_invoice_remaining_amount_with_tax_9,
  t0.pennylane_invoice_remaining_amount_without_tax AS pennylane_invoice_remaining_amount_without_tax_10,
  t0.pennylane_invoice_filename AS pennylane_invoice_filename_11,
  t0.pennylane_invoice_date AS pennylane_invoice_date_12,
  t0.pennylane_invoice_special_mention AS pennylane_invoice_special_mention_13,
  t0.pennylane_invoice_pdf_invoice_free_text AS pennylane_invoice_pdf_invoice_free_text_14,
  t0.pennylane_invoice_pdf_description AS pennylane_invoice_pdf_description_15,
  t0.pennylane_invoice_pdf_invoice_subject AS pennylane_invoice_pdf_invoice_subject_16,
  t0.pennylane_invoice_extrenal_reference AS pennylane_invoice_extrenal_reference_17,
  t0.pennylane_invoice_customer_invoice_template_id AS pennylane_invoice_customer_invoice_template_id_18,
  t0.vtiger_invoice_id AS vtiger_invoice_id_19,
  t0.vtiger_document_id AS vtiger_document_id_20,
  t0.vtiger_attachment_id AS vtiger_attachment_id_21,
  t0.generated AS generated_22,
  t0.token AS token_23,
  t0.pennylane_customer_id AS pennylane_customer_id_24
FROM
  invoices t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.pennylane_invoice_id AS pennylane_invoice_id_1, t0.pennylane_invoice_label AS pennylane_invoice_label_2, t0.pennylane_invoice_number AS pennylane_invoice_number_3, t0.pennylane_invoice_amount AS pennylane_invoice_amount_4, t0.pennylane_invoice_currency_amount AS pennylane_invoice_currency_amount_5, t0.pennylane_invoice_currency_amount_before_tax AS pennylane_invoice_currency_amount_before_tax_6, t0.pennylane_invoice_tax AS pennylane_invoice_tax_7, t0.pennylane_invoice_currency_tax AS pennylane_invoice_currency_tax_8, t0.pennylane_invoice_remaining_amount_with_tax AS pennylane_invoice_remaining_amount_with_tax_9, t0.pennylane_invoice_remaining_amount_without_tax AS pennylane_invoice_remaining_amount_without_tax_10, t0.pennylane_invoice_filename AS pennylane_invoice_filename_11, t0.pennylane_invoice_date AS pennylane_invoice_date_12, t0.pennylane_invoice_special_mention AS pennylane_invoice_special_mention_13, t0.pennylane_invoice_pdf_invoice_free_text AS pennylane_invoice_pdf_invoice_free_text_14, t0.pennylane_invoice_pdf_description AS pennylane_invoice_pdf_description_15, t0.pennylane_invoice_pdf_invoice_subject AS pennylane_invoice_pdf_invoice_subject_16, t0.pennylane_invoice_extrenal_reference AS pennylane_invoice_extrenal_reference_17, t0.pennylane_invoice_customer_invoice_template_id AS pennylane_invoice_customer_invoice_template_id_18, t0.vtiger_invoice_id AS vtiger_invoice_id_19, t0.vtiger_document_id AS vtiger_document_id_20, t0.vtiger_attachment_id AS vtiger_attachment_id_21, t0.generated AS generated_22, t0.token AS token_23, t0.pennylane_customer_id AS pennylane_customer_id_24 FROM invoices t0 WHERE t0.token = '6c779f378331f2ae4a03518571ad3321' LIMIT 1;

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

1.09 ms
(20.06%)

SELECT NEXTVAL('invoice_download_log_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('invoice_download_log_id_seq')

SELECT NEXTVAL('invoice_download_log_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 46)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 920)
4	Doctrine\ORM\UnitOfWork->persistNew (line 1815)
5	Doctrine\ORM\UnitOfWork->doPersist (line 1773)
6	Doctrine\ORM\UnitOfWork->persist (line 443)
7	Doctrine\ORM\EntityManager->persist (line 48)
8	App\Controller\InvoiceDownloadController->download (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)

1.00 ms
(18.56%)

INSERT INTO invoice_download_log (id, downloaded_at, ip_address, user_agent, invoice_pennylane_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  911
  "2026-06-15 15:42:22"
  "109.222.236.82"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0"
  "2205639888"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO invoice_download_log (
  id, downloaded_at, ip_address, user_agent,
  invoice_pennylane_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO invoice_download_log (id, downloaded_at, ip_address, user_agent, invoice_pennylane_id) VALUES (911, '2026-06-15 15:42:22', '109.222.236.82', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0', '2205639888');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 255)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 49)
7	App\Controller\InvoiceDownloadController->download (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.63 ms
(11.59%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 49)
4	App\Controller\InvoiceDownloadController->download (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.58 ms
(10.65%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 49)
5	App\Controller\InvoiceDownloadController->download (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)

Database Connections

Name	Service
local_db	doctrine.dbal.local_db_connection
remote_db	doctrine.dbal.remote_db_connection

Entity Managers

Name	Service
local_em	doctrine.orm.local_em_entity_manager
remote_em	doctrine.orm.remote_em_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

local_em entity manager

Class	Amount of managed objects

remote_em entity manager

Class	Amount of managed objects
App\Entity\Remote\Invoice	1
App\Entity\Remote\Customer	1
App\Entity\Remote\InvoiceDownloadLog	1

Entities Mapping

local_em entity manager

No loaded entities.

remote_em entity manager

Class	Mapping errors
App\Entity\Remote\Invoice	The field App\Entity\Remote\Invoice#sendSchedules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Remote\InvoiceSendAt#invoice does not contain the required 'inversedBy: "sendSchedules"' attribute.
App\Entity\Remote\Customer	No errors.
App\Entity\Remote\InvoiceLine	No errors.
App\Entity\Remote\InvoiceSendAt	No errors.
App\Entity\Remote\InvoiceDownloadLog	No errors.

Symfony Profiler

GET https://facturation.myapp.agence-saycom.com/download/invoice/6c779f378331f2ae4a03518571ad3321

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

remote_db connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

local_em entity manager

remote_em entity manager

Entities Mapping

local_em entity manager

remote_em entity manager