Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.27 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.27 ms

SELECT s0_.id AS id_0, s0_.company_type AS company_type_1, s0_.name AS name_2, s0_.brn AS brn_3, s0_.is_vat_registered AS is_vat_registered_4, s0_.vat_registration_number AS vat_registration_number_5, s0_.email AS email_6, s0_.phone AS phone_7, s0_.address AS address_8, s0_.website AS website_9, s0_.description AS description_10, s0_.contact_person_name AS contact_person_name_11, s0_.contact_person_designation AS contact_person_designation_12, s0_.contact_person_email AS contact_person_email_13, s0_.contact_person_phone AS contact_person_phone_14, s0_.bank_account_holder_name AS bank_account_holder_name_15, s0_.bank_account_number AS bank_account_number_16, s0_.bank_name AS bank_name_17, s0_.bank_branch_name AS bank_branch_name_18, s0_.bank_iban AS bank_iban_19, s0_.bank_swift AS bank_swift_20, s0_.bank_account_currency AS bank_account_currency_21, s0_.subscription_payment_plan AS subscription_payment_plan_22, s0_.is_onboarding_completed AS is_onboarding_completed_23, s0_.is_onboarding_email_sent AS is_onboarding_email_sent_24, s0_.website_link AS website_link_25, s0_.facebook_link AS facebook_link_26, s0_.instagram_link AS instagram_link_27, s0_.linked_in_link AS linked_in_link_28, s0_.tiktok_link AS tiktok_link_29, s0_.created_at AS created_at_30, s0_.updated_at AS updated_at_31, s1_.id AS id_32, s1_.name AS name_33, s1_.description AS description_34, s1_.onboarding_fee AS onboarding_fee_35, s1_.monthly_fee AS monthly_fee_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, r2_.id AS id_39, r2_.name AS name_40, r2_.created_at AS created_at_41, r2_.updated_at AS updated_at_42, s3_.id AS id_43, s3_.name AS name_44, s3_.is_custom AS is_custom_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s0_.subscription_plan_id AS subscription_plan_id_48 FROM supplier s0_ LEFT JOIN subscription_plan s1_ ON s0_.subscription_plan_id = s1_.id LEFT JOIN supplier_region s4_ ON s0_.id = s4_.supplier_id LEFT JOIN region r2_ ON r2_.id = s4_.region_id LEFT JOIN supplier_service s5_ ON s0_.id = s5_.supplier_id LEFT JOIN service s3_ ON s3_.id = s5_.service_id WHERE s0_.id = ?

Parameters:

[
  158
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.company_type AS company_type_1,
  s0_.name AS name_2,
  s0_.brn AS brn_3,
  s0_.is_vat_registered AS is_vat_registered_4,
  s0_.vat_registration_number AS vat_registration_number_5,
  s0_.email AS email_6,
  s0_.phone AS phone_7,
  s0_.address AS address_8,
  s0_.website AS website_9,
  s0_.description AS description_10,
  s0_.contact_person_name AS contact_person_name_11,
  s0_.contact_person_designation AS contact_person_designation_12,
  s0_.contact_person_email AS contact_person_email_13,
  s0_.contact_person_phone AS contact_person_phone_14,
  s0_.bank_account_holder_name AS bank_account_holder_name_15,
  s0_.bank_account_number AS bank_account_number_16,
  s0_.bank_name AS bank_name_17,
  s0_.bank_branch_name AS bank_branch_name_18,
  s0_.bank_iban AS bank_iban_19,
  s0_.bank_swift AS bank_swift_20,
  s0_.bank_account_currency AS bank_account_currency_21,
  s0_.subscription_payment_plan AS subscription_payment_plan_22,
  s0_.is_onboarding_completed AS is_onboarding_completed_23,
  s0_.is_onboarding_email_sent AS is_onboarding_email_sent_24,
  s0_.website_link AS website_link_25,
  s0_.facebook_link AS facebook_link_26,
  s0_.instagram_link AS instagram_link_27,
  s0_.linked_in_link AS linked_in_link_28,
  s0_.tiktok_link AS tiktok_link_29,
  s0_.created_at AS created_at_30,
  s0_.updated_at AS updated_at_31,
  s1_.id AS id_32,
  s1_.name AS name_33,
  s1_.description AS description_34,
  s1_.onboarding_fee AS onboarding_fee_35,
  s1_.monthly_fee AS monthly_fee_36,
  s1_.created_at AS created_at_37,
  s1_.updated_at AS updated_at_38,
  r2_.id AS id_39,
  r2_.name AS name_40,
  r2_.created_at AS created_at_41,
  r2_.updated_at AS updated_at_42,
  s3_.id AS id_43,
  s3_.name AS name_44,
  s3_.is_custom AS is_custom_45,
  s3_.created_at AS created_at_46,
  s3_.updated_at AS updated_at_47,
  s0_.subscription_plan_id AS subscription_plan_id_48
FROM
  supplier s0_
  LEFT JOIN subscription_plan s1_ ON s0_.subscription_plan_id = s1_.id
  LEFT JOIN supplier_region s4_ ON s0_.id = s4_.supplier_id
  LEFT JOIN region r2_ ON r2_.id = s4_.region_id
  LEFT JOIN supplier_service s5_ ON s0_.id = s5_.supplier_id
  LEFT JOIN service s3_ ON s3_.id = s5_.service_id
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.company_type AS company_type_1, s0_.name AS name_2, s0_.brn AS brn_3, s0_.is_vat_registered AS is_vat_registered_4, s0_.vat_registration_number AS vat_registration_number_5, s0_.email AS email_6, s0_.phone AS phone_7, s0_.address AS address_8, s0_.website AS website_9, s0_.description AS description_10, s0_.contact_person_name AS contact_person_name_11, s0_.contact_person_designation AS contact_person_designation_12, s0_.contact_person_email AS contact_person_email_13, s0_.contact_person_phone AS contact_person_phone_14, s0_.bank_account_holder_name AS bank_account_holder_name_15, s0_.bank_account_number AS bank_account_number_16, s0_.bank_name AS bank_name_17, s0_.bank_branch_name AS bank_branch_name_18, s0_.bank_iban AS bank_iban_19, s0_.bank_swift AS bank_swift_20, s0_.bank_account_currency AS bank_account_currency_21, s0_.subscription_payment_plan AS subscription_payment_plan_22, s0_.is_onboarding_completed AS is_onboarding_completed_23, s0_.is_onboarding_email_sent AS is_onboarding_email_sent_24, s0_.website_link AS website_link_25, s0_.facebook_link AS facebook_link_26, s0_.instagram_link AS instagram_link_27, s0_.linked_in_link AS linked_in_link_28, s0_.tiktok_link AS tiktok_link_29, s0_.created_at AS created_at_30, s0_.updated_at AS updated_at_31, s1_.id AS id_32, s1_.name AS name_33, s1_.description AS description_34, s1_.onboarding_fee AS onboarding_fee_35, s1_.monthly_fee AS monthly_fee_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, r2_.id AS id_39, r2_.name AS name_40, r2_.created_at AS created_at_41, r2_.updated_at AS updated_at_42, s3_.id AS id_43, s3_.name AS name_44, s3_.is_custom AS is_custom_45, s3_.created_at AS created_at_46, s3_.updated_at AS updated_at_47, s0_.subscription_plan_id AS subscription_plan_id_48 FROM supplier s0_ LEFT JOIN subscription_plan s1_ ON s0_.subscription_plan_id = s1_.id LEFT JOIN supplier_region s4_ ON s0_.id = s4_.supplier_id LEFT JOIN region r2_ ON r2_.id = s4_.region_id LEFT JOIN supplier_service s5_ ON s0_.id = s5_.supplier_id LEFT JOIN service s3_ ON s3_.id = s5_.service_id WHERE s0_.id = 158;

#	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 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 87)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Supplier\Supplier	No errors.
App\Entity\SubscriptionPlan\SubscriptionPlan	No errors.
App\Entity\Region\Region	No errors.
App\Entity\Service\Service	No errors.
App\Entity\User\User	No errors.

Symfony Profiler

GET https://admin.eventslab.africa/api/suppliers/158

Configuration Settings

Theme