Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

21.87 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.42 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.hash AS hash_5, t0.email AS email_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.no_carnet AS no_carnet_9, t0.phone AS phone_10, t0.identification_hash AS identification_hash_11, t0.active AS active_12, t0.show_notification AS show_notification_13, t0.locale AS locale_14, t0.domain_id AS domain_id_15, t16.id AS id_17, t16.carnet_name AS carnet_name_18, t16.iban AS iban_19, t16.identification AS identification_20, t16.email AS email_21, t16.logo AS logo_22, t16.company_name AS company_name_23, t16.company_representative AS company_representative_24, t16.address AS address_25, t16.postal_code AS postal_code_26, t16.city AS city_27, t16.phone_number AS phone_number_28, t16.payment_recipient AS payment_recipient_29, t16.payment_address AS payment_address_30, t16.payment_postal_code AS payment_postal_code_31, t16.payment_city AS payment_city_32, t16.min_amount AS min_amount_33, t16.max_amount AS max_amount_34, t16.use_twint_jm AS use_twint_jm_35, t16.twint_fees AS twint_fees_36, t16.twint_iban_for_payments AS twint_iban_for_payments_37, t16.min_twint_jmamount AS min_twint_jmamount_38, t16.twint_merchant_uuid AS twint_merchant_uuid_39, t16.twint_enable AS twint_enable_40, t16.twint_passphrase AS twint_passphrase_41, t16.twint_certificat_path AS twint_certificat_path_42, t16.prefix AS prefix_43, t16.closing_date AS closing_date_44, t16.catalog_image_wide AS catalog_image_wide_45, t16.catalog_image_narrow AS catalog_image_narrow_46, t16.allow_anonymous AS allow_anonymous_47, t16.send_receipt_email AS send_receipt_email_48, t16.invoice_min_amount AS invoice_min_amount_49, t16.user_creation_hash AS user_creation_hash_50, t16.sponsor_banner AS sponsor_banner_51, t16.show_sponsor_on_invoice AS show_sponsor_on_invoice_52, t16.cotisation AS cotisation_53, t16.display_phone_number_field AS display_phone_number_field_54, t16.vat_identification_number AS vat_identification_number_55, t16.user_instruction AS user_instruction_56, t16.objectif AS objectif_57, t16.locale AS locale_58, t16.print_locale_is_user_locale AS print_locale_is_user_locale_59 FROM fosuser t0 INNER JOIN domain t16 ON t0.domain_id = t16.id WHERE t0.id = ?

Parameters:

[
  "dee9975d-6f52-4bde-af14-bfa2cae7ef11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.hash AS hash_5,
  t0.email AS email_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.no_carnet AS no_carnet_9,
  t0.phone AS phone_10,
  t0.identification_hash AS identification_hash_11,
  t0.active AS active_12,
  t0.show_notification AS show_notification_13,
  t0.locale AS locale_14,
  t0.domain_id AS domain_id_15,
  t16.id AS id_17,
  t16.carnet_name AS carnet_name_18,
  t16.iban AS iban_19,
  t16.identification AS identification_20,
  t16.email AS email_21,
  t16.logo AS logo_22,
  t16.company_name AS company_name_23,
  t16.company_representative AS company_representative_24,
  t16.address AS address_25,
  t16.postal_code AS postal_code_26,
  t16.city AS city_27,
  t16.phone_number AS phone_number_28,
  t16.payment_recipient AS payment_recipient_29,
  t16.payment_address AS payment_address_30,
  t16.payment_postal_code AS payment_postal_code_31,
  t16.payment_city AS payment_city_32,
  t16.min_amount AS min_amount_33,
  t16.max_amount AS max_amount_34,
  t16.use_twint_jm AS use_twint_jm_35,
  t16.twint_fees AS twint_fees_36,
  t16.twint_iban_for_payments AS twint_iban_for_payments_37,
  t16.min_twint_jmamount AS min_twint_jmamount_38,
  t16.twint_merchant_uuid AS twint_merchant_uuid_39,
  t16.twint_enable AS twint_enable_40,
  t16.twint_passphrase AS twint_passphrase_41,
  t16.twint_certificat_path AS twint_certificat_path_42,
  t16.prefix AS prefix_43,
  t16.closing_date AS closing_date_44,
  t16.catalog_image_wide AS catalog_image_wide_45,
  t16.catalog_image_narrow AS catalog_image_narrow_46,
  t16.allow_anonymous AS allow_anonymous_47,
  t16.send_receipt_email AS send_receipt_email_48,
  t16.invoice_min_amount AS invoice_min_amount_49,
  t16.user_creation_hash AS user_creation_hash_50,
  t16.sponsor_banner AS sponsor_banner_51,
  t16.show_sponsor_on_invoice AS show_sponsor_on_invoice_52,
  t16.cotisation AS cotisation_53,
  t16.display_phone_number_field AS display_phone_number_field_54,
  t16.vat_identification_number AS vat_identification_number_55,
  t16.user_instruction AS user_instruction_56,
  t16.objectif AS objectif_57,
  t16.locale AS locale_58,
  t16.print_locale_is_user_locale AS print_locale_is_user_locale_59
FROM
  fosuser t0
  INNER JOIN domain t16 ON t0.domain_id = t16.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.hash AS hash_5, t0.email AS email_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.no_carnet AS no_carnet_9, t0.phone AS phone_10, t0.identification_hash AS identification_hash_11, t0.active AS active_12, t0.show_notification AS show_notification_13, t0.locale AS locale_14, t0.domain_id AS domain_id_15, t16.id AS id_17, t16.carnet_name AS carnet_name_18, t16.iban AS iban_19, t16.identification AS identification_20, t16.email AS email_21, t16.logo AS logo_22, t16.company_name AS company_name_23, t16.company_representative AS company_representative_24, t16.address AS address_25, t16.postal_code AS postal_code_26, t16.city AS city_27, t16.phone_number AS phone_number_28, t16.payment_recipient AS payment_recipient_29, t16.payment_address AS payment_address_30, t16.payment_postal_code AS payment_postal_code_31, t16.payment_city AS payment_city_32, t16.min_amount AS min_amount_33, t16.max_amount AS max_amount_34, t16.use_twint_jm AS use_twint_jm_35, t16.twint_fees AS twint_fees_36, t16.twint_iban_for_payments AS twint_iban_for_payments_37, t16.min_twint_jmamount AS min_twint_jmamount_38, t16.twint_merchant_uuid AS twint_merchant_uuid_39, t16.twint_enable AS twint_enable_40, t16.twint_passphrase AS twint_passphrase_41, t16.twint_certificat_path AS twint_certificat_path_42, t16.prefix AS prefix_43, t16.closing_date AS closing_date_44, t16.catalog_image_wide AS catalog_image_wide_45, t16.catalog_image_narrow AS catalog_image_narrow_46, t16.allow_anonymous AS allow_anonymous_47, t16.send_receipt_email AS send_receipt_email_48, t16.invoice_min_amount AS invoice_min_amount_49, t16.user_creation_hash AS user_creation_hash_50, t16.sponsor_banner AS sponsor_banner_51, t16.show_sponsor_on_invoice AS show_sponsor_on_invoice_52, t16.cotisation AS cotisation_53, t16.display_phone_number_field AS display_phone_number_field_54, t16.vat_identification_number AS vat_identification_number_55, t16.user_instruction AS user_instruction_56, t16.objectif AS objectif_57, t16.locale AS locale_58, t16.print_locale_is_user_locale AS print_locale_is_user_locale_59 FROM fosuser t0 INNER JOIN domain t16 ON t0.domain_id = t16.id WHERE t0.id = 'dee9975d-6f52-4bde-af14-bfa2cae7ef11';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

19.45 ms

SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.date AS date_3, a0_.email AS email_4, a0_.signature AS signature_5, a0_.npa AS npa_6, a0_.address AS address_7, a0_.address2 AS address2_8, a0_.locality AS locality_9, a0_.updated_at AS updated_at_10, a0_.anonymous AS anonymous_11, a0_.company AS company_12, a0_.validated_at AS validated_at_13, a0_.hash AS hash_14, a0_.text AS text_15, a0_.note AS note_16, a0_.invoiced_at AS invoiced_at_17, a0_.printed_at AS printed_at_18, a0_.reminder_at AS reminder_at_19, a0_.reference AS reference_20, a0_.reminder_printed_at AS reminder_printed_at_21, a0_.completed_by_donor AS completed_by_donor_22, a0_.ip_address AS ip_address_23, a0_.phone_number AS phone_number_24, a0_.demand_sent_at AS demand_sent_at_25, a0_.use_twint_jm AS use_twint_jm_26, a0_.created_by_id AS created_by_id_27, a0_.updated_by_id AS updated_by_id_28, a0_.payment_mode_id AS payment_mode_id_29, a0_.printed_by_id AS printed_by_id_30, a0_.reminder_printed_by_id AS reminder_printed_by_id_31 FROM annonceur a0_ INNER JOIN fosuser f1_ ON a0_.created_by_id = f1_.id WHERE f1_.domain_id = ? AND LOWER(a0_.company) = LOWER(?)

Parameters:

[
  Ramsey\Uuid\Uuid {#603
    __toString(): "6bc462fc-08ee-473f-8b8a-f44aa8a655ab"
  }
  "Michellod p"
]

View formatted query View runnable query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.firstname AS firstname_1,
  a0_.lastname AS lastname_2,
  a0_.date AS date_3,
  a0_.email AS email_4,
  a0_.signature AS signature_5,
  a0_.npa AS npa_6,
  a0_.address AS address_7,
  a0_.address2 AS address2_8,
  a0_.locality AS locality_9,
  a0_.updated_at AS updated_at_10,
  a0_.anonymous AS anonymous_11,
  a0_.company AS company_12,
  a0_.validated_at AS validated_at_13,
  a0_.hash AS hash_14,
  a0_.text AS text_15,
  a0_.note AS note_16,
  a0_.invoiced_at AS invoiced_at_17,
  a0_.printed_at AS printed_at_18,
  a0_.reminder_at AS reminder_at_19,
  a0_.reference AS reference_20,
  a0_.reminder_printed_at AS reminder_printed_at_21,
  a0_.completed_by_donor AS completed_by_donor_22,
  a0_.ip_address AS ip_address_23,
  a0_.phone_number AS phone_number_24,
  a0_.demand_sent_at AS demand_sent_at_25,
  a0_.use_twint_jm AS use_twint_jm_26,
  a0_.created_by_id AS created_by_id_27,
  a0_.updated_by_id AS updated_by_id_28,
  a0_.payment_mode_id AS payment_mode_id_29,
  a0_.printed_by_id AS printed_by_id_30,
  a0_.reminder_printed_by_id AS reminder_printed_by_id_31
FROM
  annonceur a0_
  INNER JOIN fosuser f1_ ON a0_.created_by_id = f1_.id
WHERE
  f1_.domain_id = ?
  AND LOWER(a0_.company) = LOWER(?)

SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.date AS date_3, a0_.email AS email_4, a0_.signature AS signature_5, a0_.npa AS npa_6, a0_.address AS address_7, a0_.address2 AS address2_8, a0_.locality AS locality_9, a0_.updated_at AS updated_at_10, a0_.anonymous AS anonymous_11, a0_.company AS company_12, a0_.validated_at AS validated_at_13, a0_.hash AS hash_14, a0_.text AS text_15, a0_.note AS note_16, a0_.invoiced_at AS invoiced_at_17, a0_.printed_at AS printed_at_18, a0_.reminder_at AS reminder_at_19, a0_.reference AS reference_20, a0_.reminder_printed_at AS reminder_printed_at_21, a0_.completed_by_donor AS completed_by_donor_22, a0_.ip_address AS ip_address_23, a0_.phone_number AS phone_number_24, a0_.demand_sent_at AS demand_sent_at_25, a0_.use_twint_jm AS use_twint_jm_26, a0_.created_by_id AS created_by_id_27, a0_.updated_by_id AS updated_by_id_28, a0_.payment_mode_id AS payment_mode_id_29, a0_.printed_by_id AS printed_by_id_30, a0_.reminder_printed_by_id AS reminder_printed_by_id_31 FROM annonceur a0_ INNER JOIN fosuser f1_ ON a0_.created_by_id = f1_.id WHERE f1_.domain_id = '6bc462fc-08ee-473f-8b8a-f44aa8a655ab' AND LOWER(a0_.company) = LOWER('Michellod p');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 1132)
7	App\Repository\AnnonceurRepository->findByCompanyName (line 77)
8	App\Controller\AnnonceurController->apiCompanyExists (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Domain	No errors.
App\Entity\Annonceur	No errors.
App\Entity\PaymentGroup	No errors.
App\Entity\PaymentMode	No errors.
App\Entity\Payment	No errors.
App\Entity\Task	No errors.
App\Entity\Template	No errors.
App\Entity\Item	No errors.
App\Entity\JMPaymentDomain	No errors.

Symfony Profiler

POST http://carnet.jmco.ch/annonceur/api/company/exists

Configuration Settings

Theme