https://ticketsdemo.softguard.com/public/es/

Query Metrics

301 Database Queries
18 Different statements
179.21 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 13.05 ms
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 = ? LIMIT 1
Parameters:
[
  "administradorsoftguard@suempresa.com"
  4
]
2 0.52 ms
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:
[
  4
]
3 0.69 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.72 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
  true
]
5 4.76 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.content AS content_3, u0_.stared AS stared_4 FROM uv_article u0_ WHERE u0_.status = ? ORDER BY u0_.viewed DESC LIMIT 10
Parameters:
[
  1
]
6 1.60 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.visibility AS visibility_3, u0_.sort_order AS sort_order_4, u0_.date_added AS date_added_5, u0_.date_updated AS date_updated_6, u0_.solution_image AS solution_image_7 FROM uv_solutions u0_ WHERE u0_.visibility = ?
Parameters:
[
  "public"
]
7 1.31 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  1
  [
    1
  ]
]
8 0.74 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  1
  [
    1
  ]
]
9 2.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  1
  1
]
10 0.79 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  9
  1
]
11 0.71 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  2
  1
]
12 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  15
  1
]
13 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  17
  1
]
14 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  18
  1
]
15 0.62 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  92
  1
]
16 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  14
  1
]
17 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  13
  1
]
18 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  16
  1
]
19 0.68 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  24
  1
]
20 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  20
  1
]
21 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  11
  1
]
22 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  30
  1
]
23 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  93
  1
]
24 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  22
  1
]
25 0.67 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  25
  1
]
26 0.64 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  19
  1
]
27 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  94
  1
]
28 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  26
  1
]
29 0.64 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  21
  1
]
30 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  29
  1
]
31 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  27
  1
]
32 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  12
  1
]
33 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  28
  1
]
34 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  83
  1
]
35 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  10
  1
]
36 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  23
  1
]
37 0.63 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  80
  1
]
38 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  89
  1
]
39 1.19 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  1
  0
]
40 0.58 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  2
  [
    1
  ]
]
41 0.62 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  2
  [
    1
  ]
]
42 0.71 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  56
  1
]
43 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  58
  1
]
44 0.63 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  57
  1
]
45 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  76
  1
]
46 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  69
  1
]
47 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  77
  1
]
48 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  66
  1
]
49 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  64
  1
]
50 1.54 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  68
  1
]
51 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  73
  1
]
52 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  70
  1
]
53 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  60
  1
]
54 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  79
  1
]
55 0.66 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  71
  1
]
56 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  74
  1
]
57 0.68 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  78
  1
]
58 0.99 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  62
  1
]
59 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  65
  1
]
60 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  59
  1
]
61 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  75
  1
]
62 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  61
  1
]
63 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  67
  1
]
64 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  84
  1
]
65 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  63
  1
]
66 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  72
  1
]
67 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  81
  1
]
68 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  90
  1
]
69 1.00 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  2
  0
]
70 0.55 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  3
  [
    1
  ]
]
71 0.59 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  3
  [
    1
  ]
]
72 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  32
  1
]
73 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  33
  1
]
74 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  31
  1
]
75 0.62 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  44
  1
]
76 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  35
  1
]
77 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  36
  1
]
78 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  42
  1
]
79 0.65 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  39
  1
]
80 0.63 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  45
  1
]
81 0.62 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  50
  1
]
82 0.61 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  47
  1
]
83 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  55
  1
]
84 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  40
  1
]
85 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  48
  1
]
86 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  51
  1
]
87 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  46
  1
]
88 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  52
  1
]
89 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  41
  1
]
90 0.55 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  54
  1
]
91 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  53
  1
]
92 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  37
  1
]
93 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  43
  1
]
94 0.62 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  87
  1
]
95 0.56 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  34
  1
]
96 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  88
  1
]
97 0.54 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  82
  1
]
98 0.57 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  91
  1
]
99 0.80 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  3
  0
]
100 0.55 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  4
  [
    1
  ]
]
101 0.58 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  4
  [
    1
  ]
]
102 0.60 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  97
  1
]
103 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  98
  1
]
104 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  99
  1
]
105 0.77 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  4
  0
]
106 0.53 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  5
  [
    1
  ]
]
107 0.54 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  5
  [
    1
  ]
]
108 0.59 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  85
  1
]
109 0.74 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  5
  0
]
110 0.53 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM uv_solutions u0_ LEFT JOIN uv_solution_category_mapping u1_ ON (u1_.solution_id = u0_.id) LEFT JOIN uv_solution_category u2_ ON (u1_.category_id = u2_.id) WHERE u1_.solution_id = ? AND u2_.status IN (?)
Parameters:
[
  6
  [
    1
  ]
]
111 0.53 ms
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_solution_category u0_ ON (u2_.category_id = u0_.id) WHERE u2_.solution_id = ? AND u0_.status IN (?) ORDER BY u0_.sort_order ASC
Parameters:
[
  6
  [
    1
  ]
]
112 0.58 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solution_category u1_ LEFT JOIN uv_article_category u0_ ON (u0_.category_id = u1_.id) LEFT JOIN uv_article u2_ ON (u0_.article_id = u2_.id) WHERE u0_.category_id = ? AND u2_.status IN (?)
Parameters:
[
  96
  1
]
113 0.70 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM uv_solutions u1_ LEFT JOIN uv_solution_category_mapping u2_ ON (u2_.solution_id = u1_.id) LEFT JOIN uv_article_category u3_ ON (u2_.category_id = u3_.category_id) LEFT JOIN uv_article u0_ ON (u3_.article_id = u0_.id) WHERE u2_.solution_id = ? AND u3_.id IS NOT NULL AND u0_.status <> ?
Parameters:
[
  6
  0
]
114 0.57 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2 FROM uv_solution_category u0_ WHERE u0_.status = ? ORDER BY u0_.date_added DESC
Parameters:
[
  1
]
115 0.52 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  99
]
116 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    299
  ]
]
117 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  98
]
118 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    297
  ]
]
119 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  97
]
120 0.47 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    296
    298
    300
  ]
]
121 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  96
]
122 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    294
  ]
]
123 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  94
]
124 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    293
  ]
]
125 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  93
]
126 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    290
  ]
]
127 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  92
]
128 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    286
  ]
]
129 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  91
]
130 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
131 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  90
]
132 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
133 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  89
]
134 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    275
  ]
]
135 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  56
]
136 0.70 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    94
    95
    114
    107
    141
    142
    143
    146
    147
    150
    153
    155
    156
    157
    158
    160
    163
    164
    166
    168
    169
    171
    172
    173
    174
    183
    185
    187
    188
    203
    207
    209
    212
    213
    242
    250
    256
    257
    258
    292
    318
  ]
]
137 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  77
]
138 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
139 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  88
]
140 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
141 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  55
]
142 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
143 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  87
]
144 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
145 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  53
]
146 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
147 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  48
]
148 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
149 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  41
]
150 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
151 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  47
]
152 0.48 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    312
    313
  ]
]
153 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  52
]
154 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    260
  ]
]
155 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  43
]
156 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
157 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  40
]
158 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
159 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  50
]
160 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
161 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  39
]
162 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
163 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  45
]
164 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
165 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  51
]
166 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
167 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  37
]
168 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
169 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  42
]
170 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
171 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  54
]
172 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
173 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  34
]
174 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
175 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  44
]
176 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    271
  ]
]
177 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  31
]
178 0.40 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
179 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  33
]
180 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
181 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  81
]
182 0.50 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    103
    121
    122
    123
    124
    246
    259
    261
    263
    328
    329
  ]
]
183 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  72
]
184 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    241
  ]
]
185 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  63
]
186 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
187 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  84
]
188 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    198
  ]
]
189 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  67
]
190 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    113
  ]
]
191 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  61
]
192 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
193 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  75
]
194 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    232
  ]
]
195 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  59
]
196 0.40 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
197 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  65
]
198 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    244
  ]
]
199 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  62
]
200 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
201 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  78
]
202 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
203 0.53 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  74
]
204 0.48 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    105
    214
    266
  ]
]
205 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  71
]
206 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    101
  ]
]
207 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  79
]
208 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
209 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  60
]
210 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    111
  ]
]
211 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  70
]
212 0.48 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    102
    106
    215
  ]
]
213 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  73
]
214 0.48 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    161
    162
    201
    236
    251
    252
    254
  ]
]
215 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  68
]
216 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
217 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  64
]
218 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
219 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  66
]
220 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
221 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  69
]
222 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    98
  ]
]
223 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  76
]
224 0.47 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    99
    115
    176
    249
    255
  ]
]
225 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  57
]
226 0.53 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    96
    97
    110
    112
    170
    178
    211
    232
    236
    245
    251
    252
    253
    254
    262
    154
    265
    317
  ]
]
227 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  58
]
228 0.52 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    100
    104
    108
    109
    180
    167
    211
    236
    251
    252
    254
    264
    248
    314
    317
  ]
]
229 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  80
]
230 0.55 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    118
    119
    120
    208
    210
    216
    217
    218
    223
    227
    247
    287
    289
    295
    165
    199
    326
    327
  ]
]
231 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  23
]
232 0.94 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    71
  ]
]
233 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  83
]
234 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    145
    226
  ]
]
235 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  28
]
236 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    90
    206
  ]
]
237 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  12
]
238 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    48
  ]
]
239 0.45 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  27
]
240 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    89
  ]
]
241 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  29
]
242 0.45 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    91
    240
  ]
]
243 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  21
]
244 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    65
  ]
]
245 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  26
]
246 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    88
  ]
]
247 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  19
]
248 0.45 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    57
    58
    59
  ]
]
249 0.51 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  25
]
250 0.48 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    86
    87
    125
    291
    321
    322
  ]
]
251 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  22
]
252 0.49 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    66
    67
    68
    69
    70
    277
    281
    283
    284
  ]
]
253 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  11
]
254 0.45 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    46
    47
  ]
]
255 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  20
]
256 0.49 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    60
    61
    62
    63
    64
    127
    220
    267
    328
  ]
]
257 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  24
]
258 0.59 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    49
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    126
    128
    129
    131
    274
    303
  ]
]
259 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  16
]
260 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    225
  ]
]
261 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  13
]
262 0.45 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    50
  ]
]
263 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  10
]
264 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    308
  ]
]
265 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  30
]
266 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    92
    93
  ]
]
267 0.47 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  14
]
268 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    51
  ]
]
269 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  18
]
270 0.44 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    56
    235
  ]
]
271 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  17
]
272 0.45 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    55
  ]
]
273 0.50 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  15
]
274 0.49 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    17
    33
    52
    53
    54
    130
    192
    268
  ]
]
275 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  2
]
276 0.73 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    1
    2
    3
    14
    15
    16
    18
    21
    22
    23
    24
    26
    27
    28
    29
    30
    31
    25
    126
    128
    129
    130
    131
    140
    145
    175
    184
    189
    221
    231
    233
    267
    268
    274
    278
    279
    280
    282
    285
    288
    301
    302
    307
    309
    310
    311
    320
  ]
]
277 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  9
]
278 0.73 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    32
    34
    35
    25
    36
    37
    38
    39
    40
    27
    41
    42
    43
    44
    45
    126
    128
    129
    131
    133
    132
    151
    152
    177
    181
    194
    195
    196
    197
    219
    221
    228
    229
    230
    231
    233
    235
    243
    222
    301
    306
    307
    309
    310
    311
    320
  ]
]
279 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  85
]
280 0.47 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    269
    270
    276
    305
    324
    325
  ]
]
281 0.48 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  82
]
282 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
283 0.44 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  46
]
284 0.42 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
285 0.50 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  36
]
286 0.41 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
287 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  35
]
288 0.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    0
  ]
]
289 0.46 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  32
]
290 0.46 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    116
    117
    272
    315
  ]
]
291 0.49 ms
SELECT u0_.article_id AS article_id_0 FROM uv_article_category u0_ WHERE u0_.category_id = ?
Parameters:
[
  1
]
292 0.67 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    5
    6
    7
    8
    9
    10
    11
    12
    13
    19
    20
    133
    132
    134
    135
    136
    137
    138
    139
    144
    148
    149
    159
    179
    182
    186
    190
    191
    193
    200
    202
    204
    205
    224
    234
    237
    238
    239
    316
    319
    323
  ]
]
293 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.visibility AS visibility_4, t0.sort_order AS sort_order_5, t0.date_added AS date_added_6, t0.date_updated AS date_updated_7, t0.solution_image AS solution_image_8 FROM uv_solutions t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
294 0.72 ms
SELECT DISTINCT u0_.article_id AS article_id_0 FROM uv_solution_category_mapping u1_ LEFT JOIN uv_article_category u0_ ON (u1_.category_id = u0_.category_id) WHERE u1_.solution_id = ?
Parameters:
[
  5
]
295 0.53 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.stared AS stared_3 FROM uv_article u0_ WHERE u0_.status = ? AND u0_.id IN (?)
Parameters:
[
  1
  [
    325
    324
    305
    276
    270
    269
    273
  ]
]
296 0.60 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"
]
297 0.46 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"
]
298 0.60 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
]
299 0.44 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"
]
300 0.54 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 = ? LIMIT 1
Parameters:
[
  2
]
301 0.85 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, CONCAT(u0_.first_name, ' ', COALESCE(u0_.last_name, '')) AS sclr_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u1_.contact_number AS contact_number_5, u1_.profile_image_path AS profile_image_path_6, u1_.profile_image_path AS profile_image_path_7 FROM uv_user u0_ LEFT JOIN uv_user_instance u1_ ON u0_.id = u1_.user_id WHERE u1_.supportRole_id = ? AND u0_.id = ?
Parameters:
[
  4
  1112
]

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\SupportCenterBundle\Entity\Article No errors.
Webkul\UVDesk\SupportCenterBundle\Entity\Solutions No errors.
Webkul\UVDesk\SupportCenterBundle\Entity\SolutionCategory No errors.