Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.06 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.77 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.type AS type_4, t0.image AS image_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM article t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "contact@clgunme.edu"
]

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.type AS type_4,
  t0.image AS image_5,
  t0.content AS content_6,
  t0.created_at AS created_at_7,
  t0.created_by AS created_by_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.type AS type_4, t0.image AS image_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM article t0 WHERE t0.slug = 'contact@clgunme.edu' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 28)
5	App\Controller\Client\ArticleController->showArticle (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.29 ms

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.type AS type_3, a0_.image AS image_4, a0_.content AS content_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9 FROM article a0_ ORDER BY a0_.created_at DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.type AS type_3,
  a0_.image AS image_4,
  a0_.content AS content_5,
  a0_.created_at AS created_at_6,
  a0_.created_by AS created_by_7,
  a0_.updated_at AS updated_at_8,
  a0_.updated_by AS updated_by_9
FROM
  article a0_
ORDER BY
  a0_.created_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.type AS type_3, a0_.image AS image_4, a0_.content AS content_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9 FROM article a0_ ORDER BY a0_.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 36)
7	App\Repository\ArticleRepository->findLatestArticles (line 31)
8	App\Controller\Client\ArticleController->showArticle (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Article	No errors.
App\Entity\Address	No errors.
App\Entity\Teacher	No errors.
App\Entity\Publish	The mappings App\Entity\Publish#promotion and App\Entity\Promotion#publishes are inconsistent with each other.
App\Entity\Subject	No errors.
App\Entity\Enrollment	No errors.
App\Entity\Semester	No errors.
App\Entity\AcademicYear	No errors.
App\Entity\Department	The mappings App\Entity\Department#formation and App\Entity\Timetable#formation are inconsistent with each other.
App\Entity\Faculty	No errors.
App\Entity\StudentResponse	No errors.
App\Entity\Promotion	The association App\Entity\Promotion#courses refers to the owning side field App\Entity\Course#promotion which does not exist. The association App\Entity\Promotion#publishes refers to the owning side field App\Entity\Publish#Promotion which does not exist.
App\Entity\Student	The mappings App\Entity\Student#formation and App\Entity\Enrollment#student are inconsistent with each other.
App\Entity\Result	No errors.
App\Entity\Event	No errors.
App\Entity\Homework	No errors.
App\Entity\Grade	No errors.
App\Entity\Room	No errors.
App\Entity\Timetable	No errors.
App\Entity\User	No errors.
App\Entity\Contact	No errors.
App\Entity\Reference	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Chapter	No errors.
App\Entity\Formation	No errors.
App\Entity\Course	No errors.
App\Entity\Service	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://datacambi.com/article/contact@clgunme.edu

Configuration Settings

Theme