Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.91 ms
(21.92%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.instagram_link AS instagram_link_7, t0.facebook_link AS facebook_link_8, t0.linkedin_link AS linkedin_link_9, t0.twitter_link AS twitter_link_10 FROM footer_contact t0 WHERE t0.lang = ? LIMIT 1

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.title AS title_4,
  t0.email AS email_5,
  t0.phonenumber AS phonenumber_6,
  t0.instagram_link AS instagram_link_7,
  t0.facebook_link AS facebook_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.twitter_link AS twitter_link_10
FROM
  footer_contact t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.instagram_link AS instagram_link_7, t0.facebook_link AS facebook_link_8, t0.linkedin_link AS linkedin_link_9, t0.twitter_link AS twitter_link_10 FROM footer_contact t0 WHERE t0.lang = 'en' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 21)
4	App\Controller\FooterContactController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 98)
12	__TwigTemplate_0c9347709ead6cc537f6b80d37f68dcb->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_ed11799a1475a6e1c31224aaee9c8197->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 538)
21	App\Controller\StudiesController->show (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.72 ms
(17.34%)

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.draft AS draft_2, s0_.lang AS lang_3, s0_.title AS title_4, s0_.full_name AS full_name_5, s0_.date AS date_6, s0_.tools_status AS tools_status_7, s0_.other_methodologies AS other_methodologies_8, s0_.excel_file AS excel_file_9, s0_.accept_upload_conditions AS accept_upload_conditions_10, s0_.study_type AS study_type_11, s0_.other_sector AS other_sector_12, s0_.country AS country_13, s0_.partner AS partner_14, s0_.study_file AS study_file_15, s0_.tools_file AS tools_file_16, s0_.summary AS summary_17, s0_.sdg AS sdg_18, s0_.image AS image_19, s0_.summary_data AS summary_data_20, s0_.link AS link_21, s0_.other_keywords AS other_keywords_22, s0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.user_type AS user_type_28, u1_.fullname AS fullname_29, u1_.firstname AS firstname_30, u1_.lastname AS lastname_31, u1_.gender AS gender_32, u1_.country AS country_33, u1_.organisation AS organisation_34, u1_.website AS website_35, u1_.job AS job_36, u1_.phonenumber AS phonenumber_37, u1_.photo AS photo_38, u1_.status AS status_39, u1_.is_verified AS is_verified_40, u1_.setup_profile AS setup_profile_41, u1_.is_archived AS is_archived_42, s0_.user_id AS user_id_43 FROM study s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.id = ?

Parameters:

[
  "219"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.draft AS draft_2,
  s0_.lang AS lang_3,
  s0_.title AS title_4,
  s0_.full_name AS full_name_5,
  s0_.date AS date_6,
  s0_.tools_status AS tools_status_7,
  s0_.other_methodologies AS other_methodologies_8,
  s0_.excel_file AS excel_file_9,
  s0_.accept_upload_conditions AS accept_upload_conditions_10,
  s0_.study_type AS study_type_11,
  s0_.other_sector AS other_sector_12,
  s0_.country AS country_13,
  s0_.partner AS partner_14,
  s0_.study_file AS study_file_15,
  s0_.tools_file AS tools_file_16,
  s0_.summary AS summary_17,
  s0_.sdg AS sdg_18,
  s0_.image AS image_19,
  s0_.summary_data AS summary_data_20,
  s0_.link AS link_21,
  s0_.other_keywords AS other_keywords_22,
  s0_.created_at AS created_at_23,
  u1_.id AS id_24,
  u1_.email AS email_25,
  u1_.roles AS roles_26,
  u1_.password AS password_27,
  u1_.user_type AS user_type_28,
  u1_.fullname AS fullname_29,
  u1_.firstname AS firstname_30,
  u1_.lastname AS lastname_31,
  u1_.gender AS gender_32,
  u1_.country AS country_33,
  u1_.organisation AS organisation_34,
  u1_.website AS website_35,
  u1_.job AS job_36,
  u1_.phonenumber AS phonenumber_37,
  u1_.photo AS photo_38,
  u1_.status AS status_39,
  u1_.is_verified AS is_verified_40,
  u1_.setup_profile AS setup_profile_41,
  u1_.is_archived AS is_archived_42,
  s0_.user_id AS user_id_43
FROM
  study s0_
  LEFT JOIN user u1_ ON s0_.user_id = u1_.id
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.draft AS draft_2, s0_.lang AS lang_3, s0_.title AS title_4, s0_.full_name AS full_name_5, s0_.date AS date_6, s0_.tools_status AS tools_status_7, s0_.other_methodologies AS other_methodologies_8, s0_.excel_file AS excel_file_9, s0_.accept_upload_conditions AS accept_upload_conditions_10, s0_.study_type AS study_type_11, s0_.other_sector AS other_sector_12, s0_.country AS country_13, s0_.partner AS partner_14, s0_.study_file AS study_file_15, s0_.tools_file AS tools_file_16, s0_.summary AS summary_17, s0_.sdg AS sdg_18, s0_.image AS image_19, s0_.summary_data AS summary_data_20, s0_.link AS link_21, s0_.other_keywords AS other_keywords_22, s0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.user_type AS user_type_28, u1_.fullname AS fullname_29, u1_.firstname AS firstname_30, u1_.lastname AS lastname_31, u1_.gender AS gender_32, u1_.country AS country_33, u1_.organisation AS organisation_34, u1_.website AS website_35, u1_.job AS job_36, u1_.phonenumber AS phonenumber_37, u1_.photo AS photo_38, u1_.status AS status_39, u1_.is_verified AS is_verified_40, u1_.setup_profile AS setup_profile_41, u1_.is_archived AS is_archived_42, s0_.user_id AS user_id_43 FROM study s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.id = '219';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 69)
7	App\Repository\StudyRepository->findStudy (line 421)
8	App\Controller\StudiesController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.69 ms
(16.45%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4 FROM sector t0 INNER JOIN study_sector ON t0.id = study_sector.sector_id WHERE study_sector.study_id = ?

Parameters:

[
  219
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.name AS name_4
FROM
  sector t0
  INNER JOIN study_sector ON t0.id = study_sector.sector_id
WHERE
  study_sector.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4 FROM sector t0 INNER JOIN study_sector ON t0.id = study_sector.sector_id WHERE study_sector.study_id = 219;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 447)
8	App\Controller\StudiesController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.65 ms
(15.52%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4 FROM keywords t0 INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id WHERE study_keywords.study_id = ?

Parameters:

[
  219
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.title AS title_4
FROM
  keywords t0
  INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id
WHERE
  study_keywords.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.title AS title_4 FROM keywords t0 INNER JOIN study_keywords ON t0.id = study_keywords.keywords_id WHERE study_keywords.study_id = 219;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 479)
8	App\Controller\StudiesController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.64 ms
(15.47%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.image AS image_3, t0.title AS title_4, t0.description AS description_5 FROM study_details_page t0 WHERE t0.lang = ? LIMIT 1

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.image AS image_3,
  t0.title AS title_4,
  t0.description AS description_5
FROM
  study_details_page t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.image AS image_3, t0.title AS title_4, t0.description AS description_5 FROM study_details_page t0 WHERE t0.lang = 'en' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 417)
4	App\Controller\StudiesController->show (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.56 ms
(13.31%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4, t0.groupe_id AS groupe_id_5 FROM methodology t0 INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id WHERE study_methodology.study_id = ?

Parameters:

[
  219
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.status AS status_3,
  t0.name AS name_4,
  t0.groupe_id AS groupe_id_5
FROM
  methodology t0
  INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id
WHERE
  study_methodology.study_id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.status AS status_3, t0.name AS name_4, t0.groupe_id AS groupe_id_5 FROM methodology t0 INNER JOIN study_methodology ON t0.id = study_methodology.methodology_id WHERE study_methodology.study_id = 219;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 463)
8	App\Controller\StudiesController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\StudyDetailsPage	No errors.
App\Entity\Study	No errors.
App\Entity\User	No errors.
App\Entity\Sector	No errors.
App\Entity\Methodology	No errors.
App\Entity\Keywords	No errors.
App\Entity\Training	No errors.
App\Entity\Survey	No errors.
App\Entity\Article	No errors.
App\Entity\Notification	No errors.
App\Entity\MethodologyGroup	No errors.
App\Entity\FooterContact	No errors.
App\Entity\TrainingSession	No errors.
App\Entity\TrainingFaq	No errors.
App\Entity\TrainingComments	No errors.
App\Entity\TrainingSatisfaction	No errors.
App\Entity\SurveyQuestion	No errors.
App\Entity\Category	No errors.
App\Entity\Media	No errors.
App\Entity\SubCategory	No errors.
App\Entity\TrainingCommentReactions	No errors.
App\Entity\SurveyCategory	No errors.
App\Entity\TrainingLibrary	No errors.
App\Entity\TrainingDetailsPage	No errors.
App\Entity\TechnicalContact	No errors.
App\Entity\TechnicalAssistance	No errors.
App\Entity\SurveyPage	No errors.
App\Entity\SubmitTrainingPage	No errors.
App\Entity\StudyUploadPage	No errors.
App\Entity\StudiesPage	No errors.
App\Entity\SocialwallComptes	No errors.
App\Entity\SocialPost	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\RegisterPage	No errors.
App\Entity\PrivacyPolicy	No errors.
App\Entity\PartnerPage	No errors.
App\Entity\PartnerDetailPage	No errors.
App\Entity\Partner	No errors.
App\Entity\Page	No errors.
App\Entity\OptionsField	No errors.
App\Entity\OpenData	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Menu	No errors.
App\Entity\LoginPage	No errors.
App\Entity\Log	No errors.
App\Entity\HomePage	No errors.
App\Entity\FormFieldOption	No errors.
App\Entity\Faq	No errors.
App\Entity\Config	No errors.
App\Entity\Address	No errors.
App\Entity\AboutUsPage	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://inclusivelabor.org/studies/show/219

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping