https://ticketsdemo.softguard.com/public/en/member/workflow/add

Query Metrics

8 Database Queries
7 Different statements
12.73 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
8.69 ms
(68.26%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.proxy_id AS proxy_id_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.is_enabled AS is_enabled_6, u0_.verification_code AS verification_code_7, u0_.timezone AS timezone_8, u0_.timeformat AS timeformat_9, u0_.lastactivity AS lastactivity_10, u0_.es_ultra AS es_ultra_11, u1_.id AS id_12, u1_.source AS source_13, u1_.skype_id AS skype_id_14, u1_.contact_number AS contact_number_15, u1_.designation AS designation_16, u1_.signature AS signature_17, u1_.profile_image_path AS profile_image_path_18, u1_.created_at AS created_at_19, u1_.updated_at AS updated_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.is_starred AS is_starred_23, u1_.ticket_access_level AS ticket_access_level_24, u0_.idor AS idor_25, u1_.user_id AS user_id_26, u1_.supportRole_id AS supportRole_id_27 FROM uv_user u0_ LEFT JOIN uv_user_instance u1_ ON (u0_.id = u1_.user_id) LEFT JOIN uv_support_role u2_ ON u1_.supportRole_id = u2_.id WHERE u0_.email = ? AND (u2_.id = ? OR u2_.id = ? OR u2_.id = ?) LIMIT 1
Parameters:
[
  "franco.garcia@synapticlinks.com.ar"
  1
  2
  3
]
1.15 ms
(9.03%)
2
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"
]
0.77 ms
(6.06%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3 FROM uv_support_role t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.64 ms
(4.99%)
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 = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  2
  1
]
0.56 ms
(4.39%)
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.is_active = ?
Parameters:
[
  1
]
0.53 ms
(4.13%)
1
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:
[
  157
]
0.40 ms
(3.13%)
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
Webkul\UVDesk\CoreFrameworkBundle\Entity\User No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\UserInstance No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportGroup No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\EmailTemplates No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SavedFilters No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportRole No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportPrivilege No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\Website No errors.
Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite
  • The association Webkul\UVDesk\SupportCenterBundle\Entity\KnowledgebaseWebsite#website refers to the inverse side field Webkul\UVDesk\CoreFrameworkBundle\Entity\Website#website which does not exist.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketType No errors.
Webkul\UVDesk\CoreFrameworkBundle\Entity\TicketPriority No errors.