Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.custom_domain AS custom_domain_5,
  t0.portal_branding AS portal_branding_6,
  t0.enabled AS enabled_7,
  t0.ssl_provisioned_at AS ssl_provisioned_at_8,
  t0.custom_domain_verified AS custom_domain_verified_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.workspace_id AS workspace_id_12
FROM
  knowledge_base t0
WHERE
  t0.custom_domain = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.custom_domain AS custom_domain_5, t0.portal_branding AS portal_branding_6, t0.enabled AS enabled_7, t0.ssl_provisioned_at AS ssl_provisioned_at_8, t0.custom_domain_verified AS custom_domain_verified_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.workspace_id AS workspace_id_12 FROM knowledge_base t0 WHERE t0.custom_domain = 'testhelp.uptimia.com' AND t0.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.plan AS plan_4,
  t0.max_agents AS max_agents_5,
  t0.api_key AS api_key_6,
  t0.enabled AS enabled_7,
  t0.custom_fields_schema AS custom_fields_schema_8,
  t0.csat_enabled AS csat_enabled_9,
  t0.csat_delay_minutes AS csat_delay_minutes_10,
  t0.csat_survey_message AS csat_survey_message_11,
  t0.timezone AS timezone_12,
  t0.default_language AS default_language_13,
  t0.auto_close_resolved_tickets AS auto_close_resolved_tickets_14,
  t0.business_hours AS business_hours_15,
  t0.portal_branding AS portal_branding_16,
  t0.stripe_customer_id AS stripe_customer_id_17,
  t0.stripe_subscription_id AS stripe_subscription_id_18,
  t0.billing_cycle AS billing_cycle_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21
FROM
  workspace t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.plan AS plan_4, t0.max_agents AS max_agents_5, t0.api_key AS api_key_6, t0.enabled AS enabled_7, t0.custom_fields_schema AS custom_fields_schema_8, t0.csat_enabled AS csat_enabled_9, t0.csat_delay_minutes AS csat_delay_minutes_10, t0.csat_survey_message AS csat_survey_message_11, t0.timezone AS timezone_12, t0.default_language AS default_language_13, t0.auto_close_resolved_tickets AS auto_close_resolved_tickets_14, t0.business_hours AS business_hours_15, t0.portal_branding AS portal_branding_16, t0.stripe_customer_id AS stripe_customer_id_17, t0.stripe_subscription_id AS stripe_subscription_id_18, t0.billing_cycle AS billing_cycle_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21 FROM workspace t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.body AS body_4,
  t0.status AS status_5,
  t0.seo_title AS seo_title_6,
  t0.meta_description AS meta_description_7,
  t0.featured_image_url AS featured_image_url_8,
  t0.sort_order AS sort_order_9,
  t0.view_count AS view_count_10,
  t0.helpful_count AS helpful_count_11,
  t0.not_helpful_count AS not_helpful_count_12,
  t0.published_at AS published_at_13,
  t0.scheduled_publish_at AS scheduled_publish_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.knowledge_base_id AS knowledge_base_id_17,
  t0.category_id AS category_id_18,
  t0.author_id AS author_id_19
FROM
  kb_article t0
WHERE
  t0.knowledge_base_id = ?
  AND t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.body AS body_4, t0.status AS status_5, t0.seo_title AS seo_title_6, t0.meta_description AS meta_description_7, t0.featured_image_url AS featured_image_url_8, t0.sort_order AS sort_order_9, t0.view_count AS view_count_10, t0.helpful_count AS helpful_count_11, t0.not_helpful_count AS not_helpful_count_12, t0.published_at AS published_at_13, t0.scheduled_publish_at AS scheduled_publish_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.knowledge_base_id AS knowledge_base_id_17, t0.category_id AS category_id_18, t0.author_id AS author_id_19 FROM kb_article t0 WHERE t0.knowledge_base_id = 1 AND t0.slug = 'getting-started-complete-guide' AND t0.status = 'published' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  kb_article
SET
  view_count = ?
WHERE
  id = ?

UPDATE kb_article SET view_count = 5 WHERE id = 19;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.body AS body_4,
  t0.status AS status_5,
  t0.seo_title AS seo_title_6,
  t0.meta_description AS meta_description_7,
  t0.featured_image_url AS featured_image_url_8,
  t0.sort_order AS sort_order_9,
  t0.view_count AS view_count_10,
  t0.helpful_count AS helpful_count_11,
  t0.not_helpful_count AS not_helpful_count_12,
  t0.published_at AS published_at_13,
  t0.scheduled_publish_at AS scheduled_publish_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.knowledge_base_id AS knowledge_base_id_17,
  t0.category_id AS category_id_18,
  t0.author_id AS author_id_19
FROM
  kb_article t0
WHERE
  t0.knowledge_base_id = ?
  AND t0.category_id = ?
  AND t0.status = ?
ORDER BY
  t0.sort_order ASC,
  t0.published_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.body AS body_4, t0.status AS status_5, t0.seo_title AS seo_title_6, t0.meta_description AS meta_description_7, t0.featured_image_url AS featured_image_url_8, t0.sort_order AS sort_order_9, t0.view_count AS view_count_10, t0.helpful_count AS helpful_count_11, t0.not_helpful_count AS not_helpful_count_12, t0.published_at AS published_at_13, t0.scheduled_publish_at AS scheduled_publish_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.knowledge_base_id AS knowledge_base_id_17, t0.category_id AS category_id_18, t0.author_id AS author_id_19 FROM kb_article t0 WHERE t0.knowledge_base_id = 1 AND t0.category_id = 6 AND t0.status = 'published' ORDER BY t0.sort_order ASC, t0.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.timezone AS timezone_6,
  t0.locale AS locale_7,
  t0.enabled AS enabled_8,
  t0.notification_preferences AS notification_preferences_9,
  t0.last_login_at AS last_login_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.avatar_url AS avatar_url_13,
  t0.signature AS signature_14,
  t0.workspace_id AS workspace_id_15,
  t0.team_id AS team_id_16
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.name AS name_5, t0.timezone AS timezone_6, t0.locale AS locale_7, t0.enabled AS enabled_8, t0.notification_preferences AS notification_preferences_9, t0.last_login_at AS last_login_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.avatar_url AS avatar_url_13, t0.signature AS signature_14, t0.workspace_id AS workspace_id_15, t0.team_id AS team_id_16 FROM `user` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.sort_order AS sort_order_5,
  t0.enabled AS enabled_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.knowledge_base_id AS knowledge_base_id_9,
  t0.parent_id AS parent_id_10
FROM
  kb_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.enabled AS enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.knowledge_base_id AS knowledge_base_id_9, t0.parent_id AS parent_id_10 FROM kb_category t0 WHERE t0.id = 6;