Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM `user` t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.color AS color_4,
  c0_.icon AS icon_5,
  c0_.position AS position_6,
  c0_.is_active AS is_active_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9
FROM
  category c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.icon AS icon_5, c0_.position AS position_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9 FROM category c0_ WHERE c0_.is_active = 1 ORDER BY c0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.excerpt AS excerpt_5,
  t0.body AS body_6,
  t0.status AS status_7,
  t0.source_topic AS source_topic_8,
  t0.satire_score AS satire_score_9,
  t0.risk_score AS risk_score_10,
  t0.is_ai_generated AS is_ai_generated_11,
  t0.is_featured AS is_featured_12,
  t0.view_count AS view_count_13,
  t0.author AS author_14,
  t0.published_at AS published_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.metadata AS metadata_18,
  t0.ai_prompt AS ai_prompt_19,
  t0.ai_response AS ai_response_20,
  t0.category_id AS category_id_21,
  t0.featured_image_id AS featured_image_id_22
FROM
  article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.excerpt AS excerpt_5, t0.body AS body_6, t0.status AS status_7, t0.source_topic AS source_topic_8, t0.satire_score AS satire_score_9, t0.risk_score AS risk_score_10, t0.is_ai_generated AS is_ai_generated_11, t0.is_featured AS is_featured_12, t0.view_count AS view_count_13, t0.author AS author_14, t0.published_at AS published_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.metadata AS metadata_18, t0.ai_prompt AS ai_prompt_19, t0.ai_response AS ai_response_20, t0.category_id AS category_id_21, t0.featured_image_id AS featured_image_id_22 FROM article t0 WHERE t0.id = '13';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  article
SET
  STATUS = ?,
  published_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE article SET STATUS = 'published', published_at = '2026-03-27 19:01:46', updated_at = '2026-03-27 19:01:46' WHERE id = 13;

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.platform AS platform_1,
  s0_.account_name AS account_name_2,
  s0_.account_id AS account_id_3,
  s0_.access_token AS access_token_4,
  s0_.refresh_token AS refresh_token_5,
  s0_.access_token_secret AS access_token_secret_6,
  s0_.token_expires_at AS token_expires_at_7,
  s0_.is_active AS is_active_8,
  s0_.auto_post AS auto_post_9,
  s0_.settings AS settings_10,
  s0_.success_count AS success_count_11,
  s0_.failure_count AS failure_count_12,
  s0_.last_post_at AS last_post_at_13,
  s0_.created_at AS created_at_14,
  s0_.updated_at AS updated_at_15
FROM
  social_account s0_
WHERE
  s0_.is_active = ?

SELECT s0_.id AS id_0, s0_.platform AS platform_1, s0_.account_name AS account_name_2, s0_.account_id AS account_id_3, s0_.access_token AS access_token_4, s0_.refresh_token AS refresh_token_5, s0_.access_token_secret AS access_token_secret_6, s0_.token_expires_at AS token_expires_at_7, s0_.is_active AS is_active_8, s0_.auto_post AS auto_post_9, s0_.settings AS settings_10, s0_.success_count AS success_count_11, s0_.failure_count AS failure_count_12, s0_.last_post_at AS last_post_at_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15 FROM social_account s0_ WHERE s0_.is_active = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO social_post (
  platform, content, STATUS, external_post_id,
  external_url, scheduled_at, posted_at,
  error_message, retry_count, metadata,
  created_at, updated_at, article_id,
  media_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO social_post (platform, content, STATUS, external_post_id, external_url, scheduled_at, posted_at, error_message, retry_count, metadata, created_at, updated_at, article_id, media_id) VALUES ('twitter', 'Le Maroc signe un traité avec l\'Antarctique pour des glaçons de menthe ! 🌍🥶 #MarocGlacial #DiplomatieFroide

https://actufake.com/article/le-maroc-devient-le-nouvel-iceberg-diplomatique-du-sahara', 'processing', NULL, NULL, NULL, NULL, NULL, 0, '[]', '2026-03-27 19:01:46', '2026-03-27 19:01:46', 13, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 8;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  social_post
SET
  STATUS = ?,
  external_post_id = ?,
  external_url = ?,
  posted_at = ?
WHERE
  id = ?

UPDATE social_post SET STATUS = 'posted', external_post_id = '2037606025583276346', external_url = 'https://twitter.com/i/status/2037606025583276346', posted_at = '2026-03-27 19:01:48' WHERE id = 18;

"COMMIT"

"COMMIT";