Symfony Profiler

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;

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;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.sort_order AS sort_order_4,
  t0.is_private AS is_private_5,
  t0.is_published AS is_published_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.banner_image AS banner_image_9,
  t0.company_id AS company_id_10,
  t0.user_id AS user_id_11
FROM
  kb_folders t0
WHERE
  t0.company_id = ?
  AND t0.id = ?
  AND t0.is_published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.is_private AS is_private_5, t0.is_published AS is_published_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.banner_image AS banner_image_9, t0.company_id AS company_id_10, t0.user_id AS user_id_11 FROM kb_folders t0 WHERE t0.company_id = 2566 AND t0.id = '2' AND t0.is_published = 1 LIMIT 1;

SELECT
  k0_.id AS id_0,
  k0_.title AS title_1,
  k0_.content AS content_2,
  k0_.is_published AS is_published_3,
  k0_.total_views AS total_views_4,
  k0_.is_starred AS is_starred_5,
  k0_.created_at AS created_at_6,
  k0_.keywords AS keywords_7,
  k0_.meta_title AS meta_title_8,
  k0_.meta_description AS meta_description_9,
  k0_.slug AS slug_10,
  k1_.id AS id_11,
  k1_.title AS title_12,
  k1_.description AS description_13,
  k1_.sort_order AS sort_order_14,
  k1_.is_private AS is_private_15,
  k1_.is_published AS is_published_16,
  k1_.created_at AS created_at_17,
  k1_.updated_at AS updated_at_18,
  k1_.banner_image AS banner_image_19,
  k0_.company_id AS company_id_20,
  k0_.author_id AS author_id_21,
  k1_.company_id AS company_id_22,
  k1_.user_id AS user_id_23
FROM
  kb_articles k0_
  LEFT JOIN kb_folder_articles k2_ ON k0_.id = k2_.article_id
  LEFT JOIN kb_folders k1_ ON k1_.id = k2_.folder_id
WHERE
  k1_.id = ?
  AND k0_.is_published = ?

SELECT k0_.id AS id_0, k0_.title AS title_1, k0_.content AS content_2, k0_.is_published AS is_published_3, k0_.total_views AS total_views_4, k0_.is_starred AS is_starred_5, k0_.created_at AS created_at_6, k0_.keywords AS keywords_7, k0_.meta_title AS meta_title_8, k0_.meta_description AS meta_description_9, k0_.slug AS slug_10, k1_.id AS id_11, k1_.title AS title_12, k1_.description AS description_13, k1_.sort_order AS sort_order_14, k1_.is_private AS is_private_15, k1_.is_published AS is_published_16, k1_.created_at AS created_at_17, k1_.updated_at AS updated_at_18, k1_.banner_image AS banner_image_19, k0_.company_id AS company_id_20, k0_.author_id AS author_id_21, k1_.company_id AS company_id_22, k1_.user_id AS user_id_23 FROM kb_articles k0_ LEFT JOIN kb_folder_articles k2_ ON k0_.id = k2_.article_id LEFT JOIN kb_folders k1_ ON k1_.id = k2_.folder_id WHERE k1_.id = 2 AND k0_.is_published = 1;

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 = ?

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 = 2566;

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

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 = 2566 AND k0_.is_published = 1 AND (k2_.locale = '.env.development' OR k2_.locale IS NULL) ORDER BY k0_.total_views DESC LIMIT 10;

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

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 = 'Google Translate' LIMIT 1;

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

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 = 2566 AND t0.application_id = 50 AND t0.is_active = 1 LIMIT 1;