Symfony Profiler

Query Metrics

30 Database Queries

19 Different statements

23.55 ms Query time

0 Invalid entities

29 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.84 ms
(16.32%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "nuip1737_tussor_dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nuip1737_tussor_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 342)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 207)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
4	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 225)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 76)
6	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
7	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
8	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
18	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
19	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
20	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
21	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\ShopController->detail (line 82)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 5)

3.40 ms
(14.45%)

SELECT
       c.TABLE_NAME,
       c.COLUMN_NAME        AS field,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'nuip1737_tussor_dev'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    )                   AS type,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
 WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
   AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION

Parameters:

[
  "nuip1737_tussor_dev"
  "nuip1737_tussor_dev"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME AS field,
  IF(
    c.DATA_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      FROM
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'nuip1737_tussor_dev'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.DATA_TYPE
  ) AS type,
  c.COLUMN_TYPE,
  c.CHARACTER_MAXIMUM_LENGTH,
  c.CHARACTER_OCTET_LENGTH,
  c.NUMERIC_PRECISION,
  c.NUMERIC_SCALE,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY
  c.TABLE_NAME,
  c.ORDINAL_POSITION

SELECT
       c.TABLE_NAME,
       c.COLUMN_NAME        AS field,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'nuip1737_tussor_dev'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    )                   AS type,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
 WHERE c.TABLE_SCHEMA = 'nuip1737_tussor_dev' AND t.TABLE_SCHEMA = 'nuip1737_tussor_dev' AND t.TABLE_NAME = 'doctrine_migration_versions'
   AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns (line 388)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchTableColumns (line 398)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns (line 144)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 484)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	App\Controller\ShopController->detail (line 82)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

3.01 ms
(12.78%)

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'

Parameters:

[
  "nuip1737_tussor_dev"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'nuip1737_tussor_dev' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->fetchTableOptionsByTable (line 474)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->getTableOptions (line 556)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 496)
4	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
7	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
8	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
9	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
19	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
20	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
21	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
22	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\ShopController->detail (line 82)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

2.30 ms
(9.78%)

SELECT
            k.TABLE_NAME,
            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION,
            c.UPDATE_RULE,
            c.DELETE_RULE
FROM information_schema.key_column_usage k
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION

Parameters:

[
  "nuip1737_tussor_dev"
  "nuip1737_tussor_dev"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION,
  c.UPDATE_RULE,
  c.DELETE_RULE
FROM
  information_schema.key_column_usage k
  INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME
WHERE
  k.TABLE_SCHEMA = ?
  AND c.CONSTRAINT_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.ORDINAL_POSITION

SELECT
            k.TABLE_NAME,
            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION,
            c.UPDATE_RULE,
            c.DELETE_RULE
FROM information_schema.key_column_usage k
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = 'nuip1737_tussor_dev' AND c.CONSTRAINT_SCHEMA = 'nuip1737_tussor_dev' AND k.TABLE_NAME = 'doctrine_migration_versions'
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectForeignKeyColumns (line 458)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchForeignKeyColumns (line 424)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableForeignKeys (line 538)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 495)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	App\Controller\ShopController->detail (line 82)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

1.95 ms
(8.27%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	Doctrine\DBAL\Connection->getDatabase (line 161)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1458)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 208)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 225)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 76)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	App\Controller\ShopController->detail (line 82)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

1.32 ms
(5.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_group_id AS product_attribute_group_id_6 FROM product_attribute t0 INNER JOIN product_product_attribute ON t0.id = product_product_attribute.product_attribute_id WHERE product_product_attribute.product_id = ?

Parameters:

[
  887
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_group_id AS product_attribute_group_id_6
FROM
  product_attribute t0
  INNER JOIN product_product_attribute ON t0.id = product_product_attribute.product_attribute_id
WHERE
  product_product_attribute.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_group_id AS product_attribute_group_id_6 FROM product_attribute t0 INNER JOIN product_product_attribute ON t0.id = product_product_attribute.product_attribute_id WHERE product_product_attribute.product_id = 887;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Service\ProductService->getCombinationByGroups (line 29)
8	App\Controller\ShopController->detail (line 45)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.20 ms
(5.10%)

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

Parameters:

[
  "canotage-large-olive"
]

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

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.slug = 'canotage-large-olive' 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\ShopController->detail (line 37)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.97 ms
(4.12%)

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 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = ?

Parameters:

[
  887
]

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
  INNER JOIN product_product ON t0.id = product_product.product_target
WHERE
  product_product.product_source = ?

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 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = 887;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getValues (line 140)
7	Twig\Extension\CoreExtension->getAttribute (line 1911)
8	__TwigTemplate_b78866eca84f5c338877174f10413382::block_body (line 719)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 131)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\ShopController->detail (line 82)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.97 ms
(4.11%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  23
]

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.image AS image_4,
  t0.alt AS alt_5,
  t0.min_price AS min_price_6,
  t0.update_at AS update_at_7,
  t0.title_page AS title_page_8,
  t0.sub_title_page AS sub_title_page_9,
  t0.cite_page AS cite_page_10,
  t0.main_image AS main_image_11,
  t0.main_alt AS main_alt_12,
  t0.second_image AS second_image_13,
  t0.second_alt AS second_alt_14,
  t0.third_image AS third_image_15,
  t0.third_alt AS third_alt_16,
  t0.fourth_image AS fourth_image_17,
  t0.fourth_alt AS fourth_alt_18,
  t0.nb_display AS nb_display_19,
  t0.sort AS sort_20,
  t0.show_sub_categories AS show_sub_categories_21,
  t0.description AS description_22,
  t0.meta_title AS meta_title_23,
  t0.parent_id AS parent_id_24
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_cb808c752e6c40fbcf08ba2ad5fd01af->doDisplay (line 107)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Controller\DefaultController->navbar (line 132)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
24	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
35	App\Controller\ShopController->detail (line 82)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 5)

0.73 ms
(3.10%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.ref AS ref_3, p0_.alt AS alt_4, p0_.position AS position_5, p0_.price AS price_6, p0_.promo AS promo_7, p0_.image AS image_8, p0_.stock AS stock_9, p0_.create_at AS create_at_10, p0_.update_at AS update_at_11, p0_.active AS active_12, p0_.default_name AS default_name_13, p0_.long_description AS long_description_14, p0_.short_description AS short_description_15, p0_.care AS care_16, p0_.category_id AS category_id_17, p0_.field_id AS field_id_18, p0_.product_option_id AS product_option_id_19 FROM product p0_ WHERE p0_.active = 1 AND p0_.id <> ? AND p0_.default_name = ?

Parameters:

[
  887
  "Canotage Large"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.ref AS ref_3,
  p0_.alt AS alt_4,
  p0_.position AS position_5,
  p0_.price AS price_6,
  p0_.promo AS promo_7,
  p0_.image AS image_8,
  p0_.stock AS stock_9,
  p0_.create_at AS create_at_10,
  p0_.update_at AS update_at_11,
  p0_.active AS active_12,
  p0_.default_name AS default_name_13,
  p0_.long_description AS long_description_14,
  p0_.short_description AS short_description_15,
  p0_.care AS care_16,
  p0_.category_id AS category_id_17,
  p0_.field_id AS field_id_18,
  p0_.product_option_id AS product_option_id_19
FROM
  product p0_
WHERE
  p0_.active = 1
  AND p0_.id <> ?
  AND p0_.default_name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.ref AS ref_3, p0_.alt AS alt_4, p0_.position AS position_5, p0_.price AS price_6, p0_.promo AS promo_7, p0_.image AS image_8, p0_.stock AS stock_9, p0_.create_at AS create_at_10, p0_.update_at AS update_at_11, p0_.active AS active_12, p0_.default_name AS default_name_13, p0_.long_description AS long_description_14, p0_.short_description AS short_description_15, p0_.care AS care_16, p0_.category_id AS category_id_17, p0_.field_id AS field_id_18, p0_.product_option_id AS product_option_id_19 FROM product p0_ WHERE p0_.active = 1 AND p0_.id <> 887 AND p0_.default_name = 'Canotage Large';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ProductRepository->findCombinations (line 44)
7	App\Service\ProductService->getCombinationByGroups (line 22)
8	App\Controller\ShopController->detail (line 45)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.65 ms
(2.75%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.id = ?

Parameters:

[
  23
]

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.image AS image_4,
  t0.alt AS alt_5,
  t0.min_price AS min_price_6,
  t0.update_at AS update_at_7,
  t0.title_page AS title_page_8,
  t0.sub_title_page AS sub_title_page_9,
  t0.cite_page AS cite_page_10,
  t0.main_image AS main_image_11,
  t0.main_alt AS main_alt_12,
  t0.second_image AS second_image_13,
  t0.second_alt AS second_alt_14,
  t0.third_image AS third_image_15,
  t0.third_alt AS third_alt_16,
  t0.fourth_image AS fourth_image_17,
  t0.fourth_alt AS fourth_alt_18,
  t0.nb_display AS nb_display_19,
  t0.sort AS sort_20,
  t0.show_sub_categories AS show_sub_categories_21,
  t0.description AS description_22,
  t0.meta_title AS meta_title_23,
  t0.parent_id AS parent_id_24
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Category::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Category->__get (line 153)
7	App\Entity\Category->getParent (line 193)
8	App\Entity\Category->getBreadcrumbPath (line 382)
9	App\Entity\Product->getBreadcrumbPath (line 498)
10	App\Controller\ShopController->detail (line 86)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

0.58 ms
(2.48%)

SELECT
        TABLE_NAME,
        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
ORDER BY TABLE_NAME,
         SEQ_IN_INDEX

Parameters:

[
  "nuip1737_tussor_dev"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME,
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  TABLE_NAME,
  SEQ_IN_INDEX

SELECT
        TABLE_NAME,
        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = 'nuip1737_tussor_dev' AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY TABLE_NAME,
         SEQ_IN_INDEX;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectIndexColumns (line 418)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchIndexColumns (line 411)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableIndexes (line 168)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 493)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
34	App\Controller\ShopController->detail (line 82)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.55 ms
(2.35%)

SELECT t0.id AS id_1, t0.custom_value AS custom_value_2, t0.product_id AS product_id_3, t0.feature_id AS feature_id_4, t0.feature_value_id AS feature_value_id_5 FROM product_feature t0 WHERE t0.product_id = ?

Parameters:

[
  887
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.custom_value AS custom_value_2,
  t0.product_id AS product_id_3,
  t0.feature_id AS feature_id_4,
  t0.feature_value_id AS feature_value_id_5
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.custom_value AS custom_value_2, t0.product_id AS product_id_3, t0.feature_id AS feature_id_4, t0.feature_value_id AS feature_value_id_5 FROM product_feature t0 WHERE t0.product_id = 887;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Controller\ShopController->detail (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.54 ms
(2.30%)

SELECT t0.id AS id_1, t0.images AS images_2, t0.alt AS alt_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.product_id AS product_id_6 FROM attachment t0 WHERE t0.product_id = ?

Parameters:

[
  887
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.images AS images_2,
  t0.alt AS alt_3,
  t0.create_at AS create_at_4,
  t0.update_at AS update_at_5,
  t0.product_id AS product_id_6
FROM
  attachment t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.images AS images_2, t0.alt AS alt_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.product_id AS product_id_6 FROM attachment t0 WHERE t0.product_id = 887;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1696)
10	__TwigTemplate_b78866eca84f5c338877174f10413382::block_meta (line 143)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 79)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\ShopController->detail (line 82)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.35 ms
(1.48%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = ? ORDER BY c0_.nb_display ASC

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.alt AS alt_4,
  c0_.min_price AS min_price_5,
  c0_.update_at AS update_at_6,
  c0_.title_page AS title_page_7,
  c0_.sub_title_page AS sub_title_page_8,
  c0_.cite_page AS cite_page_9,
  c0_.main_image AS main_image_10,
  c0_.main_alt AS main_alt_11,
  c0_.second_image AS second_image_12,
  c0_.second_alt AS second_alt_13,
  c0_.third_image AS third_image_14,
  c0_.third_alt AS third_alt_15,
  c0_.fourth_image AS fourth_image_16,
  c0_.fourth_alt AS fourth_alt_17,
  c0_.nb_display AS nb_display_18,
  c0_.sort AS sort_19,
  c0_.show_sub_categories AS show_sub_categories_20,
  c0_.description AS description_21,
  c0_.meta_title AS meta_title_22,
  c0_.parent_id AS parent_id_23
FROM
  category c0_
WHERE
  c0_.parent_id = ?
ORDER BY
  c0_.nb_display ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = 17 ORDER BY c0_.nb_display ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findSubCategoriesOrderedByNbDisplay (line 31)
7	App\Controller\DefaultController->navbar (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\ShopController->detail (line 82)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.34 ms
(1.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "Collection MER"
]

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.image AS image_4,
  t0.alt AS alt_5,
  t0.min_price AS min_price_6,
  t0.update_at AS update_at_7,
  t0.title_page AS title_page_8,
  t0.sub_title_page AS sub_title_page_9,
  t0.cite_page AS cite_page_10,
  t0.main_image AS main_image_11,
  t0.main_alt AS main_alt_12,
  t0.second_image AS second_image_13,
  t0.second_alt AS second_alt_14,
  t0.third_image AS third_image_15,
  t0.third_alt AS third_alt_16,
  t0.fourth_image AS fourth_image_17,
  t0.fourth_alt AS fourth_alt_18,
  t0.nb_display AS nb_display_19,
  t0.sort AS sort_20,
  t0.show_sub_categories AS show_sub_categories_21,
  t0.description AS description_22,
  t0.meta_title AS meta_title_23,
  t0.parent_id AS parent_id_24
FROM
  category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = 'Collection MER' 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\DefaultController->navbar (line 128)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\ShopController->detail (line 82)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.30 ms
(1.29%)

SELECT @@character_set_database, @@collation_database

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  @@character_set_database,
  @@collation_database

SELECT @@character_set_database, @@collation_database;

#	File/Call
1	Doctrine\DBAL\Connection->fetchNumeric (line 316)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->getDefaultTableOptions (line 516)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->createComparator (line 327)
4	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 204)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
7	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
8	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
9	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
19	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
20	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
21	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
22	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\ShopController->detail (line 82)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

0.30 ms
(1.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.public_name AS public_name_4, t0.position AS position_5, t0.sync AS sync_6 FROM product_attribute_group t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.public_name AS public_name_4,
  t0.position AS position_5,
  t0.sync AS sync_6
FROM
  product_attribute_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.public_name AS public_name_4, t0.position AS position_5, t0.sync AS sync_6 FROM product_attribute_group t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\ProductAttributeGroup::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ProductAttributeGroup->__get (line 153)
7	App\Entity\ProductAttributeGroup->getName (line 55)
8	App\Service\ProductService->{closure:App\Service\ProductService::getCombinationByGroups():45} (line 45)
9	array_map (line 45)
10	App\Service\ProductService::getCombinationByGroups (line 45)
11	App\Controller\ShopController->detail (line 45)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.23 ms
(0.98%)

SELECT * FROM doctrine_migration_versions

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 81)
3	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
4	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
5	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
18	__TwigTemplate_b5f889c861e5bcd2e621b73a68a88f07->doDisplay (line 112)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_b78866eca84f5c338877174f10413382->doDisplay (line 57)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\ShopController->detail (line 82)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	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	22
App\Entity\Product	2
App\Entity\ProductAttribute	2
App\Entity\ProductOption	1
App\Entity\Field	1
App\Entity\ProductAttributeGroup	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.
App\Entity\Feature	No errors.
App\Entity\FeatureValue	No errors.
App\Entity\Gift	No errors.
App\Entity\DeliveryMod	No errors.
App\Entity\Order	No errors.
App\Entity\Shop	No errors.
App\Entity\User	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Event	No errors.
App\Entity\Address	No errors.
App\Entity\ProductOrder	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://v2.tussor.net/boutique/large/produit/canotage-large-olive

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping