Symfony Profiler

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0, 
  u1_.id AS id_1, 
  u1_.code AS code_2 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_ticket_type u2_ ON u0_.type_id = u2_.id 
  LEFT JOIN uv_user u3_ ON u0_.agent_id = u3_.id 
  LEFT JOIN uv_ticket_status u1_ ON u0_.status_id = u1_.id 
  LEFT JOIN uv_thread u4_ ON u0_.id = u4_.ticket_id 
  LEFT JOIN uv_ticket_priority u5_ ON u0_.priority_id = u5_.id 
  LEFT JOIN uv_user u6_ ON u0_.customer_id = u6_.id 
  LEFT JOIN uv_support_team u7_ ON u0_.subGroup_id = u7_.id 
  LEFT JOIN uv_tickets_tags u9_ ON u0_.id = u9_.ticket_id 
  LEFT JOIN uv_tag u8_ ON u8_.id = u9_.tag_id 
  LEFT JOIN uv_support_group u10_ ON u0_.group_id = u10_.id 
  LEFT JOIN uv_user_instance u11_ ON u3_.id = u11_.user_id 
  LEFT JOIN uv_user_support_groups u13_ ON u11_.id = u13_.userInstanceId 
  LEFT JOIN uv_support_group u12_ ON u12_.id = u13_.supportGroupId 
  LEFT JOIN uv_tickets_labels u15_ ON u0_.id = u15_.ticket_id 
  LEFT JOIN uv_support_label u14_ ON u14_.id = u15_.label_id 
  LEFT JOIN uv_user_instance u16_ ON u6_.id = u16_.user_id 
  LEFT JOIN uv_support_group u17_ ON u6_.idor = u17_.id 
  LEFT JOIN uv_user_instance u18_ ON (u18_.id = ?) 
  LEFT JOIN uv_user_support_groups u20_ ON u18_.id = u20_.userInstanceId 
  LEFT JOIN uv_support_group u19_ ON u19_.id = u20_.supportGroupId 
WHERE 
  u16_.supportRole_id = 4 
  AND (
    u3_.id IS NULL 
    OR u11_.supportRole_id <> 4
  ) 
  AND u17_.id = u19_.id 
  AND u0_.is_trashed = ? 
GROUP BY 
  u1_.id

SELECT COUNT(DISTINCT u0_.id) AS sclr_0, u1_.id AS id_1, u1_.code AS code_2 FROM uv_ticket u0_ LEFT JOIN uv_ticket_type u2_ ON u0_.type_id = u2_.id LEFT JOIN uv_user u3_ ON u0_.agent_id = u3_.id LEFT JOIN uv_ticket_status u1_ ON u0_.status_id = u1_.id LEFT JOIN uv_thread u4_ ON u0_.id = u4_.ticket_id LEFT JOIN uv_ticket_priority u5_ ON u0_.priority_id = u5_.id LEFT JOIN uv_user u6_ ON u0_.customer_id = u6_.id LEFT JOIN uv_support_team u7_ ON u0_.subGroup_id = u7_.id LEFT JOIN uv_tickets_tags u9_ ON u0_.id = u9_.ticket_id LEFT JOIN uv_tag u8_ ON u8_.id = u9_.tag_id LEFT JOIN uv_support_group u10_ ON u0_.group_id = u10_.id LEFT JOIN uv_user_instance u11_ ON u3_.id = u11_.user_id LEFT JOIN uv_user_support_groups u13_ ON u11_.id = u13_.userInstanceId LEFT JOIN uv_support_group u12_ ON u12_.id = u13_.supportGroupId LEFT JOIN uv_tickets_labels u15_ ON u0_.id = u15_.ticket_id LEFT JOIN uv_support_label u14_ ON u14_.id = u15_.label_id LEFT JOIN uv_user_instance u16_ ON u6_.id = u16_.user_id LEFT JOIN uv_support_group u17_ ON u6_.idor = u17_.id LEFT JOIN uv_user_instance u18_ ON (u18_.id = 44) LEFT JOIN uv_user_support_groups u20_ ON u18_.id = u20_.userInstanceId LEFT JOIN uv_support_group u19_ ON u19_.id = u20_.supportGroupId WHERE u16_.supportRole_id = 4 AND (u3_.id IS NULL OR u11_.supportRole_id <> 4) AND u17_.id = u19_.id AND u0_.is_trashed = 0 GROUP BY u1_.id;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1 
  AND u1_.id = ?

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1 AND u1_.id = 39;

SELECT 
  DISTINCT u0_.id AS id_0, 
  u0_.updated_at AS updated_at_1 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_ticket_type u1_ ON u0_.type_id = u1_.id 
  LEFT JOIN uv_user u2_ ON u0_.agent_id = u2_.id 
  LEFT JOIN uv_thread u3_ ON u0_.id = u3_.ticket_id 
  LEFT JOIN uv_ticket_priority u4_ ON u0_.priority_id = u4_.id 
  LEFT JOIN uv_ticket_status u5_ ON u0_.status_id = u5_.id 
  LEFT JOIN uv_user u6_ ON u0_.customer_id = u6_.id 
  LEFT JOIN uv_support_group u7_ ON u6_.idor = u7_.id 
  LEFT JOIN uv_support_team u8_ ON u0_.subGroup_id = u8_.id 
  LEFT JOIN uv_tickets_tags u10_ ON u0_.id = u10_.ticket_id 
  LEFT JOIN uv_tag u9_ ON u9_.id = u10_.tag_id 
  LEFT JOIN uv_user_instance u11_ ON u2_.id = u11_.user_id 
  LEFT JOIN uv_user_support_groups u13_ ON u11_.id = u13_.userInstanceId 
  LEFT JOIN uv_support_group u12_ ON u12_.id = u13_.supportGroupId 
  LEFT JOIN uv_tickets_labels u15_ ON u0_.id = u15_.ticket_id 
  LEFT JOIN uv_support_label u14_ ON u14_.id = u15_.label_id 
  LEFT JOIN uv_support_group u16_ ON u0_.group_id = u16_.id 
  LEFT JOIN uv_user_instance u17_ ON u6_.id = u17_.user_id 
  LEFT JOIN uv_ticket_subtype u18_ ON u0_.subtype_id = u18_.id 
  LEFT JOIN uv_user_instance u19_ ON (u19_.id = ?) 
  LEFT JOIN uv_user_support_groups u21_ ON u19_.id = u21_.userInstanceId 
  LEFT JOIN uv_support_group u20_ ON u20_.id = u21_.supportGroupId 
WHERE 
  u17_.supportRole_id = 4 
  AND (
    u2_.id IS NULL 
    OR u11_.supportRole_id <> 4
  ) 
  AND u0_.is_trashed = ? 
  AND u7_.id = u20_.id 
  AND u0_.status_id = ? 
ORDER BY 
  u0_.updated_at DESC 
LIMIT 
  15

SELECT DISTINCT u0_.id AS id_0, u0_.updated_at AS updated_at_1 FROM uv_ticket u0_ LEFT JOIN uv_ticket_type u1_ ON u0_.type_id = u1_.id LEFT JOIN uv_user u2_ ON u0_.agent_id = u2_.id LEFT JOIN uv_thread u3_ ON u0_.id = u3_.ticket_id LEFT JOIN uv_ticket_priority u4_ ON u0_.priority_id = u4_.id LEFT JOIN uv_ticket_status u5_ ON u0_.status_id = u5_.id LEFT JOIN uv_user u6_ ON u0_.customer_id = u6_.id LEFT JOIN uv_support_group u7_ ON u6_.idor = u7_.id LEFT JOIN uv_support_team u8_ ON u0_.subGroup_id = u8_.id LEFT JOIN uv_tickets_tags u10_ ON u0_.id = u10_.ticket_id LEFT JOIN uv_tag u9_ ON u9_.id = u10_.tag_id LEFT JOIN uv_user_instance u11_ ON u2_.id = u11_.user_id LEFT JOIN uv_user_support_groups u13_ ON u11_.id = u13_.userInstanceId LEFT JOIN uv_support_group u12_ ON u12_.id = u13_.supportGroupId LEFT JOIN uv_tickets_labels u15_ ON u0_.id = u15_.ticket_id LEFT JOIN uv_support_label u14_ ON u14_.id = u15_.label_id LEFT JOIN uv_support_group u16_ ON u0_.group_id = u16_.id LEFT JOIN uv_user_instance u17_ ON u6_.id = u17_.user_id LEFT JOIN uv_ticket_subtype u18_ ON u0_.subtype_id = u18_.id LEFT JOIN uv_user_instance u19_ ON (u19_.id = 44) LEFT JOIN uv_user_support_groups u21_ ON u19_.id = u21_.userInstanceId LEFT JOIN uv_support_group u20_ ON u20_.id = u21_.supportGroupId WHERE u17_.supportRole_id = 4 AND (u2_.id IS NULL OR u11_.supportRole_id <> 4) AND u0_.is_trashed = 0 AND u7_.id = u20_.id AND u0_.status_id = '1' ORDER BY u0_.updated_at DESC LIMIT 15;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1 
  AND u0_.is_replied = 0

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1 AND u0_.is_replied = 0;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1 
  AND u0_.agent_id IS NULL

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1 AND u0_.agent_id IS NULL;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1 
  AND u0_.is_new = 1

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1 AND u0_.is_new = 1;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed <> 1 
  AND u0_.is_starred = 1

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed <> 1 AND u0_.is_starred = 1;

SELECT 
  u0_.message AS message_0 
FROM 
  uv_ticket u1_ 
  LEFT JOIN uv_thread u0_ ON u1_.id = u0_.ticket_id 
WHERE 
  u1_.id = ? 
ORDER BY 
  u0_.created_at DESC 
LIMIT 
  1

SELECT u0_.message AS message_0 FROM uv_ticket u1_ LEFT JOIN uv_thread u0_ ON u1_.id = u0_.ticket_id WHERE u1_.id = 22610 ORDER BY u0_.created_at DESC LIMIT 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

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 = 'fcanonico@softguard.com' AND (u2_.id = 1 OR u2_.id = 2 OR u2_.id = 3) LIMIT 1;

SELECT 
  COUNT(u0_.id) AS sclr_0 
FROM 
  uv_ticket u1_ 
  LEFT JOIN uv_thread u0_ ON u1_.id = u0_.ticket_id 
WHERE 
  u1_.id = ? 
  AND u0_.thread_type = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM uv_ticket u1_ LEFT JOIN uv_thread u0_ ON u1_.id = u0_.ticket_id WHERE u1_.id = 22610 AND u0_.thread_type = 'reply';

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id 
WHERE 
  u0_.is_trashed = 1 
  AND u1_.id = 39

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_ticket u0_ LEFT JOIN uv_user u1_ ON u0_.agent_id = u1_.id WHERE u0_.is_trashed = 1 AND u1_.id = 39;

SELECT 
  DISTINCT u0_.name AS name_0, 
  u1_.name AS name_1, 
  u2_.code AS code_2, 
  u3_.id AS id_3, 
  u3_.email AS email_4, 
  u4_.profile_image_path AS profile_image_path_5, 
  u5_.id AS id_6, 
  u5_.email AS email_7, 
  u5_.es_ultra AS es_ultra_8, 
  u5_.timezone AS timezone_9, 
  u6_.profile_image_path AS profile_image_path_10, 
  u5_.first_name AS first_name_11, 
  CONCAT(
    u3_.first_name, ' ', u3_.last_name
  ) AS sclr_12, 
  u7_.id AS id_13, 
  u7_.numeracion AS numeracion_14, 
  u7_.source AS source_15, 
  u7_.mailbox_email AS mailbox_email_16, 
  u7_.subject AS subject_17, 
  u7_.reference AS reference_18, 
  u7_.reference_ids AS reference_ids_19, 
  u7_.is_new AS is_new_20, 
  u7_.is_replied AS is_replied_21, 
  u7_.is_reply_enabled AS is_reply_enabled_22, 
  u7_.is_starred AS is_starred_23, 
  u7_.is_trashed AS is_trashed_24, 
  u7_.is_agent_viewed AS is_agent_viewed_25, 
  u7_.is_customer_viewed AS is_customer_viewed_26, 
  u7_.created_at AS created_at_27, 
  u7_.updated_at AS updated_at_28, 
  u7_.codigo_series AS codigo_series_29, 
  u7_.business_impact AS business_impact_30, 
  u7_.whatsapp AS whatsapp_31, 
  u7_.url_plataforma AS url_plataforma_32, 
  u8_.id AS id_33, 
  u8_.code AS code_34, 
  u8_.description AS description_35, 
  u8_.color_code AS color_code_36, 
  u9_.id AS id_37, 
  u9_.code AS code_38, 
  u9_.description AS description_39, 
  u9_.color_code AS color_code_40, 
  u9_.sort_order AS sort_order_41, 
  u10_.id AS id_42, 
  u10_.name AS name_43, 
  u10_.description AS description_44, 
  u10_.created_at AS created_at_45, 
  u10_.is_active AS is_active_46, 
  u10_.user_view AS user_view_47, 
  u11_.id AS id_48, 
  u11_.name AS name_49, 
  u11_.description AS description_50, 
  u11_.created_at AS created_at_51, 
  u11_.is_active AS is_active_52, 
  u11_.user_view AS user_view_53, 
  u12_.id AS id_54, 
  u12_.code AS code_55, 
  u12_.description AS description_56, 
  u12_.created_at AS created_at_57 
FROM 
  uv_ticket u7_ 
  LEFT JOIN uv_ticket_type u2_ ON u7_.type_id = u2_.id 
  LEFT JOIN uv_user u3_ ON u7_.agent_id = u3_.id 
  LEFT JOIN uv_thread u13_ ON u7_.id = u13_.ticket_id 
  LEFT JOIN uv_ticket_priority u8_ ON u7_.priority_id = u8_.id 
  LEFT JOIN uv_ticket_status u9_ ON u7_.status_id = u9_.id 
  LEFT JOIN uv_user u5_ ON u7_.customer_id = u5_.id 
  LEFT JOIN uv_support_group u10_ ON u5_.idor = u10_.id 
  LEFT JOIN uv_support_team u1_ ON u7_.subGroup_id = u1_.id 
  LEFT JOIN uv_tickets_tags u15_ ON u7_.id = u15_.ticket_id 
  LEFT JOIN uv_tag u14_ ON u14_.id = u15_.tag_id 
  LEFT JOIN uv_user_instance u4_ ON u3_.id = u4_.user_id 
  LEFT JOIN uv_user_support_groups u16_ ON u4_.id = u16_.userInstanceId 
  LEFT JOIN uv_support_group u11_ ON u11_.id = u16_.supportGroupId 
  LEFT JOIN uv_tickets_labels u18_ ON u7_.id = u18_.ticket_id 
  LEFT JOIN uv_support_label u17_ ON u17_.id = u18_.label_id 
  LEFT JOIN uv_support_group u0_ ON u7_.group_id = u0_.id 
  LEFT JOIN uv_user_instance u6_ ON u5_.id = u6_.user_id 
  LEFT JOIN uv_ticket_subtype u12_ ON u7_.subtype_id = u12_.id 
  LEFT JOIN uv_user_instance u19_ ON (u19_.id = ?) 
  LEFT JOIN uv_user_support_groups u21_ ON u19_.id = u21_.userInstanceId 
  LEFT JOIN uv_support_group u20_ ON u20_.id = u21_.supportGroupId 
WHERE 
  u6_.supportRole_id = 4 
  AND (
    u3_.id IS NULL 
    OR u4_.supportRole_id <> 4
  ) 
  AND u7_.is_trashed = ? 
  AND u10_.id = u20_.id 
  AND u7_.status_id = ? 
  AND u7_.id IN (?) 
ORDER BY 
  u7_.updated_at DESC

SELECT DISTINCT u0_.name AS name_0, u1_.name AS name_1, u2_.code AS code_2, u3_.id AS id_3, u3_.email AS email_4, u4_.profile_image_path AS profile_image_path_5, u5_.id AS id_6, u5_.email AS email_7, u5_.es_ultra AS es_ultra_8, u5_.timezone AS timezone_9, u6_.profile_image_path AS profile_image_path_10, u5_.first_name AS first_name_11, CONCAT(u3_.first_name, ' ', u3_.last_name) AS sclr_12, u7_.id AS id_13, u7_.numeracion AS numeracion_14, u7_.source AS source_15, u7_.mailbox_email AS mailbox_email_16, u7_.subject AS subject_17, u7_.reference AS reference_18, u7_.reference_ids AS reference_ids_19, u7_.is_new AS is_new_20, u7_.is_replied AS is_replied_21, u7_.is_reply_enabled AS is_reply_enabled_22, u7_.is_starred AS is_starred_23, u7_.is_trashed AS is_trashed_24, u7_.is_agent_viewed AS is_agent_viewed_25, u7_.is_customer_viewed AS is_customer_viewed_26, u7_.created_at AS created_at_27, u7_.updated_at AS updated_at_28, u7_.codigo_series AS codigo_series_29, u7_.business_impact AS business_impact_30, u7_.whatsapp AS whatsapp_31, u7_.url_plataforma AS url_plataforma_32, u8_.id AS id_33, u8_.code AS code_34, u8_.description AS description_35, u8_.color_code AS color_code_36, u9_.id AS id_37, u9_.code AS code_38, u9_.description AS description_39, u9_.color_code AS color_code_40, u9_.sort_order AS sort_order_41, u10_.id AS id_42, u10_.name AS name_43, u10_.description AS description_44, u10_.created_at AS created_at_45, u10_.is_active AS is_active_46, u10_.user_view AS user_view_47, u11_.id AS id_48, u11_.name AS name_49, u11_.description AS description_50, u11_.created_at AS created_at_51, u11_.is_active AS is_active_52, u11_.user_view AS user_view_53, u12_.id AS id_54, u12_.code AS code_55, u12_.description AS description_56, u12_.created_at AS created_at_57 FROM uv_ticket u7_ LEFT JOIN uv_ticket_type u2_ ON u7_.type_id = u2_.id LEFT JOIN uv_user u3_ ON u7_.agent_id = u3_.id LEFT JOIN uv_thread u13_ ON u7_.id = u13_.ticket_id LEFT JOIN uv_ticket_priority u8_ ON u7_.priority_id = u8_.id LEFT JOIN uv_ticket_status u9_ ON u7_.status_id = u9_.id LEFT JOIN uv_user u5_ ON u7_.customer_id = u5_.id LEFT JOIN uv_support_group u10_ ON u5_.idor = u10_.id LEFT JOIN uv_support_team u1_ ON u7_.subGroup_id = u1_.id LEFT JOIN uv_tickets_tags u15_ ON u7_.id = u15_.ticket_id LEFT JOIN uv_tag u14_ ON u14_.id = u15_.tag_id LEFT JOIN uv_user_instance u4_ ON u3_.id = u4_.user_id LEFT JOIN uv_user_support_groups u16_ ON u4_.id = u16_.userInstanceId LEFT JOIN uv_support_group u11_ ON u11_.id = u16_.supportGroupId LEFT JOIN uv_tickets_labels u18_ ON u7_.id = u18_.ticket_id LEFT JOIN uv_support_label u17_ ON u17_.id = u18_.label_id LEFT JOIN uv_support_group u0_ ON u7_.group_id = u0_.id LEFT JOIN uv_user_instance u6_ ON u5_.id = u6_.user_id LEFT JOIN uv_ticket_subtype u12_ ON u7_.subtype_id = u12_.id LEFT JOIN uv_user_instance u19_ ON (u19_.id = 44) LEFT JOIN uv_user_support_groups u21_ ON u19_.id = u21_.userInstanceId LEFT JOIN uv_support_group u20_ ON u20_.id = u21_.supportGroupId WHERE u6_.supportRole_id = 4 AND (u3_.id IS NULL OR u4_.supportRole_id <> 4) AND u7_.is_trashed = 0 AND u10_.id = u20_.id AND u7_.status_id = '1' AND u7_.id IN ('22610', '22609', '22608', '22607', '22606', '22605', '22604', '22603', '22602', '22601', '22600', '22599', '22598', '22597', '22596') ORDER BY u7_.updated_at DESC;

SELECT 
  COUNT(DISTINCT u0_.id) AS sclr_0, 
  u1_.id AS id_1 
FROM 
  uv_ticket u0_ 
  LEFT JOIN uv_tickets_labels u2_ ON u0_.id = u2_.ticket_id 
  LEFT JOIN uv_support_label u1_ ON u1_.id = u2_.label_id 
WHERE 
  u1_.user_id = ? 
GROUP BY 
  u1_.id

SELECT COUNT(DISTINCT u0_.id) AS sclr_0, u1_.id AS id_1 FROM uv_ticket u0_ LEFT JOIN uv_tickets_labels u2_ ON u0_.id = u2_.ticket_id LEFT JOIN uv_support_label u1_ ON u1_.id = u2_.label_id WHERE u1_.user_id = 39 GROUP BY u1_.id;

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

SELECT 
  u0_.id AS id_0 
FROM 
  uv_user u1_ 
  LEFT JOIN uv_user_instance u2_ ON u1_.id = u2_.user_id 
  LEFT JOIN uv_user_support_groups u3_ ON u2_.id = u3_.userInstanceId 
  LEFT JOIN uv_support_group u0_ ON u0_.id = u3_.supportGroupId 
WHERE 
  u1_.id = ? 
  AND u0_.is_active = 1

SELECT u0_.id AS id_0 FROM uv_user u1_ LEFT JOIN uv_user_instance u2_ ON u1_.id = u2_.user_id LEFT JOIN uv_user_support_groups u3_ ON u2_.id = u3_.userInstanceId LEFT JOIN uv_support_group u0_ ON u0_.id = u3_.supportGroupId WHERE u1_.id = 39 AND u0_.is_active = 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 = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3 FROM uv_support_role t0 WHERE t0.id = 2;

SELECT 
  u0_.id AS id_0 
FROM 
  uv_user u1_ 
  LEFT JOIN uv_user_instance u2_ ON u1_.id = u2_.user_id 
  LEFT JOIN uv_user_support_teams u3_ ON u2_.id = u3_.userInstanceId 
  LEFT JOIN uv_support_team u0_ ON u0_.id = u3_.supportTeamId 
WHERE 
  u1_.id = ? 
  AND u2_.supportRole_id <> ? 
  AND u0_.is_active = 1

SELECT u0_.id AS id_0 FROM uv_user u1_ LEFT JOIN uv_user_instance u2_ ON u1_.id = u2_.user_id LEFT JOIN uv_user_support_teams u3_ ON u2_.id = u3_.userInstanceId LEFT JOIN uv_support_team u0_ ON u0_.id = u3_.supportTeamId WHERE u1_.id = 39 AND u2_.supportRole_id <> '4' AND u0_.is_active = 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 = ?

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

SELECT 
  u0_.id AS id_0, 
  u0_.name AS name_1, 
  u0_.color_code AS color_code_2 
FROM 
  uv_support_label u0_ 
WHERE 
  u0_.user_id = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.color_code AS color_code_2 FROM uv_support_label u0_ WHERE u0_.user_id = 39;