Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.46 ms Query time

0 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.29 ms
(62.68%)

SELECT p0_.id AS id_0, p0_.categorie AS categorie_1, p0_.titre AS titre_2, p0_.image_principale AS image_principale_3, p0_.description AS description_4, p0_.date_publication AS date_publication_5, p0_.resume AS resume_6, p0_.is_published AS is_published_7, p0_.is_premium AS is_premium_8, p0_.document AS document_9, p0_.lien_source AS lien_source_10, p0_.video AS video_11, p0_.country AS country_12, p0_.titreen AS titreen_13, p0_.image_principaleen AS image_principaleen_14, p0_.resumeen AS resumeen_15, p0_.descriptionen AS descriptionen_16, p0_.categorieen AS categorieen_17, p0_.countryen AS countryen_18, p0_.documenten AS documenten_19, p0_.visiblefr AS visiblefr_20 FROM premium_analyse_financiere p0_ WHERE p0_.is_published = ? AND p0_.is_premium = 0 ORDER BY p0_.date_publication DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.categorie AS categorie_1,
  p0_.titre AS titre_2,
  p0_.image_principale AS image_principale_3,
  p0_.description AS description_4,
  p0_.date_publication AS date_publication_5,
  p0_.resume AS resume_6,
  p0_.is_published AS is_published_7,
  p0_.is_premium AS is_premium_8,
  p0_.document AS document_9,
  p0_.lien_source AS lien_source_10,
  p0_.video AS video_11,
  p0_.country AS country_12,
  p0_.titreen AS titreen_13,
  p0_.image_principaleen AS image_principaleen_14,
  p0_.resumeen AS resumeen_15,
  p0_.descriptionen AS descriptionen_16,
  p0_.categorieen AS categorieen_17,
  p0_.countryen AS countryen_18,
  p0_.documenten AS documenten_19,
  p0_.visiblefr AS visiblefr_20
FROM
  premium_analyse_financiere p0_
WHERE
  p0_.is_published = ?
  AND p0_.is_premium = 0
ORDER BY
  p0_.date_publication DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.categorie AS categorie_1, p0_.titre AS titre_2, p0_.image_principale AS image_principale_3, p0_.description AS description_4, p0_.date_publication AS date_publication_5, p0_.resume AS resume_6, p0_.is_published AS is_published_7, p0_.is_premium AS is_premium_8, p0_.document AS document_9, p0_.lien_source AS lien_source_10, p0_.video AS video_11, p0_.country AS country_12, p0_.titreen AS titreen_13, p0_.image_principaleen AS image_principaleen_14, p0_.resumeen AS resumeen_15, p0_.descriptionen AS descriptionen_16, p0_.categorieen AS categorieen_17, p0_.countryen AS countryen_18, p0_.documenten AS documenten_19, p0_.visiblefr AS visiblefr_20 FROM premium_analyse_financiere p0_ WHERE p0_.is_published = 1 AND p0_.is_premium = 0 ORDER BY p0_.date_publication DESC LIMIT 3;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Controller\HomeController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.17 ms
(37.32%)

SELECT t0.id AS id_1, t0.ticker AS ticker_2, t0.name AS name_3, t0.price AS price_4, t0.variation AS variation_5, t0.trend AS trend_6, t0.created_at AS created_at_7 FROM brvm_stock t0 LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ticker AS ticker_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.variation AS variation_5,
  t0.trend AS trend_6,
  t0.created_at AS created_at_7
FROM
  brvm_stock t0
LIMIT
  20

SELECT t0.id AS id_1, t0.ticker AS ticker_2, t0.name AS name_3, t0.price AS price_4, t0.variation AS variation_5, t0.trend AS trend_6, t0.created_at AS created_at_7 FROM brvm_stock t0 LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Twig\GlobalStocksExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
16	App\Controller\HomeController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\BrvmStock	20

Entities Mapping

Class	Mapping errors
App\Entity\PremiumAnalyseFinanciere	No errors.
App\Entity\BrvmStock	No errors.

Symfony Profiler

GET https://sa2if.com/fr/

Configuration Settings

Theme

Page Width