Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.08 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.46 ms

SELECT t0.id AS id_1, t0.legal_information_fr AS legal_information_fr_2, t0.general_terms_fr AS general_terms_fr_3, t0.legal_information_en AS legal_information_en_4, t0.general_terms_en AS general_terms_en_5, t0.legal_information_de AS legal_information_de_6, t0.general_terms_de AS general_terms_de_7, t0.legal_information_nl AS legal_information_nl_8, t0.general_terms_nl AS general_terms_nl_9, t0.order_email AS order_email_10, t0.noreply_email AS noreply_email_11, t0.order_hour AS order_hour_12, t0.promotion_priority AS promotion_priority_13, t0.google_api_key AS google_api_key_14, t0.rgpd_fr AS rgpd_fr_15, t0.rgpd_en AS rgpd_en_16, t0.rgpd_de AS rgpd_de_17, t0.rgpd_nl AS rgpd_nl_18, t0.is_shipping_cost AS is_shipping_cost_19, t0.min_order AS min_order_20, t0.shipping_costs AS shipping_costs_21, t0.show_articles_price AS show_articles_price_22, t0.comment_article AS comment_article_23 FROM parameters t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.legal_information_fr AS legal_information_fr_2,
  t0.general_terms_fr AS general_terms_fr_3,
  t0.legal_information_en AS legal_information_en_4,
  t0.general_terms_en AS general_terms_en_5,
  t0.legal_information_de AS legal_information_de_6,
  t0.general_terms_de AS general_terms_de_7,
  t0.legal_information_nl AS legal_information_nl_8,
  t0.general_terms_nl AS general_terms_nl_9,
  t0.order_email AS order_email_10,
  t0.noreply_email AS noreply_email_11,
  t0.order_hour AS order_hour_12,
  t0.promotion_priority AS promotion_priority_13,
  t0.google_api_key AS google_api_key_14,
  t0.rgpd_fr AS rgpd_fr_15,
  t0.rgpd_en AS rgpd_en_16,
  t0.rgpd_de AS rgpd_de_17,
  t0.rgpd_nl AS rgpd_nl_18,
  t0.is_shipping_cost AS is_shipping_cost_19,
  t0.min_order AS min_order_20,
  t0.shipping_costs AS shipping_costs_21,
  t0.show_articles_price AS show_articles_price_22,
  t0.comment_article AS comment_article_23
FROM
  parameters t0

SELECT t0.id AS id_1, t0.legal_information_fr AS legal_information_fr_2, t0.general_terms_fr AS general_terms_fr_3, t0.legal_information_en AS legal_information_en_4, t0.general_terms_en AS general_terms_en_5, t0.legal_information_de AS legal_information_de_6, t0.general_terms_de AS general_terms_de_7, t0.legal_information_nl AS legal_information_nl_8, t0.general_terms_nl AS general_terms_nl_9, t0.order_email AS order_email_10, t0.noreply_email AS noreply_email_11, t0.order_hour AS order_hour_12, t0.promotion_priority AS promotion_priority_13, t0.google_api_key AS google_api_key_14, t0.rgpd_fr AS rgpd_fr_15, t0.rgpd_en AS rgpd_en_16, t0.rgpd_de AS rgpd_de_17, t0.rgpd_nl AS rgpd_nl_18, t0.is_shipping_cost AS is_shipping_cost_19, t0.min_order AS min_order_20, t0.shipping_costs AS shipping_costs_21, t0.show_articles_price AS show_articles_price_22, t0.comment_article AS comment_article_23 FROM parameters t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Controller\RulesController->rules (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 20)

0.62 ms

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.webshop_type AS webshop_type_2,
  t0.is_kpi AS is_kpi_3,
  t0.url_kpi AS url_kpi_4,
  t0.name_kpi AS name_kpi_5,
  t0.user_count AS user_count_6
FROM
  admin_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 56)
6	App\Controller\GlobalController->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
17	App\Controller\RulesController->rules (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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\Parameters	1
App\Entity\AdminParameters	1

Entities Mapping

Class	Mapping errors
App\Entity\Parameters	No errors.
App\Entity\AdminParameters	No errors.

Symfony Profiler

GET https://test.bivteam.shop/fr/rules

Configuration Settings

Theme

Page Width