Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

6.67 ms Query time

0 Invalid entities

209 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.69 ms
(55.25%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.country AS country_5, t0.state AS state_6, t0.city AS city_7, t0.street_address AS street_address_8, t0.expiration_date AS expiration_date_9, t0.highlight AS highlight_10, t0.schedule AS schedule_11, t0.start_date AS start_date_12, t0.year_of_experience AS year_of_experience_13, t0.pay_rate AS pay_rate_14, t0.work_type AS work_type_15, t0.need AS need_16, t0.pay_rate_hourly AS pay_rate_hourly_17, t0.pay_rate_daily AS pay_rate_daily_18, t0.annual_salary AS annual_salary_19, t0.monthly_salary AS monthly_salary_20, t0.salary_type AS salary_type_21, t0.blocked AS blocked_22, t0.job_id AS job_id_23, t0.verified AS verified_24, t0.is_mediated AS is_mediated_25, t0.`rank` AS rank_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29, t0.employer_id AS employer_id_30, t0.profession_id AS profession_id_31, t0.speciality_id AS speciality_id_32, t0.assigned_recruiter_id AS assigned_recruiter_id_33 FROM b_job t0 WHERE t0.status = ? ORDER BY t0.created_at DESC

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.country AS country_5,
  t0.state AS state_6,
  t0.city AS city_7,
  t0.street_address AS street_address_8,
  t0.expiration_date AS expiration_date_9,
  t0.highlight AS highlight_10,
  t0.schedule AS schedule_11,
  t0.start_date AS start_date_12,
  t0.year_of_experience AS year_of_experience_13,
  t0.pay_rate AS pay_rate_14,
  t0.work_type AS work_type_15,
  t0.need AS need_16,
  t0.pay_rate_hourly AS pay_rate_hourly_17,
  t0.pay_rate_daily AS pay_rate_daily_18,
  t0.annual_salary AS annual_salary_19,
  t0.monthly_salary AS monthly_salary_20,
  t0.salary_type AS salary_type_21,
  t0.blocked AS blocked_22,
  t0.job_id AS job_id_23,
  t0.verified AS verified_24,
  t0.is_mediated AS is_mediated_25,
  t0.`rank` AS rank_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.user_id AS user_id_29,
  t0.employer_id AS employer_id_30,
  t0.profession_id AS profession_id_31,
  t0.speciality_id AS speciality_id_32,
  t0.assigned_recruiter_id AS assigned_recruiter_id_33
FROM
  b_job t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.country AS country_5, t0.state AS state_6, t0.city AS city_7, t0.street_address AS street_address_8, t0.expiration_date AS expiration_date_9, t0.highlight AS highlight_10, t0.schedule AS schedule_11, t0.start_date AS start_date_12, t0.year_of_experience AS year_of_experience_13, t0.pay_rate AS pay_rate_14, t0.work_type AS work_type_15, t0.need AS need_16, t0.pay_rate_hourly AS pay_rate_hourly_17, t0.pay_rate_daily AS pay_rate_daily_18, t0.annual_salary AS annual_salary_19, t0.monthly_salary AS monthly_salary_20, t0.salary_type AS salary_type_21, t0.blocked AS blocked_22, t0.job_id AS job_id_23, t0.verified AS verified_24, t0.is_mediated AS is_mediated_25, t0.`rank` AS rank_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29, t0.employer_id AS employer_id_30, t0.profession_id AS profession_id_31, t0.speciality_id AS speciality_id_32, t0.assigned_recruiter_id AS assigned_recruiter_id_33 FROM b_job t0 WHERE t0.status = 'published' ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\DefaultController->index (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.45 ms
(21.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  b_profession t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Runtime\AppExtensionRuntime->getProfessions (line 42)
5	__TwigTemplate_0162b5afe60e23771e692ada6167f607->doDisplay (line 55)
6	Twig\Template->yield (line 402)
7	Twig\Template->display (line 358)
8	Twig\Template->render (line 373)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
14	App\Controller\DefaultController->index (line 20)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.78 ms
(11.67%)

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  b_config t0

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\ConfigManager->init (line 97)
6	App\Service\ConfigManager->get (line 29)
7	App\Twig\Extension\ConfigExtension->getConfig (line 28)
8	__TwigTemplate_902a857172966c73570b70e6ff5c40a9->doDisplay (line 55)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_8c4267fb5a67e4de44c54397727380a0->doDisplay (line 122)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_0162b5afe60e23771e692ada6167f607->doDisplay (line 60)
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 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\DefaultController->index (line 20)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.76 ms
(11.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.profession_id AS profession_id_3
FROM
  b_speciality t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Runtime\AppExtensionRuntime->getSpecialities (line 48)
5	__TwigTemplate_0162b5afe60e23771e692ada6167f607->block_body (line 177)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8c4267fb5a67e4de44c54397727380a0->doDisplay (line 116)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_0162b5afe60e23771e692ada6167f607->doDisplay (line 60)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\DefaultController->index (line 20)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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\Job	134
App\Entity\Speciality	36
App\Entity\Config	23
App\Entity\Profession	6
App\Entity\User	5
App\Entity\Employer	5

Entities Mapping

Class	Mapping errors
App\Entity\Job	No errors.
App\Entity\User	No errors.
App\Entity\Employer	No errors.
App\Entity\Profession	No errors.
App\Entity\Speciality	No errors.
App\Entity\Recruiter	No errors.
App\Entity\JobRecruiter	No errors.
App\Entity\Config	No errors.

Symfony Profiler

GET http://167.172.25.174/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping