Symfony Profiler

Query Metrics

20 Database Queries

11 Different statements

19.79 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.96 ms
(20.01%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.34 ms
(16.89%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.05 ms
(15.42%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.32 ms
(11.74%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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)

2.30 ms
(11.64%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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)

2.02 ms
(10.21%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.88 ms
(4.43%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.80 ms
(4.04%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.55 ms
(2.75%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.34 ms
(1.73%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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.23 ms
(1.14%)

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_eea3b026d21cb0c31fcfc636697e0e91->doDisplay (line 56)
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\SecurityController->login (line 34)
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

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\Attachment	No errors.
App\Entity\Field	No errors.
App\Entity\ProductFeature	No errors.
App\Entity\ProductAttributeGroup	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductOption	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 https://v2.tussor.net/connexion

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping