Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.55 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.36 ms
(64.88%)

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.slug = ? LIMIT 1

Parameters:

[
  "pannelli-in-alluminio-39"
]

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.slug = ?
LIMIT
  1

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.slug = 'pannelli-in-alluminio-39' 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 72)
5	App\Controller\CatalogController->categoryToProducts (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.19 ms
(35.12%)

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.ref_GruppoCategorie = ? AND t0.enabled = ? ORDER BY t0.sortablePosition DESC

Parameters:

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.ref_GruppoCategorie = ?
  AND t0.enabled = ?
ORDER BY
  t0.sortablePosition DESC

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.ref_GruppoCategorie = 39 AND t0.enabled = 1 ORDER BY t0.sortablePosition DESC;

#	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 74)
5	App\Controller\CatalogController->categoryToProducts (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)

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.

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.

Symfony Profiler

GET https://shopdocks.copiaincolla.com/prodotti/pannelli-in-alluminio-39

Configuration Settings

Theme