Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.number AS number_3,
  t0.page_start AS page_start_4,
  t0.page_end AS page_end_5,
  t0.abstract AS abstract_6,
  t0.full_text AS full_text_7,
  t0.keywords AS keywords_8,
  t0.description AS description_9,
  t0.doi AS doi_10,
  t0.published AS published_11,
  t0.publication_date AS publication_date_12,
  t0.publication_year AS publication_year_13,
  t0.pdf AS pdf_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.deleted AS deleted_17,
  t0.deleted_at AS deleted_at_18,
  t0.journal_id AS journal_id_19,
  t20.id AS id_21,
  t20.title AS title_22,
  t20.abbreviation AS abbreviation_23,
  t20.url AS url_24,
  t20.issn AS issn_25,
  t20.doi AS doi_26,
  t20.ceased AS ceased_27,
  t20.email AS email_28,
  t20.cover_image AS cover_image_29,
  t20.created AS created_30,
  t20.updated AS updated_31,
  t20.deleted AS deleted_32,
  t20.deleted_at AS deleted_at_33,
  t20.group_id AS group_id_34,
  t0.article_type_id AS article_type_id_35,
  t36.id AS id_37,
  t36.name AS name_38,
  t36.created AS created_39,
  t36.updated AS updated_40,
  t36.deleted AS deleted_41,
  t36.deleted_at AS deleted_at_42,
  t43.id AS id_44,
  t43.downloaded AS downloaded_45,
  t43.printed AS printed_46,
  t43.shared AS shared_47,
  t43.viewed AS viewed_48,
  t43.created AS created_49,
  t43.updated AS updated_50,
  t43.article_id AS article_id_51
FROM
  articles t0
  INNER JOIN journals t20 ON t0.journal_id = t20.id
  LEFT JOIN article_types t36 ON t0.article_type_id = t36.id
  LEFT JOIN article_analytics t43 ON t43.article_id = t0.id
WHERE
  t0.number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.page_start AS page_start_4, t0.page_end AS page_end_5, t0.abstract AS abstract_6, t0.full_text AS full_text_7, t0.keywords AS keywords_8, t0.description AS description_9, t0.doi AS doi_10, t0.published AS published_11, t0.publication_date AS publication_date_12, t0.publication_year AS publication_year_13, t0.pdf AS pdf_14, t0.created AS created_15, t0.updated AS updated_16, t0.deleted AS deleted_17, t0.deleted_at AS deleted_at_18, t0.journal_id AS journal_id_19, t20.id AS id_21, t20.title AS title_22, t20.abbreviation AS abbreviation_23, t20.url AS url_24, t20.issn AS issn_25, t20.doi AS doi_26, t20.ceased AS ceased_27, t20.email AS email_28, t20.cover_image AS cover_image_29, t20.created AS created_30, t20.updated AS updated_31, t20.deleted AS deleted_32, t20.deleted_at AS deleted_at_33, t20.group_id AS group_id_34, t0.article_type_id AS article_type_id_35, t36.id AS id_37, t36.name AS name_38, t36.created AS created_39, t36.updated AS updated_40, t36.deleted AS deleted_41, t36.deleted_at AS deleted_at_42, t43.id AS id_44, t43.downloaded AS downloaded_45, t43.printed AS printed_46, t43.shared AS shared_47, t43.viewed AS viewed_48, t43.created AS created_49, t43.updated AS updated_50, t43.article_id AS article_id_51 FROM articles t0 INNER JOIN journals t20 ON t0.journal_id = t20.id LEFT JOIN article_types t36 ON t0.article_type_id = t36.id LEFT JOIN article_analytics t43 ON t43.article_id = t0.id WHERE t0.number = '3081790824022019' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.deleted AS deleted_5,
  t0.deleted_at AS deleted_at_6
FROM
  journal_groups t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6 FROM journal_groups t0 WHERE t0.id IN ('065ae945-8adf-42b7-b67c-69f2f8180043');

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.number AS number_3,
  t0.page_start AS page_start_4,
  t0.page_end AS page_end_5,
  t0.abstract AS abstract_6,
  t0.full_text AS full_text_7,
  t0.keywords AS keywords_8,
  t0.description AS description_9,
  t0.doi AS doi_10,
  t0.published AS published_11,
  t0.publication_date AS publication_date_12,
  t0.publication_year AS publication_year_13,
  t0.pdf AS pdf_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.deleted AS deleted_17,
  t0.deleted_at AS deleted_at_18,
  t0.journal_id AS journal_id_19,
  t20.id AS id_21,
  t20.title AS title_22,
  t20.abbreviation AS abbreviation_23,
  t20.url AS url_24,
  t20.issn AS issn_25,
  t20.doi AS doi_26,
  t20.ceased AS ceased_27,
  t20.email AS email_28,
  t20.cover_image AS cover_image_29,
  t20.created AS created_30,
  t20.updated AS updated_31,
  t20.deleted AS deleted_32,
  t20.deleted_at AS deleted_at_33,
  t20.group_id AS group_id_34,
  t0.article_type_id AS article_type_id_35,
  t36.id AS id_37,
  t36.name AS name_38,
  t36.created AS created_39,
  t36.updated AS updated_40,
  t36.deleted AS deleted_41,
  t36.deleted_at AS deleted_at_42,
  t43.id AS id_44,
  t43.downloaded AS downloaded_45,
  t43.printed AS printed_46,
  t43.shared AS shared_47,
  t43.viewed AS viewed_48,
  t43.created AS created_49,
  t43.updated AS updated_50,
  t43.article_id AS article_id_51
FROM
  articles t0
  INNER JOIN journals t20 ON t0.journal_id = t20.id
  LEFT JOIN article_types t36 ON t0.article_type_id = t36.id
  LEFT JOIN article_analytics t43 ON t43.article_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.page_start AS page_start_4, t0.page_end AS page_end_5, t0.abstract AS abstract_6, t0.full_text AS full_text_7, t0.keywords AS keywords_8, t0.description AS description_9, t0.doi AS doi_10, t0.published AS published_11, t0.publication_date AS publication_date_12, t0.publication_year AS publication_year_13, t0.pdf AS pdf_14, t0.created AS created_15, t0.updated AS updated_16, t0.deleted AS deleted_17, t0.deleted_at AS deleted_at_18, t0.journal_id AS journal_id_19, t20.id AS id_21, t20.title AS title_22, t20.abbreviation AS abbreviation_23, t20.url AS url_24, t20.issn AS issn_25, t20.doi AS doi_26, t20.ceased AS ceased_27, t20.email AS email_28, t20.cover_image AS cover_image_29, t20.created AS created_30, t20.updated AS updated_31, t20.deleted AS deleted_32, t20.deleted_at AS deleted_at_33, t20.group_id AS group_id_34, t0.article_type_id AS article_type_id_35, t36.id AS id_37, t36.name AS name_38, t36.created AS created_39, t36.updated AS updated_40, t36.deleted AS deleted_41, t36.deleted_at AS deleted_at_42, t43.id AS id_44, t43.downloaded AS downloaded_45, t43.printed AS printed_46, t43.shared AS shared_47, t43.viewed AS viewed_48, t43.created AS created_49, t43.updated AS updated_50, t43.article_id AS article_id_51 FROM articles t0 INNER JOIN journals t20 ON t0.journal_id = t20.id LEFT JOIN article_types t36 ON t0.article_type_id = t36.id LEFT JOIN article_analytics t43 ON t43.article_id = t0.id WHERE t0.id = 'a9ccf295-0b16-4c57-b173-d96430691aeb' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  article_analytics
SET
  downloaded = ?,
  updated = CURRENT_TIMESTAMP
WHERE
  id = ?
  AND updated = ?

UPDATE article_analytics SET downloaded = 2026, updated = CURRENT_TIMESTAMP WHERE id = '8251e399-1bfe-47ed-8109-b4ec980e71cc' AND updated = '2026-09-01 14:38:02';

SELECT
  updated
FROM
  article_analytics
WHERE
  id = ?

SELECT updated FROM article_analytics WHERE id = '8251e399-1bfe-47ed-8109-b4ec980e71cc';

"COMMIT"

"COMMIT";