Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.alias AS alias_2,
  t0.styles AS styles_3,
  t0.providers AS providers_4,
  t0.mapping AS mapping_5,
  t0.configs AS configs_6,
  t0.options AS options_7,
  t0.interactions AS interactions_8,
  t0.conditions AS conditions_9,
  t0.reference_roles AS reference_roles_10,
  t0.status AS status_11,
  t0.enabled AS enabled_12,
  t0.above_fold AS above_fold_13,
  t0.position AS position_14,
  t0.is_source AS is_source_15,
  t0.is_shortcut AS is_shortcut_16,
  t0.id AS id_17,
  t0.lock_expired AS lock_expired_18,
  t0.created AS created_19,
  t0.updated AS updated_20,
  t0.deleted AS deleted_21,
  t0.widget_type_id AS widget_type_id_22,
  t23.name AS name_24,
  t23.styles AS styles_25,
  t23.sku AS sku_26,
  t23.owner AS owner_27,
  t23.version AS version_28,
  t23.publishable AS publishable_29,
  t23.transparent AS transparent_30,
  t23.role AS role_31,
  t23.compatibles AS compatibles_32,
  t23.framework AS framework_33,
  t23.providers AS providers_34,
  t23.mapping AS mapping_35,
  t23.configs AS configs_36,
  t23.options AS options_37,
  t23.interactions AS interactions_38,
  t23.children AS children_39,
  t23.system AS system_40,
  t23.nilead_id AS nilead_id_41,
  t23.id AS id_42,
  t23.summary AS summary_43,
  t23.description AS description_44,
  t23.enabled AS enabled_45,
  t23.position AS position_46,
  t23.created AS created_47,
  t23.updated AS updated_48,
  t0.layout_source_id AS layout_source_id_49,
  t0.source_id AS source_id_50,
  t51.name AS name_52,
  t51.alias AS alias_53,
  t51.styles AS styles_54,
  t51.providers AS providers_55,
  t51.mapping AS mapping_56,
  t51.configs AS configs_57,
  t51.options AS options_58,
  t51.interactions AS interactions_59,
  t51.conditions AS conditions_60,
  t51.reference_roles AS reference_roles_61,
  t51.status AS status_62,
  t51.enabled AS enabled_63,
  t51.above_fold AS above_fold_64,
  t51.position AS position_65,
  t51.is_source AS is_source_66,
  t51.is_shortcut AS is_shortcut_67,
  t51.id AS id_68,
  t51.lock_expired AS lock_expired_69,
  t51.created AS created_70,
  t51.updated AS updated_71,
  t51.deleted AS deleted_72,
  t51.widget_type_id AS widget_type_id_73,
  t51.layout_source_id AS layout_source_id_74,
  t51.source_id AS source_id_75,
  t51.root_id AS root_id_76,
  t51.parent_id AS parent_id_77,
  t51.layout_style_id AS layout_style_id_78,
  t51.locker_id AS locker_id_79,
  t0.root_id AS root_id_80,
  t0.parent_id AS parent_id_81,
  t82.name AS name_83,
  t82.alias AS alias_84,
  t82.styles AS styles_85,
  t82.providers AS providers_86,
  t82.mapping AS mapping_87,
  t82.configs AS configs_88,
  t82.options AS options_89,
  t82.interactions AS interactions_90,
  t82.conditions AS conditions_91,
  t82.reference_roles AS reference_roles_92,
  t82.status AS status_93,
  t82.enabled AS enabled_94,
  t82.above_fold AS above_fold_95,
  t82.position AS position_96,
  t82.is_source AS is_source_97,
  t82.is_shortcut AS is_shortcut_98,
  t82.id AS id_99,
  t82.lock_expired AS lock_expired_100,
  t82.created AS created_101,
  t82.updated AS updated_102,
  t82.deleted AS deleted_103,
  t82.widget_type_id AS widget_type_id_104,
  t82.layout_source_id AS layout_source_id_105,
  t82.source_id AS source_id_106,
  t82.root_id AS root_id_107,
  t82.parent_id AS parent_id_108,
  t82.layout_style_id AS layout_style_id_109,
  t82.locker_id AS locker_id_110,
  t0.layout_style_id AS layout_style_id_111,
  t0.locker_id AS locker_id_112
FROM
  widget t0
  LEFT JOIN widget_type t23 ON t0.widget_type_id = t23.id
  LEFT JOIN widget t51 ON t0.source_id = t51.id
  LEFT JOIN widget t82 ON t0.parent_id = t82.id
WHERE
  t0.id IN (?)

SELECT t0.name AS name_1, t0.alias AS alias_2, t0.styles AS styles_3, t0.providers AS providers_4, t0.mapping AS mapping_5, t0.configs AS configs_6, t0.options AS options_7, t0.interactions AS interactions_8, t0.conditions AS conditions_9, t0.reference_roles AS reference_roles_10, t0.status AS status_11, t0.enabled AS enabled_12, t0.above_fold AS above_fold_13, t0.position AS position_14, t0.is_source AS is_source_15, t0.is_shortcut AS is_shortcut_16, t0.id AS id_17, t0.lock_expired AS lock_expired_18, t0.created AS created_19, t0.updated AS updated_20, t0.deleted AS deleted_21, t0.widget_type_id AS widget_type_id_22, t23.name AS name_24, t23.styles AS styles_25, t23.sku AS sku_26, t23.owner AS owner_27, t23.version AS version_28, t23.publishable AS publishable_29, t23.transparent AS transparent_30, t23.role AS role_31, t23.compatibles AS compatibles_32, t23.framework AS framework_33, t23.providers AS providers_34, t23.mapping AS mapping_35, t23.configs AS configs_36, t23.options AS options_37, t23.interactions AS interactions_38, t23.children AS children_39, t23.system AS system_40, t23.nilead_id AS nilead_id_41, t23.id AS id_42, t23.summary AS summary_43, t23.description AS description_44, t23.enabled AS enabled_45, t23.position AS position_46, t23.created AS created_47, t23.updated AS updated_48, t0.layout_source_id AS layout_source_id_49, t0.source_id AS source_id_50, t51.name AS name_52, t51.alias AS alias_53, t51.styles AS styles_54, t51.providers AS providers_55, t51.mapping AS mapping_56, t51.configs AS configs_57, t51.options AS options_58, t51.interactions AS interactions_59, t51.conditions AS conditions_60, t51.reference_roles AS reference_roles_61, t51.status AS status_62, t51.enabled AS enabled_63, t51.above_fold AS above_fold_64, t51.position AS position_65, t51.is_source AS is_source_66, t51.is_shortcut AS is_shortcut_67, t51.id AS id_68, t51.lock_expired AS lock_expired_69, t51.created AS created_70, t51.updated AS updated_71, t51.deleted AS deleted_72, t51.widget_type_id AS widget_type_id_73, t51.layout_source_id AS layout_source_id_74, t51.source_id AS source_id_75, t51.root_id AS root_id_76, t51.parent_id AS parent_id_77, t51.layout_style_id AS layout_style_id_78, t51.locker_id AS locker_id_79, t0.root_id AS root_id_80, t0.parent_id AS parent_id_81, t82.name AS name_83, t82.alias AS alias_84, t82.styles AS styles_85, t82.providers AS providers_86, t82.mapping AS mapping_87, t82.configs AS configs_88, t82.options AS options_89, t82.interactions AS interactions_90, t82.conditions AS conditions_91, t82.reference_roles AS reference_roles_92, t82.status AS status_93, t82.enabled AS enabled_94, t82.above_fold AS above_fold_95, t82.position AS position_96, t82.is_source AS is_source_97, t82.is_shortcut AS is_shortcut_98, t82.id AS id_99, t82.lock_expired AS lock_expired_100, t82.created AS created_101, t82.updated AS updated_102, t82.deleted AS deleted_103, t82.widget_type_id AS widget_type_id_104, t82.layout_source_id AS layout_source_id_105, t82.source_id AS source_id_106, t82.root_id AS root_id_107, t82.parent_id AS parent_id_108, t82.layout_style_id AS layout_style_id_109, t82.locker_id AS locker_id_110, t0.layout_style_id AS layout_style_id_111, t0.locker_id AS locker_id_112 FROM widget t0 LEFT JOIN widget_type t23 ON t0.widget_type_id = t23.id LEFT JOIN widget t51 ON t0.source_id = t51.id LEFT JOIN widget t82 ON t0.parent_id = t82.id WHERE t0.id IN (484481);

SELECT
  t0_.name AS name_0,
  t0_.id AS id_1,
  t0_.color AS color_2,
  t0_.created AS created_3,
  t0_.updated AS updated_4,
  t1_.source AS source_5,
  t1_.entity_id AS entity_id_6,
  t1_.id AS id_7,
  t1_.created AS created_8,
  t1_.updated AS updated_9,
  t1_.tag_id AS tag_id_10
FROM
  tag t0_
  INNER JOIN tag_relation t1_ ON t0_.id = t1_.tag_id
  AND (
    t1_.source = ?
    AND t1_.entity_id = ?
  )

SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.color AS color_2, t0_.created AS created_3, t0_.updated AS updated_4, t1_.source AS source_5, t1_.entity_id AS entity_id_6, t1_.id AS id_7, t1_.created AS created_8, t1_.updated AS updated_9, t1_.tag_id AS tag_id_10 FROM tag t0_ INNER JOIN tag_relation t1_ ON t0_.id = t1_.tag_id AND (t1_.source = 'block.widget_type' AND t1_.entity_id = 43);

"COMMIT"

"COMMIT";

SELECT
  t0.name AS name_1,
  t0.styles AS styles_2,
  t0.sku AS sku_3,
  t0.owner AS owner_4,
  t0.version AS version_5,
  t0.publishable AS publishable_6,
  t0.transparent AS transparent_7,
  t0.role AS role_8,
  t0.compatibles AS compatibles_9,
  t0.framework AS framework_10,
  t0.providers AS providers_11,
  t0.mapping AS mapping_12,
  t0.configs AS configs_13,
  t0.options AS options_14,
  t0.interactions AS interactions_15,
  t0.children AS children_16,
  t0.system AS system_17,
  t0.nilead_id AS nilead_id_18,
  t0.id AS id_19,
  t0.summary AS summary_20,
  t0.description AS description_21,
  t0.enabled AS enabled_22,
  t0.position AS position_23,
  t0.created AS created_24,
  t0.updated AS updated_25
FROM
  widget_type t0
WHERE
  t0.id IN (?)

SELECT t0.name AS name_1, t0.styles AS styles_2, t0.sku AS sku_3, t0.owner AS owner_4, t0.version AS version_5, t0.publishable AS publishable_6, t0.transparent AS transparent_7, t0.role AS role_8, t0.compatibles AS compatibles_9, t0.framework AS framework_10, t0.providers AS providers_11, t0.mapping AS mapping_12, t0.configs AS configs_13, t0.options AS options_14, t0.interactions AS interactions_15, t0.children AS children_16, t0.system AS system_17, t0.nilead_id AS nilead_id_18, t0.id AS id_19, t0.summary AS summary_20, t0.description AS description_21, t0.enabled AS enabled_22, t0.position AS position_23, t0.created AS created_24, t0.updated AS updated_25 FROM widget_type t0 WHERE t0.id IN (43);

"START TRANSACTION"

"START TRANSACTION";

SELECT
  w0_.name AS name_0,
  w0_.alias AS alias_1,
  w0_.styles AS styles_2,
  w0_.providers AS providers_3,
  w0_.mapping AS mapping_4,
  w0_.configs AS configs_5,
  w0_.options AS options_6,
  w0_.interactions AS interactions_7,
  w0_.conditions AS conditions_8,
  w0_.reference_roles AS reference_roles_9,
  w0_.status AS status_10,
  w0_.enabled AS enabled_11,
  w0_.above_fold AS above_fold_12,
  w0_.position AS position_13,
  w0_.is_source AS is_source_14,
  w0_.is_shortcut AS is_shortcut_15,
  w0_.id AS id_16,
  w0_.lock_expired AS lock_expired_17,
  w0_.created AS created_18,
  w0_.updated AS updated_19,
  w0_.deleted AS deleted_20,
  w0_.widget_type_id AS widget_type_id_21,
  w0_.layout_source_id AS layout_source_id_22,
  w0_.source_id AS source_id_23,
  w0_.root_id AS root_id_24,
  w0_.parent_id AS parent_id_25,
  w0_.layout_style_id AS layout_style_id_26,
  w0_.locker_id AS locker_id_27
FROM
  widget w0_
WHERE
  w0_.id = ?
LIMIT
  1

SELECT w0_.name AS name_0, w0_.alias AS alias_1, w0_.styles AS styles_2, w0_.providers AS providers_3, w0_.mapping AS mapping_4, w0_.configs AS configs_5, w0_.options AS options_6, w0_.interactions AS interactions_7, w0_.conditions AS conditions_8, w0_.reference_roles AS reference_roles_9, w0_.status AS status_10, w0_.enabled AS enabled_11, w0_.above_fold AS above_fold_12, w0_.position AS position_13, w0_.is_source AS is_source_14, w0_.is_shortcut AS is_shortcut_15, w0_.id AS id_16, w0_.lock_expired AS lock_expired_17, w0_.created AS created_18, w0_.updated AS updated_19, w0_.deleted AS deleted_20, w0_.widget_type_id AS widget_type_id_21, w0_.layout_source_id AS layout_source_id_22, w0_.source_id AS source_id_23, w0_.root_id AS root_id_24, w0_.parent_id AS parent_id_25, w0_.layout_style_id AS layout_style_id_26, w0_.locker_id AS locker_id_27 FROM widget w0_ WHERE w0_.id = '484482' LIMIT 1;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.salt AS salt_5,
  t0.password AS password_6,
  t0.confirmation_token AS confirmation_token_7,
  t0.last_login AS last_login_8,
  t0.password_requested AS password_requested_9,
  t0.account_registered AS account_registered_10,
  t0.account_expired AS account_expired_11,
  t0.account_locked AS account_locked_12,
  t0.credentials_expired AS credentials_expired_13,
  t0.google_authenticator_secret AS google_authenticator_secret_14,
  t0.id AS id_15,
  t0.enabled AS enabled_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.party_id AS party_id_19
FROM
  account t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.salt AS salt_5, t0.password AS password_6, t0.confirmation_token AS confirmation_token_7, t0.last_login AS last_login_8, t0.password_requested AS password_requested_9, t0.account_registered AS account_registered_10, t0.account_expired AS account_expired_11, t0.account_locked AS account_locked_12, t0.credentials_expired AS credentials_expired_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.id AS id_15, t0.enabled AS enabled_16, t0.created AS created_17, t0.updated AS updated_18, t0.party_id AS party_id_19 FROM account t0 WHERE t0.id = 3;

INSERT INTO widget_change (
  id, actor_type, ip, source, status,
  created, applied, duration_ms, user_input,
  metadata, parent_id, root_id, party_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO widget_change (id, actor_type, ip, source, status, created, applied, duration_ms, user_input, metadata, parent_id, root_id, party_id) VALUES ('chg_c73efd1a086c517d365e90e3', 'user', '2a09:bac5:55fa:25d7::3c5:41', 'manual_ui', 'applied', 1782791553, 1782791553, NULL, NULL, '[]', NULL, 484395, 6);

INSERT INTO widget_change_step (
  seq, widget_id, widget_path, op_type,
  target, payload, before_state, after_state,
  status, error, duration_ms, change_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO widget_change_step (seq, widget_id, widget_path, op_type, target, payload, before_state, after_state, status, error, duration_ms, change_id) VALUES (0, 484482, 'aacorp_header > container > container_5 > dropdown > list > language > repeat', 'update_content', NULL, '{\"changes\":[]}', '{\"name\":\"repeat\",\"enabled\":true,\"deleted\":null,\"parent_id\":484481,\"position\":0,\"configs\":[],\"mapping\":{\"items\":{\"advanced\":false,\"path_simple\":{\"provider\":\"provider_\",\"property\":null},\"path_advanced\":{\"path\":null},\"sort_key\":null,\"sort_direction\":null}},\"styles\":[],\"source_id\":null,\"reference_roles\":null,\"widget_type_sku\":\"repeat__provider\"}', '{\"name\":\"repeat\",\"enabled\":true,\"deleted\":null,\"parent_id\":484481,\"position\":0,\"configs\":[],\"mapping\":{\"items\":{\"advanced\":false,\"path_simple\":{\"provider\":\"provider_\",\"property\":null},\"path_advanced\":{\"path\":null},\"sort_key\":null,\"sort_direction\":null}},\"styles\":[],\"source_id\":null,\"reference_roles\":null,\"widget_type_sku\":\"repeat__provider\"}', 'applied', NULL, NULL, 'chg_c73efd1a086c517d365e90e3');