Symfony Profiler

Query Metrics

103 Database Queries

18 Different statements

1827.01 ms Query time

0 Invalid entities

56 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

728.32 ms
(39.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1

Parameters:

[
  "slider_title_1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content_text AS content_text_4,
  t0.screenshot AS screenshot_5
FROM
  content t0
WHERE
  t0.description = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = 'slider_title_1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 46)
7	App\Twig\Render->renderContent (line 65)
8	__TwigTemplate_39d30951ee902162d411b906f6dfb440->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 1520)
13	Twig\Extension\CoreExtension::include (line 103)
14	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
15	Twig\Template->yieldBlock (line 252)
16	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
27	App\Controller\IndexController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

317.34 ms
(17.37%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "slider_image_1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.src AS src_4
FROM
  image t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0 WHERE t0.slug = 'slider_image_1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 167)
5	App\Twig\Render->renderImage (line 57)
6	__TwigTemplate_39d30951ee902162d411b906f6dfb440->doDisplay (line 402)
7	Twig\Template->yield (line 358)
8	Twig\Template->display (line 373)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 1520)
11	Twig\Extension\CoreExtension::include (line 103)
12	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
13	Twig\Template->yieldBlock (line 252)
14	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
25	App\Controller\IndexController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

268.97 ms
(14.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.title AS title_4, t0.content AS content_5, t0.video_url AS video_url_6 FROM testimonials t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.video_url AS video_url_6
FROM
  testimonials t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.title AS title_4, t0.content AS content_5, t0.video_url AS video_url_6 FROM testimonials t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 62)
6	App\Controller\IndexController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

129.85 ms
(7.11%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.content AS content_2,
  b0_.publication_date AS publication_date_3,
  b0_.is_published AS is_published_4,
  b0_.slug AS slug_5,
  b0_.featured_image AS featured_image_6,
  b0_.meta_title AS meta_title_7,
  b0_.meta_description AS meta_description_8,
  b0_.video_url AS video_url_9,
  b0_.author_id AS author_id_10
FROM
  blog b0_
WHERE
  b0_.is_published = ?
ORDER BY
  b0_.id DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = 1 ORDER BY b0_.id DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 38)
7	App\Repository\BlogRepository->findPublished (line 63)
8	App\Controller\IndexController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

84.20 ms
(4.61%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.light_logo_path AS light_logo_path_6, t0.keywords AS keywords_7 FROM seo t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.logo_path AS logo_path_5,
  t0.light_logo_path AS light_logo_path_6,
  t0.keywords AS keywords_7
FROM
  seo t0

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.light_logo_path AS light_logo_path_6, t0.keywords AS keywords_7 FROM seo t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 39)
6	App\Twig\GlobalVars->getGlobalVars (line 58)
7	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
8	Twig\Template->yield (line 53)
9	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
18	App\Controller\IndexController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

48.45 ms
(2.65%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.src AS src_4
FROM
  image t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 56)
6	App\Controller\IndexController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

43.02 ms
(2.35%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.template_path AS template_path_3,
  t0.priority AS priority_4
FROM
  section t0
  INNER JOIN page_section ON t0.id = page_section.section_id
WHERE
  page_section.page_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	iterator_to_array (line 1044)
9	Twig\Extension\CoreExtension::sort (line 79)
10	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
11	Twig\Template->yieldBlock (line 252)
12	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
23	App\Controller\IndexController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

36.31 ms
(1.99%)

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.header AS header_9, p0_.type AS type_10, p0_.keywords AS keywords_11 FROM page p0_ WHERE p0_.is_service = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.heading AS heading_1,
  p0_.meta_title AS meta_title_2,
  p0_.meta_description AS meta_description_3,
  p0_.url AS url_4,
  p0_.featured_image AS featured_image_5,
  p0_.page_content AS page_content_6,
  p0_.content_first AS content_first_7,
  p0_.is_service AS is_service_8,
  p0_.header AS header_9,
  p0_.type AS type_10,
  p0_.keywords AS keywords_11
FROM
  page p0_
WHERE
  p0_.is_service = ?

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.header AS header_9, p0_.type AS type_10, p0_.keywords AS keywords_11 FROM page p0_ WHERE p0_.is_service = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\PageRepository->findByIsService (line 43)
8	App\Twig\GlobalVars->getGlobalVars (line 58)
9	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\IndexController->index (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

32.88 ms
(1.80%)

SELECT t0.id AS id_1, t0.booking_date AS booking_date_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.status AS status_5, t0.total_amount AS total_amount_6, t0.booking_amount_paid AS booking_amount_paid_7, t0.custom_service_fee AS custom_service_fee_8, t0.custom_booking_amount AS custom_booking_amount_9, t0.custom_payment_terms AS custom_payment_terms_10, t0.custom_cancellation_policy AS custom_cancellation_policy_11, t0.notes AS notes_12, t0.agreement_signed AS agreement_signed_13, t0.agreement_signed_at AS agreement_signed_at_14, t0.agreement_token AS agreement_token_15, t0.signature_data AS signature_data_16, t0.signature_type AS signature_type_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.service_id AS service_id_20, t0.contact_id AS contact_id_21, t0.event_id AS event_id_22, t23.id AS id_24, t23.name AS name_25, t23.contact_number AS contact_number_26, t23.email AS email_27, t23.how_heard AS how_heard_28, t23.diagnosis AS diagnosis_29, t23.age AS age_30, t23.gender AS gender_31, t23.height AS height_32, t23.weight AS weight_33, t23.dod AS dod_34, t23.medications AS medications_35, t23.treatments AS treatments_36, t23.symptoms AS symptoms_37, t23.has_tumors AS has_tumors_38, t23.tumor_size AS tumor_size_39, t23.multiple_tumors AS multiple_tumors_40, t23.tumor_location AS tumor_location_41, t23.tumor_pain AS tumor_pain_42, t23.tumor_ooze_weep_bleed AS tumor_ooze_weep_bleed_43, t23.tumor_near_nipple AS tumor_near_nipple_44, t23.tumor_foul_odor AS tumor_foul_odor_45, t23.body_pain AS body_pain_46, t23.sugar_levels AS sugar_levels_47, t23.blood_pressure AS blood_pressure_48, t23.bags_attachments AS bags_attachments_49, t23.other_symptoms AS other_symptoms_50, t23.mobility_stairs AS mobility_stairs_51, t23.feeding_keep_down AS feeding_keep_down_52, t23.bowel_movements AS bowel_movements_53, t23.allergies AS allergies_54, t23.special_diet AS special_diet_55, t23.has_pets AS has_pets_56, t23.pet_types AS pet_types_57, t23.pet_details AS pet_details_58, t23.pets_sick AS pets_sick_59, t23.pet_health_issues AS pet_health_issues_60, t23.created_at AS created_at_61, t23.updated_at AS updated_at_62, t23.contact_id AS contact_id_63, t23.booking_id AS booking_id_64 FROM booking t0 LEFT JOIN profile t23 ON t23.booking_id = t0.id WHERE t0.service_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.booking_date AS booking_date_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.status AS status_5,
  t0.total_amount AS total_amount_6,
  t0.booking_amount_paid AS booking_amount_paid_7,
  t0.custom_service_fee AS custom_service_fee_8,
  t0.custom_booking_amount AS custom_booking_amount_9,
  t0.custom_payment_terms AS custom_payment_terms_10,
  t0.custom_cancellation_policy AS custom_cancellation_policy_11,
  t0.notes AS notes_12,
  t0.agreement_signed AS agreement_signed_13,
  t0.agreement_signed_at AS agreement_signed_at_14,
  t0.agreement_token AS agreement_token_15,
  t0.signature_data AS signature_data_16,
  t0.signature_type AS signature_type_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.service_id AS service_id_20,
  t0.contact_id AS contact_id_21,
  t0.event_id AS event_id_22,
  t23.id AS id_24,
  t23.name AS name_25,
  t23.contact_number AS contact_number_26,
  t23.email AS email_27,
  t23.how_heard AS how_heard_28,
  t23.diagnosis AS diagnosis_29,
  t23.age AS age_30,
  t23.gender AS gender_31,
  t23.height AS height_32,
  t23.weight AS weight_33,
  t23.dod AS dod_34,
  t23.medications AS medications_35,
  t23.treatments AS treatments_36,
  t23.symptoms AS symptoms_37,
  t23.has_tumors AS has_tumors_38,
  t23.tumor_size AS tumor_size_39,
  t23.multiple_tumors AS multiple_tumors_40,
  t23.tumor_location AS tumor_location_41,
  t23.tumor_pain AS tumor_pain_42,
  t23.tumor_ooze_weep_bleed AS tumor_ooze_weep_bleed_43,
  t23.tumor_near_nipple AS tumor_near_nipple_44,
  t23.tumor_foul_odor AS tumor_foul_odor_45,
  t23.body_pain AS body_pain_46,
  t23.sugar_levels AS sugar_levels_47,
  t23.blood_pressure AS blood_pressure_48,
  t23.bags_attachments AS bags_attachments_49,
  t23.other_symptoms AS other_symptoms_50,
  t23.mobility_stairs AS mobility_stairs_51,
  t23.feeding_keep_down AS feeding_keep_down_52,
  t23.bowel_movements AS bowel_movements_53,
  t23.allergies AS allergies_54,
  t23.special_diet AS special_diet_55,
  t23.has_pets AS has_pets_56,
  t23.pet_types AS pet_types_57,
  t23.pet_details AS pet_details_58,
  t23.pets_sick AS pets_sick_59,
  t23.pet_health_issues AS pet_health_issues_60,
  t23.created_at AS created_at_61,
  t23.updated_at AS updated_at_62,
  t23.contact_id AS contact_id_63,
  t23.booking_id AS booking_id_64
FROM
  booking t0
  LEFT JOIN profile t23 ON t23.booking_id = t0.id
WHERE
  t0.service_id = ?

SELECT t0.id AS id_1, t0.booking_date AS booking_date_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.status AS status_5, t0.total_amount AS total_amount_6, t0.booking_amount_paid AS booking_amount_paid_7, t0.custom_service_fee AS custom_service_fee_8, t0.custom_booking_amount AS custom_booking_amount_9, t0.custom_payment_terms AS custom_payment_terms_10, t0.custom_cancellation_policy AS custom_cancellation_policy_11, t0.notes AS notes_12, t0.agreement_signed AS agreement_signed_13, t0.agreement_signed_at AS agreement_signed_at_14, t0.agreement_token AS agreement_token_15, t0.signature_data AS signature_data_16, t0.signature_type AS signature_type_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.service_id AS service_id_20, t0.contact_id AS contact_id_21, t0.event_id AS event_id_22, t23.id AS id_24, t23.name AS name_25, t23.contact_number AS contact_number_26, t23.email AS email_27, t23.how_heard AS how_heard_28, t23.diagnosis AS diagnosis_29, t23.age AS age_30, t23.gender AS gender_31, t23.height AS height_32, t23.weight AS weight_33, t23.dod AS dod_34, t23.medications AS medications_35, t23.treatments AS treatments_36, t23.symptoms AS symptoms_37, t23.has_tumors AS has_tumors_38, t23.tumor_size AS tumor_size_39, t23.multiple_tumors AS multiple_tumors_40, t23.tumor_location AS tumor_location_41, t23.tumor_pain AS tumor_pain_42, t23.tumor_ooze_weep_bleed AS tumor_ooze_weep_bleed_43, t23.tumor_near_nipple AS tumor_near_nipple_44, t23.tumor_foul_odor AS tumor_foul_odor_45, t23.body_pain AS body_pain_46, t23.sugar_levels AS sugar_levels_47, t23.blood_pressure AS blood_pressure_48, t23.bags_attachments AS bags_attachments_49, t23.other_symptoms AS other_symptoms_50, t23.mobility_stairs AS mobility_stairs_51, t23.feeding_keep_down AS feeding_keep_down_52, t23.bowel_movements AS bowel_movements_53, t23.allergies AS allergies_54, t23.special_diet AS special_diet_55, t23.has_pets AS has_pets_56, t23.pet_types AS pet_types_57, t23.pet_details AS pet_details_58, t23.pets_sick AS pets_sick_59, t23.pet_health_issues AS pet_health_issues_60, t23.created_at AS created_at_61, t23.updated_at AS updated_at_62, t23.contact_id AS contact_id_63, t23.booking_id AS booking_id_64 FROM booking t0 LEFT JOIN profile t23 ON t23.booking_id = t0.id WHERE t0.service_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 460)
8	App\Entity\Service->getAvailableSpots (line 469)
9	App\Entity\Service->hasAvailableSpots (line 474)
10	App\Entity\Service->canBookService (line 1909)
11	Twig\Extension\CoreExtension::getAttribute (line 190)
12	__TwigTemplate_4a4bf740378016cdad333820c8f13955->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1520)
17	Twig\Extension\CoreExtension::include (line 103)
18	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
19	Twig\Template->yieldBlock (line 252)
20	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
21	Twig\Template->yield (line 53)
22	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 333)
27	Twig\Environment->render (line 459)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
31	App\Controller\IndexController->index (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

31.34 ms
(1.72%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3 FROM faq t0 ORDER BY t0.id ASC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3
FROM
  faq t0
ORDER BY
  t0.id ASC
LIMIT
  3

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3 FROM faq t0 ORDER BY t0.id ASC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 64)
5	App\Controller\IndexController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

29.84 ms
(1.63%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.service_type AS service_type_4, t0.duration AS duration_5, t0.full_fee AS full_fee_6, t0.booking_amount AS booking_amount_7, t0.starting_date_is_flexible AS starting_date_is_flexible_8, t0.duration_is_flexible AS duration_is_flexible_9, t0.conflicts_with_events AS conflicts_with_events_10, t0.can_book_service_only AS can_book_service_only_11, t0.missed_deadline_payment_forfeited AS missed_deadline_payment_forfeited_12, t0.slug AS slug_13, t0.is_active AS is_active_14, t0.requires_full_profile AS requires_full_profile_15, t0.image_url AS image_url_16, t0.max_participants AS max_participants_17, t0.icon_name AS icon_name_18, t0.terms_and_conditions AS terms_and_conditions_19, t0.testimonial_videos AS testimonial_videos_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM service t0 WHERE t0.is_active = ? ORDER BY t0.title ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.service_type AS service_type_4,
  t0.duration AS duration_5,
  t0.full_fee AS full_fee_6,
  t0.booking_amount AS booking_amount_7,
  t0.starting_date_is_flexible AS starting_date_is_flexible_8,
  t0.duration_is_flexible AS duration_is_flexible_9,
  t0.conflicts_with_events AS conflicts_with_events_10,
  t0.can_book_service_only AS can_book_service_only_11,
  t0.missed_deadline_payment_forfeited AS missed_deadline_payment_forfeited_12,
  t0.slug AS slug_13,
  t0.is_active AS is_active_14,
  t0.requires_full_profile AS requires_full_profile_15,
  t0.image_url AS image_url_16,
  t0.max_participants AS max_participants_17,
  t0.icon_name AS icon_name_18,
  t0.terms_and_conditions AS terms_and_conditions_19,
  t0.testimonial_videos AS testimonial_videos_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22
FROM
  service t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.service_type AS service_type_4, t0.duration AS duration_5, t0.full_fee AS full_fee_6, t0.booking_amount AS booking_amount_7, t0.starting_date_is_flexible AS starting_date_is_flexible_8, t0.duration_is_flexible AS duration_is_flexible_9, t0.conflicts_with_events AS conflicts_with_events_10, t0.can_book_service_only AS can_book_service_only_11, t0.missed_deadline_payment_forfeited AS missed_deadline_payment_forfeited_12, t0.slug AS slug_13, t0.is_active AS is_active_14, t0.requires_full_profile AS requires_full_profile_15, t0.image_url AS image_url_16, t0.max_participants AS max_participants_17, t0.icon_name AS icon_name_18, t0.terms_and_conditions AS terms_and_conditions_19, t0.testimonial_videos AS testimonial_videos_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM service t0 WHERE t0.is_active = 1 ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 60)
5	App\Controller\IndexController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

25.89 ms
(1.42%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.phone_number AS phone_number_3,
  t0.work_hours AS work_hours_4,
  t0.instagram_link AS instagram_link_5,
  t0.facebook_link AS facebook_link_6,
  t0.youtube_link AS youtube_link_7,
  t0.tiktok_link AS tiktok_link_8,
  t0.business_location AS business_location_9,
  t0.twitter_link AS twitter_link_10,
  t0.linkedin_link AS linkedin_link_11,
  t0.google_map_embed AS google_map_embed_12,
  t0.email_address AS email_address_13,
  t0.whatsapp_number AS whatsapp_number_14,
  t0.website_tagline AS website_tagline_15,
  t0.primary_color AS primary_color_16,
  t0.secondary_color AS secondary_color_17,
  t0.background_color AS background_color_18,
  t0.custom_css_overrides AS custom_css_overrides_19,
  t0.booking_available_days AS booking_available_days_20,
  t0.automatic_confirmation AS automatic_confirmation_21,
  t0.booking_cutoff_hours AS booking_cutoff_hours_22,
  t0.default_payment_terms AS default_payment_terms_23,
  t0.late_payment_grace_period_days AS late_payment_grace_period_days_24,
  t0.wire_transfer_account_details AS wire_transfer_account_details_25,
  t0.stripe_public_key AS stripe_public_key_26,
  t0.stripe_private_key AS stripe_private_key_27,
  t0.default_booking_amounts AS default_booking_amounts_28,
  t0.currency AS currency_29,
  t0.tax_rate AS tax_rate_30,
  t0.payment_reminder_schedule AS payment_reminder_schedule_31,
  t0.bank_account_name AS bank_account_name_32,
  t0.bank_name AS bank_name_33,
  t0.bank_routing_number AS bank_routing_number_34,
  t0.bank_wire_routing_number AS bank_wire_routing_number_35,
  t0.bank_international_wire_routing AS bank_international_wire_routing_36,
  t0.bank_swift_code AS bank_swift_code_37,
  t0.bank_account_number AS bank_account_number_38,
  t0.account_holder_address AS account_holder_address_39,
  t0.bank_address AS bank_address_40,
  t0.wire_transfer_instructions AS wire_transfer_instructions_41,
  t0.display_price_publicly AS display_price_publicly_42,
  t0.smtp_host AS smtp_host_43,
  t0.smtp_port AS smtp_port_44,
  t0.smtp_username AS smtp_username_45,
  t0.smtp_password AS smtp_password_46,
  t0.smtp_encryption AS smtp_encryption_47,
  t0.default_from_email AS default_from_email_48,
  t0.default_from_name AS default_from_name_49,
  t0.auto_send_welcome_letter AS auto_send_welcome_letter_50,
  t0.email_signature AS email_signature_51,
  t0.welcome_email_template AS welcome_email_template_52,
  t0.payment_reminder_email_template AS payment_reminder_email_template_53,
  t0.birthday_reminder_email_template AS birthday_reminder_email_template_54,
  t0.agreement_email_template AS agreement_email_template_55,
  t0.booking_confirmation_template AS booking_confirmation_template_56,
  t0.service_completion_template AS service_completion_template_57,
  t0.appointment_reminder_template AS appointment_reminder_template_58,
  t0.default_cancellation_policy AS default_cancellation_policy_59,
  t0.refund_policy_text AS refund_policy_text_60,
  t0.public_edit_mode AS public_edit_mode_61,
  t0.terms_and_conditions_text AS terms_and_conditions_text_62,
  t0.privacy_policy_text AS privacy_policy_text_63,
  t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64,
  t0.calendar_view_default AS calendar_view_default_65,
  t0.first_day_of_week AS first_day_of_week_66,
  t0.time_slot_intervals AS time_slot_intervals_67,
  t0.calendar_timezone AS calendar_timezone_68,
  t0.application_timezone AS application_timezone_69,
  t0.available_months_advance AS available_months_advance_70,
  t0.weekend_availability AS weekend_availability_71,
  t0.admin_notification_emails AS admin_notification_emails_72,
  t0.new_booking_notifications AS new_booking_notifications_73,
  t0.payment_received_notifications AS payment_received_notifications_74,
  t0.contact_form_notifications AS contact_form_notifications_75,
  t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76,
  t0.newsletter_from_address AS newsletter_from_address_77,
  t0.unsubscribe_page_text AS unsubscribe_page_text_78,
  t0.contact_form_auto_response AS contact_form_auto_response_79,
  t0.default_email_campaign_template AS default_email_campaign_template_80,
  t0.session_timeout_duration AS session_timeout_duration_81,
  t0.data_retention_period_days AS data_retention_period_days_82,
  t0.cookie_policy_text AS cookie_policy_text_83,
  t0.qualification_certificate_templates AS qualification_certificate_templates_84,
  t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85,
  t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86,
  t0.house_call_service_areas AS house_call_service_areas_87,
  t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88,
  t0.analytics_tracking_codes AS analytics_tracking_codes_89,
  t0.twilio_account_sid AS twilio_account_sid_90,
  t0.twilio_auth_token AS twilio_auth_token_91,
  t0.twilio_phone_number AS twilio_phone_number_92,
  t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93,
  t0.welcome_sequence_timing AS welcome_sequence_timing_94,
  t0.follow_up_email_schedules AS follow_up_email_schedules_95,
  t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96,
  t0.post_service_feedback_requests AS post_service_feedback_requests_97,
  t0.birthday_campaign_automation AS birthday_campaign_automation_98,
  t0.payment_reminder_sequences AS payment_reminder_sequences_99
FROM
  setting t0

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 40)
6	App\Twig\GlobalVars->getGlobalVars (line 58)
7	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
8	Twig\Template->yield (line 53)
9	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
18	App\Controller\IndexController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

21.91 ms
(1.20%)

SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.description AS description_3 FROM blog_category t0 INNER JOIN blog_category_blog ON t0.id = blog_category_blog.blog_category_id WHERE blog_category_blog.blog_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2,
  t0.description AS description_3
FROM
  blog_category t0
  INNER JOIN blog_category_blog ON t0.id = blog_category_blog.blog_category_id
WHERE
  blog_category_blog.blog_id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.description AS description_3 FROM blog_category t0 INNER JOIN blog_category_blog ON t0.id = blog_category_blog.blog_category_id WHERE blog_category_blog.blog_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 116)
9	__TwigTemplate_a06ab4f94694cd6f1c194cb57b04d273->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1520)
14	Twig\Extension\CoreExtension::include (line 103)
15	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
16	Twig\Template->yieldBlock (line 252)
17	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
28	App\Controller\IndexController->index (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

9.90 ms
(0.54%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9, t0.header AS header_10, t0.type AS type_11, t0.keywords AS keywords_12 FROM page t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "homepage"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.url AS url_5,
  t0.featured_image AS featured_image_6,
  t0.page_content AS page_content_7,
  t0.content_first AS content_first_8,
  t0.is_service AS is_service_9,
  t0.header AS header_10,
  t0.type AS type_11,
  t0.keywords AS keywords_12
FROM
  page t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9, t0.header AS header_10, t0.type AS type_11, t0.keywords AS keywords_12 FROM page t0 WHERE t0.url = 'homepage' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 59)
7	App\Controller\IndexController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

8.07 ms
(0.44%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.phone_number AS phone_number_3,
  t0.work_hours AS work_hours_4,
  t0.instagram_link AS instagram_link_5,
  t0.facebook_link AS facebook_link_6,
  t0.youtube_link AS youtube_link_7,
  t0.tiktok_link AS tiktok_link_8,
  t0.business_location AS business_location_9,
  t0.twitter_link AS twitter_link_10,
  t0.linkedin_link AS linkedin_link_11,
  t0.google_map_embed AS google_map_embed_12,
  t0.email_address AS email_address_13,
  t0.whatsapp_number AS whatsapp_number_14,
  t0.website_tagline AS website_tagline_15,
  t0.primary_color AS primary_color_16,
  t0.secondary_color AS secondary_color_17,
  t0.background_color AS background_color_18,
  t0.custom_css_overrides AS custom_css_overrides_19,
  t0.booking_available_days AS booking_available_days_20,
  t0.automatic_confirmation AS automatic_confirmation_21,
  t0.booking_cutoff_hours AS booking_cutoff_hours_22,
  t0.default_payment_terms AS default_payment_terms_23,
  t0.late_payment_grace_period_days AS late_payment_grace_period_days_24,
  t0.wire_transfer_account_details AS wire_transfer_account_details_25,
  t0.stripe_public_key AS stripe_public_key_26,
  t0.stripe_private_key AS stripe_private_key_27,
  t0.default_booking_amounts AS default_booking_amounts_28,
  t0.currency AS currency_29,
  t0.tax_rate AS tax_rate_30,
  t0.payment_reminder_schedule AS payment_reminder_schedule_31,
  t0.bank_account_name AS bank_account_name_32,
  t0.bank_name AS bank_name_33,
  t0.bank_routing_number AS bank_routing_number_34,
  t0.bank_wire_routing_number AS bank_wire_routing_number_35,
  t0.bank_international_wire_routing AS bank_international_wire_routing_36,
  t0.bank_swift_code AS bank_swift_code_37,
  t0.bank_account_number AS bank_account_number_38,
  t0.account_holder_address AS account_holder_address_39,
  t0.bank_address AS bank_address_40,
  t0.wire_transfer_instructions AS wire_transfer_instructions_41,
  t0.display_price_publicly AS display_price_publicly_42,
  t0.smtp_host AS smtp_host_43,
  t0.smtp_port AS smtp_port_44,
  t0.smtp_username AS smtp_username_45,
  t0.smtp_password AS smtp_password_46,
  t0.smtp_encryption AS smtp_encryption_47,
  t0.default_from_email AS default_from_email_48,
  t0.default_from_name AS default_from_name_49,
  t0.auto_send_welcome_letter AS auto_send_welcome_letter_50,
  t0.email_signature AS email_signature_51,
  t0.welcome_email_template AS welcome_email_template_52,
  t0.payment_reminder_email_template AS payment_reminder_email_template_53,
  t0.birthday_reminder_email_template AS birthday_reminder_email_template_54,
  t0.agreement_email_template AS agreement_email_template_55,
  t0.booking_confirmation_template AS booking_confirmation_template_56,
  t0.service_completion_template AS service_completion_template_57,
  t0.appointment_reminder_template AS appointment_reminder_template_58,
  t0.default_cancellation_policy AS default_cancellation_policy_59,
  t0.refund_policy_text AS refund_policy_text_60,
  t0.public_edit_mode AS public_edit_mode_61,
  t0.terms_and_conditions_text AS terms_and_conditions_text_62,
  t0.privacy_policy_text AS privacy_policy_text_63,
  t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64,
  t0.calendar_view_default AS calendar_view_default_65,
  t0.first_day_of_week AS first_day_of_week_66,
  t0.time_slot_intervals AS time_slot_intervals_67,
  t0.calendar_timezone AS calendar_timezone_68,
  t0.application_timezone AS application_timezone_69,
  t0.available_months_advance AS available_months_advance_70,
  t0.weekend_availability AS weekend_availability_71,
  t0.admin_notification_emails AS admin_notification_emails_72,
  t0.new_booking_notifications AS new_booking_notifications_73,
  t0.payment_received_notifications AS payment_received_notifications_74,
  t0.contact_form_notifications AS contact_form_notifications_75,
  t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76,
  t0.newsletter_from_address AS newsletter_from_address_77,
  t0.unsubscribe_page_text AS unsubscribe_page_text_78,
  t0.contact_form_auto_response AS contact_form_auto_response_79,
  t0.default_email_campaign_template AS default_email_campaign_template_80,
  t0.session_timeout_duration AS session_timeout_duration_81,
  t0.data_retention_period_days AS data_retention_period_days_82,
  t0.cookie_policy_text AS cookie_policy_text_83,
  t0.qualification_certificate_templates AS qualification_certificate_templates_84,
  t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85,
  t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86,
  t0.house_call_service_areas AS house_call_service_areas_87,
  t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88,
  t0.analytics_tracking_codes AS analytics_tracking_codes_89,
  t0.twilio_account_sid AS twilio_account_sid_90,
  t0.twilio_auth_token AS twilio_auth_token_91,
  t0.twilio_phone_number AS twilio_phone_number_92,
  t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93,
  t0.welcome_sequence_timing AS welcome_sequence_timing_94,
  t0.follow_up_email_schedules AS follow_up_email_schedules_95,
  t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96,
  t0.post_service_feedback_requests AS post_service_feedback_requests_97,
  t0.birthday_campaign_automation AS birthday_campaign_automation_98,
  t0.payment_reminder_sequences AS payment_reminder_sequences_99
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 242)
5	App\Twig\Render->renderDynamicCss (line 123)
6	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
7	Twig\Template->yield (line 53)
8	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 459)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
17	App\Controller\IndexController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

4.83 ms
(0.26%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content_text AS content_text_4,
  t0.screenshot AS screenshot_5
FROM
  content t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 55)
6	App\Controller\IndexController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

4.13 ms
(0.23%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.photo AS photo_4, t0.description AS description_5 FROM team_member t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.photo AS photo_4,
  t0.description AS description_5
FROM
  team_member t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.photo AS photo_4, t0.description AS description_5 FROM team_member t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 61)
6	App\Controller\IndexController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.76 ms
(0.10%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone_number AS phone_number_7, t0.profile_picture AS profile_picture_8, t0.usertype AS usertype_9, t0.is_active AS is_active_10, t0.about AS about_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone_number AS phone_number_7,
  t0.profile_picture AS profile_picture_8,
  t0.usertype AS usertype_9,
  t0.is_active AS is_active_10,
  t0.about AS about_11,
  t0.reset_token AS reset_token_12,
  t0.reset_token_expires_at AS reset_token_expires_at_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone_number AS phone_number_7, t0.profile_picture AS profile_picture_8, t0.usertype AS usertype_9, t0.is_active AS is_active_10, t0.about AS about_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\User->__get (line 95)
8	App\Entity\User->getFullname (line 73)
9	App\Entity\User->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 157)
11	__TwigTemplate_a06ab4f94694cd6f1c194cb57b04d273->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 103)
17	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->block_page (line 446)
18	Twig\Template->yieldBlock (line 252)
19	__TwigTemplate_475a43756e1b657a468373570f990802->doDisplay (line 402)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_a2b45c8c87e185162b799c793b13b74a->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 333)
26	Twig\Environment->render (line 459)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
30	App\Controller\IndexController->index (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\Section	9
App\Entity\Booking	7
App\Entity\Service	6
App\Entity\Contact	6
App\Entity\Image	5
App\Entity\Page	5
App\Entity\TeamMember	3
App\Entity\Testimonials	3
App\Entity\Blog	3
App\Entity\FAQ	3
App\Entity\Content	1
App\Entity\User	1
App\Entity\SEO	1
App\Entity\Setting	1
App\Entity\Profile	1
App\Entity\BlogCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\Content	No errors.
App\Entity\Image	No errors.
App\Entity\Page	No errors.
App\Entity\Section	No errors.
App\Entity\Service	No errors.
App\Entity\Event	No errors.
App\Entity\Booking	No errors.
App\Entity\Calendar	No errors.
App\Entity\AvailabilityRule	No errors.
App\Entity\BlockedDate	No errors.
App\Entity\CalendarEvent	No errors.
App\Entity\TeamMember	No errors.
App\Entity\Testimonials	No errors.
App\Entity\Blog	No errors.
App\Entity\User	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\FAQ	No errors.
App\Entity\SEO	No errors.
App\Entity\Setting	No errors.
App\Entity\Contact	No errors.
App\Entity\Profile	No errors.
App\Entity\Installment	No errors.

Symfony Profiler

GET https://saving-health.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping