Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

3.42 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.56 ms
(45.61%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title IS NULL
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 166)
5	App\Helper\System\Currency\CurrencyHelper->getCurrency (line 115)
6	App\Helper\System\Currency\CurrencyHelper->currencySelectByVisitorInfo (line 106)
7	App\Helper\System\Currency\CurrencyHelper->currencyControl (line 49)
8	App\Subscriber\RequestSubscriber->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

0.97 ms
(28.36%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = ? AND t0.is_enabled = ? LIMIT 1

Parameters:

[
  "USD"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title = ?
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = 'USD' AND t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\Helper\System\Currency\CurrencyHelper->changeCurrency (line 131)
6	App\Helper\System\Currency\CurrencyHelper->currencySelectByVisitorInfo (line 106)
7	App\Helper\System\Currency\CurrencyHelper->currencyControl (line 49)
8	App\Subscriber\RequestSubscriber->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

0.89 ms
(26.03%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.id = ?

Parameters:

[
  "i"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sira AS sira_3,
  t0.barcode AS barcode_4,
  t0.product_code AS product_code_5,
  t0.is_enabled AS is_enabled_6,
  t0.del AS del_7,
  t0.new_product AS new_product_8,
  t0.show_home AS show_home_9,
  t0.is_variant AS is_variant_10,
  t0.avarage_rating AS avarage_rating_11,
  t0.total_visited AS total_visited_12,
  t0.position AS position_13,
  t0.total_sales AS total_sales_14,
  t0.audio_file AS audio_file_15,
  t0.uuid AS uuid_16,
  t0.length AS length_17,
  t0.depth AS depth_18,
  t0.height AS height_19,
  t0.weight AS weight_20,
  t0.product_material AS product_material_21,
  t0.product_color AS product_color_22,
  t0.product_suggestion AS product_suggestion_23,
  t0.product_paint_type AS product_paint_type_24,
  t0.delivery_time AS delivery_time_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.is_jewel_price AS is_jewel_price_28,
  t0.brand_id AS brand_id_29,
  t0.main_category_id AS main_category_id_30,
  t0.blog_id AS blog_id_31,
  t32.id AS id_33,
  t32.amount AS amount_34,
  t32.created_at AS created_at_35,
  t32.updated_at AS updated_at_36,
  t32.product_id AS product_id_37,
  t32.jewel_id AS jewel_id_38
FROM
  main_products t0
  LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.id = 'i';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 10)

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

Entities Mapping

Class	Mapping errors
App\Entity\System\Currency	No errors.
App\Entity\Main\Product\Product	No errors.
App\Entity\Main\Product\Brand	No errors.
App\Entity\Main\Product\Category	No errors.
App\Entity\Main\Blog\Blog	No errors.
App\Entity\Main\Product\ProductJewel	No errors.
App\Entity\System\Jewel	No errors.
App\Entity\Main\Product\ProductPricing	No errors.
App\Entity\Main\Product\ProductJewelPricing	No errors.
App\Entity\Main\Order\Order	No errors.
App\Entity\Main\Product\ProductGroupAssing	No errors.
App\Entity\Main\Product\ProductImages	No errors.
App\Entity\Main\Product\ProductCatalogMarker	No errors.
App\Entity\Main\Product\ProductLang	No errors.
App\Entity\Main\Product\ProductOtherCategory	No errors.
App\Entity\Main\Product\ProductVariant	No errors.
App\Entity\Main\Product\ProductReview	No errors.
App\Entity\Main\Product\ProductVariantAssing	No errors.
App\Entity\Main\Order\Cart	No errors.
App\Entity\Main\Order\OrderItem	No errors.
App\Entity\Main\Product\SimularProduct	No errors.
App\Entity\Main\Product\WishlistProduct	No errors.
App\Entity\Main\Banner\Banner	No errors.
App\Entity\Main\Product\CategoryImages	No errors.
App\Entity\Main\Product\CategoryLang	No errors.
App\Entity\Main\Tax\TaxRateCategory	No errors.
App\Entity\Main\Blog\BlogLang	No errors.

Symfony Profiler

GET https://www.thema8.e-ticaret.biz/deneme-2/p/i

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping