Symfony Profiler

Query Metrics

10 Database Queries

9 Different statements

9.95 ms Query time

2 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.30 ms
(33.14%)

SELECT t0.id AS id_1, t0.customer_number AS customer_number_2, t0.vat_id AS vat_id_3, t0.shop_id AS shop_id_4, t0.email AS email_5, t0.email2 AS email2_6, t0.email3 AS email3_7, t0.phone AS phone_8, t0.phone2 AS phone2_9, t0.mobil AS mobil_10, t0.fax AS fax_11, t0.website AS website_12, t0.account_holder AS account_holder_13, t0.bank_name AS bank_name_14, t0.bic AS bic_15, t0.iban AS iban_16, t0.sepa_mandate_date AS sepa_mandate_date_17, t0.sepa_monthly_limit AS sepa_monthly_limit_18, t0.password AS password_19, t0.shop_created_at AS shop_created_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.status AS status_23, t0.internal_comment AS internal_comment_24, t0.reminder_contact_date AS reminder_contact_date_25, t0.track_and_trace_eoid AS track_and_trace_eoid_26, t0.track_and_trace_fid AS track_and_trace_fid_27, t0.default_billing_address_id AS default_billing_address_id_28, t0.default_shipping_address_id AS default_shipping_address_id_29, t0.last_contact_id AS last_contact_id_30, t0.reminder_contact_id AS reminder_contact_id_31, t0.sales_channel_id AS sales_channel_id_32, t0.customer_group_id AS customer_group_id_33, t34.id AS id_35, t34.sold_articles AS sold_articles_36, t34.sales_volume_net AS sales_volume_net_37, t34.sales_volume AS sales_volume_38, t34.balanca AS balanca_39, t34.customer_id AS customer_id_40, t0.sales_person_id AS sales_person_id_41 FROM customer t0 LEFT JOIN statistic t34 ON t34.customer_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "info@eraofsmoke.de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.customer_number AS customer_number_2,
  t0.vat_id AS vat_id_3,
  t0.shop_id AS shop_id_4,
  t0.email AS email_5,
  t0.email2 AS email2_6,
  t0.email3 AS email3_7,
  t0.phone AS phone_8,
  t0.phone2 AS phone2_9,
  t0.mobil AS mobil_10,
  t0.fax AS fax_11,
  t0.website AS website_12,
  t0.account_holder AS account_holder_13,
  t0.bank_name AS bank_name_14,
  t0.bic AS bic_15,
  t0.iban AS iban_16,
  t0.sepa_mandate_date AS sepa_mandate_date_17,
  t0.sepa_monthly_limit AS sepa_monthly_limit_18,
  t0.password AS password_19,
  t0.shop_created_at AS shop_created_at_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.status AS status_23,
  t0.internal_comment AS internal_comment_24,
  t0.reminder_contact_date AS reminder_contact_date_25,
  t0.track_and_trace_eoid AS track_and_trace_eoid_26,
  t0.track_and_trace_fid AS track_and_trace_fid_27,
  t0.default_billing_address_id AS default_billing_address_id_28,
  t0.default_shipping_address_id AS default_shipping_address_id_29,
  t0.last_contact_id AS last_contact_id_30,
  t0.reminder_contact_id AS reminder_contact_id_31,
  t0.sales_channel_id AS sales_channel_id_32,
  t0.customer_group_id AS customer_group_id_33,
  t34.id AS id_35,
  t34.sold_articles AS sold_articles_36,
  t34.sales_volume_net AS sales_volume_net_37,
  t34.sales_volume AS sales_volume_38,
  t34.balanca AS balanca_39,
  t34.customer_id AS customer_id_40,
  t0.sales_person_id AS sales_person_id_41
FROM
  customer t0
  LEFT JOIN statistic t34 ON t34.customer_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.customer_number AS customer_number_2, t0.vat_id AS vat_id_3, t0.shop_id AS shop_id_4, t0.email AS email_5, t0.email2 AS email2_6, t0.email3 AS email3_7, t0.phone AS phone_8, t0.phone2 AS phone2_9, t0.mobil AS mobil_10, t0.fax AS fax_11, t0.website AS website_12, t0.account_holder AS account_holder_13, t0.bank_name AS bank_name_14, t0.bic AS bic_15, t0.iban AS iban_16, t0.sepa_mandate_date AS sepa_mandate_date_17, t0.sepa_monthly_limit AS sepa_monthly_limit_18, t0.password AS password_19, t0.shop_created_at AS shop_created_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.status AS status_23, t0.internal_comment AS internal_comment_24, t0.reminder_contact_date AS reminder_contact_date_25, t0.track_and_trace_eoid AS track_and_trace_eoid_26, t0.track_and_trace_fid AS track_and_trace_fid_27, t0.default_billing_address_id AS default_billing_address_id_28, t0.default_shipping_address_id AS default_shipping_address_id_29, t0.last_contact_id AS last_contact_id_30, t0.reminder_contact_id AS reminder_contact_id_31, t0.sales_channel_id AS sales_channel_id_32, t0.customer_group_id AS customer_group_id_33, t34.id AS id_35, t34.sold_articles AS sold_articles_36, t34.sales_volume_net AS sales_volume_net_37, t34.sales_volume AS sales_volume_38, t34.balanca AS balanca_39, t34.customer_id AS customer_id_40, t0.sales_person_id AS sales_person_id_41 FROM customer t0 LEFT JOIN statistic t34 ON t34.customer_id = t0.id WHERE t0.email = 'info@eraofsmoke.de' 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\Message\CustomerPushedHandler->__invoke (line 42)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
15	App\Controller\Api\ShopController->shopPush (line 48)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.60 ms
(16.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.shop_id AS shop_id_3, t0.active AS active_4, t0.iso AS iso_5 FROM country t0 WHERE t0.shop_id = ? LIMIT 1

Parameters:

[
  "018ee73bd1127170acb3da18a073a3dc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shop_id AS shop_id_3,
  t0.active AS active_4,
  t0.iso AS iso_5
FROM
  country t0
WHERE
  t0.shop_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.shop_id AS shop_id_3, t0.active AS active_4, t0.iso AS iso_5 FROM country t0 WHERE t0.shop_id = '018ee73bd1127170acb3da18a073a3dc' 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\Service\CustomerImportService->getCountryByShopId (line 235)
5	App\Service\CustomerImportService->upsertBillingAddress (line 170)
6	App\Service\CustomerImportService->update (line 64)
7	App\Message\CustomerPushedHandler->__invoke (line 44)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
15	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
16	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
17	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
18	App\Controller\Api\ShopController->shopPush (line 48)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.18 ms
(11.89%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.street AS street_5, t0.salutation AS salutation_6, t0.additional_line1 AS additional_line1_7, t0.additional_line2 AS additional_line2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.shop_id AS shop_id_11, t0.department AS department_12, t0.country_id AS country_id_13, t14.id AS id_15, t14.customer_number AS customer_number_16, t14.vat_id AS vat_id_17, t14.shop_id AS shop_id_18, t14.email AS email_19, t14.email2 AS email2_20, t14.email3 AS email3_21, t14.phone AS phone_22, t14.phone2 AS phone2_23, t14.mobil AS mobil_24, t14.fax AS fax_25, t14.website AS website_26, t14.account_holder AS account_holder_27, t14.bank_name AS bank_name_28, t14.bic AS bic_29, t14.iban AS iban_30, t14.sepa_mandate_date AS sepa_mandate_date_31, t14.sepa_monthly_limit AS sepa_monthly_limit_32, t14.password AS password_33, t14.shop_created_at AS shop_created_at_34, t14.created_at AS created_at_35, t14.updated_at AS updated_at_36, t14.status AS status_37, t14.internal_comment AS internal_comment_38, t14.reminder_contact_date AS reminder_contact_date_39, t14.track_and_trace_eoid AS track_and_trace_eoid_40, t14.track_and_trace_fid AS track_and_trace_fid_41, t14.default_billing_address_id AS default_billing_address_id_42, t14.default_shipping_address_id AS default_shipping_address_id_43, t14.last_contact_id AS last_contact_id_44, t14.reminder_contact_id AS reminder_contact_id_45, t14.sales_channel_id AS sales_channel_id_46, t14.customer_group_id AS customer_group_id_47, t14.sales_person_id AS sales_person_id_48 FROM billing_address t0 LEFT JOIN customer t14 ON t14.default_billing_address_id = t0.id WHERE t0.id = ?

Parameters:

[
  11082
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.company AS company_4,
  t0.street AS street_5,
  t0.salutation AS salutation_6,
  t0.additional_line1 AS additional_line1_7,
  t0.additional_line2 AS additional_line2_8,
  t0.zip_code AS zip_code_9,
  t0.city AS city_10,
  t0.shop_id AS shop_id_11,
  t0.department AS department_12,
  t0.country_id AS country_id_13,
  t14.id AS id_15,
  t14.customer_number AS customer_number_16,
  t14.vat_id AS vat_id_17,
  t14.shop_id AS shop_id_18,
  t14.email AS email_19,
  t14.email2 AS email2_20,
  t14.email3 AS email3_21,
  t14.phone AS phone_22,
  t14.phone2 AS phone2_23,
  t14.mobil AS mobil_24,
  t14.fax AS fax_25,
  t14.website AS website_26,
  t14.account_holder AS account_holder_27,
  t14.bank_name AS bank_name_28,
  t14.bic AS bic_29,
  t14.iban AS iban_30,
  t14.sepa_mandate_date AS sepa_mandate_date_31,
  t14.sepa_monthly_limit AS sepa_monthly_limit_32,
  t14.password AS password_33,
  t14.shop_created_at AS shop_created_at_34,
  t14.created_at AS created_at_35,
  t14.updated_at AS updated_at_36,
  t14.status AS status_37,
  t14.internal_comment AS internal_comment_38,
  t14.reminder_contact_date AS reminder_contact_date_39,
  t14.track_and_trace_eoid AS track_and_trace_eoid_40,
  t14.track_and_trace_fid AS track_and_trace_fid_41,
  t14.default_billing_address_id AS default_billing_address_id_42,
  t14.default_shipping_address_id AS default_shipping_address_id_43,
  t14.last_contact_id AS last_contact_id_44,
  t14.reminder_contact_id AS reminder_contact_id_45,
  t14.sales_channel_id AS sales_channel_id_46,
  t14.customer_group_id AS customer_group_id_47,
  t14.sales_person_id AS sales_person_id_48
FROM
  billing_address t0
  LEFT JOIN customer t14 ON t14.default_billing_address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.street AS street_5, t0.salutation AS salutation_6, t0.additional_line1 AS additional_line1_7, t0.additional_line2 AS additional_line2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.shop_id AS shop_id_11, t0.department AS department_12, t0.country_id AS country_id_13, t14.id AS id_15, t14.customer_number AS customer_number_16, t14.vat_id AS vat_id_17, t14.shop_id AS shop_id_18, t14.email AS email_19, t14.email2 AS email2_20, t14.email3 AS email3_21, t14.phone AS phone_22, t14.phone2 AS phone2_23, t14.mobil AS mobil_24, t14.fax AS fax_25, t14.website AS website_26, t14.account_holder AS account_holder_27, t14.bank_name AS bank_name_28, t14.bic AS bic_29, t14.iban AS iban_30, t14.sepa_mandate_date AS sepa_mandate_date_31, t14.sepa_monthly_limit AS sepa_monthly_limit_32, t14.password AS password_33, t14.shop_created_at AS shop_created_at_34, t14.created_at AS created_at_35, t14.updated_at AS updated_at_36, t14.status AS status_37, t14.internal_comment AS internal_comment_38, t14.reminder_contact_date AS reminder_contact_date_39, t14.track_and_trace_eoid AS track_and_trace_eoid_40, t14.track_and_trace_fid AS track_and_trace_fid_41, t14.default_billing_address_id AS default_billing_address_id_42, t14.default_shipping_address_id AS default_shipping_address_id_43, t14.last_contact_id AS last_contact_id_44, t14.reminder_contact_id AS reminder_contact_id_45, t14.sales_channel_id AS sales_channel_id_46, t14.customer_group_id AS customer_group_id_47, t14.sales_person_id AS sales_person_id_48 FROM billing_address t0 LEFT JOIN customer t14 ON t14.default_billing_address_id = t0.id WHERE t0.id = 11082;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\BillingAddress::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\BillingAddress->__set (line 201)
7	App\Entity\BillingAddress->setSalutation (line 115)
8	App\Service\CustomerImportService->upsertBillingAddress (line 178)
9	App\Service\CustomerImportService->update (line 64)
10	App\Message\CustomerPushedHandler->__invoke (line 44)
11	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
12	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
13	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
18	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
21	App\Controller\Api\ShopController->shopPush (line 48)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.84 ms
(8.42%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.additional_line1 AS additional_line1_5, t0.additional_line2 AS additional_line2_6, t0.street AS street_7, t0.zip_code AS zip_code_8, t0.salutation AS salutation_9, t0.city AS city_10, t0.shop_id AS shop_id_11, t0.department AS department_12, t0.country_id AS country_id_13, t14.id AS id_15, t14.customer_number AS customer_number_16, t14.vat_id AS vat_id_17, t14.shop_id AS shop_id_18, t14.email AS email_19, t14.email2 AS email2_20, t14.email3 AS email3_21, t14.phone AS phone_22, t14.phone2 AS phone2_23, t14.mobil AS mobil_24, t14.fax AS fax_25, t14.website AS website_26, t14.account_holder AS account_holder_27, t14.bank_name AS bank_name_28, t14.bic AS bic_29, t14.iban AS iban_30, t14.sepa_mandate_date AS sepa_mandate_date_31, t14.sepa_monthly_limit AS sepa_monthly_limit_32, t14.password AS password_33, t14.shop_created_at AS shop_created_at_34, t14.created_at AS created_at_35, t14.updated_at AS updated_at_36, t14.status AS status_37, t14.internal_comment AS internal_comment_38, t14.reminder_contact_date AS reminder_contact_date_39, t14.track_and_trace_eoid AS track_and_trace_eoid_40, t14.track_and_trace_fid AS track_and_trace_fid_41, t14.default_billing_address_id AS default_billing_address_id_42, t14.default_shipping_address_id AS default_shipping_address_id_43, t14.last_contact_id AS last_contact_id_44, t14.reminder_contact_id AS reminder_contact_id_45, t14.sales_channel_id AS sales_channel_id_46, t14.customer_group_id AS customer_group_id_47, t14.sales_person_id AS sales_person_id_48 FROM shipping_address t0 LEFT JOIN customer t14 ON t14.default_shipping_address_id = t0.id WHERE t0.id = ?

Parameters:

[
  11079
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.company AS company_4,
  t0.additional_line1 AS additional_line1_5,
  t0.additional_line2 AS additional_line2_6,
  t0.street AS street_7,
  t0.zip_code AS zip_code_8,
  t0.salutation AS salutation_9,
  t0.city AS city_10,
  t0.shop_id AS shop_id_11,
  t0.department AS department_12,
  t0.country_id AS country_id_13,
  t14.id AS id_15,
  t14.customer_number AS customer_number_16,
  t14.vat_id AS vat_id_17,
  t14.shop_id AS shop_id_18,
  t14.email AS email_19,
  t14.email2 AS email2_20,
  t14.email3 AS email3_21,
  t14.phone AS phone_22,
  t14.phone2 AS phone2_23,
  t14.mobil AS mobil_24,
  t14.fax AS fax_25,
  t14.website AS website_26,
  t14.account_holder AS account_holder_27,
  t14.bank_name AS bank_name_28,
  t14.bic AS bic_29,
  t14.iban AS iban_30,
  t14.sepa_mandate_date AS sepa_mandate_date_31,
  t14.sepa_monthly_limit AS sepa_monthly_limit_32,
  t14.password AS password_33,
  t14.shop_created_at AS shop_created_at_34,
  t14.created_at AS created_at_35,
  t14.updated_at AS updated_at_36,
  t14.status AS status_37,
  t14.internal_comment AS internal_comment_38,
  t14.reminder_contact_date AS reminder_contact_date_39,
  t14.track_and_trace_eoid AS track_and_trace_eoid_40,
  t14.track_and_trace_fid AS track_and_trace_fid_41,
  t14.default_billing_address_id AS default_billing_address_id_42,
  t14.default_shipping_address_id AS default_shipping_address_id_43,
  t14.last_contact_id AS last_contact_id_44,
  t14.reminder_contact_id AS reminder_contact_id_45,
  t14.sales_channel_id AS sales_channel_id_46,
  t14.customer_group_id AS customer_group_id_47,
  t14.sales_person_id AS sales_person_id_48
FROM
  shipping_address t0
  LEFT JOIN customer t14 ON t14.default_shipping_address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.company AS company_4, t0.additional_line1 AS additional_line1_5, t0.additional_line2 AS additional_line2_6, t0.street AS street_7, t0.zip_code AS zip_code_8, t0.salutation AS salutation_9, t0.city AS city_10, t0.shop_id AS shop_id_11, t0.department AS department_12, t0.country_id AS country_id_13, t14.id AS id_15, t14.customer_number AS customer_number_16, t14.vat_id AS vat_id_17, t14.shop_id AS shop_id_18, t14.email AS email_19, t14.email2 AS email2_20, t14.email3 AS email3_21, t14.phone AS phone_22, t14.phone2 AS phone2_23, t14.mobil AS mobil_24, t14.fax AS fax_25, t14.website AS website_26, t14.account_holder AS account_holder_27, t14.bank_name AS bank_name_28, t14.bic AS bic_29, t14.iban AS iban_30, t14.sepa_mandate_date AS sepa_mandate_date_31, t14.sepa_monthly_limit AS sepa_monthly_limit_32, t14.password AS password_33, t14.shop_created_at AS shop_created_at_34, t14.created_at AS created_at_35, t14.updated_at AS updated_at_36, t14.status AS status_37, t14.internal_comment AS internal_comment_38, t14.reminder_contact_date AS reminder_contact_date_39, t14.track_and_trace_eoid AS track_and_trace_eoid_40, t14.track_and_trace_fid AS track_and_trace_fid_41, t14.default_billing_address_id AS default_billing_address_id_42, t14.default_shipping_address_id AS default_shipping_address_id_43, t14.last_contact_id AS last_contact_id_44, t14.reminder_contact_id AS reminder_contact_id_45, t14.sales_channel_id AS sales_channel_id_46, t14.customer_group_id AS customer_group_id_47, t14.sales_person_id AS sales_person_id_48 FROM shipping_address t0 LEFT JOIN customer t14 ON t14.default_shipping_address_id = t0.id WHERE t0.id = 11079;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\ShippingAddress::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\ShippingAddress->__set (line 201)
7	App\Entity\ShippingAddress->setSalutation (line 151)
8	App\Service\CustomerImportService->upsertShippingAddress (line 216)
9	App\Service\CustomerImportService->update (line 65)
10	App\Message\CustomerPushedHandler->__invoke (line 44)
11	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
12	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
13	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
18	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
21	App\Controller\Api\ShopController->shopPush (line 48)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.82 ms
(8.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.shop_id AS shop_id_4, t0.is_b2b AS is_b2b_5 FROM customer_group t0 WHERE t0.shop_id = ? LIMIT 1

Parameters:

[
  "018f14c4f6d8704e9c98ddfe646d0536"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.shop_id AS shop_id_4,
  t0.is_b2b AS is_b2b_5
FROM
  customer_group t0
WHERE
  t0.shop_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.shop_id AS shop_id_4, t0.is_b2b AS is_b2b_5 FROM customer_group t0 WHERE t0.shop_id = '018f14c4f6d8704e9c98ddfe646d0536' 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\Service\CustomerImportService->getCustomerGroupByShopId (line 144)
5	App\Service\CustomerImportService->update (line 50)
6	App\Message\CustomerPushedHandler->__invoke (line 44)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
9	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
11	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
12	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
13	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
17	App\Controller\Api\ShopController->shopPush (line 48)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.75 ms
(7.51%)

"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\Message\CustomerPushedHandler->__invoke (line 55)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
15	App\Controller\Api\ShopController->shopPush (line 48)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.62 ms
(6.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.shop_id AS shop_id_4, t0.access_key AS access_key_5, t0.storefront_url AS storefront_url_6, t0.customer_group_id AS customer_group_id_7 FROM sales_channel t0 WHERE t0.shop_id = ? LIMIT 1

Parameters:

[
  "0198a7b5f3f87bc9927d12765016c578"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.shop_id AS shop_id_4,
  t0.access_key AS access_key_5,
  t0.storefront_url AS storefront_url_6,
  t0.customer_group_id AS customer_group_id_7
FROM
  sales_channel t0
WHERE
  t0.shop_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.shop_id AS shop_id_4, t0.access_key AS access_key_5, t0.storefront_url AS storefront_url_6, t0.customer_group_id AS customer_group_id_7 FROM sales_channel t0 WHERE t0.shop_id = '0198a7b5f3f87bc9927d12765016c578' 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\Service\CustomerImportService->getSalesChannelByShopId (line 152)
5	App\Service\CustomerImportService->update (line 51)
6	App\Message\CustomerPushedHandler->__invoke (line 44)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
9	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
11	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
12	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
13	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
17	App\Controller\Api\ShopController->shopPush (line 48)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.56 ms
(5.59%)

UPDATE customer SET updated_at = ? WHERE id = ?

Parameters:

[
  "2026-10-14 11:32:05"
  11355
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  customer
SET
  updated_at = ?
WHERE
  id = ?

UPDATE customer SET updated_at = '2026-10-14 11:32:05' WHERE id = 11355;

#	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\Message\CustomerPushedHandler->__invoke (line 55)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
9	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
11	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
12	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
13	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
17	App\Controller\Api\ShopController->shopPush (line 48)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.30 ms
(2.98%)

"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\Message\CustomerPushedHandler->__invoke (line 55)
4	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
12	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
13	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
14	App\Controller\Api\ShopController->shopPush (line 48)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	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\CustomerGroup	2
App\Entity\Customer	1
App\Entity\BillingAddress	1
App\Entity\ShippingAddress	1
App\Entity\User	1
App\Entity\SalesChannel	1
App\Entity\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\Customer	The mappings App\Entity\Customer#salesPerson and App\Entity\User#customers are inconsistent with each other.
App\Entity\BillingAddress	No errors.
App\Entity\ShippingAddress	No errors.
App\Entity\User	The association App\Entity\User#customers refers to the owning side field App\Entity\Customer#salesPersonId which does not exist.
App\Entity\SalesChannel	No errors.
App\Entity\CustomerGroup	No errors.
App\Entity\Statistic	No errors.
App\Entity\Contact	No errors.
App\Entity\Document	No errors.
App\Entity\Protocol	No errors.
App\Entity\Checklist	No errors.
App\Entity\Tag	No errors.
App\Entity\Order	No errors.
App\Entity\Country	No errors.

Symfony Profiler

GET https://mg-wesel.symfonians.de/api/shop/push/019c94217073703d99d93bf2399c5f72

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping