Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.03 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.39 ms
(79.05%)

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 INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id WHERE mg_products_mg_categories.mg_categories_id = ?

Parameters:

[
  21
]

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
  INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id
WHERE
  mg_products_mg_categories.mg_categories_id = ?

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 INNER JOIN mg_products_mg_categories ON t0.id = mg_products_mg_categories.mg_products_id WHERE mg_products_mg_categories.mg_categories_id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\ProductsController->catalog (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.63 ms
(20.95%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Enceintes-et-accessoires"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.force_display AS force_display_4,
  t0.type AS type_5,
  t0.date_add AS date_add_6,
  t0.date_up AS date_up_7,
  t0.level AS level_8,
  t0.name AS name_9,
  t0.description AS description_10,
  t0.slug AS slug_11,
  t0.parent_id AS parent_id_12
FROM
  mg_categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.slug = 'Enceintes-et-accessoires' 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->catalog (line 29)
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)

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\MgCategories	2
App\Entity\MgProducts	1
App\Entity\MgSuppliers	1

Entities Mapping

Class	Mapping errors
App\Entity\MgCategories	No errors.
App\Entity\MgPosts	No 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\MgUsers	No errors.
App\Entity\MgPostsLang	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\MgCarriersConfig	No errors.
App\Entity\MgOrdersCarriers	No errors.
App\Entity\MgTaxesLang	No errors.
App\Entity\MgOrdersTaxes	No errors.

Symfony Profiler

GET https://www.cms-morgane.fr/catalog/category/Enceintes-et-accessoires/17

Configuration Settings

Theme

Page Width