Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

3.28 ms Query time

0 Invalid entities

89 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.24 ms
(37.93%)

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 138)
5	__TwigTemplate_a8a5717ecd9d22a96e384ed7f7afee84->block_body (line 2187)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_6424e2458b307b2080d7d8d80c3925f1->doDisplay (line 156)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_a8a5717ecd9d22a96e384ed7f7afee84->doDisplay (line 56)
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)

0.94 ms
(28.56%)

SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.archived_at AS archived_at_28, t0.is_archived AS is_archived_29, t0.agency_payout_status AS agency_payout_status_30, t0.agency_payout_amount AS agency_payout_amount_31, t0.agency_payout_date AS agency_payout_date_32, t0.agency_payout_reference AS agency_payout_reference_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.user_id AS user_id_36, t0.employer_id AS employer_id_37, t0.staffing_agency_id AS staffing_agency_id_38, t0.profession_id AS profession_id_39, t0.speciality_id AS speciality_id_40, t0.assigned_recruiter_id AS assigned_recruiter_id_41 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.status_mode AS status_mode_1,
  t0.id AS id_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.country AS country_6,
  t0.state AS state_7,
  t0.city AS city_8,
  t0.street_address AS street_address_9,
  t0.expiration_date AS expiration_date_10,
  t0.highlight AS highlight_11,
  t0.schedule AS schedule_12,
  t0.start_date AS start_date_13,
  t0.year_of_experience AS year_of_experience_14,
  t0.pay_rate AS pay_rate_15,
  t0.work_type AS work_type_16,
  t0.need AS need_17,
  t0.pay_rate_hourly AS pay_rate_hourly_18,
  t0.pay_rate_daily AS pay_rate_daily_19,
  t0.annual_salary AS annual_salary_20,
  t0.monthly_salary AS monthly_salary_21,
  t0.salary_type AS salary_type_22,
  t0.blocked AS blocked_23,
  t0.job_id AS job_id_24,
  t0.verified AS verified_25,
  t0.is_mediated AS is_mediated_26,
  t0.`rank` AS rank_27,
  t0.archived_at AS archived_at_28,
  t0.is_archived AS is_archived_29,
  t0.agency_payout_status AS agency_payout_status_30,
  t0.agency_payout_amount AS agency_payout_amount_31,
  t0.agency_payout_date AS agency_payout_date_32,
  t0.agency_payout_reference AS agency_payout_reference_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t0.user_id AS user_id_36,
  t0.employer_id AS employer_id_37,
  t0.staffing_agency_id AS staffing_agency_id_38,
  t0.profession_id AS profession_id_39,
  t0.speciality_id AS speciality_id_40,
  t0.assigned_recruiter_id AS assigned_recruiter_id_41
FROM
  b_job t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC

SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.archived_at AS archived_at_28, t0.is_archived AS is_archived_29, t0.agency_payout_status AS agency_payout_status_30, t0.agency_payout_amount AS agency_payout_amount_31, t0.agency_payout_date AS agency_payout_date_32, t0.agency_payout_reference AS agency_payout_reference_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.user_id AS user_id_36, t0.employer_id AS employer_id_37, t0.staffing_agency_id AS staffing_agency_id_38, t0.profession_id AS profession_id_39, t0.speciality_id AS speciality_id_40, t0.assigned_recruiter_id AS assigned_recruiter_id_41 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)

0.58 ms
(17.76%)

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 99)
6	App\Service\ConfigManager->get (line 30)
7	App\Twig\Extension\ConfigExtension->getConfig (line 28)
8	__TwigTemplate_53046790e426b2222b36f47d2aef53ef->doDisplay (line 55)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_6424e2458b307b2080d7d8d80c3925f1->doDisplay (line 168)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a8a5717ecd9d22a96e384ed7f7afee84->doDisplay (line 56)
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.52 ms
(15.74%)

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 144)
5	__TwigTemplate_a8a5717ecd9d22a96e384ed7f7afee84->block_body (line 2290)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_6424e2458b307b2080d7d8d80c3925f1->doDisplay (line 156)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_a8a5717ecd9d22a96e384ed7f7afee84->doDisplay (line 56)
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\Speciality	36
App\Entity\Config	23
App\Entity\Job	18
App\Entity\Profession	5
App\Entity\User	3
App\Entity\Employer	3
App\Entity\Recruiter	1

Entities Mapping

Class	Mapping errors
App\Entity\Job	No errors.
App\Entity\User	No errors.
App\Entity\Employer	No errors.
App\Entity\StaffingAgency	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