Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE t0.slug = 'bhp' LIMIT 1;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_category a1_ ON a1_.id = a2_.category_id
WHERE
  (
    a0_.is_active = ?
    AND a1_.id IN (?)
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id IN (0x019CFBC1220B75E4B61881ED79770E60)) AND a0_.type IN ('audio', 'download', 'text', 'video');

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  article a0_
  INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_category a1_ ON a1_.id = a2_.category_id
WHERE
  (
    a0_.is_active = ?
    AND a1_.id IN (?)
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
ORDER BY
  a0_.created_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id IN (0x019CFBC1220B75E4B61881ED79770E60)) AND a0_.type IN ('audio', 'download', 'text', 'video') ORDER BY a0_.created_at DESC LIMIT 12;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_is_no_index AS seo_is_no_index_13,
  a0_.description AS description_14,
  a0_.description AS description_15,
  a0_.lead AS lead_16,
  a0_.content AS content_17,
  a0_.video_url AS video_url_18,
  a0_.description AS description_19,
  a0_.type AS type_20,
  a0_.image_id AS image_id_21,
  a0_.created_by_id AS created_by_id_22,
  a0_.updated_by_id AS updated_by_id_23,
  a0_.audio_id AS audio_id_24,
  a0_.file_id AS file_id_25
FROM
  article a0_
  INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN article_category a1_ ON a1_.id = a2_.category_id
WHERE
  (
    a0_.is_active = ?
    AND a1_.id IN (?)
    AND a0_.id IN (?)
  )
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_is_no_index AS seo_is_no_index_13, a0_.description AS description_14, a0_.description AS description_15, a0_.lead AS lead_16, a0_.content AS content_17, a0_.video_url AS video_url_18, a0_.description AS description_19, a0_.type AS type_20, a0_.image_id AS image_id_21, a0_.created_by_id AS created_by_id_22, a0_.updated_by_id AS updated_by_id_23, a0_.audio_id AS audio_id_24, a0_.file_id AS file_id_25 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id IN (0x019CFBC1220B75E4B61881ED79770E60) AND a0_.id IN (0x019CFBC1743C7E9D856D051BE4D9F39C)) AND a0_.type IN ('audio', 'download', 'text', 'video') ORDER BY a0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.is_active AS is_active_1,
  a0_.name AS name_2,
  a0_.slug AS slug_3,
  a0_.icon AS icon_4,
  a0_.color AS color_5,
  a0_.short_body AS short_body_6,
  a0_.body AS body_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.image_id AS image_id_10,
  a0_.desktop_banner_id AS desktop_banner_id_11,
  a0_.mobile_banner_id AS mobile_banner_id_12,
  a0_.created_by_id AS created_by_id_13,
  a0_.updated_by_id AS updated_by_id_14,
  a0_.parent_id AS parent_id_15
FROM
  article_category a0_
WHERE
  a0_.parent_id IS NULL
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1;

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.icon AS icon_4,
  c0_.color AS color_5,
  c0_.short_body AS short_body_6,
  c0_.body AS body_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.image_id AS image_id_10,
  c0_.desktop_banner_id AS desktop_banner_id_11,
  c0_.mobile_banner_id AS mobile_banner_id_12,
  c0_.created_by_id AS created_by_id_13,
  c0_.updated_by_id AS updated_by_id_14,
  c0_.parent_id AS parent_id_15
FROM
  course_category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019AD9490EC27E0FA2CE996C99855032);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADA17C2D3754DA2101B4399091AB3);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADEBFB4547A709C11A714B6197416);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADEC02F4F7F0780D2C3023AEB4E27);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADEC077E87686B8B8D2E45442F307);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADEC0AB317600BBFA6ED07A56EBD3);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ADEC0DC7C7A09B5629A8E5178D54F);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019CFAEA4C7977B0B810650F3BFCB76B);