Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.introtext AS introtext_3,
  a0_.content AS content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.status AS status_8,
  a0_.featured AS featured_9,
  a0_.main_view AS main_view_10,
  a0_.clicks AS clicks_11,
  a0_.reviewed_at AS reviewed_at_12,
  a0_.metakey AS metakey_13,
  a0_.metadesc AS metadesc_14,
  a0_.robots AS robots_15,
  a0_.published_at AS published_at_16,
  a0_.canonical AS canonical_17,
  a0_.super_tag AS super_tag_18,
  c1_.id AS id_19,
  c1_.name AS name_20,
  c1_.slug AS slug_21,
  c1_.created_at AS created_at_22,
  c1_.updated_at AS updated_at_23,
  c1_.deleted_at AS deleted_at_24,
  c1_.status AS status_25,
  c1_.description AS description_26,
  c1_.main_view AS main_view_27,
  c1_.theme AS theme_28,
  c1_.orders AS orders_29,
  c1_.metakey AS metakey_30,
  c1_.metadesc AS metadesc_31,
  c1_.canonical AS canonical_32,
  f2_.id AS id_33,
  f2_.description AS description_34,
  f2_.url AS url_35,
  f2_.created_at AS created_at_36,
  f2_.updated_at AS updated_at_37,
  a0_.user_id AS user_id_38,
  a0_.category_id AS category_id_39,
  a0_.image_card_id AS image_card_id_40,
  a0_.image_header_id AS image_header_id_41
FROM
  article a0_
  LEFT JOIN category c1_ ON a0_.category_id = c1_.id
  LEFT JOIN FILE f2_ ON a0_.image_card_id = f2_.id
WHERE
  a0_.reviewed_at IS NOT NULL
  AND a0_.main_view = ?
  AND a0_.status = ?
  AND a0_.published_at <= ?
ORDER BY
  a0_.published_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, c1_.id AS id_19, c1_.name AS name_20, c1_.slug AS slug_21, c1_.created_at AS created_at_22, c1_.updated_at AS updated_at_23, c1_.deleted_at AS deleted_at_24, c1_.status AS status_25, c1_.description AS description_26, c1_.main_view AS main_view_27, c1_.theme AS theme_28, c1_.orders AS orders_29, c1_.metakey AS metakey_30, c1_.metadesc AS metadesc_31, c1_.canonical AS canonical_32, f2_.id AS id_33, f2_.description AS description_34, f2_.url AS url_35, f2_.created_at AS created_at_36, f2_.updated_at AS updated_at_37, a0_.user_id AS user_id_38, a0_.category_id AS category_id_39, a0_.image_card_id AS image_card_id_40, a0_.image_header_id AS image_header_id_41 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN FILE f2_ ON a0_.image_card_id = f2_.id WHERE a0_.reviewed_at IS NOT NULL AND a0_.main_view = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' ORDER BY a0_.published_at DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.introtext AS introtext_3,
  a0_.content AS content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.status AS status_8,
  a0_.featured AS featured_9,
  a0_.main_view AS main_view_10,
  a0_.clicks AS clicks_11,
  a0_.reviewed_at AS reviewed_at_12,
  a0_.metakey AS metakey_13,
  a0_.metadesc AS metadesc_14,
  a0_.robots AS robots_15,
  a0_.published_at AS published_at_16,
  a0_.canonical AS canonical_17,
  a0_.super_tag AS super_tag_18,
  a0_.user_id AS user_id_19,
  a0_.category_id AS category_id_20,
  a0_.image_card_id AS image_card_id_21,
  a0_.image_header_id AS image_header_id_22
FROM
  article a0_
WHERE
  a0_.reviewed_at IS NOT NULL
  AND a0_.category_id IS NOT NULL
  AND a0_.featured = ?
  AND a0_.status = ?
  AND a0_.published_at <= ?
ORDER BY
  a0_.published_at DESC
LIMIT
  9

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.featured = 1 AND a0_.status = 'published' AND a0_.published_at <= '2025-01-14 14:52:36' ORDER BY a0_.published_at DESC LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.original_url AS original_url_2,
  t0.redirection_url AS redirection_url_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  redirection t0
WHERE
  t0.original_url = ?
  AND t0.status = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.value AS value_2,
  s0_.type AS type_3
FROM
  setting s0_
WHERE
  s0_.name = ?
  AND s0_.type = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = 'facebook' AND s0_.type = 'general';