Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.48 ms
(67.83%)

SELECT u0_.id AS id_0, u0_.draft_type AS draft_type_1, u0_.draft_status AS draft_status_2, u0_.draft_token AS draft_token_3, u0_.opened_at AS opened_at_4, u0_.univ_code AS univ_code_5, u0_.univ_name AS univ_name_6, u0_.found_type AS found_type_7, u0_.client_type AS client_type_8, u0_.gender_type AS gender_type_9, u0_.school_type AS school_type_10, u0_.memo AS memo_11, u0_.univ_url AS univ_url_12, u0_.post_code AS post_code_13, u0_.prefecture AS prefecture_14, u0_.addr_city AS addr_city_15, u0_.addr_town AS addr_town_16, u0_.addr_building AS addr_building_17, u0_.telephone AS telephone_18, u0_.email AS email_19, u0_.parent_id AS parent_id_20, u0_.emblem_image_id AS emblem_image_id_21 FROM university u0_ WHERE u0_.draft_type = ? AND u0_.draft_status = ?

Parameters:

[
  "MAIN"
  "OPEN"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.draft_type AS draft_type_1,
  u0_.draft_status AS draft_status_2,
  u0_.draft_token AS draft_token_3,
  u0_.opened_at AS opened_at_4,
  u0_.univ_code AS univ_code_5,
  u0_.univ_name AS univ_name_6,
  u0_.found_type AS found_type_7,
  u0_.client_type AS client_type_8,
  u0_.gender_type AS gender_type_9,
  u0_.school_type AS school_type_10,
  u0_.memo AS memo_11,
  u0_.univ_url AS univ_url_12,
  u0_.post_code AS post_code_13,
  u0_.prefecture AS prefecture_14,
  u0_.addr_city AS addr_city_15,
  u0_.addr_town AS addr_town_16,
  u0_.addr_building AS addr_building_17,
  u0_.telephone AS telephone_18,
  u0_.email AS email_19,
  u0_.parent_id AS parent_id_20,
  u0_.emblem_image_id AS emblem_image_id_21
FROM
  university u0_
WHERE
  u0_.draft_type = ?
  AND u0_.draft_status = ?

SELECT u0_.id AS id_0, u0_.draft_type AS draft_type_1, u0_.draft_status AS draft_status_2, u0_.draft_token AS draft_token_3, u0_.opened_at AS opened_at_4, u0_.univ_code AS univ_code_5, u0_.univ_name AS univ_name_6, u0_.found_type AS found_type_7, u0_.client_type AS client_type_8, u0_.gender_type AS gender_type_9, u0_.school_type AS school_type_10, u0_.memo AS memo_11, u0_.univ_url AS univ_url_12, u0_.post_code AS post_code_13, u0_.prefecture AS prefecture_14, u0_.addr_city AS addr_city_15, u0_.addr_town AS addr_town_16, u0_.addr_building AS addr_building_17, u0_.telephone AS telephone_18, u0_.email AS email_19, u0_.parent_id AS parent_id_20, u0_.emblem_image_id AS emblem_image_id_21 FROM university u0_ WHERE u0_.draft_type = 'MAIN' AND u0_.draft_status = 'OPEN';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Controller\TopController->getUniversities (line 22)
8	App\Controller\TopController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.23 ms
(32.17%)

SELECT t0.id AS id_1, t0.image_status AS image_status_2, t0.image_type AS image_type_3, t0.file_name AS file_name_4, t0.title AS title_5, t0.uploaded_at AS uploaded_at_6, t0.contents AS contents_7, t0.original_name AS original_name_8, t0.file_loc AS file_loc_9, t0.university_id AS university_id_10 FROM images t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_status AS image_status_2,
  t0.image_type AS image_type_3,
  t0.file_name AS file_name_4,
  t0.title AS title_5,
  t0.uploaded_at AS uploaded_at_6,
  t0.contents AS contents_7,
  t0.original_name AS original_name_8,
  t0.file_loc AS file_loc_9,
  t0.university_id AS university_id_10
FROM
  images t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image_status AS image_status_2, t0.image_type AS image_type_3, t0.file_name AS file_name_4, t0.title AS title_5, t0.uploaded_at AS uploaded_at_6, t0.contents AS contents_7, t0.original_name AS original_name_8, t0.file_loc AS file_loc_9, t0.university_id AS university_id_10 FROM images t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Images::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Images->__get (line 64)
8	App\Entity\Images->getImageStatus (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 147)
10	__TwigTemplate_8eb2c195a3ba2c507a400eef2cc2a74d->block_contents (line 432)
11	Twig\Template->yieldBlock (line 191)
12	__TwigTemplate_bac6b6d99e4d733db3d39bd4ba8861ec->block_body (line 432)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_8412246a47a3f6671a07ff29063dc42e->doDisplay (line 388)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_bac6b6d99e4d733db3d39bd4ba8861ec->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_8eb2c195a3ba2c507a400eef2cc2a74d->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
27	App\Controller\TopController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\University	No errors.
App\Entity\Images	No errors.
App\Entity\Posts	No errors.
App\Entity\UnivCampus	No errors.

Symfony Profiler

GET https://test8.studyu.jp/

Configuration Settings

Theme