Symfony Profiler

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

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

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 > 1780404032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('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;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          g0_.id AS id_0,
          g0_.ownerId AS ownerId_1,
          g0_.state AS state_2,
          g0_.currentStep AS currentStep_3,
          g0_.currentMessage AS currentMessage_4,
          g0_.log AS log_5,
          g0_.serializedJob AS serializedJob_6,
          g0_.context AS context_7,
          g0_.creationDate AS creationDate_8,
          g0_.modificationDate AS modificationDate_9,
          g0_.executionContext AS executionContext_10,
          g0_.totalElements AS totalElements_11,
          g0_.processedElementsForStep AS processedElementsForStep_12,
          b1_.jobRunId AS jobRunId_13
        FROM
          generic_execution_engine_job_run g0_
          LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId)
        WHERE
          b1_.jobRunId IS NULL
          AND g0_.ownerId = ?
          AND g0_.id = ?
          AND g0_.executionContext IN (?, ?)
      ) dctrn_result_inner
    ORDER BY
      id_0 ASC
  ) dctrn_result
LIMIT
  1

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT g0_.id AS id_0, g0_.ownerId AS ownerId_1, g0_.state AS state_2, g0_.currentStep AS currentStep_3, g0_.currentMessage AS currentMessage_4, g0_.log AS log_5, g0_.serializedJob AS serializedJob_6, g0_.context AS context_7, g0_.creationDate AS creationDate_8, g0_.modificationDate AS modificationDate_9, g0_.executionContext AS executionContext_10, g0_.totalElements AS totalElements_11, g0_.processedElementsForStep AS processedElementsForStep_12, b1_.jobRunId AS jobRunId_13 FROM generic_execution_engine_job_run g0_ LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId) WHERE b1_.jobRunId IS NULL AND g0_.ownerId = 2 AND g0_.id = 18 AND g0_.executionContext IN ('studio_stop_on_error', 'studio_continue_on_error')) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 1;

SELECT
  g0_.id AS id_0,
  g0_.ownerId AS ownerId_1,
  g0_.state AS state_2,
  g0_.currentStep AS currentStep_3,
  g0_.currentMessage AS currentMessage_4,
  g0_.log AS log_5,
  g0_.serializedJob AS serializedJob_6,
  g0_.context AS context_7,
  g0_.creationDate AS creationDate_8,
  g0_.modificationDate AS modificationDate_9,
  g0_.executionContext AS executionContext_10,
  g0_.totalElements AS totalElements_11,
  g0_.processedElementsForStep AS processedElementsForStep_12
FROM
  generic_execution_engine_job_run g0_
  LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId)
WHERE
  b1_.jobRunId IS NULL
  AND g0_.ownerId = ?
  AND g0_.id = ?
  AND g0_.executionContext IN (?, ?)
  AND g0_.id IN (?)
ORDER BY
  g0_.id ASC

SELECT g0_.id AS id_0, g0_.ownerId AS ownerId_1, g0_.state AS state_2, g0_.currentStep AS currentStep_3, g0_.currentMessage AS currentMessage_4, g0_.log AS log_5, g0_.serializedJob AS serializedJob_6, g0_.context AS context_7, g0_.creationDate AS creationDate_8, g0_.modificationDate AS modificationDate_9, g0_.executionContext AS executionContext_10, g0_.totalElements AS totalElements_11, g0_.processedElementsForStep AS processedElementsForStep_12 FROM generic_execution_engine_job_run g0_ LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId) WHERE b1_.jobRunId IS NULL AND g0_.ownerId = 2 AND g0_.id = 18 AND g0_.executionContext IN ('studio_stop_on_error', 'studio_continue_on_error') AND g0_.id IN (18) ORDER BY g0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          g0_.id AS id_0,
          g0_.ownerId AS ownerId_1,
          g0_.state AS state_2,
          g0_.currentStep AS currentStep_3,
          g0_.currentMessage AS currentMessage_4,
          g0_.log AS log_5,
          g0_.serializedJob AS serializedJob_6,
          g0_.context AS context_7,
          g0_.creationDate AS creationDate_8,
          g0_.modificationDate AS modificationDate_9,
          g0_.executionContext AS executionContext_10,
          g0_.totalElements AS totalElements_11,
          g0_.processedElementsForStep AS processedElementsForStep_12
        FROM
          generic_execution_engine_job_run g0_
          LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId)
        WHERE
          b1_.jobRunId IS NULL
          AND g0_.ownerId = ?
          AND g0_.id = ?
          AND g0_.executionContext IN (?, ?)
        ORDER BY
          g0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT g0_.id AS id_0, g0_.ownerId AS ownerId_1, g0_.state AS state_2, g0_.currentStep AS currentStep_3, g0_.currentMessage AS currentMessage_4, g0_.log AS log_5, g0_.serializedJob AS serializedJob_6, g0_.context AS context_7, g0_.creationDate AS creationDate_8, g0_.modificationDate AS modificationDate_9, g0_.executionContext AS executionContext_10, g0_.totalElements AS totalElements_11, g0_.processedElementsForStep AS processedElementsForStep_12 FROM generic_execution_engine_job_run g0_ LEFT JOIN bundle_studio_execution_engine_hidden_job_run b1_ ON (g0_.id = b1_.jobRunId) WHERE b1_.jobRunId IS NULL AND g0_.ownerId = 2 AND g0_.id = 18 AND g0_.executionContext IN ('studio_stop_on_error', 'studio_continue_on_error') ORDER BY g0_.id ASC) dctrn_result) dctrn_table;