Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.47 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.45 ms
(58.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.location AS location_5, t0.employment_type AS employment_type_6, t0.route_type AS route_type_7, t0.requirements AS requirements_8, t0.required_endorsements AS required_endorsements_9, t0.salary AS salary_10, t0.is_active AS is_active_11, t0.expires_at AS expires_at_12, t0.custom_questions AS custom_questions_13, t0.video_url AS video_url_14, t0.parsed_video_embed AS parsed_video_embed_15, t0.radius AS radius_16, t0.minimum_experience AS minimum_experience_17, t0.pay_range AS pay_range_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.company_id AS company_id_21 FROM job_posting t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.location AS location_5,
  t0.employment_type AS employment_type_6,
  t0.route_type AS route_type_7,
  t0.requirements AS requirements_8,
  t0.required_endorsements AS required_endorsements_9,
  t0.salary AS salary_10,
  t0.is_active AS is_active_11,
  t0.expires_at AS expires_at_12,
  t0.custom_questions AS custom_questions_13,
  t0.video_url AS video_url_14,
  t0.parsed_video_embed AS parsed_video_embed_15,
  t0.radius AS radius_16,
  t0.minimum_experience AS minimum_experience_17,
  t0.pay_range AS pay_range_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.company_id AS company_id_21
FROM
  job_posting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.location AS location_5, t0.employment_type AS employment_type_6, t0.route_type AS route_type_7, t0.requirements AS requirements_8, t0.required_endorsements AS required_endorsements_9, t0.salary AS salary_10, t0.is_active AS is_active_11, t0.expires_at AS expires_at_12, t0.custom_questions AS custom_questions_13, t0.video_url AS video_url_14, t0.parsed_video_embed AS parsed_video_embed_15, t0.radius AS radius_16, t0.minimum_experience AS minimum_experience_17, t0.pay_range AS pay_range_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.company_id AS company_id_21 FROM job_posting 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 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.01 ms
(41.14%)

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.location AS location_4, j0_.employment_type AS employment_type_5, j0_.route_type AS route_type_6, j0_.requirements AS requirements_7, j0_.required_endorsements AS required_endorsements_8, j0_.salary AS salary_9, j0_.is_active AS is_active_10, j0_.expires_at AS expires_at_11, j0_.custom_questions AS custom_questions_12, j0_.video_url AS video_url_13, j0_.parsed_video_embed AS parsed_video_embed_14, j0_.radius AS radius_15, j0_.minimum_experience AS minimum_experience_16, j0_.pay_range AS pay_range_17, j0_.created_at AS created_at_18, j0_.updated_at AS updated_at_19, c1_.id AS id_20, c1_.company_name AS company_name_21, c1_.description AS description_22, c1_.website AS website_23, c1_.address AS address_24, c1_.city AS city_25, c1_.state AS state_26, c1_.zip_code AS zip_code_27, c1_.phone AS phone_28, c1_.is_verified AS is_verified_29, c1_.is_profile_complete AS is_profile_complete_30, c1_.company_size AS company_size_31, c1_.status AS status_32, c1_.created_at AS created_at_33, c1_.last_activity_at AS last_activity_at_34, c1_.activity_metrics AS activity_metrics_35, c1_.integration_statuses AS integration_statuses_36, j0_.company_id AS company_id_37, c1_.owner_id AS owner_id_38 FROM job_posting j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id WHERE j0_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.slug AS slug_2,
  j0_.description AS description_3,
  j0_.location AS location_4,
  j0_.employment_type AS employment_type_5,
  j0_.route_type AS route_type_6,
  j0_.requirements AS requirements_7,
  j0_.required_endorsements AS required_endorsements_8,
  j0_.salary AS salary_9,
  j0_.is_active AS is_active_10,
  j0_.expires_at AS expires_at_11,
  j0_.custom_questions AS custom_questions_12,
  j0_.video_url AS video_url_13,
  j0_.parsed_video_embed AS parsed_video_embed_14,
  j0_.radius AS radius_15,
  j0_.minimum_experience AS minimum_experience_16,
  j0_.pay_range AS pay_range_17,
  j0_.created_at AS created_at_18,
  j0_.updated_at AS updated_at_19,
  c1_.id AS id_20,
  c1_.company_name AS company_name_21,
  c1_.description AS description_22,
  c1_.website AS website_23,
  c1_.address AS address_24,
  c1_.city AS city_25,
  c1_.state AS state_26,
  c1_.zip_code AS zip_code_27,
  c1_.phone AS phone_28,
  c1_.is_verified AS is_verified_29,
  c1_.is_profile_complete AS is_profile_complete_30,
  c1_.company_size AS company_size_31,
  c1_.status AS status_32,
  c1_.created_at AS created_at_33,
  c1_.last_activity_at AS last_activity_at_34,
  c1_.activity_metrics AS activity_metrics_35,
  c1_.integration_statuses AS integration_statuses_36,
  j0_.company_id AS company_id_37,
  c1_.owner_id AS owner_id_38
FROM
  job_posting j0_
  LEFT JOIN company c1_ ON j0_.company_id = c1_.id
WHERE
  j0_.id = ?

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.location AS location_4, j0_.employment_type AS employment_type_5, j0_.route_type AS route_type_6, j0_.requirements AS requirements_7, j0_.required_endorsements AS required_endorsements_8, j0_.salary AS salary_9, j0_.is_active AS is_active_10, j0_.expires_at AS expires_at_11, j0_.custom_questions AS custom_questions_12, j0_.video_url AS video_url_13, j0_.parsed_video_embed AS parsed_video_embed_14, j0_.radius AS radius_15, j0_.minimum_experience AS minimum_experience_16, j0_.pay_range AS pay_range_17, j0_.created_at AS created_at_18, j0_.updated_at AS updated_at_19, c1_.id AS id_20, c1_.company_name AS company_name_21, c1_.description AS description_22, c1_.website AS website_23, c1_.address AS address_24, c1_.city AS city_25, c1_.state AS state_26, c1_.zip_code AS zip_code_27, c1_.phone AS phone_28, c1_.is_verified AS is_verified_29, c1_.is_profile_complete AS is_profile_complete_30, c1_.company_size AS company_size_31, c1_.status AS status_32, c1_.created_at AS created_at_33, c1_.last_activity_at AS last_activity_at_34, c1_.activity_metrics AS activity_metrics_35, c1_.integration_statuses AS integration_statuses_36, j0_.company_id AS company_id_37, c1_.owner_id AS owner_id_38 FROM job_posting j0_ LEFT JOIN company c1_ ON j0_.company_id = c1_.id WHERE j0_.id = 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 96)
7	App\Controller\JobController->view (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\JobPosting	No errors.
App\Entity\Company	No errors.
App\Entity\JobApplication	The association App\Entity\JobApplication#driver refers to the inverse side field App\Entity\DriverProfile#applications which does not exist.
App\Entity\User	No errors.

Symfony Profiler

GET https://trucker.brettevanson.com/jobs/1

Configuration Settings

Theme