Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

2.74 ms Query time

1 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.41 ms

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:

[
  "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 = '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.33 ms

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:

[
  "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 = '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	Webkul\UserBundle\Services\UserService->getCurrentWebsite (line 136)
5	Webkul\UserBundle\Services\UserService->getCurrentCompany (line 97)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_a1003f326313abd7006db8622d2c44fa::doDisplay (line 61)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_111d1ff853af68efa6056cfa961d8f77->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	Webkul\MobileBundle\Controller\DefaultController->index (line 29)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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
Webkul\SupportCenterBundle\Entity\Website	1
Webkul\UserBundle\Entity\Company	1

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://helpdesk8-4.voipkul.com/

Configuration Settings

Theme

Page Width