Symfony Profiler

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/admin/misc/ping' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/misc/ping?_dc=1765465234197' AND `type` = 'path_query') OR
                (source = 'https://plateform.lab.fortesting2.fr/admin/misc/ping?_dc=1765465234197' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765465234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765465234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 2;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765465234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_users');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765465234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'resource
tags
');

UPDATE
  users
SET
  id = ?,
  parentId = ?,
  name = ?,
  type = ?,
  permissions = ?,
  classes = ?,
  docTypes = ?,
  perspectives = ?,
  websiteTranslationLanguagesView = ?,
  websiteTranslationLanguagesEdit = ?,
  password = ?,
  passwordRecoveryToken = ?,
  firstname = ?,
  lastname = ?,
  email = ?,
  language = ?,
  datetimeLocale = ?,
  admin = ?,
  active = ?,
  roles = ?,
  welcomescreen = ?,
  closeWarning = ?,
  memorizeTabs = ?,
  allowDirtyClose = ?,
  contentLanguages = ?,
  activePerspective = ?,
  lastLogin = ?,
  keyBindings = ?,
  twoFactorAuthentication = ?,
  provider = ?
WHERE
  id = ?

UPDATE users SET id = 2, parentId = 0, name = 'codeway', type = 'user', permissions = 'admin_translations,application_logging,assets,asset_metadata,bundle_ecommerce_back-office_order,bundle_ecommerce_pricing_rules,bundle_outputDataConfigToolkit,classes,classificationstore,clear_cache,clear_fullpage_cache,clear_temp_files,dashboards,documents,document_types,emails,fieldcollections,gdpr_data_extractor,gee_job_run_permission,gee_see_all_job_runs_permission,glossary,google_marketing,http_errors,newsletters,notes_events,notifications,notifications_send,objectbricks,objects,plugins,plugin_cmf_perm_activityview,plugin_cmf_perm_customerview,plugin_cmf_perm_customerview_admin,plugin_cmf_perm_customer_automation_rules,plugin_cmf_perm_newsletter_enqueue_all_customers,plugin_datahub_adapter_graphql,plugin_datahub_admin,plugin_datahub_config,predefined_properties,qr_codes,quantityValueUnits,recyclebin,redirects,reports,reports_config,robots.txt,routes,seemode,selectoptions,seo_document_editor,share_configurations,system_appearance_settings,system_settings,tags_assignment,tags_configuration,tags_search,targeting,thumbnails,translations,users,web2print_settings,web2print_web2print_favourite_output_channels,website_settings,word_export,workflow_details,xliff_import_export', classes = '', docTypes = '', perspectives = '', websiteTranslationLanguagesView = '', websiteTranslationLanguagesEdit = '', password = '$2y$10$Y179vGRvWPCbgK3CC0MrXuW7f.seAO7dY80YljjhqMDZUk1X.8x76', passwordRecoveryToken = NULL, firstname = 'Florent', lastname = 'BERNARD', email = 'contact@codeway.fr', language = 'fr', datetimeLocale = '', admin = 1, active = 1, roles = '', welcomescreen = 0, closeWarning = 0, memorizeTabs = 0, allowDirtyClose = 1, contentLanguages = 'en,fr', activePerspective = 'default', lastLogin = 1765463536, keyBindings = '[{\"key\":83,\"action\":\"save\",\"ctrl\":true,\"alt\":false,\"shift\":false},{\"key\":80,\"action\":\"publish\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":85,\"action\":\"unpublish\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":82,\"action\":\"rename\",\"alt\":true,\"shift\":true,\"ctrl\":false},{\"key\":116,\"action\":\"refresh\",\"alt\":false,\"ctrl\":false,\"shift\":false},{\"key\":68,\"action\":\"openDocument\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":65,\"action\":\"openAsset\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":79,\"action\":\"openObject\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":67,\"action\":\"openClassEditor\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":76,\"action\":\"openInTree\",\"ctrl\":true,\"shift\":true,\"alt\":false},{\"key\":73,\"action\":\"showMetaInfo\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":87,\"action\":\"searchDocument\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":65,\"action\":\"searchAsset\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":79,\"action\":\"searchObject\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":72,\"action\":\"showElementHistory\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":84,\"action\":\"closeAllTabs\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":83,\"action\":\"searchAndReplaceAssignments\",\"alt\":true,\"ctrl\":false,\"shift\":false},{\"key\":82,\"action\":\"redirects\",\"ctrl\":false,\"alt\":true,\"shift\":false},{\"key\":84,\"action\":\"sharedTranslations\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":82,\"action\":\"recycleBin\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":78,\"action\":\"notesEvents\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":72,\"action\":\"tagManager\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":78,\"action\":\"tagConfiguration\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":85,\"action\":\"users\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":80,\"action\":\"roles\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":81,\"action\":\"clearAllCaches\",\"ctrl\":false,\"alt\":true,\"shift\":false},{\"key\":67,\"action\":\"clearDataCache\",\"ctrl\":false,\"alt\":true,\"shift\":false},{\"key\":67,\"action\":\"customReports\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":77,\"action\":\"reports\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":76,\"action\":\"applicationLogger\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":71,\"action\":\"glossary\",\"alt\":true,\"shift\":true,\"ctrl\":false},{\"key\":83,\"action\":\"seoDocumentEditor\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":74,\"action\":\"robots\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":79,\"action\":\"httpErrorLog\",\"ctrl\":true,\"alt\":true,\"shift\":false},{\"key\":70,\"action\":\"quickSearch\",\"ctrl\":true,\"shift\":true,\"alt\":false}]', twoFactorAuthentication = '{\"required\":false,\"enabled\":false,\"secret\":\"\",\"type\":\"\"}', provider = NULL WHERE id = 2;

DELETE FROM
  users_workspaces_asset
WHERE
  userId = ?

DELETE FROM users_workspaces_asset WHERE userId = 2;

DELETE FROM
  users_workspaces_document
WHERE
  userId = ?

DELETE FROM users_workspaces_document WHERE userId = 2;

DELETE FROM
  users_workspaces_object
WHERE
  userId = ?

DELETE FROM users_workspaces_object WHERE userId = 2;

"COMMIT"

"COMMIT";