Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.logo AS logo_4,
  t0.theme_color AS theme_color_5,
  t0.favicon AS favicon_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_active AS is_active_9,
  t0.timezone AS timezone_10,
  t0.timeformat AS timeformat_11
FROM
  uv_website t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo AS logo_4, t0.theme_color AS theme_color_5, t0.favicon AS favicon_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.timezone AS timezone_10, t0.timeformat AS timeformat_11 FROM uv_website t0 WHERE t0.code = 'knowledgebase' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.proxy_id AS proxy_id_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_enabled AS is_enabled_7,
  t0.verification_code AS verification_code_8,
  t0.timezone AS timezone_9,
  t0.timeformat AS timeformat_10
FROM
  uv_user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.proxy_id AS proxy_id_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_enabled AS is_enabled_7, t0.verification_code AS verification_code_8, t0.timezone AS timezone_9, t0.timeformat AS timeformat_10 FROM uv_user t0 WHERE t0.email = 'noreplyhere@aol.com' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.source AS source_1,
  u0_.message_id AS message_id_2,
  u0_.thread_type AS thread_type_3,
  u0_.created_by AS created_by_4,
  u0_.cc AS cc_5,
  u0_.bcc AS bcc_6,
  u0_.reply_to AS reply_to_7,
  u0_.delivery_status AS delivery_status_8,
  u0_.is_locked AS is_locked_9,
  u0_.is_bookmarked AS is_bookmarked_10,
  u0_.message AS message_11,
  u0_.created_at AS created_at_12,
  u0_.updated_at AS updated_at_13,
  u0_.agent_viewed_at AS agent_viewed_at_14,
  u0_.customer_viewed_at AS customer_viewed_at_15,
  u0_.ticket_id AS ticket_id_16,
  u0_.user_id AS user_id_17
FROM
  uv_thread u0_
WHERE
  u0_.ticket_id = ?
ORDER BY
  u0_.id DESC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.source AS source_1, u0_.message_id AS message_id_2, u0_.thread_type AS thread_type_3, u0_.created_by AS created_by_4, u0_.cc AS cc_5, u0_.bcc AS bcc_6, u0_.reply_to AS reply_to_7, u0_.delivery_status AS delivery_status_8, u0_.is_locked AS is_locked_9, u0_.is_bookmarked AS is_bookmarked_10, u0_.message AS message_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.agent_viewed_at AS agent_viewed_at_14, u0_.customer_viewed_at AS customer_viewed_at_15, u0_.ticket_id AS ticket_id_16, u0_.user_id AS user_id_17 FROM uv_thread u0_ WHERE u0_.ticket_id = 765 ORDER BY u0_.id DESC LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.description AS description_2,
  u0_.conditions AS conditions_3,
  u0_.actions AS actions_4,
  u0_.sort_order AS sort_order_5,
  u0_.is_predefind AS is_predefind_6,
  u0_.status AS status_7,
  u0_.date_added AS date_added_8,
  u0_.date_updated AS date_updated_9
FROM
  uv_workflow u0_
  LEFT JOIN uv_workflow_events u1_ ON u0_.id = u1_.workflow_id
WHERE
  u0_.status = ?
  AND u0_.is_predefind = ?
  AND u1_.event = ?
ORDER BY
  u0_.sort_order ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.conditions AS conditions_3, u0_.actions AS actions_4, u0_.sort_order AS sort_order_5, u0_.is_predefind AS is_predefind_6, u0_.status AS status_7, u0_.date_added AS date_added_8, u0_.date_updated AS date_updated_9 FROM uv_workflow u0_ LEFT JOIN uv_workflow_events u1_ ON u0_.id = u1_.workflow_id WHERE u0_.status = 1 AND u0_.is_predefind = 1 AND u1_.event = 'uvdesk.ticket.created' ORDER BY u0_.sort_order ASC;

UPDATE
  uv_ticket
SET
  reference_ids = ?,
  is_replied = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE uv_ticket SET reference_ids = ' <pewc8scv2vztaaokyrvx@localhost>', is_replied = 0, updated_at = '2024-11-23 05:18:46' WHERE id = 765;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.brand_color AS brand_color_3,
  t0.page_background_color AS page_background_color_4,
  t0.header_background_color AS header_background_color_5,
  t0.link_color AS link_color_6,
  t0.article_text_color AS article_text_color_7,
  t0.ticket_create_option AS ticket_create_option_8,
  t0.site_description AS site_description_9,
  t0.meta_description AS meta_description_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.homepage_content AS homepage_content_12,
  t0.white_list AS white_list_13,
  t0.black_list AS black_list_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.broadcast_message AS broadcast_message_17,
  t0.disable_customer_login AS disable_customer_login_18,
  t0.script AS script_19,
  t0.custom_css AS custom_css_20,
  t0.is_active AS is_active_21,
  t0.header_links AS header_links_22,
  t0.footer_links AS footer_links_23,
  t0.banner_background_color AS banner_background_color_24,
  t0.link_hover_color AS link_hover_color_25,
  t0.login_required_to_create AS login_required_to_create_26,
  t0.remove_customer_login_button AS remove_customer_login_button_27,
  t0.remove_branding_content AS remove_branding_content_28,
  t0.website AS website_29
FROM
  uv_website_knowledgebase t0
WHERE
  t0.website = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.brand_color AS brand_color_3, t0.page_background_color AS page_background_color_4, t0.header_background_color AS header_background_color_5, t0.link_color AS link_color_6, t0.article_text_color AS article_text_color_7, t0.ticket_create_option AS ticket_create_option_8, t0.site_description AS site_description_9, t0.meta_description AS meta_description_10, t0.meta_keywords AS meta_keywords_11, t0.homepage_content AS homepage_content_12, t0.white_list AS white_list_13, t0.black_list AS black_list_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.broadcast_message AS broadcast_message_17, t0.disable_customer_login AS disable_customer_login_18, t0.script AS script_19, t0.custom_css AS custom_css_20, t0.is_active AS is_active_21, t0.header_links AS header_links_22, t0.footer_links AS footer_links_23, t0.banner_background_color AS banner_background_color_24, t0.link_hover_color AS link_hover_color_25, t0.login_required_to_create AS login_required_to_create_26, t0.remove_customer_login_button AS remove_customer_login_button_27, t0.remove_branding_content AS remove_branding_content_28, t0.website AS website_29 FROM uv_website_knowledgebase t0 WHERE t0.website = 2 AND t0.is_active = 1 LIMIT 1;

INSERT INTO uv_ticket (
  source, mailbox_email, subject, reference_ids,
  is_new, is_replied, is_reply_enabled,
  is_starred, is_trashed, is_agent_viewed,
  is_customer_viewed, created_at,
  updated_at, status_id, priority_id,
  type_id, customer_id, agent_id, group_id,
  subGroup_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO uv_ticket (source, mailbox_email, subject, reference_ids, is_new, is_replied, is_reply_enabled, is_starred, is_trashed, is_agent_viewed, is_customer_viewed, created_at, updated_at, status_id, priority_id, type_id, customer_id, agent_id, group_id, subGroup_id) VALUES ('website', NULL, 'question', NULL, 1, 0, 1, 0, 0, 0, 0, '2024-11-23 05:18:46', '2024-11-23 05:18:46', 1, 1, 1, 75, NULL, NULL, NULL);

UPDATE
  uv_ticket
SET
  agent_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE uv_ticket SET agent_id = 3, updated_at = '2024-11-23 05:18:46' WHERE id = 765;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO agent_activity (
  agent_name, customer_name, thread_type,
  created_at, agent_id, ticket_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO agent_activity (agent_name, customer_name, thread_type, created_at, agent_id, ticket_id) VALUES ('agent', 'Phil Stewart', 'create', '2024-11-23 05:18:46', 75, 765);

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3
FROM
  uv_support_role t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3 FROM uv_support_role t0 WHERE t0.code = 'ROLE_CUSTOMER' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.code AS code_1,
  u0_.description AS description_2,
  u0_.is_active AS is_active_3
FROM
  uv_ticket_type u0_
WHERE
  u0_.is_active = ?
  AND u0_.id IN (?)
ORDER BY
  u0_.description ASC

SELECT u0_.id AS id_0, u0_.code AS code_1, u0_.description AS description_2, u0_.is_active AS is_active_3 FROM uv_ticket_type u0_ WHERE u0_.is_active = 1 AND u0_.id IN ('1') ORDER BY u0_.description ASC;

SELECT
  t0.id AS id_1,
  t0.source AS source_2,
  t0.skype_id AS skype_id_3,
  t0.contact_number AS contact_number_4,
  t0.designation AS designation_5,
  t0.signature AS signature_6,
  t0.profile_image_path AS profile_image_path_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_active AS is_active_10,
  t0.is_verified AS is_verified_11,
  t0.is_starred AS is_starred_12,
  t0.ticket_access_level AS ticket_access_level_13,
  t0.user_id AS user_id_14,
  t0.supportRole_id AS supportRole_id_15
FROM
  uv_user_instance t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.source AS source_2, t0.skype_id AS skype_id_3, t0.contact_number AS contact_number_4, t0.designation AS designation_5, t0.signature AS signature_6, t0.profile_image_path AS profile_image_path_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.is_verified AS is_verified_11, t0.is_starred AS is_starred_12, t0.ticket_access_level AS ticket_access_level_13, t0.user_id AS user_id_14, t0.supportRole_id AS supportRole_id_15 FROM uv_user_instance t0 WHERE t0.user_id = 75;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.brand_color AS brand_color_3,
  t0.page_background_color AS page_background_color_4,
  t0.header_background_color AS header_background_color_5,
  t0.link_color AS link_color_6,
  t0.article_text_color AS article_text_color_7,
  t0.ticket_create_option AS ticket_create_option_8,
  t0.site_description AS site_description_9,
  t0.meta_description AS meta_description_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.homepage_content AS homepage_content_12,
  t0.white_list AS white_list_13,
  t0.black_list AS black_list_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.broadcast_message AS broadcast_message_17,
  t0.disable_customer_login AS disable_customer_login_18,
  t0.script AS script_19,
  t0.custom_css AS custom_css_20,
  t0.is_active AS is_active_21,
  t0.header_links AS header_links_22,
  t0.footer_links AS footer_links_23,
  t0.banner_background_color AS banner_background_color_24,
  t0.link_hover_color AS link_hover_color_25,
  t0.login_required_to_create AS login_required_to_create_26,
  t0.remove_customer_login_button AS remove_customer_login_button_27,
  t0.remove_branding_content AS remove_branding_content_28,
  t0.website AS website_29
FROM
  uv_website_knowledgebase t0
WHERE
  t0.website = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.brand_color AS brand_color_3, t0.page_background_color AS page_background_color_4, t0.header_background_color AS header_background_color_5, t0.link_color AS link_color_6, t0.article_text_color AS article_text_color_7, t0.ticket_create_option AS ticket_create_option_8, t0.site_description AS site_description_9, t0.meta_description AS meta_description_10, t0.meta_keywords AS meta_keywords_11, t0.homepage_content AS homepage_content_12, t0.white_list AS white_list_13, t0.black_list AS black_list_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.broadcast_message AS broadcast_message_17, t0.disable_customer_login AS disable_customer_login_18, t0.script AS script_19, t0.custom_css AS custom_css_20, t0.is_active AS is_active_21, t0.header_links AS header_links_22, t0.footer_links AS footer_links_23, t0.banner_background_color AS banner_background_color_24, t0.link_hover_color AS link_hover_color_25, t0.login_required_to_create AS login_required_to_create_26, t0.remove_customer_login_button AS remove_customer_login_button_27, t0.remove_branding_content AS remove_branding_content_28, t0.website AS website_29 FROM uv_website_knowledgebase t0 WHERE t0.website = 2 AND t0.status = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.color_code AS color_code_4,
  t0.sort_order AS sort_order_5
FROM
  uv_ticket_status t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.color_code AS color_code_4, t0.sort_order AS sort_order_5 FROM uv_ticket_status t0 WHERE t0.code = 'open' LIMIT 1;

INSERT INTO uv_thread (
  source, message_id, thread_type, created_by,
  cc, bcc, reply_to, delivery_status,
  is_locked, is_bookmarked, message,
  created_at, updated_at, agent_viewed_at,
  customer_viewed_at, ticket_id, user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO uv_thread (source, message_id, thread_type, created_by, cc, bcc, reply_to, delivery_status, is_locked, is_bookmarked, message, created_at, updated_at, agent_viewed_at, customer_viewed_at, ticket_id, user_id) VALUES ('website', '<pewc8scv2vztaaokyrvx@localhost>', 'create', 'customer', 'N;', 'N;', 'N;', NULL, 0, 0, 'Why let ad platforms dictate your success? Contact form advertising gives you total control over your outreach. No restrictions, no bans—just your message delivered to millions of websites.

 Contact me today for more details—my info is listed below.

Regards,
Preston Blunt
Email: Preston.Blunt@morebiz.my
Website: http://lyf6j8.form-marketing.top
Skype: marketingwithcontactforms', '2024-11-23 05:18:46', '2024-11-23 05:18:46', NULL, NULL, 765, 75);

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.proxy_id AS proxy_id_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_enabled AS is_enabled_7,
  t0.verification_code AS verification_code_8,
  t0.timezone AS timezone_9,
  t0.timeformat AS timeformat_10
FROM
  uv_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.proxy_id AS proxy_id_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_enabled AS is_enabled_7, t0.verification_code AS verification_code_8, t0.timezone AS timezone_9, t0.timeformat AS timeformat_10 FROM uv_user t0 WHERE t0.id = '3';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.color_code AS color_code_4
FROM
  uv_ticket_priority t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.color_code AS color_code_4 FROM uv_ticket_priority t0 WHERE t0.code = 'low' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_key AS site_key_2,
  t0.secret_key AS secret_key_3,
  t0.is_active AS is_active_4
FROM
  recaptcha t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_key AS site_key_2, t0.secret_key AS secret_key_3, t0.is_active AS is_active_4 FROM recaptcha t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4
FROM
  uv_ticket_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.is_active AS is_active_4 FROM uv_ticket_type t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.proxy_id AS proxy_id_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_enabled AS is_enabled_7,
  t0.verification_code AS verification_code_8,
  t0.timezone AS timezone_9,
  t0.timeformat AS timeformat_10
FROM
  uv_user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.proxy_id AS proxy_id_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_enabled AS is_enabled_7, t0.verification_code AS verification_code_8, t0.timezone AS timezone_9, t0.timeformat AS timeformat_10 FROM uv_user t0 WHERE t0.id = 3 LIMIT 1;