Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.48 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.35 ms
(72.32%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.Codice AS Codice_3, t0.TSCreazione AS TSCreazione_4, t0.TSModifica AS TSModifica_5, t0.tra_Descrizione AS tra_Descrizione_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.alternativeTitle AS alternativeTitle_9, t0.description AS description_10, t0.productListDescription AS productListDescription_11, t0.productDescription AS productDescription_12, t0.sortablePosition AS sortablePosition_13, t0.multilanguage AS multilanguage_14, t0.locale AS locale_15, t0.metaTitle AS metaTitle_16, t0.metaDescription AS metaDescription_17, t0.ogType AS ogType_18, t0.ogTitle AS ogTitle_19, t0.ogDescription AS ogDescription_20, t0.twitterTitle AS twitterTitle_21, t0.twitterDescription AS twitterDescription_22, t0.keywords AS keywords_23, t0.ogImageName AS ogImageName_24, t0.slug AS slug_25, t0.ref_GruppoCategorie AS ref_GruppoCategorie_26 FROM Categorie t0 WHERE t0.Codice IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.enabled = ?

Parameters:

[
  "01MI"
  "01MU"
  "02MS"
  "03AF"
  "04LU"
  "05PE"
  "06LA"
  "07LC"
  "08LM"
  "09LP"
  "10BD"
  "11LV"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.Codice AS Codice_3,
  t0.TSCreazione AS TSCreazione_4,
  t0.TSModifica AS TSModifica_5,
  t0.tra_Descrizione AS tra_Descrizione_6,
  t0.enabled AS enabled_7,
  t0.imageName AS imageName_8,
  t0.alternativeTitle AS alternativeTitle_9,
  t0.description AS description_10,
  t0.productListDescription AS productListDescription_11,
  t0.productDescription AS productDescription_12,
  t0.sortablePosition AS sortablePosition_13,
  t0.multilanguage AS multilanguage_14,
  t0.locale AS locale_15,
  t0.metaTitle AS metaTitle_16,
  t0.metaDescription AS metaDescription_17,
  t0.ogType AS ogType_18,
  t0.ogTitle AS ogTitle_19,
  t0.ogDescription AS ogDescription_20,
  t0.twitterTitle AS twitterTitle_21,
  t0.twitterDescription AS twitterDescription_22,
  t0.keywords AS keywords_23,
  t0.ogImageName AS ogImageName_24,
  t0.slug AS slug_25,
  t0.ref_GruppoCategorie AS ref_GruppoCategorie_26
FROM
  Categorie t0
WHERE
  t0.Codice IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.Codice AS Codice_3, t0.TSCreazione AS TSCreazione_4, t0.TSModifica AS TSModifica_5, t0.tra_Descrizione AS tra_Descrizione_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.alternativeTitle AS alternativeTitle_9, t0.description AS description_10, t0.productListDescription AS productListDescription_11, t0.productDescription AS productDescription_12, t0.sortablePosition AS sortablePosition_13, t0.multilanguage AS multilanguage_14, t0.locale AS locale_15, t0.metaTitle AS metaTitle_16, t0.metaDescription AS metaDescription_17, t0.ogType AS ogType_18, t0.ogTitle AS ogTitle_19, t0.ogDescription AS ogDescription_20, t0.twitterTitle AS twitterTitle_21, t0.twitterDescription AS twitterDescription_22, t0.keywords AS keywords_23, t0.ogImageName AS ogImageName_24, t0.slug AS slug_25, t0.ref_GruppoCategorie AS ref_GruppoCategorie_26 FROM Categorie t0 WHERE t0.Codice IN ('01MI', '01MU', '02MS', '03AF', '04LU', '05PE', '06LA', '07LC', '08LM', '09LP', '10BD', '11LV') AND t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\Controller\CatalogController->catalog (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.13 ms
(27.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.metaTitle AS metaTitle_6, t0.metaDescription AS metaDescription_7, t0.ogType AS ogType_8, t0.ogTitle AS ogTitle_9, t0.ogDescription AS ogDescription_10, t0.twitterTitle AS twitterTitle_11, t0.twitterDescription AS twitterDescription_12, t0.keywords AS keywords_13, t0.ogImageName AS ogImageName_14, t0.multilanguage AS multilanguage_15, t0.locale AS locale_16 FROM StaticPage t0 WHERE t0.route = ? AND t0.locale = ? LIMIT 1

Parameters:

[
  "app_catalog"
  "it"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.route AS route_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.metaTitle AS metaTitle_6,
  t0.metaDescription AS metaDescription_7,
  t0.ogType AS ogType_8,
  t0.ogTitle AS ogTitle_9,
  t0.ogDescription AS ogDescription_10,
  t0.twitterTitle AS twitterTitle_11,
  t0.twitterDescription AS twitterDescription_12,
  t0.keywords AS keywords_13,
  t0.ogImageName AS ogImageName_14,
  t0.multilanguage AS multilanguage_15,
  t0.locale AS locale_16
FROM
  StaticPage t0
WHERE
  t0.route = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.metaTitle AS metaTitle_6, t0.metaDescription AS metaDescription_7, t0.ogType AS ogType_8, t0.ogTitle AS ogTitle_9, t0.ogDescription AS ogDescription_10, t0.twitterTitle AS twitterTitle_11, t0.twitterDescription AS twitterDescription_12, t0.keywords AS keywords_13, t0.ogImageName AS ogImageName_14, t0.multilanguage AS multilanguage_15, t0.locale AS locale_16 FROM StaticPage t0 WHERE t0.route = 'app_catalog' AND t0.locale = 'it' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 18)
5	App\Controller\MetatagsController->getStaticPageMetatagsAndHreflangs (line 20)
6	App\Controller\MetatagsController->_metatags (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 168)
14	__TwigTemplate_c2e85b906d79ead6421f831bfb9366b6->{closure} (line 1919)
15	Twig\Extension\CoreExtension::captureOutput (line 173)
16	__TwigTemplate_c2e85b906d79ead6421f831bfb9366b6->{closure} (line 111)
17	Symfony\Component\Cache\LockRegistry::compute (line 104)
18	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
19	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 111)
20	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
21	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 174)
22	__TwigTemplate_c2e85b906d79ead6421f831bfb9366b6->block_meta_group (line 437)
23	Twig\Template->yieldBlock (line 70)
24	__TwigTemplate_c2e85b906d79ead6421f831bfb9366b6->doDisplay (line 393)
25	Twig\Template->yield (line 58)
26	__TwigTemplate_0c4aae97f2aaa9a1771cd00ff0147269->doDisplay (line 393)
27	Twig\Template->yield (line 349)
28	Twig\Template->display (line 364)
29	Twig\Template->render (line 35)
30	Twig\TemplateWrapper->render (line 306)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 64)
35	App\Controller\CatalogController->catalog (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	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.

Entities Mapping

Class	Mapping errors
App\Entity\Categorie	No errors.
App\Entity\Articoli	The field 'App\Entity\Articoli#PrezzoCatalogo' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Articoli#PrezzoVendita' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Articoli#PrezzoIVAInclusa' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Articoli#Profondita' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\StaticPage	No errors.

Symfony Profiler

GET https://shopdocks.copiaincolla.com/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DApp%255CController%255CMetatagsController%253A%253A_metatags

Configuration Settings

Theme