Symfony Profiler

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/financial/benefits-and-challenges-of-web3-in-real-estate' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.description AS description_8,
  t0.main_view AS main_view_9,
  t0.theme AS theme_10,
  t0.orders AS orders_11,
  t0.metakey AS metakey_12,
  t0.metadesc AS metadesc_13,
  t0.canonical AS canonical_14
FROM
  category t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.description AS description_8, t0.main_view AS main_view_9, t0.theme AS theme_10, t0.orders AS orders_11, t0.metakey AS metakey_12, t0.metadesc AS metadesc_13, t0.canonical AS canonical_14 FROM category t0 WHERE t0.slug = 'financial' AND t0.status = 'published' LIMIT 1;

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_.slug = ?
  AND a0_.deleted_at IS NULL
  AND a0_.published_at <= ?
  AND a0_.status = ?
LIMIT
  1

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_.slug = 'benefits-and-challenges-of-web3-in-real-estate' AND a0_.deleted_at IS NULL AND a0_.published_at <= '2025-01-15 10:30:08' AND a0_.status = 'published' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.email AS email_7,
  t0.name AS name_8,
  t0.require_reset AS require_reset_9,
  t0.description AS description_10,
  t0.is_active AS is_active_11,
  t0.disabled_scroll AS disabled_scroll_12,
  t0.networks AS networks_13,
  t0.slug AS slug_14,
  t0.job_title AS job_title_15,
  t0.last_login AS last_login_16,
  t0.ordering AS ordering_17,
  t0.canonical AS canonical_18,
  t0.image_profile_id AS image_profile_id_19
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.email AS email_7, t0.name AS name_8, t0.require_reset AS require_reset_9, t0.description AS description_10, t0.is_active AS is_active_11, t0.disabled_scroll AS disabled_scroll_12, t0.networks AS networks_13, t0.slug AS slug_14, t0.job_title AS job_title_15, t0.last_login AS last_login_16, t0.ordering AS ordering_17, t0.canonical AS canonical_18, t0.image_profile_id AS image_profile_id_19 FROM user t0 WHERE t0.id = 458;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.email AS email_2,
  c0_.website AS website_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.content AS content_6,
  c0_.status AS status_7,
  c0_.replyto AS replyto_8,
  c0_.article_id AS article_id_9
FROM
  COMMENT c0_
WHERE
  c0_.status = ?
  AND c0_.article_id = ?
ORDER BY
  c0_.created_at ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.email AS email_2, c0_.website AS website_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.content AS content_6, c0_.status AS status_7, c0_.replyto AS replyto_8, c0_.article_id AS article_id_9 FROM COMMENT c0_ WHERE c0_.status = 'published' AND c0_.article_id = 16819 ORDER BY c0_.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.url AS url_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  FILE t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = 66904;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  article
SET
  clicks = ?
WHERE
  id = ?

UPDATE article SET clicks = 3496 WHERE id = 16819;

"COMMIT"

"COMMIT";

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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis' AND t0.status = 'published' 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 = ?
  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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderHeader' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.status AS status_6,
  c0_.description AS description_7,
  c0_.main_view AS main_view_8,
  c0_.theme AS theme_9,
  c0_.orders AS orders_10,
  c0_.metakey AS metakey_11,
  c0_.metadesc AS metadesc_12,
  c0_.canonical AS canonical_13
FROM
  category c0_
WHERE
  c0_.status = ?
ORDER BY
  c0_.orders ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = 'published' ORDER BY c0_.orders ASC;

SELECT
  p0_.title AS title_0,
  p0_.slug AS slug_1
FROM
  PAGE p0_
WHERE
  p0_.status = ?
ORDER BY
  p0_.orders ASC

SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = 'published' ORDER BY p0_.orders ASC;

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';

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 = 'twitter' AND s0_.type = 'general';

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 = 'linkedin' AND s0_.type = 'general';

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 = 'youtube' AND s0_.type = 'general';

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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CArticleController%253A%253AtrendingArticle' AND t0.status = 'published' ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.description AS description_8,
  t0.main_view AS main_view_9,
  t0.theme AS theme_10,
  t0.orders AS orders_11,
  t0.metakey AS metakey_12,
  t0.metadesc AS metadesc_13,
  t0.canonical AS canonical_14
FROM
  category t0
WHERE
  t0.name = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.description AS description_8, t0.main_view AS main_view_9, t0.theme AS theme_10, t0.orders AS orders_11, t0.metakey AS metakey_12, t0.metadesc AS metadesc_13, t0.canonical AS canonical_14 FROM category t0 WHERE t0.name = 'Finance';

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_.category_id = ?
  AND a0_.featured = 1
  AND a0_.published_at <= ?
  AND a0_.status = ?
ORDER BY
  a0_.clicks DESC
LIMIT
  5

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_.category_id = 104 AND a0_.featured = 1 AND a0_.published_at <= '2025-01-15 10:30:09' AND a0_.status = 'published' ORDER BY a0_.clicks DESC LIMIT 5;