http://crypuesupport.com/en/customer/create-ticket/ Return to referer URL

Query Metrics

32 Database Queries
22 Different statements
27.43 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 ms
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
Parameters:
[
  "knowledgebase"
]
2 0.57 ms
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
Parameters:
[
  2
  1
]
3 0.32 ms
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
Parameters:
[
  "knowledgebase"
]
4 0.37 ms
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
Parameters:
[
  2
  1
]
5 0.31 ms
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
Parameters:
[
  1
]
6 0.30 ms
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 = ?
Parameters:
[
  "1"
]
7 0.71 ms
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
Parameters:
[
  "knowledgebase"
]
8 0.50 ms
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
Parameters:
[
  2
  1
]
9 0.58 ms
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
Parameters:
[
  1
  [
    "1"
  ]
]
10 0.60 ms
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
Parameters:
[
  "ROLE_CUSTOMER"
]
11 0.58 ms
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
Parameters:
[
  "noreplyhere@aol.com"
]
12 0.52 ms
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
Parameters:
[
  "noreplyhere@aol.com"
]
13 0.39 ms
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
Parameters:
[
  "knowledgebase"
]
14 0.57 ms
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 = ?
Parameters:
[
  75
]
15 0.55 ms
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
Parameters:
[
  "open"
]
16 0.39 ms
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
Parameters:
[
  "low"
]
17 0.33 ms
"START TRANSACTION"
Parameters:
[]
18 0.84 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "website"
  2 => null
  3 => "question"
  4 => null
  5 => 1
  6 => 0
  7 => 1
  8 => 0
  9 => 0
  10 => 0
  11 => 0
  12 => "2024-11-23 05:18:46"
  13 => "2024-11-23 05:18:46"
  14 => 1
  15 => 1
  16 => 1
  17 => 75
  18 => null
  19 => null
  20 => null
]
19 6.11 ms
"COMMIT"
Parameters:
[]
20 1.15 ms
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
Parameters:
[
  765
]
21 0.19 ms
"START TRANSACTION"
Parameters:
[]
22 0.66 ms
INSERT INTO agent_activity (agent_name, customer_name, thread_type, created_at, agent_id, ticket_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "agent"
  2 => "Phil Stewart"
  3 => "create"
  4 => "2024-11-23 05:18:46"
  5 => 75
  6 => 765
]
23 0.50 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "website"
  2 => "<pewc8scv2vztaaokyrvx@localhost>"
  3 => "create"
  4 => "customer"
  5 => "N;"
  6 => "N;"
  7 => "N;"
  8 => null
  9 => 0
  10 => 0
  11 => """
    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.\r\n
    \r\n
     Contact me today for more details—my info is listed below.\r\n
    \r\n
    Regards,\r\n
    Preston Blunt\r\n
    Email: Preston.Blunt@morebiz.my\r\n
    Website: http://lyf6j8.form-marketing.top\r\n
    Skype: marketingwithcontactforms
    """
  12 => "2024-11-23 05:18:46"
  13 => "2024-11-23 05:18:46"
  14 => null
  15 => null
  16 => 765
  17 => 75
]
24 0.89 ms
UPDATE uv_ticket SET reference_ids = ?, is_replied = ?, updated_at = ? WHERE id = ?
Parameters:
[
  " <pewc8scv2vztaaokyrvx@localhost>"
  0
  "2024-11-23 05:18:46"
  765
]
25 2.20 ms
"COMMIT"
Parameters:
[]
26 0.98 ms
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
Parameters:
[
  1
  1
  "uvdesk.ticket.created"
]
27 0.48 ms
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 = ?
Parameters:
[
  "3"
]
28 0.33 ms
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
Parameters:
[
  "abhishek.singh@atrox.io"
]
29 0.23 ms
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
Parameters:
[
  3
]
30 0.19 ms
"START TRANSACTION"
Parameters:
[]
31 0.71 ms
UPDATE uv_ticket SET agent_id = ?, updated_at = ? WHERE id = ?
Parameters:
[
  3
  "2024-11-23 05:18:46"
  765
]
32 3.91 ms
"COMMIT"
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
Webkul\UVDesk\CoreFrameworkBundle\Entity\Website No errors.
Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Recaptcha No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketType No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket
  • The association Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket#supportGroup refers to the inverse side field Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup#tickets which does not exist.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportRole No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\User No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\EmailTemplates No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SavedFilters No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportPrivilege No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketStatus No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketPriority No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Thread No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketRating No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Tag
  • The field Webkul\UVDesk\CoreFrameworkBundle\Entity\Tag#tickets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket#supportTags does not contain the required 'inversedBy="tickets"' attribute.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportLabel No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\AgentActivity No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Attachment No errors.
Webkul\UVDesk\AutomationBundle\Entity\Workflow
  • The mappings Webkul\UVDesk\AutomationBundle\Entity\Workflow#workflowEvents and Webkul\UVDesk\AutomationBundle\Entity\WorkflowEvents#workflow are inconsistent with each other.
Webkul\UVDesk\AutomationBundle\Entity\WorkflowEvents
  • The association Webkul\UVDesk\AutomationBundle\Entity\WorkflowEvents#workflow refers to the inverse side field Webkul\UVDesk\AutomationBundle\Entity\Workflow#WorkflowEvents which does not exist.