Symfony Profiler

Query Metrics

42 Database Queries

17 Different statements

32.67 ms Query time

12 Invalid entities

51 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.70 ms
(17.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.banner_name AS banner_name_4,
  t0.banner_size AS banner_size_5,
  t0.banner_updated_at AS banner_updated_at_6,
  t0.banner_alt AS banner_alt_7,
  t0.banner_youtube_url_original AS banner_youtube_url_original_8,
  t0.banner_youtube_url_embed AS banner_youtube_url_embed_9,
  t0.advantage_title AS advantage_title_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.slug AS slug_13,
  t14.product_name AS product_name_15,
  t14.product_size AS product_size_16,
  t14.product_updated_at AS product_updated_at_17,
  t14.product_alt AS product_alt_18,
  t14.cover_name AS cover_name_19,
  t14.cover_size AS cover_size_20,
  t14.cover_updated_at AS cover_updated_at_21,
  t14.cover_alt AS cover_alt_22,
  t14.logo_name AS logo_name_23,
  t14.logo_size AS logo_size_24,
  t14.logo_updated_at AS logo_updated_at_25,
  t14.logo_alt AS logo_alt_26,
  t14.display_hp AS display_hp_27,
  t14.id AS id_28,
  t14.position AS position_29,
  t14.is_published AS is_published_30,
  t14.category_id AS category_id_31,
  t14.translation_en_id AS translation_en_id_32,
  t14.translation_fr_id AS translation_fr_id_33,
  t34.product_name AS product_name_35,
  t34.product_size AS product_size_36,
  t34.product_updated_at AS product_updated_at_37,
  t34.product_alt AS product_alt_38,
  t34.cover_name AS cover_name_39,
  t34.cover_size AS cover_size_40,
  t34.cover_updated_at AS cover_updated_at_41,
  t34.cover_alt AS cover_alt_42,
  t34.logo_name AS logo_name_43,
  t34.logo_size AS logo_size_44,
  t34.logo_updated_at AS logo_updated_at_45,
  t34.logo_alt AS logo_alt_46,
  t34.display_hp AS display_hp_47,
  t34.id AS id_48,
  t34.position AS position_49,
  t34.is_published AS is_published_50,
  t34.category_id AS category_id_51,
  t34.translation_en_id AS translation_en_id_52,
  t34.translation_fr_id AS translation_fr_id_53
FROM
  product t0
  LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id
  LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Product\Product::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\Product->__get (line 22)
8	App\Entity\Product\Product->getSlug (line 98)
9	App\Entity\Product\ProductGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 226)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
12	Twig\Template->yieldBlock (line 52)
13	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
14	Twig\Template->yield (line 162)
15	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
28	App\Controller\FrontController->homepage (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

4.73 ms
(14.47%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.advantage_sub_title AS advantage_sub_title_4, t0.advantage_title AS advantage_title_5, t0.banner_name AS banner_name_6, t0.banner_size AS banner_size_7, t0.banner_updated_at AS banner_updated_at_8, t0.banner_alt AS banner_alt_9, t0.banner_youtube_url_original AS banner_youtube_url_original_10, t0.banner_youtube_url_embed AS banner_youtube_url_embed_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.slug AS slug_14, t15.id AS id_16, t15.image_name AS image_name_17, t15.image_size AS image_size_18, t15.image_updated_at AS image_updated_at_19, t15.image_alt AS image_alt_20, t15.position AS position_21, t15.is_published AS is_published_22, t15.translation_en_id AS translation_en_id_23, t15.translation_fr_id AS translation_fr_id_24, t25.id AS id_26, t25.image_name AS image_name_27, t25.image_size AS image_size_28, t25.image_updated_at AS image_updated_at_29, t25.image_alt AS image_alt_30, t25.position AS position_31, t25.is_published AS is_published_32, t25.translation_en_id AS translation_en_id_33, t25.translation_fr_id AS translation_fr_id_34 FROM technology t0 LEFT JOIN technology_global t15 ON t15.translation_en_id = t0.id LEFT JOIN technology_global t25 ON t25.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.advantage_sub_title AS advantage_sub_title_4,
  t0.advantage_title AS advantage_title_5,
  t0.banner_name AS banner_name_6,
  t0.banner_size AS banner_size_7,
  t0.banner_updated_at AS banner_updated_at_8,
  t0.banner_alt AS banner_alt_9,
  t0.banner_youtube_url_original AS banner_youtube_url_original_10,
  t0.banner_youtube_url_embed AS banner_youtube_url_embed_11,
  t0.meta_title AS meta_title_12,
  t0.meta_description AS meta_description_13,
  t0.slug AS slug_14,
  t15.id AS id_16,
  t15.image_name AS image_name_17,
  t15.image_size AS image_size_18,
  t15.image_updated_at AS image_updated_at_19,
  t15.image_alt AS image_alt_20,
  t15.position AS position_21,
  t15.is_published AS is_published_22,
  t15.translation_en_id AS translation_en_id_23,
  t15.translation_fr_id AS translation_fr_id_24,
  t25.id AS id_26,
  t25.image_name AS image_name_27,
  t25.image_size AS image_size_28,
  t25.image_updated_at AS image_updated_at_29,
  t25.image_alt AS image_alt_30,
  t25.position AS position_31,
  t25.is_published AS is_published_32,
  t25.translation_en_id AS translation_en_id_33,
  t25.translation_fr_id AS translation_fr_id_34
FROM
  technology t0
  LEFT JOIN technology_global t15 ON t15.translation_en_id = t0.id
  LEFT JOIN technology_global t25 ON t25.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.advantage_sub_title AS advantage_sub_title_4, t0.advantage_title AS advantage_title_5, t0.banner_name AS banner_name_6, t0.banner_size AS banner_size_7, t0.banner_updated_at AS banner_updated_at_8, t0.banner_alt AS banner_alt_9, t0.banner_youtube_url_original AS banner_youtube_url_original_10, t0.banner_youtube_url_embed AS banner_youtube_url_embed_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.slug AS slug_14, t15.id AS id_16, t15.image_name AS image_name_17, t15.image_size AS image_size_18, t15.image_updated_at AS image_updated_at_19, t15.image_alt AS image_alt_20, t15.position AS position_21, t15.is_published AS is_published_22, t15.translation_en_id AS translation_en_id_23, t15.translation_fr_id AS translation_fr_id_24, t25.id AS id_26, t25.image_name AS image_name_27, t25.image_size AS image_size_28, t25.image_updated_at AS image_updated_at_29, t25.image_alt AS image_alt_30, t25.position AS position_31, t25.is_published AS is_published_32, t25.translation_en_id AS translation_en_id_33, t25.translation_fr_id AS translation_fr_id_34 FROM technology t0 LEFT JOIN technology_global t15 ON t15.translation_en_id = t0.id LEFT JOIN technology_global t25 ON t25.translation_fr_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Technology\Technology::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Technology\Technology->__get (line 22)
8	App\Entity\Technology\Technology->getSlug (line 98)
9	App\Entity\Technology\TechnologyGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 338)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
12	Twig\Template->yieldBlock (line 52)
13	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
14	Twig\Template->yield (line 162)
15	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
28	App\Controller\FrontController->homepage (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

3.30 ms
(10.11%)

SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_size AS image_size_2, s0_.image_updated_at AS image_updated_at_3, s0_.image_alt AS image_alt_4, s0_.icon_name AS icon_name_5, s0_.icon_size AS icon_size_6, s0_.icon_updated_at AS icon_updated_at_7, s0_.icon_alt AS icon_alt_8, s0_.is_published AS is_published_9, s0_.translation_en_id AS translation_en_id_10, s0_.translation_fr_id AS translation_fr_id_11 FROM service_global s0_ WHERE s0_.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.image_name AS image_name_1,
  s0_.image_size AS image_size_2,
  s0_.image_updated_at AS image_updated_at_3,
  s0_.image_alt AS image_alt_4,
  s0_.icon_name AS icon_name_5,
  s0_.icon_size AS icon_size_6,
  s0_.icon_updated_at AS icon_updated_at_7,
  s0_.icon_alt AS icon_alt_8,
  s0_.is_published AS is_published_9,
  s0_.translation_en_id AS translation_en_id_10,
  s0_.translation_fr_id AS translation_fr_id_11
FROM
  service_global s0_
WHERE
  s0_.is_published = ?

SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_size AS image_size_2, s0_.image_updated_at AS image_updated_at_3, s0_.image_alt AS image_alt_4, s0_.icon_name AS icon_name_5, s0_.icon_size AS icon_size_6, s0_.icon_updated_at AS icon_updated_at_7, s0_.icon_alt AS icon_alt_8, s0_.is_published AS is_published_9, s0_.translation_en_id AS translation_en_id_10, s0_.translation_fr_id AS translation_fr_id_11 FROM service_global s0_ WHERE s0_.is_published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\Service\ServiceGlobalRepository->findPublished (line 98)
8	App\Twig\AppExtension->getServices (line 384)
9	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
10	Twig\Template->yieldBlock (line 52)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
12	Twig\Template->yield (line 162)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

2.68 ms
(8.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.accordion_title AS accordion_title_4, t0.accordion_description AS accordion_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.slug AS slug_8, t9.id AS id_10, t9.image_name AS image_name_11, t9.image_size AS image_size_12, t9.image_updated_at AS image_updated_at_13, t9.image_alt AS image_alt_14, t9.icon_name AS icon_name_15, t9.icon_size AS icon_size_16, t9.icon_updated_at AS icon_updated_at_17, t9.icon_alt AS icon_alt_18, t9.is_published AS is_published_19, t9.translation_en_id AS translation_en_id_20, t9.translation_fr_id AS translation_fr_id_21, t22.id AS id_23, t22.image_name AS image_name_24, t22.image_size AS image_size_25, t22.image_updated_at AS image_updated_at_26, t22.image_alt AS image_alt_27, t22.icon_name AS icon_name_28, t22.icon_size AS icon_size_29, t22.icon_updated_at AS icon_updated_at_30, t22.icon_alt AS icon_alt_31, t22.is_published AS is_published_32, t22.translation_en_id AS translation_en_id_33, t22.translation_fr_id AS translation_fr_id_34 FROM service t0 LEFT JOIN service_global t9 ON t9.translation_en_id = t0.id LEFT JOIN service_global t22 ON t22.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.accordion_title AS accordion_title_4,
  t0.accordion_description AS accordion_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.slug AS slug_8,
  t9.id AS id_10,
  t9.image_name AS image_name_11,
  t9.image_size AS image_size_12,
  t9.image_updated_at AS image_updated_at_13,
  t9.image_alt AS image_alt_14,
  t9.icon_name AS icon_name_15,
  t9.icon_size AS icon_size_16,
  t9.icon_updated_at AS icon_updated_at_17,
  t9.icon_alt AS icon_alt_18,
  t9.is_published AS is_published_19,
  t9.translation_en_id AS translation_en_id_20,
  t9.translation_fr_id AS translation_fr_id_21,
  t22.id AS id_23,
  t22.image_name AS image_name_24,
  t22.image_size AS image_size_25,
  t22.image_updated_at AS image_updated_at_26,
  t22.image_alt AS image_alt_27,
  t22.icon_name AS icon_name_28,
  t22.icon_size AS icon_size_29,
  t22.icon_updated_at AS icon_updated_at_30,
  t22.icon_alt AS icon_alt_31,
  t22.is_published AS is_published_32,
  t22.translation_en_id AS translation_en_id_33,
  t22.translation_fr_id AS translation_fr_id_34
FROM
  service t0
  LEFT JOIN service_global t9 ON t9.translation_en_id = t0.id
  LEFT JOIN service_global t22 ON t22.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.accordion_title AS accordion_title_4, t0.accordion_description AS accordion_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.slug AS slug_8, t9.id AS id_10, t9.image_name AS image_name_11, t9.image_size AS image_size_12, t9.image_updated_at AS image_updated_at_13, t9.image_alt AS image_alt_14, t9.icon_name AS icon_name_15, t9.icon_size AS icon_size_16, t9.icon_updated_at AS icon_updated_at_17, t9.icon_alt AS icon_alt_18, t9.is_published AS is_published_19, t9.translation_en_id AS translation_en_id_20, t9.translation_fr_id AS translation_fr_id_21, t22.id AS id_23, t22.image_name AS image_name_24, t22.image_size AS image_size_25, t22.image_updated_at AS image_updated_at_26, t22.image_alt AS image_alt_27, t22.icon_name AS icon_name_28, t22.icon_size AS icon_size_29, t22.icon_updated_at AS icon_updated_at_30, t22.icon_alt AS icon_alt_31, t22.is_published AS is_published_32, t22.translation_en_id AS translation_en_id_33, t22.translation_fr_id AS translation_fr_id_34 FROM service t0 LEFT JOIN service_global t9 ON t9.translation_en_id = t0.id LEFT JOIN service_global t22 ON t22.translation_fr_id = t0.id WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Service\Service::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Service\Service->__get (line 22)
8	App\Entity\Service\Service->getSlug (line 98)
9	App\Entity\Service\ServiceGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 401)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
12	Twig\Template->yieldBlock (line 52)
13	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
14	Twig\Template->yield (line 162)
15	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
28	App\Controller\FrontController->homepage (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

2.50 ms
(7.64%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.created_at AS created_at_4, t0.slug AS slug_5, t0.position AS position_6, t7.picture_name AS picture_name_8, t7.picture_size AS picture_size_9, t7.picture_updated_at AS picture_updated_at_10, t7.picture_alt AS picture_alt_11, t7.meta_title AS meta_title_12, t7.meta_description AS meta_description_13, t7.is_published AS is_published_14, t7.id AS id_15, t7.translation_en_id AS translation_en_id_16, t7.translation_fr_id AS translation_fr_id_17, t18.picture_name AS picture_name_19, t18.picture_size AS picture_size_20, t18.picture_updated_at AS picture_updated_at_21, t18.picture_alt AS picture_alt_22, t18.meta_title AS meta_title_23, t18.meta_description AS meta_description_24, t18.is_published AS is_published_25, t18.id AS id_26, t18.translation_en_id AS translation_en_id_27, t18.translation_fr_id AS translation_fr_id_28 FROM article t0 LEFT JOIN article_global t7 ON t7.translation_en_id = t0.id LEFT JOIN article_global t18 ON t18.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.created_at AS created_at_4,
  t0.slug AS slug_5,
  t0.position AS position_6,
  t7.picture_name AS picture_name_8,
  t7.picture_size AS picture_size_9,
  t7.picture_updated_at AS picture_updated_at_10,
  t7.picture_alt AS picture_alt_11,
  t7.meta_title AS meta_title_12,
  t7.meta_description AS meta_description_13,
  t7.is_published AS is_published_14,
  t7.id AS id_15,
  t7.translation_en_id AS translation_en_id_16,
  t7.translation_fr_id AS translation_fr_id_17,
  t18.picture_name AS picture_name_19,
  t18.picture_size AS picture_size_20,
  t18.picture_updated_at AS picture_updated_at_21,
  t18.picture_alt AS picture_alt_22,
  t18.meta_title AS meta_title_23,
  t18.meta_description AS meta_description_24,
  t18.is_published AS is_published_25,
  t18.id AS id_26,
  t18.translation_en_id AS translation_en_id_27,
  t18.translation_fr_id AS translation_fr_id_28
FROM
  article t0
  LEFT JOIN article_global t7 ON t7.translation_en_id = t0.id
  LEFT JOIN article_global t18 ON t18.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.created_at AS created_at_4, t0.slug AS slug_5, t0.position AS position_6, t7.picture_name AS picture_name_8, t7.picture_size AS picture_size_9, t7.picture_updated_at AS picture_updated_at_10, t7.picture_alt AS picture_alt_11, t7.meta_title AS meta_title_12, t7.meta_description AS meta_description_13, t7.is_published AS is_published_14, t7.id AS id_15, t7.translation_en_id AS translation_en_id_16, t7.translation_fr_id AS translation_fr_id_17, t18.picture_name AS picture_name_19, t18.picture_size AS picture_size_20, t18.picture_updated_at AS picture_updated_at_21, t18.picture_alt AS picture_alt_22, t18.meta_title AS meta_title_23, t18.meta_description AS meta_description_24, t18.is_published AS is_published_25, t18.id AS id_26, t18.translation_en_id AS translation_en_id_27, t18.translation_fr_id AS translation_fr_id_28 FROM article t0 LEFT JOIN article_global t7 ON t7.translation_en_id = t0.id LEFT JOIN article_global t18 ON t18.translation_fr_id = t0.id WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Blog\Article::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Blog\Article->__get (line 98)
8	App\Entity\Blog\Article->getTitle (line 98)
9	App\Entity\Blog\ArticleGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 77)
11	__TwigTemplate_bc39f95d4d514753777a0c5fbc7b5436->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 77)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 420)
18	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->block_body (line 431)
19	Twig\Template->yieldBlock (line 167)
20	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
21	Twig\Template->yield (line 58)
22	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
25	Twig\Template->yield (line 343)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 35)
28	Twig\TemplateWrapper->render (line 320)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
33	App\Controller\FrontController->homepage (line 178)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

2.00 ms
(6.13%)

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.product_name AS product_name_0,
  p0_.product_size AS product_size_1,
  p0_.product_updated_at AS product_updated_at_2,
  p0_.product_alt AS product_alt_3,
  p0_.cover_name AS cover_name_4,
  p0_.cover_size AS cover_size_5,
  p0_.cover_updated_at AS cover_updated_at_6,
  p0_.cover_alt AS cover_alt_7,
  p0_.logo_name AS logo_name_8,
  p0_.logo_size AS logo_size_9,
  p0_.logo_updated_at AS logo_updated_at_10,
  p0_.logo_alt AS logo_alt_11,
  p0_.display_hp AS display_hp_12,
  p0_.id AS id_13,
  p0_.position AS position_14,
  p0_.is_published AS is_published_15,
  p0_.category_id AS category_id_16,
  p0_.translation_en_id AS translation_en_id_17,
  p0_.translation_fr_id AS translation_fr_id_18
FROM
  product_global p0_
WHERE
  p0_.is_published = ?

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.is_published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\Product\ProductGlobalRepository->findPublished (line 89)
8	App\Twig\AppExtension->getProducts (line 161)
9	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
10	Twig\Template->yieldBlock (line 52)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
12	Twig\Template->yield (line 162)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.77 ms
(5.43%)

SELECT t0_.id AS id_0, t0_.image_name AS image_name_1, t0_.image_size AS image_size_2, t0_.image_updated_at AS image_updated_at_3, t0_.image_alt AS image_alt_4, t0_.position AS position_5, t0_.is_published AS is_published_6, t0_.translation_en_id AS translation_en_id_7, t0_.translation_fr_id AS translation_fr_id_8 FROM technology_global t0_ WHERE t0_.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.image_name AS image_name_1,
  t0_.image_size AS image_size_2,
  t0_.image_updated_at AS image_updated_at_3,
  t0_.image_alt AS image_alt_4,
  t0_.position AS position_5,
  t0_.is_published AS is_published_6,
  t0_.translation_en_id AS translation_en_id_7,
  t0_.translation_fr_id AS translation_fr_id_8
FROM
  technology_global t0_
WHERE
  t0_.is_published = ?

SELECT t0_.id AS id_0, t0_.image_name AS image_name_1, t0_.image_size AS image_size_2, t0_.image_updated_at AS image_updated_at_3, t0_.image_alt AS image_alt_4, t0_.position AS position_5, t0_.is_published AS is_published_6, t0_.translation_en_id AS translation_en_id_7, t0_.translation_fr_id AS translation_fr_id_8 FROM technology_global t0_ WHERE t0_.is_published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\Technology\TechnologyGlobalRepository->findPublished (line 107)
8	App\Twig\AppExtension->getTechnologies (line 321)
9	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
10	Twig\Template->yieldBlock (line 52)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
12	Twig\Template->yield (line 162)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.71 ms
(5.23%)

SELECT t0.product_name AS product_name_1, t0.product_size AS product_size_2, t0.product_updated_at AS product_updated_at_3, t0.product_alt AS product_alt_4, t0.cover_name AS cover_name_5, t0.cover_size AS cover_size_6, t0.cover_updated_at AS cover_updated_at_7, t0.cover_alt AS cover_alt_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt AS logo_alt_12, t0.display_hp AS display_hp_13, t0.id AS id_14, t0.position AS position_15, t0.is_published AS is_published_16, t0.category_id AS category_id_17, t0.translation_en_id AS translation_en_id_18, t0.translation_fr_id AS translation_fr_id_19 FROM product_global t0 WHERE t0.category_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.product_name AS product_name_1,
  t0.product_size AS product_size_2,
  t0.product_updated_at AS product_updated_at_3,
  t0.product_alt AS product_alt_4,
  t0.cover_name AS cover_name_5,
  t0.cover_size AS cover_size_6,
  t0.cover_updated_at AS cover_updated_at_7,
  t0.cover_alt AS cover_alt_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt AS logo_alt_12,
  t0.display_hp AS display_hp_13,
  t0.id AS id_14,
  t0.position AS position_15,
  t0.is_published AS is_published_16,
  t0.category_id AS category_id_17,
  t0.translation_en_id AS translation_en_id_18,
  t0.translation_fr_id AS translation_fr_id_19
FROM
  product_global t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.product_name AS product_name_1, t0.product_size AS product_size_2, t0.product_updated_at AS product_updated_at_3, t0.product_alt AS product_alt_4, t0.cover_name AS cover_name_5, t0.cover_size AS cover_size_6, t0.cover_updated_at AS cover_updated_at_7, t0.cover_alt AS cover_alt_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt AS logo_alt_12, t0.display_hp AS display_hp_13, t0.id AS id_14, t0.position AS position_15, t0.is_published AS is_published_16, t0.category_id AS category_id_17, t0.translation_en_id AS translation_en_id_18, t0.translation_fr_id AS translation_fr_id_19 FROM product_global t0 WHERE t0.category_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 214)
9	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
10	Twig\Template->yieldBlock (line 52)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
12	Twig\Template->yield (line 162)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.55 ms
(4.75%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t9.image_name AS image_name_10,
  t9.image_size AS image_size_11,
  t9.image_updated_at AS image_updated_at_12,
  t9.image_alt AS image_alt_13,
  t9.id AS id_14,
  t9.translation_en_id AS translation_en_id_15,
  t9.translation_fr_id AS translation_fr_id_16,
  t17.image_name AS image_name_18,
  t17.image_size AS image_size_19,
  t17.image_updated_at AS image_updated_at_20,
  t17.image_alt AS image_alt_21,
  t17.id AS id_22,
  t17.translation_en_id AS translation_en_id_23,
  t17.translation_fr_id AS translation_fr_id_24
FROM
  product_category t0
  LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id
  LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t9.image_name AS image_name_10, t9.image_size AS image_size_11, t9.image_updated_at AS image_updated_at_12, t9.image_alt AS image_alt_13, t9.id AS id_14, t9.translation_en_id AS translation_en_id_15, t9.translation_fr_id AS translation_fr_id_16, t17.image_name AS image_name_18, t17.image_size AS image_size_19, t17.image_updated_at AS image_updated_at_20, t17.image_alt AS image_alt_21, t17.id AS id_22, t17.translation_en_id AS translation_en_id_23, t17.translation_fr_id AS translation_fr_id_24 FROM product_category t0 LEFT JOIN product_category_global t9 ON t9.translation_en_id = t0.id LEFT JOIN product_category_global t17 ON t17.translation_fr_id = t0.id WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Product\ProductCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\ProductCategory->__get (line 51)
8	App\Entity\Product\ProductCategory->getName (line 98)
9	App\Entity\Product\ProductCategoryGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 195)
11	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
12	Twig\Template->yieldBlock (line 52)
13	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
14	Twig\Template->yield (line 162)
15	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
28	App\Controller\FrontController->homepage (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

1.24 ms
(3.79%)

SELECT t0.id AS id_1, t0.template_type AS template_type_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_updated_at AS image_updated_at_5, t0.image_alt AS image_alt_6, t0.second_image_name AS second_image_name_7, t0.second_image_size AS second_image_size_8, t0.second_image_updated_at AS second_image_updated_at_9, t0.second_image_alt AS second_image_alt_10, t0.sub_title AS sub_title_11, t0.title AS title_12, t0.description AS description_13, t0.second_column_subtitle AS second_column_subtitle_14, t0.second_column_title AS second_column_title_15, t0.second_column_text AS second_column_text_16, t0.cta1_text AS cta1_text_17, t0.cta1_link AS cta1_link_18, t0.cta1_pdf_name AS cta1_pdf_name_19, t0.cta1_pdf_size AS cta1_pdf_size_20, t0.cta1_pdf_updated_at AS cta1_pdf_updated_at_21, t0.cta1_external AS cta1_external_22, t0.cta2_text AS cta2_text_23, t0.cta2_link AS cta2_link_24, t0.cta2_pdf_name AS cta2_pdf_name_25, t0.cta2_pdf_size AS cta2_pdf_size_26, t0.cta2_pdf_updated_at AS cta2_pdf_updated_at_27, t0.cta2_external AS cta2_external_28, t0.cta3_text AS cta3_text_29, t0.cta3_link AS cta3_link_30, t0.cta3_pdf_name AS cta3_pdf_name_31, t0.cta3_pdf_size AS cta3_pdf_size_32, t0.cta3_pdf_updated_at AS cta3_pdf_updated_at_33, t0.cta3_external AS cta3_external_34, t0.cta4_text AS cta4_text_35, t0.cta4_link AS cta4_link_36, t0.cta4_pdf_name AS cta4_pdf_name_37, t0.cta4_pdf_size AS cta4_pdf_size_38, t0.cta4_pdf_updated_at AS cta4_pdf_updated_at_39, t0.cta4_external AS cta4_external_40, t0.youtube_url_original AS youtube_url_original_41, t0.youtube_url_embed AS youtube_url_embed_42, t0.position AS position_43, t0.homepage_id AS homepage_id_44, t0.product_id AS product_id_45, t0.second_product_id AS second_product_id_46, t0.intro_product_id AS intro_product_id_47, t0.intro_technology_id AS intro_technology_id_48, t0.first_technology_id AS first_technology_id_49, t0.second_technology_id AS second_technology_id_50, t0.service_accordion_id AS service_accordion_id_51, t0.service_paragraphs_first_id AS service_paragraphs_first_id_52, t0.service_paragraphs_second_id AS service_paragraphs_second_id_53, t0.intro_about_us_page_id AS intro_about_us_page_id_54, t0.last_section_about_us_page_id AS last_section_about_us_page_id_55, t0.career_page_id AS career_page_id_56, t0.article_id AS article_id_57, t0.landing_page_id AS landing_page_id_58, t0.product_page_id AS product_page_id_59, t0.technology_page_id AS technology_page_id_60 FROM paragraph t0 WHERE t0.homepage_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.template_type AS template_type_2,
  t0.image_name AS image_name_3,
  t0.image_size AS image_size_4,
  t0.image_updated_at AS image_updated_at_5,
  t0.image_alt AS image_alt_6,
  t0.second_image_name AS second_image_name_7,
  t0.second_image_size AS second_image_size_8,
  t0.second_image_updated_at AS second_image_updated_at_9,
  t0.second_image_alt AS second_image_alt_10,
  t0.sub_title AS sub_title_11,
  t0.title AS title_12,
  t0.description AS description_13,
  t0.second_column_subtitle AS second_column_subtitle_14,
  t0.second_column_title AS second_column_title_15,
  t0.second_column_text AS second_column_text_16,
  t0.cta1_text AS cta1_text_17,
  t0.cta1_link AS cta1_link_18,
  t0.cta1_pdf_name AS cta1_pdf_name_19,
  t0.cta1_pdf_size AS cta1_pdf_size_20,
  t0.cta1_pdf_updated_at AS cta1_pdf_updated_at_21,
  t0.cta1_external AS cta1_external_22,
  t0.cta2_text AS cta2_text_23,
  t0.cta2_link AS cta2_link_24,
  t0.cta2_pdf_name AS cta2_pdf_name_25,
  t0.cta2_pdf_size AS cta2_pdf_size_26,
  t0.cta2_pdf_updated_at AS cta2_pdf_updated_at_27,
  t0.cta2_external AS cta2_external_28,
  t0.cta3_text AS cta3_text_29,
  t0.cta3_link AS cta3_link_30,
  t0.cta3_pdf_name AS cta3_pdf_name_31,
  t0.cta3_pdf_size AS cta3_pdf_size_32,
  t0.cta3_pdf_updated_at AS cta3_pdf_updated_at_33,
  t0.cta3_external AS cta3_external_34,
  t0.cta4_text AS cta4_text_35,
  t0.cta4_link AS cta4_link_36,
  t0.cta4_pdf_name AS cta4_pdf_name_37,
  t0.cta4_pdf_size AS cta4_pdf_size_38,
  t0.cta4_pdf_updated_at AS cta4_pdf_updated_at_39,
  t0.cta4_external AS cta4_external_40,
  t0.youtube_url_original AS youtube_url_original_41,
  t0.youtube_url_embed AS youtube_url_embed_42,
  t0.position AS position_43,
  t0.homepage_id AS homepage_id_44,
  t0.product_id AS product_id_45,
  t0.second_product_id AS second_product_id_46,
  t0.intro_product_id AS intro_product_id_47,
  t0.intro_technology_id AS intro_technology_id_48,
  t0.first_technology_id AS first_technology_id_49,
  t0.second_technology_id AS second_technology_id_50,
  t0.service_accordion_id AS service_accordion_id_51,
  t0.service_paragraphs_first_id AS service_paragraphs_first_id_52,
  t0.service_paragraphs_second_id AS service_paragraphs_second_id_53,
  t0.intro_about_us_page_id AS intro_about_us_page_id_54,
  t0.last_section_about_us_page_id AS last_section_about_us_page_id_55,
  t0.career_page_id AS career_page_id_56,
  t0.article_id AS article_id_57,
  t0.landing_page_id AS landing_page_id_58,
  t0.product_page_id AS product_page_id_59,
  t0.technology_page_id AS technology_page_id_60
FROM
  paragraph t0
WHERE
  t0.homepage_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.template_type AS template_type_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_updated_at AS image_updated_at_5, t0.image_alt AS image_alt_6, t0.second_image_name AS second_image_name_7, t0.second_image_size AS second_image_size_8, t0.second_image_updated_at AS second_image_updated_at_9, t0.second_image_alt AS second_image_alt_10, t0.sub_title AS sub_title_11, t0.title AS title_12, t0.description AS description_13, t0.second_column_subtitle AS second_column_subtitle_14, t0.second_column_title AS second_column_title_15, t0.second_column_text AS second_column_text_16, t0.cta1_text AS cta1_text_17, t0.cta1_link AS cta1_link_18, t0.cta1_pdf_name AS cta1_pdf_name_19, t0.cta1_pdf_size AS cta1_pdf_size_20, t0.cta1_pdf_updated_at AS cta1_pdf_updated_at_21, t0.cta1_external AS cta1_external_22, t0.cta2_text AS cta2_text_23, t0.cta2_link AS cta2_link_24, t0.cta2_pdf_name AS cta2_pdf_name_25, t0.cta2_pdf_size AS cta2_pdf_size_26, t0.cta2_pdf_updated_at AS cta2_pdf_updated_at_27, t0.cta2_external AS cta2_external_28, t0.cta3_text AS cta3_text_29, t0.cta3_link AS cta3_link_30, t0.cta3_pdf_name AS cta3_pdf_name_31, t0.cta3_pdf_size AS cta3_pdf_size_32, t0.cta3_pdf_updated_at AS cta3_pdf_updated_at_33, t0.cta3_external AS cta3_external_34, t0.cta4_text AS cta4_text_35, t0.cta4_link AS cta4_link_36, t0.cta4_pdf_name AS cta4_pdf_name_37, t0.cta4_pdf_size AS cta4_pdf_size_38, t0.cta4_pdf_updated_at AS cta4_pdf_updated_at_39, t0.cta4_external AS cta4_external_40, t0.youtube_url_original AS youtube_url_original_41, t0.youtube_url_embed AS youtube_url_embed_42, t0.position AS position_43, t0.homepage_id AS homepage_id_44, t0.product_id AS product_id_45, t0.second_product_id AS second_product_id_46, t0.intro_product_id AS intro_product_id_47, t0.intro_technology_id AS intro_technology_id_48, t0.first_technology_id AS first_technology_id_49, t0.second_technology_id AS second_technology_id_50, t0.service_accordion_id AS service_accordion_id_51, t0.service_paragraphs_first_id AS service_paragraphs_first_id_52, t0.service_paragraphs_second_id AS service_paragraphs_second_id_53, t0.intro_about_us_page_id AS intro_about_us_page_id_54, t0.last_section_about_us_page_id AS last_section_about_us_page_id_55, t0.career_page_id AS career_page_id_56, t0.article_id AS article_id_57, t0.landing_page_id AS landing_page_id_58, t0.product_page_id AS product_page_id_59, t0.technology_page_id AS technology_page_id_60 FROM paragraph t0 WHERE t0.homepage_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 99)
9	App\Entity\HomepageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 132)
11	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->block_body (line 431)
12	Twig\Template->yieldBlock (line 167)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.13 ms
(3.45%)

SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.image_name AS image_name_1,
  t0.image_size AS image_size_2,
  t0.image_updated_at AS image_updated_at_3,
  t0.image_alt AS image_alt_4,
  t0.id AS id_5,
  t0.translation_en_id AS translation_en_id_6,
  t0.translation_fr_id AS translation_fr_id_7
FROM
  product_category_global t0
WHERE
  t0.id = ?

SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_updated_at AS image_updated_at_3, t0.image_alt AS image_alt_4, t0.id AS id_5, t0.translation_en_id AS translation_en_id_6, t0.translation_fr_id AS translation_fr_id_7 FROM product_category_global t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Product\ProductCategoryGlobal::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\ProductCategoryGlobal->__get (line 37)
8	App\Entity\Product\ProductCategoryGlobal->__call (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 195)
10	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->block_header (line 431)
11	Twig\Template->yieldBlock (line 52)
12	__TwigTemplate_42e76ffd7b669254781c56d447a8f1ca->doDisplay (line 387)
13	Twig\Template->yield (line 162)
14	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
15	Twig\Template->yield (line 58)
16	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
27	App\Controller\FrontController->homepage (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.09 ms
(3.34%)

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5 FROM seopage_global s0_ WHERE s0_.route = ?

Parameters:

[
  "app_homepage"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.page_name AS page_name_1,
  s0_.route AS route_2,
  s0_.h1_enabled AS h1_enabled_3,
  s0_.translation_en_id AS translation_en_id_4,
  s0_.translation_fr_id AS translation_fr_id_5
FROM
  seopage_global s0_
WHERE
  s0_.route = ?

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5 FROM seopage_global s0_ WHERE s0_.route = 'app_homepage';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 48)
7	App\Repository\SEOPageGlobalRepository->findExistingRoute (line 36)
8	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.72 ms
(2.19%)

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t4.id AS id_5, t4.translation_en_id AS translation_en_id_6, t4.translation_fr_id AS translation_fr_id_7, t8.id AS id_9, t8.translation_en_id AS translation_en_id_10, t8.translation_fr_id AS translation_fr_id_11 FROM homepage t0 LEFT JOIN homepage_global t4 ON t4.translation_en_id = t0.id LEFT JOIN homepage_global t8 ON t8.translation_fr_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t4.id AS id_5,
  t4.translation_en_id AS translation_en_id_6,
  t4.translation_fr_id AS translation_fr_id_7,
  t8.id AS id_9,
  t8.translation_en_id AS translation_en_id_10,
  t8.translation_fr_id AS translation_fr_id_11
FROM
  homepage t0
  LEFT JOIN homepage_global t4 ON t4.translation_en_id = t0.id
  LEFT JOIN homepage_global t8 ON t8.translation_fr_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t4.id AS id_5, t4.translation_en_id AS translation_en_id_6, t4.translation_fr_id AS translation_fr_id_7, t8.id AS id_9, t8.translation_en_id AS translation_en_id_10, t8.translation_fr_id AS translation_fr_id_11 FROM homepage t0 LEFT JOIN homepage_global t4 ON t4.translation_en_id = t0.id LEFT JOIN homepage_global t8 ON t8.translation_fr_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Homepage::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Homepage->__get (line 55)
8	App\Entity\Homepage->getParagraphs (line 98)
9	App\Entity\HomepageGlobal->__call (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 132)
11	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->block_body (line 431)
12	Twig\Template->yieldBlock (line 167)
13	__TwigTemplate_55663d7ec472d4a6a9f2de98803742e7->doDisplay (line 387)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_8b89ae82455e82331d9adbf609d4097a->doDisplay (line 387)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_af7c7211c883c30c66ab53d1138e25dd->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
26	App\Controller\FrontController->homepage (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.71 ms
(2.18%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.66 ms
(2.04%)

SELECT a0_.picture_name AS picture_name_0, a0_.picture_size AS picture_size_1, a0_.picture_updated_at AS picture_updated_at_2, a0_.picture_alt AS picture_alt_3, a0_.meta_title AS meta_title_4, a0_.meta_description AS meta_description_5, a0_.is_published AS is_published_6, a0_.id AS id_7, a0_.translation_en_id AS translation_en_id_8, a0_.translation_fr_id AS translation_fr_id_9 FROM article_global a0_ WHERE a0_.is_published = ? LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.picture_name AS picture_name_0,
  a0_.picture_size AS picture_size_1,
  a0_.picture_updated_at AS picture_updated_at_2,
  a0_.picture_alt AS picture_alt_3,
  a0_.meta_title AS meta_title_4,
  a0_.meta_description AS meta_description_5,
  a0_.is_published AS is_published_6,
  a0_.id AS id_7,
  a0_.translation_en_id AS translation_en_id_8,
  a0_.translation_fr_id AS translation_fr_id_9
FROM
  article_global a0_
WHERE
  a0_.is_published = ?
LIMIT
  3

SELECT a0_.picture_name AS picture_name_0, a0_.picture_size AS picture_size_1, a0_.picture_updated_at AS picture_updated_at_2, a0_.picture_alt AS picture_alt_3, a0_.meta_title AS meta_title_4, a0_.meta_description AS meta_description_5, a0_.is_published AS is_published_6, a0_.id AS id_7, a0_.translation_en_id AS translation_en_id_8, a0_.translation_fr_id AS translation_fr_id_9 FROM article_global a0_ WHERE a0_.is_published = 1 LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\Blog\ArticleGlobalRepository->findPublishedRecent (line 54)
8	App\Controller\FrontController->homepage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.65 ms
(2.00%)

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.display_hp = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.product_name AS product_name_0,
  p0_.product_size AS product_size_1,
  p0_.product_updated_at AS product_updated_at_2,
  p0_.product_alt AS product_alt_3,
  p0_.cover_name AS cover_name_4,
  p0_.cover_size AS cover_size_5,
  p0_.cover_updated_at AS cover_updated_at_6,
  p0_.cover_alt AS cover_alt_7,
  p0_.logo_name AS logo_name_8,
  p0_.logo_size AS logo_size_9,
  p0_.logo_updated_at AS logo_updated_at_10,
  p0_.logo_alt AS logo_alt_11,
  p0_.display_hp AS display_hp_12,
  p0_.id AS id_13,
  p0_.position AS position_14,
  p0_.is_published AS is_published_15,
  p0_.category_id AS category_id_16,
  p0_.translation_en_id AS translation_en_id_17,
  p0_.translation_fr_id AS translation_fr_id_18
FROM
  product_global p0_
WHERE
  p0_.display_hp = ?

SELECT p0_.product_name AS product_name_0, p0_.product_size AS product_size_1, p0_.product_updated_at AS product_updated_at_2, p0_.product_alt AS product_alt_3, p0_.cover_name AS cover_name_4, p0_.cover_size AS cover_size_5, p0_.cover_updated_at AS cover_updated_at_6, p0_.cover_alt AS cover_alt_7, p0_.logo_name AS logo_name_8, p0_.logo_size AS logo_size_9, p0_.logo_updated_at AS logo_updated_at_10, p0_.logo_alt AS logo_alt_11, p0_.display_hp AS display_hp_12, p0_.id AS id_13, p0_.position AS position_14, p0_.is_published AS is_published_15, p0_.category_id AS category_id_16, p0_.translation_en_id AS translation_en_id_17, p0_.translation_fr_id AS translation_fr_id_18 FROM product_global p0_ WHERE p0_.display_hp = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 60)
7	App\Repository\Product\ProductGlobalRepository->getDisplayHp (line 55)
8	App\Controller\FrontController->homepage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.52 ms
(1.58%)

SELECT h0_.id AS id_0, h0_.translation_en_id AS translation_en_id_1, h0_.translation_fr_id AS translation_fr_id_2 FROM homepage_global h0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.translation_en_id AS translation_en_id_1,
  h0_.translation_fr_id AS translation_fr_id_2
FROM
  homepage_global h0_
LIMIT
  1

SELECT h0_.id AS id_0, h0_.translation_en_id AS translation_en_id_1, h0_.translation_fr_id AS translation_fr_id_2 FROM homepage_global h0_ LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 24)
7	App\Repository\HomepageGlobalRepository->findUnique (line 53)
8	App\Controller\FrontController->homepage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Product\Product	7
App\Entity\Technology\TechnologyGlobal	6
App\Entity\Technology\Technology	6
App\Entity\Blog\Article	5
App\Entity\Product\ProductGlobal	5
App\Entity\Service\Service	5
App\Entity\Product\ProductCategory	4
App\Entity\Blog\ArticleGlobal	3
App\Entity\Service\ServiceGlobal	3
App\Entity\Homepage	2
App\Entity\Product\ProductCategoryGlobal	2
App\Entity\SiteSettings	1
App\Entity\HomepageGlobal	1
App\Entity\Paragraph	1

Entities Mapping

Class	Mapping errors
App\Entity\SEOPageGlobal	No errors.
App\Entity\SEOPage	The field App\Entity\SEOPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\SEOPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\HomepageGlobal	No errors.
App\Entity\Homepage	The field App\Entity\Homepage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HomepageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Homepage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HomepageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Blog\ArticleGlobal	No errors.
App\Entity\Blog\Article	The field App\Entity\Blog\Article#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Blog\Article#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog\ArticleGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Product\ProductGlobal	No errors.
App\Entity\Product\ProductCategoryGlobal	No errors.
App\Entity\Product\Product	The field App\Entity\Product\Product#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\Product#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Technology\TechnologyGlobal	No errors.
App\Entity\Product\ProductCategory	The field App\Entity\Product\ProductCategory#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\ProductCategory#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductCategoryGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Product\ProductAttribute	No errors.
App\Entity\Paragraph	No errors.
App\Entity\Advantage	No errors.
App\Entity\TestimonialGlobal	No errors.
App\Entity\Product\ProductMedia	No errors.
App\Entity\Product\ProductDataTable	No errors.
App\Entity\DocumentGlobal	No errors.
App\Entity\Technology\Technology	The field App\Entity\Technology\Technology#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Technology\TechnologyGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Technology\Technology#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Technology\TechnologyGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Service\ServiceGlobal	No errors.
App\Entity\Service\Service	The field App\Entity\Service\Service#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Service\ServiceGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Service\Service#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Service\ServiceGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Service\ServiceAccordion	No errors.
App\Entity\AboutUs\AboutUsPage	The field App\Entity\AboutUs\AboutUsPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\AboutUs\AboutUsPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AboutUs\AboutUsPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Career\CareerPage	The field App\Entity\Career\CareerPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Career\CareerPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Career\CareerPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Career\CareerPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\LandingPage\LandingPage	The field App\Entity\LandingPage\LandingPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LandingPage\LandingPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\LandingPage\LandingPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LandingPage\LandingPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Product\ProductPage	The field App\Entity\Product\ProductPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\ProductPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
App\Entity\Technology\TechnologyPage	The field App\Entity\Technology\TechnologyPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Technology\TechnologyPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Technology\TechnologyPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Technology\TechnologyPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.

Symfony Profiler

GET https://evrard.asb-digital.fr/en/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping