Symfony Profiler

SELECT 
  k0_.locale AS locale_0, 
  k0_.domain AS domain_1 
FROM 
  kuma_translation k0_ 
GROUP BY 
  k0_.locale, 
  k0_.domain

SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain;

SELECT 
  t0.domain AS domain_1, 
  t0.origin AS origin_2, 
  t0.note AS note_3, 
  t0.target AS target_4, 
  t0.permanent AS permanent_5, 
  t0.id AS id_6 
FROM 
  kuma_redirects t0

SELECT t0.domain AS domain_1, t0.origin AS origin_2, t0.note AS note_3, t0.target AS target_4, t0.permanent AS permanent_5, t0.id AS id_6 FROM kuma_redirects t0;

SELECT 
  t0.code AS code_1, 
  t0.url AS url_2, 
  t0.url_referer AS url_referer_3, 
  t0.hash AS hash_4, 
  t0.events AS events_5, 
  t0.is_resolved AS is_resolved_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.id AS id_9 
FROM 
  kuma_exception t0 
WHERE 
  t0.hash = ? 
LIMIT 
  1

SELECT t0.code AS code_1, t0.url AS url_2, t0.url_referer AS url_referer_3, t0.hash AS hash_4, t0.events AS events_5, t0.is_resolved AS is_resolved_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM kuma_exception t0 WHERE t0.hash = 'fdf834b89ccbd6dae8bae5ba73b85d63' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  kuma_exception 
SET 
  events = ?, 
  updated_at = ? 
WHERE 
  id = ?

UPDATE kuma_exception SET events = 82, updated_at = '2025-01-08 02:18:55' WHERE id = '100111';

"COMMIT"

"COMMIT";

SELECT 
  k0_.lft AS lft_0, 
  k0_.lvl AS lvl_1, 
  k0_.rgt AS rgt_2, 
  k0_.deleted AS deleted_3, 
  k0_.hidden_from_nav AS hidden_from_nav_4, 
  k0_.ref_entity_name AS ref_entity_name_5, 
  k0_.internal_name AS internal_name_6, 
  k0_.id AS id_7, 
  k1_.lang AS lang_8, 
  k1_.online AS online_9, 
  k1_.title AS title_10, 
  k1_.slug AS slug_11, 
  k1_.url AS url_12, 
  k1_.weight AS weight_13, 
  k1_.created AS created_14, 
  k1_.updated AS updated_15, 
  k1_.id AS id_16, 
  k2_.type AS type_17, 
  k2_.owner AS owner_18, 
  k2_.created AS created_19, 
  k2_.updated AS updated_20, 
  k2_.ref_id AS ref_id_21, 
  k2_.ref_entity_name AS ref_entity_name_22, 
  k2_.id AS id_23, 
  k0_.parent_id AS parent_id_24, 
  k1_.node_id AS node_id_25, 
  k1_.public_node_version_id AS public_node_version_id_26, 
  k2_.node_translation_id AS node_translation_id_27, 
  k2_.origin_id AS origin_id_28 
FROM 
  kuma_nodes k0_ 
  LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id 
  AND (k1_.lang = ?) 
  LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id 
  AND (
    k1_.public_node_version_id = k2_.id
  ) 
  JOIN (
    SELECT 
      DISTINCT o.object_identifier as id 
    FROM 
      host7_gcs_dev.acl_object_identities as o 
      INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id 
      LEFT JOIN host7_gcs_dev.acl_entries e ON (
        e.class_id = o.class_id 
        AND (
          e.object_identity_id = o.id 
          OR e.object_identity_id IS NULL
        )
      ) 
      LEFT JOIN host7_gcs_dev.acl_security_identities s ON (s.id = e.security_identity_id) 
    WHERE 
      c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node" 
      AND (
        s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY"
      ) 
      AND e.mask & 1 > 0
  ) ta_ ON k0_.id = ta_.id 
WHERE 
  k0_.deleted = 0 
  AND (
    (
      k0_.hidden_from_nav <> 1 
      OR k0_.internal_name IS NOT NULL
    )
  ) 
ORDER BY 
  k1_.weight ASC, 
  k1_.title ASC

SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = NULL) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) JOIN (SELECT DISTINCT o.object_identifier as id FROM host7_gcs_dev.acl_object_identities as o
INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id
LEFT JOIN host7_gcs_dev.acl_entries e ON (
    e.class_id = o.class_id AND (e.object_identity_id = o.id
    OR e.object_identity_id IS NULL)
)
LEFT JOIN host7_gcs_dev.acl_security_identities s ON (
s.id = e.security_identity_id
)
WHERE c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node"
AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY")
AND e.mask & 1 > 0) ta_ ON k0_.id = ta_.id WHERE k0_.deleted = 0 AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;