Redirect 301 redirect from GET @webkul_support_center_front_solutions (f7234d)

GET https://helpdesk8-4.voipkul.com/sitemap.xml/

Query Metrics

11 Database Queries
10 Different statements
12.17 ms Query time
10 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 1.28 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"
]
2 1.26 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"
]
3 1.12 ms
SELECT k0_.id AS id_0, k0_.title AS title_1, k0_.description AS description_2, k0_.sort_order AS sort_order_3, k0_.is_private AS is_private_4, k0_.is_published AS is_published_5, k0_.created_at AS created_at_6, k0_.updated_at AS updated_at_7, k0_.banner_image AS banner_image_8, k0_.user_id AS sclr_9 FROM kb_folders k0_ WHERE k0_.company_id = ?
Parameters:
[
  2566
]
4 0.84 ms
SELECT DISTINCT article_id, folder_id FROM kb_folder_articles WHERE folder_id IN (1, 2, 3, 4, 5, 6, 7)
Parameters:
[]
5 0.86 ms
SELECT DISTINCT category_id, folder_id FROM kb_folder_categories WHERE folder_id IN (1, 2, 3, 4, 5, 6, 7)
Parameters:
[]
6 0.89 ms
SELECT k0_.id AS id_0, k0_.title AS title_1, k0_.description AS description_2, k0_.sort_order AS sort_order_3, k0_.is_published AS is_published_4, k0_.created_at AS created_at_5, k0_.updated_at AS updated_at_6 FROM kb_categories k0_ WHERE k0_.company_id = ? AND k0_.is_published = ? ORDER BY k0_.sort_order ASC LIMIT 5
Parameters:
[
  2566
  1
]
7 1.30 ms
SELECT k0_.id AS id_0, c1_.id AS id_1, k0_.title AS title_2, k0_.slug AS slug_3, k0_.content AS content_4, k0_.keywords AS keywords_5, k0_.meta_title AS meta_title_6, k0_.is_published AS is_published_7, k0_.total_views AS total_views_8, k0_.is_starred AS is_starred_9, k2_.locale AS locale_10, k2_.title AS title_11, k2_.content AS content_12 FROM kb_articles k0_ LEFT JOIN company c1_ ON k0_.company_id = c1_.id LEFT JOIN kb_translated_article k2_ ON (k2_.knowledgebase_article_id = k0_.id) WHERE c1_.id = ? AND k0_.is_published = ? AND (k2_.locale = ? OR k2_.locale IS NULL) ORDER BY k0_.total_views DESC LIMIT 10
Parameters:
[
  2566
  1
  "sitemap.xml"
]
8 1.25 ms
SELECT t0.id AS id_1, t0.next_ticket_id AS next_ticket_id_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.timezone AS timezone_5, t0.time_format AS time_format_6, t0.website_label AS website_label_7, t0.business_hour_status AS business_hour_status_8, t0.business_hours AS business_hours_9, t0.white_list AS white_list_10, t0.black_list AS black_list_11, t0.support_email AS support_email_12, t0.negative_threshold AS negative_threshold_13, t0.pending_since AS pending_since_14, t0.configure_steps AS configure_steps_15, t0.configure_steps_backup1 AS configure_steps_backup1_16, t0.default_locale AS default_locale_17, t0.allow_email_command AS allow_email_command_18, t0.email_delimiter AS email_delimiter_19, t0.enable_reply_trimming AS enable_reply_trimming_20, t0.enable_editor AS enable_editor_21, t0.record_activity_status AS record_activity_status_22, t0.record_activities AS record_activities_23, t0.record_activities_backup1 AS record_activities_backup1_24, t0.configured AS configured_25, t0.is_company_under_review AS is_company_under_review_26, t0.is_trial_api_resource_enabled AS is_trial_api_resource_enabled_27, t0.is_trial_email_activity_allowed AS is_trial_email_activity_allowed_28, t0.is_agent_email_management_disabled AS is_agent_email_management_disabled_29, t0.is_elastic_search_enabled AS is_elastic_search_enabled_30, t0.is_elastic_view_enabled AS is_elastic_view_enabled_31, t0.enable_otp AS enable_otp_32, t0.enable_mfa AS enable_mfa_33, t0.force_mfa_agent AS force_mfa_agent_34, t0.force_mfa_customer AS force_mfa_customer_35, t0.gdpr_url AS gdpr_url_36, t37.id AS id_38, t37.region AS region_39, t37.fax AS fax_40, t37.postcode AS postcode_41, t37.address1 AS address1_42, t37.address2 AS address2_43, t37.city AS city_44, t37.telephone AS telephone_45, t37.country AS country_46, t37.email AS email_47, t37.first_name AS first_name_48, t37.last_name AS last_name_49, t37.created_at AS created_at_50, t37.updated_at AS updated_at_51, t37.company_id AS company_id_52, t37.recurring_profile_id AS recurring_profile_id_53, t37.sale_order_id AS sale_order_id_54, t0.template_id AS template_id_55, t0.pending_notification_status_id AS pending_notification_status_id_56, t0.recurring_profile_id AS recurring_profile_id_57, t0.mailbox_id AS mailbox_id_58, t0.status_id AS status_id_59, t0.priority_id AS priority_id_60 FROM company t0 LEFT JOIN billing_address t37 ON t37.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  2566
]
9 1.25 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.type AS type_3, t0.payment_status AS payment_status_4, t0.internal_reference_id AS internal_reference_id_5, t0.reference_id AS reference_id_6, t0.schedule_description AS schedule_description_7, t0.period_unit AS period_unit_8, t0.per_agent_per_month_amount AS per_agent_per_month_amount_9, t0.TIN AS TIN_10, t0.billing_amount AS billing_amount_11, t0.payment_method AS payment_method_12, t0.created_at AS created_at_13, t0.next_due_date AS next_due_date_14, t0.cycle_expired_on AS cycle_expired_on_15, t16.id AS id_17, t16.region AS region_18, t16.fax AS fax_19, t16.postcode AS postcode_20, t16.address1 AS address1_21, t16.address2 AS address2_22, t16.city AS city_23, t16.telephone AS telephone_24, t16.country AS country_25, t16.email AS email_26, t16.first_name AS first_name_27, t16.last_name AS last_name_28, t16.created_at AS created_at_29, t16.updated_at AS updated_at_30, t16.company_id AS company_id_31, t16.recurring_profile_id AS recurring_profile_id_32, t16.sale_order_id AS sale_order_id_33, t34.id AS id_35, t34.mailboxes AS mailboxes_36, t34.agents AS agents_37, t34.knowledgebase AS knowledgebase_38, t34.folders AS folders_39, t34.categories AS categories_40, t34.articles AS articles_41, t34.theame_customization AS theame_customization_42, t34.workflow AS workflow_43, t34.email_templates AS email_templates_44, t34.reports AS reports_45, t34.tasks AS tasks_46, t34.custom_fields AS custom_fields_47, t34.saved_replies AS saved_replies_48, t34.saved_filters AS saved_filters_49, t34.sku AS sku_50, t34.created_at AS created_at_51, t34.updated_at AS updated_at_52, t34.recurring_profile_id AS recurring_profile_id_53, t34.sale_order_id AS sale_order_id_54, t0.order_id AS order_id_55, t0.company_id AS company_id_56 FROM recurring_profile t0 LEFT JOIN billing_address t16 ON t16.recurring_profile_id = t0.id LEFT JOIN order_item t34 ON t34.recurring_profile_id = t0.id WHERE t0.id = ?
Parameters:
[
  150
]
10 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.about AS about_5, t0.overview AS overview_6, t0.instruction AS instruction_7, t0.banner AS banner_8, t0.video AS video_9, t0.poster AS poster_10, t0.dependency_name AS dependency_name_11 FROM application t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Google Translate"
]
11 1.01 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.company_id AS company_id_4, t0.userData_id AS userData_id_5, t0.application_id AS application_id_6 FROM application_user t0 WHERE t0.company_id = ? AND t0.application_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  2566
  50
  1
]

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
Webkul\SalesBundle\Entity\RecurringProfile 1
Webkul\TicketBundle\Entity\Status 1
Webkul\TicketBundle\Entity\Priority 1
Webkul\UserBundle\Entity\BillingAddress 1
Webkul\SalesBundle\Entity\OrderItem 1
Webkul\AppBundle\Entity\Application 1
Webkul\AppBundle\Entity\ApplicationUser 1
Webkul\UserBundle\Entity\UserData 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.
Webkul\SupportCenterBundle\Entity\KnowledgebaseFolder No errors.
Webkul\UserBundle\Entity\User No errors.
Webkul\SupportCenterBundle\Entity\KnowledgebaseCategory
  • The field Webkul\SupportCenterBundle\Entity\KnowledgebaseCategory#articles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\SupportCenterBundle\Entity\KnowledgebaseArticle#categories does not contain the required 'inversedBy: "articles"' attribute.
Webkul\SupportCenterBundle\Entity\KnowledgebaseArticle No errors.
Webkul\SupportCenterBundle\Entity\KnowledgebaseTranslatedArticle No errors.
Webkul\UserBundle\Entity\BillingAddress No errors.
Webkul\SalesBundle\Entity\RecurringProfile
  • The field Webkul\SalesBundle\Entity\RecurringProfile#billingAddress is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\UserBundle\Entity\BillingAddress#recurringProfile does not contain the required 'inversedBy: "billingAddress"' attribute.
Webkul\SalesBundle\Entity\SaleOrder
  • The field Webkul\SalesBundle\Entity\SaleOrder#billingAddress is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\UserBundle\Entity\BillingAddress#saleOrder does not contain the required 'inversedBy: "billingAddress"' attribute.
Webkul\UserBundle\Entity\EmailTemplatesCompany
  • The association Webkul\UserBundle\Entity\EmailTemplatesCompany#appEmailTemplates refers to the inverse side field Webkul\AdminBundle\Entity\EmailTemplates#compnayEmailTemplates which does not exist.
Webkul\TicketBundle\Entity\Status No errors.
Webkul\TicketBundle\Entity\Mailbox
  • The association Webkul\TicketBundle\Entity\Mailbox#company refers to the inverse side field Webkul\UserBundle\Entity\Company#mailboxes which does not exist.
Webkul\TicketBundle\Entity\Priority No errors.
Webkul\UserBundle\Entity\SavedFilters No errors.
Webkul\SupportCenterBundle\Entity\Solutions No errors.
Webkul\TicketBundle\Entity\TicketRules No errors.
Webkul\TicketBundle\Entity\PreparedResponses No errors.
Webkul\TicketBundle\Entity\Events No errors.
Webkul\TicketBundle\Entity\CustomFields
  • The association Webkul\TicketBundle\Entity\CustomFields#customFieldsDependency refers to the inverse side field Webkul\TicketBundle\Entity\Type#customFields which does not exist.
Webkul\SalesBundle\Entity\OrderItem No errors.
Webkul\UserBundle\Entity\UserData
  • The association Webkul\UserBundle\Entity\UserData#userRole refers to the inverse side field Webkul\UserBundle\Entity\Role#userRole which does not exist.
Webkul\UserBundle\Entity\BackupCode No errors.
Webkul\UserBundle\Entity\UserGroup
  • The association Webkul\UserBundle\Entity\UserGroup#company refers to the inverse side field Webkul\UserBundle\Entity\Company#groups which does not exist.
  • The field Webkul\UserBundle\Entity\UserGroup#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\UserBundle\Entity\User#groups does not contain the required 'inversedBy: "users"' attribute.
Webkul\SupportCenterBundle\Entity\KnowledgebaseArticleEditHistory No errors.
Webkul\SupportCenterBundle\Entity\KnowledgebaseTranslatedArticleEditHistory No errors.
Webkul\AdminBundle\Entity\EmailTemplates No errors.
Webkul\UserBundle\Entity\UserSubGroup No errors.
Webkul\TicketBundle\Entity\EventEvents No errors.
Webkul\TicketBundle\Entity\CustomFieldsValues No errors.
Webkul\TicketBundle\Entity\TicketCustomFieldsValues No errors.
Webkul\TicketBundle\Entity\Type
  • The association Webkul\TicketBundle\Entity\Type#company refers to the inverse side field Webkul\UserBundle\Entity\Company#types which does not exist.
Webkul\AppBundle\Entity\Application No errors.
Webkul\AppBundle\Entity\ApplicationCategory No errors.
Webkul\AppBundle\Entity\ApplicationFeature No errors.
Webkul\AppBundle\Entity\ApplicationUser No errors.