Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

5.53 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.66 ms
(30.06%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "BATTLE4-usb"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.purshasing_price AS purshasing_price_3,
  t0.selling_price AS selling_price_4,
  t0.selling_price_all_taxes AS selling_price_all_taxes_5,
  t0.sales_unit AS sales_unit_6,
  t0.min_quantity AS min_quantity_7,
  t0.max_quantity AS max_quantity_8,
  t0.bulk_quantity AS bulk_quantity_9,
  t0.discount AS discount_10,
  t0.discount_type AS discount_type_11,
  t0.discount_on_taxe AS discount_on_taxe_12,
  t0.stock_management AS stock_management_13,
  t0.quantity AS quantity_14,
  t0.sell_out_of_stock AS sell_out_of_stock_15,
  t0.stock_alert AS stock_alert_16,
  t0.pre_order AS pre_order_17,
  t0.available_date AS available_date_18,
  t0.date_publish AS date_publish_19,
  t0.offline AS offline_20,
  t0.type AS type_21,
  t0.date_add AS date_add_22,
  t0.date_up AS date_up_23,
  t0.additionnal_shipping_cost AS additionnal_shipping_cost_24,
  t0.width AS width_25,
  t0.height AS height_26,
  t0.depth AS depth_27,
  t0.weight AS weight_28,
  t0.name AS name_29,
  t0.summary AS summary_30,
  t0.slug AS slug_31,
  t0.description AS description_32,
  t0.supplier_id AS supplier_id_33,
  t0.gamme_id AS gamme_id_34,
  t0.carrier_id AS carrier_id_35,
  t0.parent_id AS parent_id_36,
  t0.taxe_id AS taxe_id_37
FROM
  mg_products t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.slug = 'BATTLE4-usb' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ProductsController->show (line 143)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.55 ms
(27.96%)

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.position AS position_3,
  t0.cover AS cover_4,
  t0.mime_type AS mime_type_5,
  t0.product_id AS product_id_6
FROM
  mg_products_images t0
WHERE
  t0.product_id = ?
  AND t0.cover = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = 149 AND t0.cover = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ProductsController->show (line 150)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.92 ms
(16.61%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = ? AND t0.offline = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.purshasing_price AS purshasing_price_3,
  t0.selling_price AS selling_price_4,
  t0.selling_price_all_taxes AS selling_price_all_taxes_5,
  t0.sales_unit AS sales_unit_6,
  t0.min_quantity AS min_quantity_7,
  t0.max_quantity AS max_quantity_8,
  t0.bulk_quantity AS bulk_quantity_9,
  t0.discount AS discount_10,
  t0.discount_type AS discount_type_11,
  t0.discount_on_taxe AS discount_on_taxe_12,
  t0.stock_management AS stock_management_13,
  t0.quantity AS quantity_14,
  t0.sell_out_of_stock AS sell_out_of_stock_15,
  t0.stock_alert AS stock_alert_16,
  t0.pre_order AS pre_order_17,
  t0.available_date AS available_date_18,
  t0.date_publish AS date_publish_19,
  t0.offline AS offline_20,
  t0.type AS type_21,
  t0.date_add AS date_add_22,
  t0.date_up AS date_up_23,
  t0.additionnal_shipping_cost AS additionnal_shipping_cost_24,
  t0.width AS width_25,
  t0.height AS height_26,
  t0.depth AS depth_27,
  t0.weight AS weight_28,
  t0.name AS name_29,
  t0.summary AS summary_30,
  t0.slug AS slug_31,
  t0.description AS description_32,
  t0.supplier_id AS supplier_id_33,
  t0.gamme_id AS gamme_id_34,
  t0.carrier_id AS carrier_id_35,
  t0.parent_id AS parent_id_36,
  t0.taxe_id AS taxe_id_37
FROM
  mg_products t0
WHERE
  t0.parent_id = ?
  AND t0.offline = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.purshasing_price AS purshasing_price_3, t0.selling_price AS selling_price_4, t0.selling_price_all_taxes AS selling_price_all_taxes_5, t0.sales_unit AS sales_unit_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.bulk_quantity AS bulk_quantity_9, t0.discount AS discount_10, t0.discount_type AS discount_type_11, t0.discount_on_taxe AS discount_on_taxe_12, t0.stock_management AS stock_management_13, t0.quantity AS quantity_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.stock_alert AS stock_alert_16, t0.pre_order AS pre_order_17, t0.available_date AS available_date_18, t0.date_publish AS date_publish_19, t0.offline AS offline_20, t0.type AS type_21, t0.date_add AS date_add_22, t0.date_up AS date_up_23, t0.additionnal_shipping_cost AS additionnal_shipping_cost_24, t0.width AS width_25, t0.height AS height_26, t0.depth AS depth_27, t0.weight AS weight_28, t0.name AS name_29, t0.summary AS summary_30, t0.slug AS slug_31, t0.description AS description_32, t0.supplier_id AS supplier_id_33, t0.gamme_id AS gamme_id_34, t0.carrier_id AS carrier_id_35, t0.parent_id AS parent_id_36, t0.taxe_id AS taxe_id_37 FROM mg_products t0 WHERE t0.parent_id = 149 AND t0.offline = 0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ProductsController->show (line 179)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.76 ms
(13.77%)

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = ? AND t0.cover = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.position AS position_3,
  t0.cover AS cover_4,
  t0.mime_type AS mime_type_5,
  t0.product_id AS product_id_6
FROM
  mg_products_images t0
WHERE
  t0.product_id = ?
  AND t0.cover = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.position AS position_3, t0.cover AS cover_4, t0.mime_type AS mime_type_5, t0.product_id AS product_id_6 FROM mg_products_images t0 WHERE t0.product_id = 149 AND t0.cover = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\ProductsController->show (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.64 ms
(11.60%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = ?

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.slogan AS slogan_3,
  t0.seo_description AS seo_description_4,
  t0.email_contact AS email_contact_5,
  t0.email_order AS email_order_6,
  t0.logo AS logo_7,
  t0.nb_posts AS nb_posts_8
FROM
  mg_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Services\AppService->getParams (line 20)
7	Twig\Extension\CoreExtension->getAttribute (line 1913)
8	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544::doDisplay (line 64)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_17e382f36c43fcbedec0406928c852c9->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\ProductsController->show (line 192)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\MgProductsImages	2
App\Entity\MgProducts	1
App\Entity\MgSuppliers	1
App\Entity\MgCarriers	1
App\Entity\MgTaxes	1
App\Entity\MgParameters	1

Entities Mapping

Class	Mapping errors
App\Entity\MgProducts	No errors.
App\Entity\MgSuppliers	No errors.
App\Entity\MgGammes	No errors.
App\Entity\MgCarriers	No errors.
App\Entity\MgTaxes	No errors.
App\Entity\MgProductsImages	No errors.
App\Entity\MgProductsNumerical	No errors.
App\Entity\MgPropertiesContents	No errors.
App\Entity\MgMovementsStocks	No errors.
App\Entity\MgAuthors	No errors.
App\Entity\MgOrdersContent	No errors.
App\Entity\MgUsers	No errors.
App\Entity\MgCategories	No errors.
App\Entity\MgParameters	No errors.

Symfony Profiler

GET https://www.cms-morgane.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CSearchController%253A%253Asearch

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping