Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

5.52 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.27 ms
(23.07%)

"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 431)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 49)
5	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.02 ms
(18.45%)

SELECT t0.name AS name_1, t0.display_name AS display_name_2, t0.phones AS phones_3, t0.is_seller AS is_seller_4, t0.is_pool AS is_pool_5, t0.oenodata AS oenodata_6, t0.siret_number AS siret_number_7, t0.vat_number AS vat_number_8, t0.accise_number AS accise_number_9, t0.gacc_number AS gacc_number_10, t0.fda_number AS fda_number_11, t0.duns_number AS duns_number_12, t0.owner AS owner_13, t0.is_archived AS is_archived_14, t0.approved AS approved_15, t0.ignore_import AS ignore_import_16, t0.merged_uuids AS merged_uuids_17, t0.provisioning AS provisioning_18, t0.offer_type AS offer_type_19, t0.public_offer AS public_offer_20, t0.emails AS emails_21, t0.offer_disable_comment AS offer_disable_comment_22, t0.default_import_packaging_value AS default_import_packaging_value_23, t0.id AS id_24, t0.uuid AS uuid_25, t0.code AS code_26, t0.status AS status_27, t0.address AS address_28, t0.address2 AS address2_29, t0.postcode AS postcode_30, t0.city AS city_31, t0.url AS url_32, t0.parent_id AS parent_id_33, t0.type_id AS type_id_34, t35.columns AS columns_36, t35.type AS type_37, t35.id AS id_38, t35.uuid AS uuid_39, t35.status AS status_40, t35.entity_id AS entity_id_41, t0.pay_type_id AS pay_type_id_42, t0.default_import_packaging_id AS default_import_packaging_id_43, t0.country_id AS country_id_44 FROM entity t0 LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id WHERE t0.id = ?

Parameters:

[
  6737
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.display_name AS display_name_2,
  t0.phones AS phones_3,
  t0.is_seller AS is_seller_4,
  t0.is_pool AS is_pool_5,
  t0.oenodata AS oenodata_6,
  t0.siret_number AS siret_number_7,
  t0.vat_number AS vat_number_8,
  t0.accise_number AS accise_number_9,
  t0.gacc_number AS gacc_number_10,
  t0.fda_number AS fda_number_11,
  t0.duns_number AS duns_number_12,
  t0.owner AS owner_13,
  t0.is_archived AS is_archived_14,
  t0.approved AS approved_15,
  t0.ignore_import AS ignore_import_16,
  t0.merged_uuids AS merged_uuids_17,
  t0.provisioning AS provisioning_18,
  t0.offer_type AS offer_type_19,
  t0.public_offer AS public_offer_20,
  t0.emails AS emails_21,
  t0.offer_disable_comment AS offer_disable_comment_22,
  t0.default_import_packaging_value AS default_import_packaging_value_23,
  t0.id AS id_24,
  t0.uuid AS uuid_25,
  t0.code AS code_26,
  t0.status AS status_27,
  t0.address AS address_28,
  t0.address2 AS address2_29,
  t0.postcode AS postcode_30,
  t0.city AS city_31,
  t0.url AS url_32,
  t0.parent_id AS parent_id_33,
  t0.type_id AS type_id_34,
  t35.columns AS columns_36,
  t35.type AS type_37,
  t35.id AS id_38,
  t35.uuid AS uuid_39,
  t35.status AS status_40,
  t35.entity_id AS entity_id_41,
  t0.pay_type_id AS pay_type_id_42,
  t0.default_import_packaging_id AS default_import_packaging_id_43,
  t0.country_id AS country_id_44
FROM
  entity t0
  LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.display_name AS display_name_2, t0.phones AS phones_3, t0.is_seller AS is_seller_4, t0.is_pool AS is_pool_5, t0.oenodata AS oenodata_6, t0.siret_number AS siret_number_7, t0.vat_number AS vat_number_8, t0.accise_number AS accise_number_9, t0.gacc_number AS gacc_number_10, t0.fda_number AS fda_number_11, t0.duns_number AS duns_number_12, t0.owner AS owner_13, t0.is_archived AS is_archived_14, t0.approved AS approved_15, t0.ignore_import AS ignore_import_16, t0.merged_uuids AS merged_uuids_17, t0.provisioning AS provisioning_18, t0.offer_type AS offer_type_19, t0.public_offer AS public_offer_20, t0.emails AS emails_21, t0.offer_disable_comment AS offer_disable_comment_22, t0.default_import_packaging_value AS default_import_packaging_value_23, t0.id AS id_24, t0.uuid AS uuid_25, t0.code AS code_26, t0.status AS status_27, t0.address AS address_28, t0.address2 AS address2_29, t0.postcode AS postcode_30, t0.city AS city_31, t0.url AS url_32, t0.parent_id AS parent_id_33, t0.type_id AS type_id_34, t35.columns AS columns_36, t35.type AS type_37, t35.id AS id_38, t35.uuid AS uuid_39, t35.status AS status_40, t35.entity_id AS entity_id_41, t0.pay_type_id AS pay_type_id_42, t0.default_import_packaging_id AS default_import_packaging_id_43, t0.country_id AS country_id_44 FROM entity t0 LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id WHERE t0.id = 6737;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Property\Property::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Property\Property->__get (line 883)
8	App\Entity\Property\Property->getOfferType (line 115)
9	App\Controller\App\Offer\ImportController->processPreview (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.94 ms
(17.02%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.83 ms
(15.04%)

SELECT i0_.logs AS logs_0, i0_.date AS date_1, i0_.is_full AS is_full_2, i0_.type AS type_3, i0_.duration AS duration_4, i0_.items AS items_5, i0_.id AS id_6, i0_.uuid AS uuid_7, i0_.status AS status_8, i0_.items AS items_9, i0_.entity_id AS entity_id_10, i0_.created_by_id AS created_by_id_11 FROM import_logs i0_ WHERE i0_.entity_id = ? AND i0_.is_full = ? ORDER BY i0_.id DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.logs AS logs_0,
  i0_.date AS date_1,
  i0_.is_full AS is_full_2,
  i0_.type AS type_3,
  i0_.duration AS duration_4,
  i0_.items AS items_5,
  i0_.id AS id_6,
  i0_.uuid AS uuid_7,
  i0_.status AS status_8,
  i0_.items AS items_9,
  i0_.entity_id AS entity_id_10,
  i0_.created_by_id AS created_by_id_11
FROM
  import_logs i0_
WHERE
  i0_.entity_id = ?
  AND i0_.is_full = ?
ORDER BY
  i0_.id DESC
LIMIT
  1

SELECT i0_.logs AS logs_0, i0_.date AS date_1, i0_.is_full AS is_full_2, i0_.type AS type_3, i0_.duration AS duration_4, i0_.items AS items_5, i0_.id AS id_6, i0_.uuid AS uuid_7, i0_.status AS status_8, i0_.items AS items_9, i0_.entity_id AS entity_id_10, i0_.created_by_id AS created_by_id_11 FROM import_logs i0_ WHERE i0_.entity_id = 6737 AND i0_.is_full = 1 ORDER BY i0_.id DESC LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 46)
7	App\Repository\Import\ImportLogRepository->getLastImportLog (line 107)
8	App\Controller\App\Offer\ImportController->processPreview (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)

0.65 ms
(11.72%)

SELECT t0.type AS type_1, t0.is_full AS is_full_2, t0.files_datas AS files_datas_3, t0.duration AS duration_4, t0.items AS items_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.entity_id AS entity_id_8 FROM import_prepare t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "8434ed52-9e2a-4880-9610-7c6f4ece0d66"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.is_full AS is_full_2,
  t0.files_datas AS files_datas_3,
  t0.duration AS duration_4,
  t0.items AS items_5,
  t0.id AS id_6,
  t0.uuid AS uuid_7,
  t0.entity_id AS entity_id_8
FROM
  import_prepare t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.type AS type_1, t0.is_full AS is_full_2, t0.files_datas AS files_datas_3, t0.duration AS duration_4, t0.items AS items_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.entity_id AS entity_id_8 FROM import_prepare t0 WHERE t0.uuid = '8434ed52-9e2a-4880-9610-7c6f4ece0d66' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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)

0.57 ms
(10.27%)

UPDATE user SET last_activity = ? WHERE id = ?

Parameters:

[
  "2025-07-07 07:19:33"
  20
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 07:19:33' WHERE id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 49)
7	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.24 ms
(4.43%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 49)
4	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
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)

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\User	1
App\Entity\Company	1
App\Entity\Import\ImportPrepare	1
App\Entity\Property\Property	1
App\Entity\Property\PropertyType	1
App\Entity\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Product\Offer	No errors.
App\Entity\Product\FavouriteOffer	No errors.
App\Entity\Offer\OfferProposal	No errors.
App\Entity\Offer\OfferUserConsult	No errors.
App\Entity\Import\ImportPrepare	No errors.
App\Entity\Property\Property	No errors.
App\Entity\Import\ImportLog	No errors.
App\Entity\Property\PropertyType	No errors.
App\Entity\Import\Feed	No errors.
App\Entity\Property\PayType	No errors.
App\Entity\Product\Packaging	No errors.
App\Entity\Country	No errors.
App\Entity\Contact\ContactProperty	No errors.
App\Entity\Warehouse	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Property\Producer	No errors.
App\Entity\Product\Waitlist	No errors.
App\Entity\Product\IgnoreTerms	No errors.
App\Entity\Sales\Transactions	No errors.
App\Entity\Property\Demand	No errors.

Symfony Profiler

GET https://app103.fr/app/offer-import/process-preview/8434ed52-9e2a-4880-9610-7c6f4ece0d66

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping