Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.83 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.95 ms
(51.95%)

SELECT s0_.id AS id_0, s0_.payment_sandbox AS payment_sandbox_1, s0_.payment_seamless_enabled AS payment_seamless_enabled_2, s0_.payment_timeout_sec AS payment_timeout_sec_3, s0_.payment_success_message AS payment_success_message_4, s0_.payment_failure_message AS payment_failure_message_5, s0_.wupex_fulfillment_max_retries AS wupex_fulfillment_max_retries_6, s0_.wupex_fulfillment_retry_delay_sec AS wupex_fulfillment_retry_delay_sec_7, s0_.wupex_manual_relaunch_enabled AS wupex_manual_relaunch_enabled_8, s0_.catalog_page_size AS catalog_page_size_9, s0_.catalog_show_stock AS catalog_show_stock_10, s0_.catalog_default_sort AS catalog_default_sort_11, s0_.order_min_amount_xof AS order_min_amount_xof_12, s0_.order_max_amount_xof AS order_max_amount_xof_13, s0_.order_require_phone AS order_require_phone_14, s0_.loyalty_points_expiry_days AS loyalty_points_expiry_days_15, s0_.loyalty_points_per_order_cap AS loyalty_points_per_order_cap_16, s0_.loyalty_event_bonus_percent AS loyalty_event_bonus_percent_17, s0_.referral_max_per_month AS referral_max_per_month_18, s0_.referral_first_order_only AS referral_first_order_only_19, s0_.seo_home_title AS seo_home_title_20, s0_.seo_promo_banner_text AS seo_promo_banner_text_21, s0_.cms_footer_text AS cms_footer_text_22, s0_.updated_at AS updated_at_23 FROM system_setting s0_ ORDER BY s0_.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.payment_sandbox AS payment_sandbox_1,
  s0_.payment_seamless_enabled AS payment_seamless_enabled_2,
  s0_.payment_timeout_sec AS payment_timeout_sec_3,
  s0_.payment_success_message AS payment_success_message_4,
  s0_.payment_failure_message AS payment_failure_message_5,
  s0_.wupex_fulfillment_max_retries AS wupex_fulfillment_max_retries_6,
  s0_.wupex_fulfillment_retry_delay_sec AS wupex_fulfillment_retry_delay_sec_7,
  s0_.wupex_manual_relaunch_enabled AS wupex_manual_relaunch_enabled_8,
  s0_.catalog_page_size AS catalog_page_size_9,
  s0_.catalog_show_stock AS catalog_show_stock_10,
  s0_.catalog_default_sort AS catalog_default_sort_11,
  s0_.order_min_amount_xof AS order_min_amount_xof_12,
  s0_.order_max_amount_xof AS order_max_amount_xof_13,
  s0_.order_require_phone AS order_require_phone_14,
  s0_.loyalty_points_expiry_days AS loyalty_points_expiry_days_15,
  s0_.loyalty_points_per_order_cap AS loyalty_points_per_order_cap_16,
  s0_.loyalty_event_bonus_percent AS loyalty_event_bonus_percent_17,
  s0_.referral_max_per_month AS referral_max_per_month_18,
  s0_.referral_first_order_only AS referral_first_order_only_19,
  s0_.seo_home_title AS seo_home_title_20,
  s0_.seo_promo_banner_text AS seo_promo_banner_text_21,
  s0_.cms_footer_text AS cms_footer_text_22,
  s0_.updated_at AS updated_at_23
FROM
  system_setting s0_
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.payment_sandbox AS payment_sandbox_1, s0_.payment_seamless_enabled AS payment_seamless_enabled_2, s0_.payment_timeout_sec AS payment_timeout_sec_3, s0_.payment_success_message AS payment_success_message_4, s0_.payment_failure_message AS payment_failure_message_5, s0_.wupex_fulfillment_max_retries AS wupex_fulfillment_max_retries_6, s0_.wupex_fulfillment_retry_delay_sec AS wupex_fulfillment_retry_delay_sec_7, s0_.wupex_manual_relaunch_enabled AS wupex_manual_relaunch_enabled_8, s0_.catalog_page_size AS catalog_page_size_9, s0_.catalog_show_stock AS catalog_show_stock_10, s0_.catalog_default_sort AS catalog_default_sort_11, s0_.order_min_amount_xof AS order_min_amount_xof_12, s0_.order_max_amount_xof AS order_max_amount_xof_13, s0_.order_require_phone AS order_require_phone_14, s0_.loyalty_points_expiry_days AS loyalty_points_expiry_days_15, s0_.loyalty_points_per_order_cap AS loyalty_points_per_order_cap_16, s0_.loyalty_event_bonus_percent AS loyalty_event_bonus_percent_17, s0_.referral_max_per_month AS referral_max_per_month_18, s0_.referral_first_order_only AS referral_first_order_only_19, s0_.seo_home_title AS seo_home_title_20, s0_.seo_promo_banner_text AS seo_promo_banner_text_21, s0_.cms_footer_text AS cms_footer_text_22, s0_.updated_at AS updated_at_23 FROM system_setting s0_ ORDER BY s0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\SystemSettingRepository->findCurrent (line 25)
7	App\Twig\SystemSettingExtension->getGlobals (line 20)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\CartController->index (line 30)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.88 ms
(48.05%)

SELECT p0_.id AS id_0, p0_.base_currency AS base_currency_1, p0_.display_currency AS display_currency_2, p0_.manual_rate AS manual_rate_3, p0_.auto_update_rate AS auto_update_rate_4, p0_.commission_percent AS commission_percent_5, p0_.exchange_rate_api_url AS exchange_rate_api_url_6, p0_.updated_at AS updated_at_7 FROM pricing_setting p0_ ORDER BY p0_.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.base_currency AS base_currency_1,
  p0_.display_currency AS display_currency_2,
  p0_.manual_rate AS manual_rate_3,
  p0_.auto_update_rate AS auto_update_rate_4,
  p0_.commission_percent AS commission_percent_5,
  p0_.exchange_rate_api_url AS exchange_rate_api_url_6,
  p0_.updated_at AS updated_at_7
FROM
  pricing_setting p0_
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.base_currency AS base_currency_1, p0_.display_currency AS display_currency_2, p0_.manual_rate AS manual_rate_3, p0_.auto_update_rate AS auto_update_rate_4, p0_.commission_percent AS commission_percent_5, p0_.exchange_rate_api_url AS exchange_rate_api_url_6, p0_.updated_at AS updated_at_7 FROM pricing_setting p0_ ORDER BY p0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\PricingSettingRepository->findCurrent (line 25)
7	App\Service\Pricing\CatalogPricingService->resolveContext (line 42)
8	App\Service\Cart\CartService->getDetailedCart (line 67)
9	App\Controller\CartController->index (line 28)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\PricingSetting	1
App\Entity\SystemSetting	1

Entities Mapping

Class	Mapping errors
App\Entity\PricingSetting	No errors.
App\Entity\SystemSetting	No errors.

Symfony Profiler

GET https://instacode.ges-eas.com/panier

Configuration Settings

Theme

Page Width