Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.20 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.20 ms
(100.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ref AS ref_4, t0.alt AS alt_5, t0.position AS position_6, t0.price AS price_7, t0.promo AS promo_8, t0.image AS image_9, t0.stock AS stock_10, t0.create_at AS create_at_11, t0.update_at AS update_at_12, t0.active AS active_13, t0.default_name AS default_name_14, t0.long_description AS long_description_15, t0.short_description AS short_description_16, t0.care AS care_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.image AS image_23, t19.alt AS alt_24, t19.min_price AS min_price_25, t19.update_at AS update_at_26, t19.title_page AS title_page_27, t19.sub_title_page AS sub_title_page_28, t19.cite_page AS cite_page_29, t19.main_image AS main_image_30, t19.main_alt AS main_alt_31, t19.second_image AS second_image_32, t19.second_alt AS second_alt_33, t19.third_image AS third_image_34, t19.third_alt AS third_alt_35, t19.fourth_image AS fourth_image_36, t19.fourth_alt AS fourth_alt_37, t19.nb_display AS nb_display_38, t19.sort AS sort_39, t19.show_sub_categories AS show_sub_categories_40, t19.description AS description_41, t19.meta_title AS meta_title_42, t19.parent_id AS parent_id_43, t0.field_id AS field_id_44, t0.product_option_id AS product_option_id_45 FROM product t0 LEFT JOIN category t19 ON t0.category_id = t19.id WHERE t0.id = ?

Parameters:

[
  "30"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.ref AS ref_4,
  t0.alt AS alt_5,
  t0.position AS position_6,
  t0.price AS price_7,
  t0.promo AS promo_8,
  t0.image AS image_9,
  t0.stock AS stock_10,
  t0.create_at AS create_at_11,
  t0.update_at AS update_at_12,
  t0.active AS active_13,
  t0.default_name AS default_name_14,
  t0.long_description AS long_description_15,
  t0.short_description AS short_description_16,
  t0.care AS care_17,
  t0.category_id AS category_id_18,
  t19.id AS id_20,
  t19.name AS name_21,
  t19.slug AS slug_22,
  t19.image AS image_23,
  t19.alt AS alt_24,
  t19.min_price AS min_price_25,
  t19.update_at AS update_at_26,
  t19.title_page AS title_page_27,
  t19.sub_title_page AS sub_title_page_28,
  t19.cite_page AS cite_page_29,
  t19.main_image AS main_image_30,
  t19.main_alt AS main_alt_31,
  t19.second_image AS second_image_32,
  t19.second_alt AS second_alt_33,
  t19.third_image AS third_image_34,
  t19.third_alt AS third_alt_35,
  t19.fourth_image AS fourth_image_36,
  t19.fourth_alt AS fourth_alt_37,
  t19.nb_display AS nb_display_38,
  t19.sort AS sort_39,
  t19.show_sub_categories AS show_sub_categories_40,
  t19.description AS description_41,
  t19.meta_title AS meta_title_42,
  t19.parent_id AS parent_id_43,
  t0.field_id AS field_id_44,
  t0.product_option_id AS product_option_id_45
FROM
  product t0
  LEFT JOIN category t19 ON t0.category_id = t19.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ref AS ref_4, t0.alt AS alt_5, t0.position AS position_6, t0.price AS price_7, t0.promo AS promo_8, t0.image AS image_9, t0.stock AS stock_10, t0.create_at AS create_at_11, t0.update_at AS update_at_12, t0.active AS active_13, t0.default_name AS default_name_14, t0.long_description AS long_description_15, t0.short_description AS short_description_16, t0.care AS care_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.image AS image_23, t19.alt AS alt_24, t19.min_price AS min_price_25, t19.update_at AS update_at_26, t19.title_page AS title_page_27, t19.sub_title_page AS sub_title_page_28, t19.cite_page AS cite_page_29, t19.main_image AS main_image_30, t19.main_alt AS main_alt_31, t19.second_image AS second_image_32, t19.second_alt AS second_alt_33, t19.third_image AS third_image_34, t19.third_alt AS third_alt_35, t19.fourth_image AS fourth_image_36, t19.fourth_alt AS fourth_alt_37, t19.nb_display AS nb_display_38, t19.sort AS sort_39, t19.show_sub_categories AS show_sub_categories_40, t19.description AS description_41, t19.meta_title AS meta_title_42, t19.parent_id AS parent_id_43, t0.field_id AS field_id_44, t0.product_option_id AS product_option_id_45 FROM product t0 LEFT JOIN category t19 ON t0.category_id = t19.id WHERE t0.id = '30';

#	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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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\Category	2
App\Entity\Product	1
App\Entity\Field	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Field	No errors.
App\Entity\ProductOption	No errors.
App\Entity\Attachment	No errors.
App\Entity\ProductFeature	No errors.
App\Entity\ProductAttributeGroup	No errors.
App\Entity\ProductAttribute	No errors.

Symfony Profiler

GET http://v2.tussor.net/panier/remove-product/30

Configuration Settings

Theme

Page Width