Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.18 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.50 ms
(42.04%)

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_.campus_name AS campus_name_5, u0_.hot_topic1 AS hot_topic1_6, u0_.hot_topic2 AS hot_topic2_7, u0_.hero_title AS hero_title_8, u0_.hero_text AS hero_text_9, u0_.cat_city AS cat_city_10, u0_.cat_green AS cat_green_11, u0_.cat_new AS cat_new_12, u0_.cat_expand AS cat_expand_13, u0_.cat_highrise AS cat_highrise_14, u0_.cat_near_stn AS cat_near_stn_15, u0_.cat_one_campus AS cat_one_campus_16, u0_.post_code AS post_code_17, u0_.prefecture AS prefecture_18, u0_.addr_city AS addr_city_19, u0_.addr_town AS addr_town_20, u0_.addr_building AS addr_building_21, u0_.telephone AS telephone_22, u0_.email AS email_23, u0_.university_id AS university_id_24, u0_.parent_id AS parent_id_25, u0_.hero_image_id AS hero_image_id_26, u0_.post1_id AS post1_id_27, u0_.post2_id AS post2_id_28, u0_.post3_id AS post3_id_29, u0_.post4_id AS post4_id_30, u0_.post5_id AS post5_id_31, u0_.post6_id AS post6_id_32, u0_.post7_id AS post7_id_33, u0_.post8_id AS post8_id_34, u0_.post9_id AS post9_id_35, u0_.post10_id AS post10_id_36 FROM univ_campus u0_ WHERE u0_.university_id = ? AND u0_.draft_type = ?

Parameters:

[
  1
  "MAIN"
]

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_.campus_name AS campus_name_5,
  u0_.hot_topic1 AS hot_topic1_6,
  u0_.hot_topic2 AS hot_topic2_7,
  u0_.hero_title AS hero_title_8,
  u0_.hero_text AS hero_text_9,
  u0_.cat_city AS cat_city_10,
  u0_.cat_green AS cat_green_11,
  u0_.cat_new AS cat_new_12,
  u0_.cat_expand AS cat_expand_13,
  u0_.cat_highrise AS cat_highrise_14,
  u0_.cat_near_stn AS cat_near_stn_15,
  u0_.cat_one_campus AS cat_one_campus_16,
  u0_.post_code AS post_code_17,
  u0_.prefecture AS prefecture_18,
  u0_.addr_city AS addr_city_19,
  u0_.addr_town AS addr_town_20,
  u0_.addr_building AS addr_building_21,
  u0_.telephone AS telephone_22,
  u0_.email AS email_23,
  u0_.university_id AS university_id_24,
  u0_.parent_id AS parent_id_25,
  u0_.hero_image_id AS hero_image_id_26,
  u0_.post1_id AS post1_id_27,
  u0_.post2_id AS post2_id_28,
  u0_.post3_id AS post3_id_29,
  u0_.post4_id AS post4_id_30,
  u0_.post5_id AS post5_id_31,
  u0_.post6_id AS post6_id_32,
  u0_.post7_id AS post7_id_33,
  u0_.post8_id AS post8_id_34,
  u0_.post9_id AS post9_id_35,
  u0_.post10_id AS post10_id_36
FROM
  univ_campus u0_
WHERE
  u0_.university_id = ?
  AND u0_.draft_type = ?

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_.campus_name AS campus_name_5, u0_.hot_topic1 AS hot_topic1_6, u0_.hot_topic2 AS hot_topic2_7, u0_.hero_title AS hero_title_8, u0_.hero_text AS hero_text_9, u0_.cat_city AS cat_city_10, u0_.cat_green AS cat_green_11, u0_.cat_new AS cat_new_12, u0_.cat_expand AS cat_expand_13, u0_.cat_highrise AS cat_highrise_14, u0_.cat_near_stn AS cat_near_stn_15, u0_.cat_one_campus AS cat_one_campus_16, u0_.post_code AS post_code_17, u0_.prefecture AS prefecture_18, u0_.addr_city AS addr_city_19, u0_.addr_town AS addr_town_20, u0_.addr_building AS addr_building_21, u0_.telephone AS telephone_22, u0_.email AS email_23, u0_.university_id AS university_id_24, u0_.parent_id AS parent_id_25, u0_.hero_image_id AS hero_image_id_26, u0_.post1_id AS post1_id_27, u0_.post2_id AS post2_id_28, u0_.post3_id AS post3_id_29, u0_.post4_id AS post4_id_30, u0_.post5_id AS post5_id_31, u0_.post6_id AS post6_id_32, u0_.post7_id AS post7_id_33, u0_.post8_id AS post8_id_34, u0_.post9_id AS post9_id_35, u0_.post10_id AS post10_id_36 FROM univ_campus u0_ WHERE u0_.university_id = 1 AND u0_.draft_type = 'MAIN';

#	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 85)
7	App\Repository\UnivCampusRepository->findMainByUniv (line 52)
8	App\Controller\Main\University\UnivController->viewDetail (line 33)
9	App\Controller\Main\University\UnivController->detail (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.43 ms
(36.13%)

SELECT t0.id AS id_1, t0.draft_type AS draft_type_2, t0.draft_status AS draft_status_3, t0.draft_token AS draft_token_4, t0.opened_at AS opened_at_5, t0.univ_code AS univ_code_6, t0.univ_name AS univ_name_7, t0.found_type AS found_type_8, t0.client_type AS client_type_9, t0.gender_type AS gender_type_10, t0.school_type AS school_type_11, t0.memo AS memo_12, t0.univ_url AS univ_url_13, t0.post_code AS post_code_14, t0.prefecture AS prefecture_15, t0.addr_city AS addr_city_16, t0.addr_town AS addr_town_17, t0.addr_building AS addr_building_18, t0.telephone AS telephone_19, t0.email AS email_20, t0.parent_id AS parent_id_21, t0.emblem_image_id AS emblem_image_id_22 FROM university t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.draft_type AS draft_type_2,
  t0.draft_status AS draft_status_3,
  t0.draft_token AS draft_token_4,
  t0.opened_at AS opened_at_5,
  t0.univ_code AS univ_code_6,
  t0.univ_name AS univ_name_7,
  t0.found_type AS found_type_8,
  t0.client_type AS client_type_9,
  t0.gender_type AS gender_type_10,
  t0.school_type AS school_type_11,
  t0.memo AS memo_12,
  t0.univ_url AS univ_url_13,
  t0.post_code AS post_code_14,
  t0.prefecture AS prefecture_15,
  t0.addr_city AS addr_city_16,
  t0.addr_town AS addr_town_17,
  t0.addr_building AS addr_building_18,
  t0.telephone AS telephone_19,
  t0.email AS email_20,
  t0.parent_id AS parent_id_21,
  t0.emblem_image_id AS emblem_image_id_22
FROM
  university t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.draft_type AS draft_type_2, t0.draft_status AS draft_status_3, t0.draft_token AS draft_token_4, t0.opened_at AS opened_at_5, t0.univ_code AS univ_code_6, t0.univ_name AS univ_name_7, t0.found_type AS found_type_8, t0.client_type AS client_type_9, t0.gender_type AS gender_type_10, t0.school_type AS school_type_11, t0.memo AS memo_12, t0.univ_url AS univ_url_13, t0.post_code AS post_code_14, t0.prefecture AS prefecture_15, t0.addr_city AS addr_city_16, t0.addr_town AS addr_town_17, t0.addr_building AS addr_building_18, t0.telephone AS telephone_19, t0.email AS email_20, t0.parent_id AS parent_id_21, t0.emblem_image_id AS emblem_image_id_22 FROM university 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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 24)
7	App\Repository\UniversityRepository->findMainById (line 116)
8	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 59)
9	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 230)
10	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 59)
11	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
14	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.26 ms
(21.83%)

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 201)
10	__TwigTemplate_f0b378b3a33f04207283346bb3593327->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 56)
18	__TwigTemplate_f0b378b3a33f04207283346bb3593327->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 62)
27	App\Controller\Main\University\UnivController->viewDetail (line 33)
28	App\Controller\Main\University\UnivController->detail (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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/univ/1?%2Funiv%2F1=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping