Symfony Profiler

SELECT
  TABLE_NAME as name,
  TABLE_ROWS as `rows`
from
  information_schema.TABLES
WHERE
  TABLE_ROWS IS NOT NULL
  AND TABLE_SCHEMA = ?

SELECT TABLE_NAME as name,TABLE_ROWS as `rows` from information_schema.TABLES
                WHERE TABLE_ROWS IS NOT NULL AND TABLE_SCHEMA = 'dam';

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 45;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 45;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 45;

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

SELECT * FROM settings_store WHERE id = 'web_to_print' AND scope = 'pimcore_web_to_print';

SELECT
  VERSION()

SELECT VERSION();