Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

9.02 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.08 ms
(45.18%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = ? LIMIT 1

Parameters:

[
  "developpement"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.siret AS siret_4,
  t0.tva AS tva_5,
  t0.phone AS phone_6,
  t0.siren AS siren_7,
  t0.nic AS nic_8,
  t0.cat_juridique AS cat_juridique_9,
  t0.denomination AS denomination_10,
  t0.activite_principal AS activite_principal_11,
  t0.address1 AS address1_12,
  t0.address2 AS address2_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.frequency AS frequency_16,
  t0.iban AS iban_17,
  t0.bic AS bic_18,
  t0.mandate_id AS mandate_id_19,
  t0.mandate_date AS mandate_date_20,
  t0.offer_value AS offer_value_21,
  t0.societe_old_id AS societe_old_id_22,
  t0.tirelire AS tirelire_23,
  t0.abondement AS abondement_24,
  t0.subdomain AS subdomain_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.contract_date AS contract_date_28,
  t0.date_abondement AS date_abondement_29,
  t0.bans AS bans_30,
  t0.bans_sg AS bans_sg_31,
  t0.card_price AS card_price_32,
  t0.wallet_id AS wallet_id_33,
  t0.start_contract AS start_contract_34,
  t0.contract_duration AS contract_duration_35,
  t0.renewal_year AS renewal_year_36,
  t0.months_notice AS months_notice_37,
  t0.date_cancellation AS date_cancellation_38,
  t0.theoretical_end_contract AS theoretical_end_contract_39,
  t0.end_contract_renewal AS end_contract_renewal_40,
  t0.date_request_cancellation AS date_request_cancellation_41,
  t0.benefeciary_id AS benefeciary_id_42,
  t0.offer_id AS offer_id_43,
  t0.salesperson_id AS salesperson_id_44,
  t0.departement_id AS departement_id_45,
  t46.id AS id_47,
  t46.bic AS bic_48,
  t46.iban AS iban_49,
  t46.company_id_id AS company_id_id_50,
  t0.debit_bank_id AS debit_bank_id_51
FROM
  company t0
  LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = 'developpement' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 34)
4	App\Twig\ThemeExtension->getTheme (line 83)
5	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->doDisplay (line 393)
6	Twig\Template->yield (line 55)
7	__TwigTemplate_516a16fdeed7751dfbac3520f596ea40->doDisplay (line 393)
8	Twig\Template->yield (line 349)
9	Twig\Template->display (line 364)
10	Twig\Template->render (line 35)
11	Twig\TemplateWrapper->render (line 306)
12	Twig\Environment->render (line 243)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
15	App\Controller\Front\PrivacyController->index_cgu (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

2.44 ms
(27.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "CGU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'CGU' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 22)
4	App\Service\Config->get (line 31)
5	App\Controller\Front\PrivacyController->index_cgu (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.21 ms
(13.40%)

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.url AS url_3, t0.active AS active_4, t0.position AS position_5 FROM social_media t0 WHERE t0.active = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.position AS position_5
FROM
  social_media t0
WHERE
  t0.active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.url AS url_3, t0.active AS active_4, t0.position AS position_5 FROM social_media t0 WHERE t0.active = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 146)
4	App\Twig\AppExtension->getRs (line 124)
5	__TwigTemplate_7307757c7113b1fdc24807014b944223->doDisplay (line 393)
6	Twig\Template->yield (line 66)
7	__TwigTemplate_e86c53140a1a15deb4cf3b261934f94e->doDisplay (line 393)
8	Twig\Template->yield (line 409)
9	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->block_header (line 437)
10	Twig\Template->yieldBlock (line 176)
11	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->doDisplay (line 393)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_516a16fdeed7751dfbac3520f596ea40->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
21	App\Controller\Front\PrivacyController->index_cgu (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.76 ms
(8.43%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.platform AS platform_3, t0.parameters AS parameters_4 FROM customization t0 WHERE t0.label = ? AND t0.platform = ? LIMIT 1

Parameters:

[
  "banner"
  "Web"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.platform AS platform_3,
  t0.parameters AS parameters_4
FROM
  customization t0
WHERE
  t0.label = ?
  AND t0.platform = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.platform AS platform_3, t0.parameters AS parameters_4 FROM customization t0 WHERE t0.label = 'banner' AND t0.platform = 'Web' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 28)
4	App\Twig\CustomizationExtension->getBanner (line 48)
5	__TwigTemplate_e86c53140a1a15deb4cf3b261934f94e->doDisplay (line 393)
6	Twig\Template->yield (line 409)
7	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->block_header (line 437)
8	Twig\Template->yieldBlock (line 176)
9	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->doDisplay (line 393)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_516a16fdeed7751dfbac3520f596ea40->doDisplay (line 393)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 243)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
19	App\Controller\Front\PrivacyController->index_cgu (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.54 ms
(5.98%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_home AS description_home_4, t0.link_video AS link_video_5, t0.image AS image_6, t0.image_group AS image_group_7, t0.position AS position_8, t0.reverse AS reverse_9, t0.slug AS slug_10, t0.display_home AS display_home_11 FROM solution t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.description_home AS description_home_4,
  t0.link_video AS link_video_5,
  t0.image AS image_6,
  t0.image_group AS image_group_7,
  t0.position AS position_8,
  t0.reverse AS reverse_9,
  t0.slug AS slug_10,
  t0.display_home AS display_home_11
FROM
  solution t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_home AS description_home_4, t0.link_video AS link_video_5, t0.image AS image_6, t0.image_group AS image_group_7, t0.position AS position_8, t0.reverse AS reverse_9, t0.slug AS slug_10, t0.display_home AS display_home_11 FROM solution t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 30)
5	App\Twig\SolutionExtension->getAllSolutions (line 48)
6	__TwigTemplate_7307757c7113b1fdc24807014b944223->doDisplay (line 393)
7	Twig\Template->yield (line 66)
8	__TwigTemplate_e86c53140a1a15deb4cf3b261934f94e->doDisplay (line 393)
9	Twig\Template->yield (line 409)
10	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->block_header (line 437)
11	Twig\Template->yieldBlock (line 176)
12	__TwigTemplate_2bd6693a70f57a5a3e2f998731fb0435->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_516a16fdeed7751dfbac3520f596ea40->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
22	App\Controller\Front\PrivacyController->index_cgu (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Configuration	No errors.
App\Entity\Company	No errors.
App\Entity\Offer	No errors.
App\Entity\User	No errors.
App\Entity\Maps\Notification\Departement	No errors.
App\Entity\CompanyTreezorWallet	No errors.
App\Entity\Finance\DebitBank	No errors.
App\Entity\Configuration\Customization	No errors.
App\Entity\Solutions\Solution	No errors.
App\Entity\Solutions\BlockSolution	No errors.
App\Entity\Configuration\SocialMedia	No errors.
App\Entity\UserCompany	No errors.
App\Entity\Refund\RefundActivity	No errors.
App\Entity\Article	No errors.
App\Entity\Log\LogsDirigeant	No errors.
App\Entity\SharedPdf	No errors.
App\Entity\Company\CompanyTaxFile	No errors.
App\Entity\PartnerHome	No errors.
App\Entity\Company\IbanCompanyChange	No errors.
App\Entity\CagnotteRequest	No errors.
App\Entity\AdditionalProduct\AdditionalProductOrder	No errors.
App\Entity\Company\OfferRulesCompany	No errors.
App\Entity\CompanyUserStatus	No errors.
App\Entity\CompanyAbondementExceptionnel	No errors.
App\Entity\CompanyAbondement	No errors.
App\Entity\Company\CompanyHistoryOs	No errors.
App\Entity\TreezorOrderCard	No errors.
App\Entity\TreezorDeliveryDetails	No errors.
App\Entity\Reminder	No errors.
App\Entity\Cagnotte	No errors.
App\Entity\UserAdresse	No errors.
App\Entity\Famille\FamilleMembre	No errors.
App\Entity\Famille\Famille	No errors.
App\Entity\Refund\RefundRequest	No errors.
App\Entity\Salarie\IbanChange	No errors.
App\Entity\ArticleBlog	No errors.
App\Entity\Log\LogsAdmin	No errors.
App\Entity\Card	No errors.
App\Entity\Emails\EmailList	No errors.
App\Entity\Order\Order	No errors.
App\Entity\Notifications\NotificationsUser	No errors.
App\Entity\ReducCe\ProductRequest	No errors.
App\Entity\Analytics\AnalyticsPermissions	No errors.
App\Entity\MailProgrammation	No errors.
App\Entity\UserTreezor	No errors.
App\Entity\Treezor\HistoryApiException	No errors.
App\Entity\Treezor\HistoryWebHookId	No errors.
App\Entity\Treezor\TreezorTransfert	The mappings App\Entity\Treezor\TreezorTransfert#creditedWallet and App\Entity\CompanyTreezorWallet#treezorTransferts are inconsistent with each other.
App\Entity\Maps\Notification\Region	No errors.

Symfony Profiler

GET https://developpement.amhappy.fr/cgu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping