Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

179.59 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

129.31 ms
(72.01%)

SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.name AS name_40, p2_.free AS free_41, p2_.single AS single_42, p2_.monthly AS monthly_43, p2_.deleted_at AS deleted_at_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, p2_.id AS id_47, i3_.name AS name_48, i3_.original_name AS original_name_49, i3_.size AS size_50, i3_.alt AS alt_51, i3_.source AS source_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, i3_.id AS id_55, p4_.title AS title_56, p4_.content AS content_57, p4_.id AS id_58, c5_.position AS position_59, c5_.id AS id_60, p1_.basis_id AS basis_id_61, p1_.image_id AS image_id_62, p1_.page_id AS page_id_63, p4_.plan_id AS plan_id_64, c5_.company_id AS company_id_65, c5_.slide_id AS slide_id_66 FROM company c0_ LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id LEFT JOIN image i3_ ON p1_.image_id = i3_.id LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id ORDER BY c0_.id ASC, p1_.lipiwell_id ASC, c5_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.host AS host_1,
  c0_.class AS class_2,
  c0_.main AS main_3,
  c0_.order_code AS order_code_4,
  c0_.messages AS messages_5,
  c0_.sections AS sections_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.id AS id_10,
  p1_.name AS name_11,
  p1_.full_name AS full_name_12,
  p1_.content AS content_13,
  p1_.description AS description_14,
  p1_.initial_price AS initial_price_15,
  p1_.recurring_price AS recurring_price_16,
  p1_.color AS color_17,
  p1_.initial AS initial_18,
  p1_.nutriwell AS nutriwell_19,
  p1_.chronotype AS chronotype_20,
  p1_.recipes AS recipes_21,
  p1_.tips AS tips_22,
  p1_.nutritional_program AS nutritional_program_23,
  p1_.supplementation_program AS supplementation_program_24,
  p1_.nutritionist AS nutritionist_25,
  p1_.inbody AS inbody_26,
  p1_.ages AS ages_27,
  p1_.lipidomic AS lipidomic_28,
  p1_.vital_status AS vital_status_29,
  p1_.contact AS contact_30,
  p1_.duration AS duration_31,
  p1_.needs_blood_extraction AS needs_blood_extraction_32,
  p1_.has_appointments AS has_appointments_33,
  p1_.lipiwell_id AS lipiwell_id_34,
  p1_.position AS position_35,
  p1_.created_at AS created_at_36,
  p1_.updated_at AS updated_at_37,
  p1_.active AS active_38,
  p1_.id AS id_39,
  p2_.name AS name_40,
  p2_.free AS free_41,
  p2_.single AS single_42,
  p2_.monthly AS monthly_43,
  p2_.deleted_at AS deleted_at_44,
  p2_.created_at AS created_at_45,
  p2_.updated_at AS updated_at_46,
  p2_.id AS id_47,
  i3_.name AS name_48,
  i3_.original_name AS original_name_49,
  i3_.size AS size_50,
  i3_.alt AS alt_51,
  i3_.source AS source_52,
  i3_.created_at AS created_at_53,
  i3_.updated_at AS updated_at_54,
  i3_.id AS id_55,
  p4_.title AS title_56,
  p4_.content AS content_57,
  p4_.id AS id_58,
  c5_.position AS position_59,
  c5_.id AS id_60,
  p1_.basis_id AS basis_id_61,
  p1_.image_id AS image_id_62,
  p1_.page_id AS page_id_63,
  p4_.plan_id AS plan_id_64,
  c5_.company_id AS company_id_65,
  c5_.slide_id AS slide_id_66
FROM
  company c0_
  LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id
  LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id
  LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id
  LEFT JOIN image i3_ ON p1_.image_id = i3_.id
  LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id
  LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id
ORDER BY
  c0_.id ASC,
  p1_.lipiwell_id ASC,
  c5_.position ASC

SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.name AS name_40, p2_.free AS free_41, p2_.single AS single_42, p2_.monthly AS monthly_43, p2_.deleted_at AS deleted_at_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, p2_.id AS id_47, i3_.name AS name_48, i3_.original_name AS original_name_49, i3_.size AS size_50, i3_.alt AS alt_51, i3_.source AS source_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, i3_.id AS id_55, p4_.title AS title_56, p4_.content AS content_57, p4_.id AS id_58, c5_.position AS position_59, c5_.id AS id_60, p1_.basis_id AS basis_id_61, p1_.image_id AS image_id_62, p1_.page_id AS page_id_63, p4_.plan_id AS plan_id_64, c5_.company_id AS company_id_65, c5_.slide_id AS slide_id_66 FROM company c0_ LEFT JOIN company_plan c6_ ON c0_.id = c6_.company_id LEFT JOIN plan p1_ ON p1_.id = c6_.plan_id LEFT JOIN plan_basis p2_ ON p1_.basis_id = p2_.id LEFT JOIN image i3_ ON p1_.image_id = i3_.id LEFT JOIN plan_feature p4_ ON p1_.id = p4_.plan_id LEFT JOIN company_slide c5_ ON c0_.id = c5_.company_id ORDER BY c0_.id ASC, p1_.lipiwell_id ASC, c5_.position ASC;

#	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 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 80)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
14	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 95)
15	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
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)

20.37 ms
(11.34%)

SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.image_id AS image_id_6, t0.link_id AS link_id_7, t0.video_id AS video_id_8 FROM slide t0 WHERE t0.id = ?

Parameters:

[
  "0193c01e-3854-728d-b9b6-81d6e8b9df94"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.subtitle AS subtitle_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.image_id AS image_id_6,
  t0.link_id AS link_id_7,
  t0.video_id AS video_id_8
FROM
  slide t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.image_id AS image_id_6, t0.link_id AS link_id_7, t0.video_id AS video_id_8 FROM slide t0 WHERE t0.id = '0193c01e-3854-728d-b9b6-81d6e8b9df94';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Media\Slide::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Media\Slide->__get (line 46)
8	App\Entity\Abstracts\AbstractSlide->getTitle (line 412)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 99)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 151)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 223)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
17	Symfony\Component\Serializer\Serializer->normalize (line 177)
18	Symfony\Component\Serializer\Serializer->normalize (line 776)
19	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
20	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 174)
21	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
23	Symfony\Component\Serializer\Serializer->normalize (line 138)
24	Symfony\Component\Serializer\Serializer->serialize (line 47)
25	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
26	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
27	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

16.59 ms
(9.24%)

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.alt AS alt_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8 FROM image t0 WHERE t0.id = ?

Parameters:

[
  "0193c01e-3855-73e3-8730-1df9b61cba15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.size AS size_3,
  t0.alt AS alt_4,
  t0.source AS source_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.id AS id_8
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.alt AS alt_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8 FROM image t0 WHERE t0.id = '0193c01e-3855-73e3-8730-1df9b61cba15';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Media\Image::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Media\Image->__get (line 50)
8	App\Entity\Abstracts\AbstractImage->getName (line 412)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 99)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 151)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 223)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
17	Symfony\Component\Serializer\Serializer->normalize (line 223)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
20	Symfony\Component\Serializer\Serializer->normalize (line 177)
21	Symfony\Component\Serializer\Serializer->normalize (line 776)
22	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
23	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 174)
24	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
25	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
26	Symfony\Component\Serializer\Serializer->normalize (line 138)
27	Symfony\Component\Serializer\Serializer->serialize (line 47)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
29	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
30	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

13.31 ms
(7.41%)

SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.host AS host_1,
  c0_.class AS class_2,
  c0_.main AS main_3,
  c0_.order_code AS order_code_4,
  c0_.messages AS messages_5,
  c0_.sections AS sections_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.id AS id_10,
  p1_.name AS name_11,
  p1_.full_name AS full_name_12,
  p1_.content AS content_13,
  p1_.description AS description_14,
  p1_.initial_price AS initial_price_15,
  p1_.recurring_price AS recurring_price_16,
  p1_.color AS color_17,
  p1_.initial AS initial_18,
  p1_.nutriwell AS nutriwell_19,
  p1_.chronotype AS chronotype_20,
  p1_.recipes AS recipes_21,
  p1_.tips AS tips_22,
  p1_.nutritional_program AS nutritional_program_23,
  p1_.supplementation_program AS supplementation_program_24,
  p1_.nutritionist AS nutritionist_25,
  p1_.inbody AS inbody_26,
  p1_.ages AS ages_27,
  p1_.lipidomic AS lipidomic_28,
  p1_.vital_status AS vital_status_29,
  p1_.contact AS contact_30,
  p1_.duration AS duration_31,
  p1_.needs_blood_extraction AS needs_blood_extraction_32,
  p1_.has_appointments AS has_appointments_33,
  p1_.lipiwell_id AS lipiwell_id_34,
  p1_.position AS position_35,
  p1_.created_at AS created_at_36,
  p1_.updated_at AS updated_at_37,
  p1_.active AS active_38,
  p1_.id AS id_39,
  p2_.title AS title_40,
  p2_.menu_title AS menu_title_41,
  p2_.content AS content_42,
  p2_.feature AS feature_43,
  p2_.published_at AS published_at_44,
  p2_.deleted_at AS deleted_at_45,
  p2_.position AS position_46,
  p2_.created_at AS created_at_47,
  p2_.updated_at AS updated_at_48,
  p2_.active AS active_49,
  p2_.id AS id_50,
  s3_.slug AS slug_51,
  s3_.class_name AS class_name_52,
  s3_.content_updated_at AS content_updated_at_53,
  s3_.created_at AS created_at_54,
  s3_.updated_at AS updated_at_55,
  s3_.id AS id_56,
  p1_.basis_id AS basis_id_57,
  p1_.image_id AS image_id_58,
  p1_.page_id AS page_id_59,
  p2_.basis_id AS basis_id_60,
  p2_.banner_id AS banner_id_61,
  p2_.company_id AS company_id_62,
  p2_.plan_id AS plan_id_63,
  p2_.meta_id AS meta_id_64,
  p2_.slug_id AS slug_id_65
FROM
  company c0_
  LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id
  LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id
  LEFT JOIN page p2_ ON p1_.page_id = p2_.id
  AND (p2_.deleted_at IS NULL)
  LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id
ORDER BY
  p1_.lipiwell_id ASC

SELECT c0_.name AS name_0, c0_.host AS host_1, c0_.class AS class_2, c0_.main AS main_3, c0_.order_code AS order_code_4, c0_.messages AS messages_5, c0_.sections AS sections_6, c0_.deleted_at AS deleted_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.id AS id_10, p1_.name AS name_11, p1_.full_name AS full_name_12, p1_.content AS content_13, p1_.description AS description_14, p1_.initial_price AS initial_price_15, p1_.recurring_price AS recurring_price_16, p1_.color AS color_17, p1_.initial AS initial_18, p1_.nutriwell AS nutriwell_19, p1_.chronotype AS chronotype_20, p1_.recipes AS recipes_21, p1_.tips AS tips_22, p1_.nutritional_program AS nutritional_program_23, p1_.supplementation_program AS supplementation_program_24, p1_.nutritionist AS nutritionist_25, p1_.inbody AS inbody_26, p1_.ages AS ages_27, p1_.lipidomic AS lipidomic_28, p1_.vital_status AS vital_status_29, p1_.contact AS contact_30, p1_.duration AS duration_31, p1_.needs_blood_extraction AS needs_blood_extraction_32, p1_.has_appointments AS has_appointments_33, p1_.lipiwell_id AS lipiwell_id_34, p1_.position AS position_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.active AS active_38, p1_.id AS id_39, p2_.title AS title_40, p2_.menu_title AS menu_title_41, p2_.content AS content_42, p2_.feature AS feature_43, p2_.published_at AS published_at_44, p2_.deleted_at AS deleted_at_45, p2_.position AS position_46, p2_.created_at AS created_at_47, p2_.updated_at AS updated_at_48, p2_.active AS active_49, p2_.id AS id_50, s3_.slug AS slug_51, s3_.class_name AS class_name_52, s3_.content_updated_at AS content_updated_at_53, s3_.created_at AS created_at_54, s3_.updated_at AS updated_at_55, s3_.id AS id_56, p1_.basis_id AS basis_id_57, p1_.image_id AS image_id_58, p1_.page_id AS page_id_59, p2_.basis_id AS basis_id_60, p2_.banner_id AS banner_id_61, p2_.company_id AS company_id_62, p2_.plan_id AS plan_id_63, p2_.meta_id AS meta_id_64, p2_.slug_id AS slug_id_65 FROM company c0_ LEFT JOIN company_plan c4_ ON c0_.id = c4_.company_id LEFT JOIN plan p1_ ON p1_.id = c4_.plan_id LEFT JOIN page p2_ ON p1_.page_id = p2_.id AND (p2_.deleted_at IS NULL) LEFT JOIN slug s3_ ON p2_.slug_id = s3_.id ORDER BY p1_.lipiwell_id ASC;

#	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 33)
7	App\Repository\User\CompanyRepository->findOneBy (line 364)
8	Doctrine\ORM\EntityRepository->resolveMagicCall (line 275)
9	Doctrine\ORM\EntityRepository->__call (line 87)
10	App\Services\Entity\User\CompanyAdministrableEntity->getCurrent (line 18)
11	App\Controller\API\User\CompanyController->__invoke (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\User\Company	No errors.
App\Entity\Plan\Plan	The mappings App\Entity\Plan\Plan#suscriptions and App\Entity\Plan\Suscription#plan are inconsistent with each other.
App\Entity\Plan\PlanFeature	No errors.
App\Entity\Plan\PlanBasis	No errors.
App\Entity\Abstracts\AbstractImage	No errors.
App\Entity\Media\Image	No errors.
App\Entity\User\CompanySlide	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Abstracts\AbstractSlide	No errors.
App\Entity\Media\Slide	No errors.
App\Entity\User\UserProfile	The mappings App\Entity\User\UserProfile#suscriptions and App\Entity\Plan\Suscription#profile are inconsistent with each other.
App\Entity\Form\Form	No errors.
App\Entity\LipiwellContent\LipiwellContent	No errors.
App\Entity\Plan\Suscription	The association App\Entity\Plan\Suscription#profile refers to the inverse side field App\Entity\User\UserProfile#plans which does not exist. The association App\Entity\Plan\Suscription#plan refers to the inverse side field App\Entity\Plan\Plan#profiles which does not exist. The association App\Entity\Plan\Suscription#cart refers to the inverse side field App\Entity\Cart\Cart#plans which does not exist.
App\Entity\Block\BlockImage	No errors.
App\Entity\Page\PageImage	No errors.
App\Entity\SEO\Slug	No errors.
App\Entity\Page\PageBasis	No errors.
App\Entity\SEO\Meta	No errors.
App\Entity\Block\Block	No errors.
App\Entity\Page\PageDownload	No errors.
App\Entity\Page\PageSlide	No errors.
App\Entity\Abstracts\AbstractLink	No errors.
App\Entity\Media\Link	No errors.
App\Entity\Abstracts\AbstractVideo	No errors.
App\Entity\Media\Video	No errors.

Symfony Profiler

GET https://lipiwell.do26.veiss.com/api/company/current

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping