Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.61 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.34 ms
(36.95%)

SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.domain AS domain_4, t0.c_name AS c_name_5, t0.status AS status_6, t0.logo AS logo_7, t0.favicon AS favicon_8, t0.banner AS banner_9, t0.touch AS touch_10, t0.header_links AS header_links_11, t0.header_links_backup1 AS header_links_backup1_12, t0.footer_links AS footer_links_13, t0.footer_links_backup1 AS footer_links_backup1_14, t0.script AS script_15, t0.custom_css AS custom_css_16, t0.brand_color AS brand_color_17, t0.page_background_color AS page_background_color_18, t0.header_background_color AS header_background_color_19, t0.banner_background_color AS banner_background_color_20, t0.nav_text_color AS nav_text_color_21, t0.nav_active_color AS nav_active_color_22, t0.link_color AS link_color_23, t0.link_hover_color AS link_hover_color_24, t0.article_text_color AS article_text_color_25, t0.homepage_url AS homepage_url_26, t0.link_to_site_logo AS link_to_site_logo_27, t0.home_link_text AS home_link_text_28, t0.site_descritption AS site_descritption_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.homepage_content AS homepage_content_32, t0.ticket_create_option AS ticket_create_option_33, t0.login_required_to_create AS login_required_to_create_34, t0.remove_customer_login_button AS remove_customer_login_button_35, t0.disable_customer_login AS disable_customer_login_36, t0.remove_branding_content AS remove_branding_content_37, t0.is_merged AS is_merged_38, t0.is_merged_child_closed AS is_merged_child_closed_39, t0.date_added AS date_added_40, t0.date_updated AS date_updated_41, t0.broadcast_message AS broadcast_message_42, t0.broadcast_message_backup1 AS broadcast_message_backup1_43, t0.company_id AS company_id_44, t45.id AS id_46, t45.website_id AS website_id_47, t45.domain AS domain_48, t45.website_id AS website_id_49 FROM website t0 LEFT JOIN website_history t45 ON t45.website_id = t0.id WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "www.helpdesk8-4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_id AS company_id_2,
  t0.name AS name_3,
  t0.domain AS domain_4,
  t0.c_name AS c_name_5,
  t0.status AS status_6,
  t0.logo AS logo_7,
  t0.favicon AS favicon_8,
  t0.banner AS banner_9,
  t0.touch AS touch_10,
  t0.header_links AS header_links_11,
  t0.header_links_backup1 AS header_links_backup1_12,
  t0.footer_links AS footer_links_13,
  t0.footer_links_backup1 AS footer_links_backup1_14,
  t0.script AS script_15,
  t0.custom_css AS custom_css_16,
  t0.brand_color AS brand_color_17,
  t0.page_background_color AS page_background_color_18,
  t0.header_background_color AS header_background_color_19,
  t0.banner_background_color AS banner_background_color_20,
  t0.nav_text_color AS nav_text_color_21,
  t0.nav_active_color AS nav_active_color_22,
  t0.link_color AS link_color_23,
  t0.link_hover_color AS link_hover_color_24,
  t0.article_text_color AS article_text_color_25,
  t0.homepage_url AS homepage_url_26,
  t0.link_to_site_logo AS link_to_site_logo_27,
  t0.home_link_text AS home_link_text_28,
  t0.site_descritption AS site_descritption_29,
  t0.meta_description AS meta_description_30,
  t0.meta_keywords AS meta_keywords_31,
  t0.homepage_content AS homepage_content_32,
  t0.ticket_create_option AS ticket_create_option_33,
  t0.login_required_to_create AS login_required_to_create_34,
  t0.remove_customer_login_button AS remove_customer_login_button_35,
  t0.disable_customer_login AS disable_customer_login_36,
  t0.remove_branding_content AS remove_branding_content_37,
  t0.is_merged AS is_merged_38,
  t0.is_merged_child_closed AS is_merged_child_closed_39,
  t0.date_added AS date_added_40,
  t0.date_updated AS date_updated_41,
  t0.broadcast_message AS broadcast_message_42,
  t0.broadcast_message_backup1 AS broadcast_message_backup1_43,
  t0.company_id AS company_id_44,
  t45.id AS id_46,
  t45.website_id AS website_id_47,
  t45.domain AS domain_48,
  t45.website_id AS website_id_49
FROM
  website t0
  LEFT JOIN website_history t45 ON t45.website_id = t0.id
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.domain AS domain_4, t0.c_name AS c_name_5, t0.status AS status_6, t0.logo AS logo_7, t0.favicon AS favicon_8, t0.banner AS banner_9, t0.touch AS touch_10, t0.header_links AS header_links_11, t0.header_links_backup1 AS header_links_backup1_12, t0.footer_links AS footer_links_13, t0.footer_links_backup1 AS footer_links_backup1_14, t0.script AS script_15, t0.custom_css AS custom_css_16, t0.brand_color AS brand_color_17, t0.page_background_color AS page_background_color_18, t0.header_background_color AS header_background_color_19, t0.banner_background_color AS banner_background_color_20, t0.nav_text_color AS nav_text_color_21, t0.nav_active_color AS nav_active_color_22, t0.link_color AS link_color_23, t0.link_hover_color AS link_hover_color_24, t0.article_text_color AS article_text_color_25, t0.homepage_url AS homepage_url_26, t0.link_to_site_logo AS link_to_site_logo_27, t0.home_link_text AS home_link_text_28, t0.site_descritption AS site_descritption_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.homepage_content AS homepage_content_32, t0.ticket_create_option AS ticket_create_option_33, t0.login_required_to_create AS login_required_to_create_34, t0.remove_customer_login_button AS remove_customer_login_button_35, t0.disable_customer_login AS disable_customer_login_36, t0.remove_branding_content AS remove_branding_content_37, t0.is_merged AS is_merged_38, t0.is_merged_child_closed AS is_merged_child_closed_39, t0.date_added AS date_added_40, t0.date_updated AS date_updated_41, t0.broadcast_message AS broadcast_message_42, t0.broadcast_message_backup1 AS broadcast_message_backup1_43, t0.company_id AS company_id_44, t45.id AS id_46, t45.website_id AS website_id_47, t45.domain AS domain_48, t45.website_id AS website_id_49 FROM website t0 LEFT JOIN website_history t45 ON t45.website_id = t0.id WHERE t0.domain = 'www.helpdesk8-4' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Uvdesk\SecurityBundle\Security\AccessControl->lookupHelpdeskWebsite (line 263)
5	Uvdesk\SecurityBundle\Security\AccessControl->getCurrentHelpdeskWebsiteInSession (line 345)
6	Uvdesk\SecurityBundle\Security\AccessControl->getCurrentHelpdeskInSession (line 317)
7	Uvdesk\SecurityBundle\EventListener\SessionValidationListener->onSessionValidation (line 65)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 208)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 6)

1.31 ms
(36.34%)

SELECT w0_.id AS id_0, w0_.company_id AS company_id_1, w0_.name AS name_2, w0_.domain AS domain_3, w0_.c_name AS c_name_4, w0_.status AS status_5, w0_.logo AS logo_6, w0_.favicon AS favicon_7, w0_.banner AS banner_8, w0_.touch AS touch_9, w0_.header_links AS header_links_10, w0_.header_links_backup1 AS header_links_backup1_11, w0_.footer_links AS footer_links_12, w0_.footer_links_backup1 AS footer_links_backup1_13, w0_.script AS script_14, w0_.custom_css AS custom_css_15, w0_.brand_color AS brand_color_16, w0_.page_background_color AS page_background_color_17, w0_.header_background_color AS header_background_color_18, w0_.banner_background_color AS banner_background_color_19, w0_.nav_text_color AS nav_text_color_20, w0_.nav_active_color AS nav_active_color_21, w0_.link_color AS link_color_22, w0_.link_hover_color AS link_hover_color_23, w0_.article_text_color AS article_text_color_24, w0_.homepage_url AS homepage_url_25, w0_.link_to_site_logo AS link_to_site_logo_26, w0_.home_link_text AS home_link_text_27, w0_.site_descritption AS site_descritption_28, w0_.meta_description AS meta_description_29, w0_.meta_keywords AS meta_keywords_30, w0_.homepage_content AS homepage_content_31, w0_.ticket_create_option AS ticket_create_option_32, w0_.login_required_to_create AS login_required_to_create_33, w0_.remove_customer_login_button AS remove_customer_login_button_34, w0_.disable_customer_login AS disable_customer_login_35, w0_.remove_branding_content AS remove_branding_content_36, w0_.is_merged AS is_merged_37, w0_.is_merged_child_closed AS is_merged_child_closed_38, w0_.date_added AS date_added_39, w0_.date_updated AS date_updated_40, w0_.broadcast_message AS broadcast_message_41, w0_.broadcast_message_backup1 AS broadcast_message_backup1_42, w0_.company_id AS company_id_43 FROM website w0_ WHERE w0_.c_name IN (?, ?, ?, ?) LIMIT 1

Parameters:

[
  "http://www.helpdesk8-4.voipkul.com"
  "http://www.www.helpdesk8-4.voipkul.com"
  "https://www.helpdesk8-4.voipkul.com"
  "https://www.www.helpdesk8-4.voipkul.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.company_id AS company_id_1,
  w0_.name AS name_2,
  w0_.domain AS domain_3,
  w0_.c_name AS c_name_4,
  w0_.status AS status_5,
  w0_.logo AS logo_6,
  w0_.favicon AS favicon_7,
  w0_.banner AS banner_8,
  w0_.touch AS touch_9,
  w0_.header_links AS header_links_10,
  w0_.header_links_backup1 AS header_links_backup1_11,
  w0_.footer_links AS footer_links_12,
  w0_.footer_links_backup1 AS footer_links_backup1_13,
  w0_.script AS script_14,
  w0_.custom_css AS custom_css_15,
  w0_.brand_color AS brand_color_16,
  w0_.page_background_color AS page_background_color_17,
  w0_.header_background_color AS header_background_color_18,
  w0_.banner_background_color AS banner_background_color_19,
  w0_.nav_text_color AS nav_text_color_20,
  w0_.nav_active_color AS nav_active_color_21,
  w0_.link_color AS link_color_22,
  w0_.link_hover_color AS link_hover_color_23,
  w0_.article_text_color AS article_text_color_24,
  w0_.homepage_url AS homepage_url_25,
  w0_.link_to_site_logo AS link_to_site_logo_26,
  w0_.home_link_text AS home_link_text_27,
  w0_.site_descritption AS site_descritption_28,
  w0_.meta_description AS meta_description_29,
  w0_.meta_keywords AS meta_keywords_30,
  w0_.homepage_content AS homepage_content_31,
  w0_.ticket_create_option AS ticket_create_option_32,
  w0_.login_required_to_create AS login_required_to_create_33,
  w0_.remove_customer_login_button AS remove_customer_login_button_34,
  w0_.disable_customer_login AS disable_customer_login_35,
  w0_.remove_branding_content AS remove_branding_content_36,
  w0_.is_merged AS is_merged_37,
  w0_.is_merged_child_closed AS is_merged_child_closed_38,
  w0_.date_added AS date_added_39,
  w0_.date_updated AS date_updated_40,
  w0_.broadcast_message AS broadcast_message_41,
  w0_.broadcast_message_backup1 AS broadcast_message_backup1_42,
  w0_.company_id AS company_id_43
FROM
  website w0_
WHERE
  w0_.c_name IN (?, ?, ?, ?)
LIMIT
  1

SELECT w0_.id AS id_0, w0_.company_id AS company_id_1, w0_.name AS name_2, w0_.domain AS domain_3, w0_.c_name AS c_name_4, w0_.status AS status_5, w0_.logo AS logo_6, w0_.favicon AS favicon_7, w0_.banner AS banner_8, w0_.touch AS touch_9, w0_.header_links AS header_links_10, w0_.header_links_backup1 AS header_links_backup1_11, w0_.footer_links AS footer_links_12, w0_.footer_links_backup1 AS footer_links_backup1_13, w0_.script AS script_14, w0_.custom_css AS custom_css_15, w0_.brand_color AS brand_color_16, w0_.page_background_color AS page_background_color_17, w0_.header_background_color AS header_background_color_18, w0_.banner_background_color AS banner_background_color_19, w0_.nav_text_color AS nav_text_color_20, w0_.nav_active_color AS nav_active_color_21, w0_.link_color AS link_color_22, w0_.link_hover_color AS link_hover_color_23, w0_.article_text_color AS article_text_color_24, w0_.homepage_url AS homepage_url_25, w0_.link_to_site_logo AS link_to_site_logo_26, w0_.home_link_text AS home_link_text_27, w0_.site_descritption AS site_descritption_28, w0_.meta_description AS meta_description_29, w0_.meta_keywords AS meta_keywords_30, w0_.homepage_content AS homepage_content_31, w0_.ticket_create_option AS ticket_create_option_32, w0_.login_required_to_create AS login_required_to_create_33, w0_.remove_customer_login_button AS remove_customer_login_button_34, w0_.disable_customer_login AS disable_customer_login_35, w0_.remove_branding_content AS remove_branding_content_36, w0_.is_merged AS is_merged_37, w0_.is_merged_child_closed AS is_merged_child_closed_38, w0_.date_added AS date_added_39, w0_.date_updated AS date_updated_40, w0_.broadcast_message AS broadcast_message_41, w0_.broadcast_message_backup1 AS broadcast_message_backup1_42, w0_.company_id AS company_id_43 FROM website w0_ WHERE w0_.c_name IN ('http://www.helpdesk8-4.voipkul.com', 'http://www.www.helpdesk8-4.voipkul.com', 'https://www.helpdesk8-4.voipkul.com', 'https://www.www.helpdesk8-4.voipkul.com') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Webkul\UserBundle\Services\UserService->getCurrentWebsite (line 170)
7	Webkul\UserBundle\Services\UserService->getCurrentCompany (line 97)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_a1003f326313abd7006db8622d2c44fa::doDisplay (line 61)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_111d1ff853af68efa6056cfa961d8f77->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	Webkul\MobileBundle\Controller\DefaultController->index (line 29)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 6)

0.97 ms
(26.71%)

SELECT t0.id AS id_1, t0.website_id AS website_id_2, t0.domain AS domain_3, t0.website_id AS website_id_4 FROM website_history t0 WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "www.helpdesk8-4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.website_id AS website_id_2,
  t0.domain AS domain_3,
  t0.website_id AS website_id_4
FROM
  website_history t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.website_id AS website_id_2, t0.domain AS domain_3, t0.website_id AS website_id_4 FROM website_history t0 WHERE t0.domain = 'www.helpdesk8-4' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Uvdesk\SecurityBundle\Security\AccessControl->lookupHelpdeskWebsite (line 268)
4	Uvdesk\SecurityBundle\Security\AccessControl->getCurrentHelpdeskWebsiteInSession (line 345)
5	Uvdesk\SecurityBundle\Security\AccessControl->getCurrentHelpdeskInSession (line 317)
6	Uvdesk\SecurityBundle\EventListener\SessionValidationListener->onSessionValidation (line 65)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 6)

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

Entities Mapping

Class	Mapping errors
Webkul\SupportCenterBundle\Entity\Website	No errors.
Webkul\UserBundle\Entity\Company	The field Webkul\UserBundle\Entity\Company#websites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\SupportCenterBundle\Entity\Website#company does not contain the required 'inversedBy: "websites"' attribute. The field Webkul\UserBundle\Entity\Company#ticketRules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\TicketBundle\Entity\TicketRules#company does not contain the required 'inversedBy: "ticketRules"' attribute.
Webkul\SupportCenterBundle\Entity\WebsiteHistory	No errors.

Symfony Profiler

GET https://www.helpdesk8-4.voipkul.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping