Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.sortorder AS sortorder_2,
  b0_.version AS version_3,
  b1_.id AS id_4,
  b1_.value AS value_5,
  b1_.locale AS locale_6,
  b0_.type AS type_7,
  b0_.content_id AS content_id_8,
  b0_.parent_id AS parent_id_9,
  b1_.translatable_id AS translatable_id_10
FROM
  bolt_field b0_
  INNER JOIN bolt_field_translation b1_ ON b0_.id = b1_.translatable_id
WHERE
  (
    CAST(
      JSON_UNQUOTE(
        JSON_EXTRACT(b1_.value, '$[0]')
      ) AS CHAR
    ) = ?
    AND b0_.type IN (?)
  )
  AND b0_.type IN (
    'generic', 'block', 'checkbox', 'collection',
    'data', 'date', 'email', 'embed',
    'file', 'filelist', 'hidden', 'html',
    'image', 'imagelist', 'markdown',
    'number', 'select', 'set', 'slug',
    'templateselect', 'text', 'textarea',
    'article', 'seo', 'redactor'
  )

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b1_.id AS id_4, b1_.value AS value_5, b1_.locale AS locale_6, b0_.type AS type_7, b0_.content_id AS content_id_8, b0_.parent_id AS parent_id_9, b1_.translatable_id AS translatable_id_10 FROM bolt_field b0_ INNER JOIN bolt_field_translation b1_ ON b0_.id = b1_.translatable_id WHERE (CAST(JSON_UNQUOTE(JSON_EXTRACT(b1_.value, '$[0]')) AS CHAR) = 'peringatan-nuzulul-qur-an-dan-doa-bersama-dalam-rangka-hut-ke-79-persit-kartika-chandra-kirana' AND b0_.type IN ('slug')) AND b0_.type IN ('generic', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'select', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'seo', 'redactor');

INSERT INTO bolt_field_translation (value, locale, translatable_id)
VALUES
  (?, ?, ?)

INSERT INTO bolt_field_translation (value, locale, translatable_id) VALUES ('[\"PERINGATAN NUZULUL QUR\'AN DAN DOA BERSAMA DALAM RANGKA HUT KE-79 PERSIT KARTIKA CHANDRA KIRANA \"]', 'en', 15888);

INSERT INTO bolt_field (
  name, sortorder, version, content_id,
  parent_id, type
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO bolt_field (name, sortorder, version, content_id, parent_id, type) VALUES ('seo', 0, NULL, 552, NULL, 'seo');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.lastseen_at AS lastseen_at_7,
  t0.last_ip AS last_ip_8,
  t0.locale AS locale_9,
  t0.backend_theme AS backend_theme_10,
  t0.status AS status_11,
  t0.avatar AS avatar_12,
  t13.id AS id_14,
  t13.useragent AS useragent_15,
  t13.validity AS validity_16,
  t13.user_id AS user_id_17
FROM
  bolt_user t0
  LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id = 1;

update
  bolt_content
SET
  status = 'held',
  depublished_at = :now
WHERE
  status = 'published'
  AND depublished_at < :now

update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now;

update
  bolt_content
SET
  status = 'published',
  published_at = :now
WHERE
  status = 'timed'
  AND published_at < :now

update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now;

INSERT INTO bolt_log (
  message, context, level, level_name,
  created_at, extra, `user`, content,
  location
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO bolt_log (message, context, level, level_name, created_at, extra, `user`, content, location) VALUES ('Saved content \"{title}\" ({content_type} № {content_id})', 'a:3:{s:10:\"content_id\";i:552;s:12:\"content_type\";s:5:\"pages\";s:5:\"title\";s:82:\"PERINGATAN NUZULUL QUR\'AN DAN DOA BERSAMA DALAM RANGKA HUT KE-79 PERSIT KARTIKA…\";}', 200, 'INFO', '2026-06-26 03:02:48', 'a:5:{s:9:\"client_ip\";s:15:\"103.165.128.173\";s:11:\"client_port\";i:80;s:3:\"uri\";s:38:\"http://ppid.rspadgs.net/bolt/new/pages\";s:12:\"query_string\";N;s:6:\"method\";s:4:\"POST\";}', 'a:3:{s:2:\"id\";i:1;s:8:\"username\";s:4:\"root\";s:5:\"roles\";a:1:{i:0;s:14:\"ROLE_DEVELOPER\";}}', 552, 'a:5:{s:4:\"file\";s:61:\"…/vendor/symfony/event-dispatcher/Debug/WrappedListener.php\";s:4:\"line\";i:118;s:5:\"class\";s:55:\"Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener\";s:4:\"type\";s:2:\"->\";s:8:\"function\";s:8:\"__invoke\";}');

INSERT INTO bolt_content (
  content_type, status, created_at,
  modified_at, published_at, depublished_at,
  author_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO bolt_content (content_type, status, created_at, modified_at, published_at, depublished_at, author_id) VALUES ('pages', 'published', '2026-06-26 03:02:48', '2026-06-26 03:02:48', '2026-06-26 10:00:16', NULL, 1);

"START TRANSACTION"

"START TRANSACTION";