Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.53 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲

Time

Info

2.53 ms

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.color AS color_2, s0_.description AS description_3, s0_.enabled AS enabled_4, s0_.hostname AS hostname_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.id AS id_8, s0_.theme_name AS theme_name_9, s0_.tax_calculation_strategy AS tax_calculation_strategy_10, s0_.contact_email AS contact_email_11, s0_.contact_phone_number AS contact_phone_number_12, s0_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, s0_.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, s0_.account_verification_required AS account_verification_required_15, s0_.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_16, s0_.default_shop AS default_shop_17, s0_.is_spam_alert_sent AS is_spam_alert_sent_18, s1_.code AS code_19, s1_.created_at AS created_at_20, s1_.updated_at AS updated_at_21, s1_.id AS id_22, s2_.code AS code_23, s2_.created_at AS created_at_24, s2_.updated_at AS updated_at_25, s2_.id AS id_26, s3_.code AS code_27, s3_.enabled AS enabled_28, s3_.id AS id_29, t4_.id_ws AS id_ws_30, t4_.name AS name_31, t4_.url_type AS url_type_32, t4_.slug AS slug_33, t4_.color AS color_34, t4_.code AS code_35, t4_.favicon AS favicon_36, t4_.logo AS logo_37, t4_.placeholder_logo AS placeholder_logo_38, t4_.placeholder_color AS placeholder_color_39, t4_.authentication_text AS authentication_text_40, t4_.authentication_logo AS authentication_logo_41, t4_.sender_email AS sender_email_42, t4_.active AS active_43, t4_.is_archived AS is_archived_44, t4_.is_authentication_mandatory AS is_authentication_mandatory_45, t4_.is_access_protected AS is_access_protected_46, t4_.password_access AS password_access_47, t4_.login_description AS login_description_48, t4_.created_at AS created_at_49, t4_.updated_at AS updated_at_50, t4_.id AS id_51, s0_.default_locale_id AS default_locale_id_52, s0_.base_currency_id AS base_currency_id_53, s0_.default_tax_zone_id AS default_tax_zone_id_54, s0_.menu_taxon_id AS menu_taxon_id_55, s0_.insurance_id AS insurance_id_56, s0_.shop_billing_data_id AS shop_billing_data_id_57, t4_.channel_id AS channel_id_58 FROM sylius_channel s0_ INNER JOIN sylius_channel_currencies s5_ ON s0_.id = s5_.channel_id INNER JOIN sylius_currency s1_ ON s1_.id = s5_.currency_id INNER JOIN sylius_channel_locales s6_ ON s0_.id = s6_.channel_id INNER JOIN sylius_locale s2_ ON s2_.id = s6_.locale_id LEFT JOIN sylius_channel_countries s7_ ON s0_.id = s7_.channel_id LEFT JOIN sylius_country s3_ ON s3_.id = s7_.country_id LEFT JOIN ticklive_white_label t4_ ON s0_.id = t4_.channel_id ORDER BY s0_.id ASC, s1_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.code AS code_0,
  s0_.name AS name_1,
  s0_.color AS color_2,
  s0_.description AS description_3,
  s0_.enabled AS enabled_4,
  s0_.hostname AS hostname_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.id AS id_8,
  s0_.theme_name AS theme_name_9,
  s0_.tax_calculation_strategy AS tax_calculation_strategy_10,
  s0_.contact_email AS contact_email_11,
  s0_.contact_phone_number AS contact_phone_number_12,
  s0_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13,
  s0_.skipping_payment_step_allowed AS skipping_payment_step_allowed_14,
  s0_.account_verification_required AS account_verification_required_15,
  s0_.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_16,
  s0_.default_shop AS default_shop_17,
  s0_.is_spam_alert_sent AS is_spam_alert_sent_18,
  s1_.code AS code_19,
  s1_.created_at AS created_at_20,
  s1_.updated_at AS updated_at_21,
  s1_.id AS id_22,
  s2_.code AS code_23,
  s2_.created_at AS created_at_24,
  s2_.updated_at AS updated_at_25,
  s2_.id AS id_26,
  s3_.code AS code_27,
  s3_.enabled AS enabled_28,
  s3_.id AS id_29,
  t4_.id_ws AS id_ws_30,
  t4_.name AS name_31,
  t4_.url_type AS url_type_32,
  t4_.slug AS slug_33,
  t4_.color AS color_34,
  t4_.code AS code_35,
  t4_.favicon AS favicon_36,
  t4_.logo AS logo_37,
  t4_.placeholder_logo AS placeholder_logo_38,
  t4_.placeholder_color AS placeholder_color_39,
  t4_.authentication_text AS authentication_text_40,
  t4_.authentication_logo AS authentication_logo_41,
  t4_.sender_email AS sender_email_42,
  t4_.active AS active_43,
  t4_.is_archived AS is_archived_44,
  t4_.is_authentication_mandatory AS is_authentication_mandatory_45,
  t4_.is_access_protected AS is_access_protected_46,
  t4_.password_access AS password_access_47,
  t4_.login_description AS login_description_48,
  t4_.created_at AS created_at_49,
  t4_.updated_at AS updated_at_50,
  t4_.id AS id_51,
  s0_.default_locale_id AS default_locale_id_52,
  s0_.base_currency_id AS base_currency_id_53,
  s0_.default_tax_zone_id AS default_tax_zone_id_54,
  s0_.menu_taxon_id AS menu_taxon_id_55,
  s0_.insurance_id AS insurance_id_56,
  s0_.shop_billing_data_id AS shop_billing_data_id_57,
  t4_.channel_id AS channel_id_58
FROM
  sylius_channel s0_
  INNER JOIN sylius_channel_currencies s5_ ON s0_.id = s5_.channel_id
  INNER JOIN sylius_currency s1_ ON s1_.id = s5_.currency_id
  INNER JOIN sylius_channel_locales s6_ ON s0_.id = s6_.channel_id
  INNER JOIN sylius_locale s2_ ON s2_.id = s6_.locale_id
  LEFT JOIN sylius_channel_countries s7_ ON s0_.id = s7_.channel_id
  LEFT JOIN sylius_country s3_ ON s3_.id = s7_.country_id
  LEFT JOIN ticklive_white_label t4_ ON s0_.id = t4_.channel_id
ORDER BY
  s0_.id ASC,
  s1_.id ASC

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.color AS color_2, s0_.description AS description_3, s0_.enabled AS enabled_4, s0_.hostname AS hostname_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.id AS id_8, s0_.theme_name AS theme_name_9, s0_.tax_calculation_strategy AS tax_calculation_strategy_10, s0_.contact_email AS contact_email_11, s0_.contact_phone_number AS contact_phone_number_12, s0_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, s0_.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, s0_.account_verification_required AS account_verification_required_15, s0_.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_16, s0_.default_shop AS default_shop_17, s0_.is_spam_alert_sent AS is_spam_alert_sent_18, s1_.code AS code_19, s1_.created_at AS created_at_20, s1_.updated_at AS updated_at_21, s1_.id AS id_22, s2_.code AS code_23, s2_.created_at AS created_at_24, s2_.updated_at AS updated_at_25, s2_.id AS id_26, s3_.code AS code_27, s3_.enabled AS enabled_28, s3_.id AS id_29, t4_.id_ws AS id_ws_30, t4_.name AS name_31, t4_.url_type AS url_type_32, t4_.slug AS slug_33, t4_.color AS color_34, t4_.code AS code_35, t4_.favicon AS favicon_36, t4_.logo AS logo_37, t4_.placeholder_logo AS placeholder_logo_38, t4_.placeholder_color AS placeholder_color_39, t4_.authentication_text AS authentication_text_40, t4_.authentication_logo AS authentication_logo_41, t4_.sender_email AS sender_email_42, t4_.active AS active_43, t4_.is_archived AS is_archived_44, t4_.is_authentication_mandatory AS is_authentication_mandatory_45, t4_.is_access_protected AS is_access_protected_46, t4_.password_access AS password_access_47, t4_.login_description AS login_description_48, t4_.created_at AS created_at_49, t4_.updated_at AS updated_at_50, t4_.id AS id_51, s0_.default_locale_id AS default_locale_id_52, s0_.base_currency_id AS base_currency_id_53, s0_.default_tax_zone_id AS default_tax_zone_id_54, s0_.menu_taxon_id AS menu_taxon_id_55, s0_.insurance_id AS insurance_id_56, s0_.shop_billing_data_id AS shop_billing_data_id_57, t4_.channel_id AS channel_id_58 FROM sylius_channel s0_ INNER JOIN sylius_channel_currencies s5_ ON s0_.id = s5_.channel_id INNER JOIN sylius_currency s1_ ON s1_.id = s5_.currency_id INNER JOIN sylius_channel_locales s6_ ON s0_.id = s6_.channel_id INNER JOIN sylius_locale s2_ ON s2_.id = s6_.locale_id LEFT JOIN sylius_channel_countries s7_ ON s0_.id = s7_.channel_id LEFT JOIN sylius_country s3_ ON s3_.id = s7_.country_id LEFT JOIN ticklive_white_label t4_ ON s0_.id = t4_.channel_id ORDER BY s0_.id ASC, s1_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	TickLive\ShopBundle\Repository\ChannelRepository->findAllChannels (line 239)
8	TickLive\ShopBundle\Infrastructure\Context\Channel\ChannelContext->loadChannels (line 77)
9	TickLive\ShopBundle\Infrastructure\Context\Channel\ChannelContext->getChannel (line 165)
10	TickLive\ShopBundle\Services\Ticketing\WhiteLabelManager->getCurrentWhiteLabel (line 20)
11	TickLive\ShopBundle\Security\WhiteLabel\WhiteLabelAuthenticatedFirewallMatcher->matches (line 72)
12	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallContext (line 49)
13	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallConfig (line 48)
14	Symfony\Bundle\SecurityBundle\EventListener\FirewallListener->configureLogoutUrlGenerator (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
supervisor	doctrine.dbal.supervisor_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
supervisor	doctrine.orm.supervisor_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://dev.web.tickandlive.com/_fos_user_context_hash

Configuration Settings

Theme

Page Width