Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

5.50 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.50 ms
(100.00%)

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 30)
11	App\EventListener\Frontend\CompanyListener->onKernelController (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

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\Page\Page	No errors.
App\Entity\SEO\Slug	No errors.
App\Entity\Plan\PlanBasis	No errors.
App\Entity\Abstracts\AbstractImage	No errors.
App\Entity\Media\Image	No errors.
App\Entity\Page\PageBasis	No errors.
App\Entity\SEO\Meta	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\User\CompanySlide	No errors.
App\Entity\LipiwellContent\LipiwellContent	No errors.
App\Entity\Plan\PlanFeature	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\Block	No errors.
App\Entity\Page\PageDownload	No errors.
App\Entity\Page\PageImage	No errors.
App\Entity\Page\PageSlide	No errors.

Symfony Profiler

GET https://lipiwell.do26.veiss.com/_profiler

Configuration Settings

Theme