Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Configuration

Query Metrics

SELECT DATABASE()

[]

SELECT
  DATABASE()

SELECT DATABASE();

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

[
  "craiova_amme_skeleton_api"
]

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'craiova_amme_skeleton_api'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT `key`, `value` FROM `owner`

[]

SELECT
  `key`,
  `value`
FROM
  `owner`

SELECT `key`, `value` FROM `owner`;

SELECT v.id, v.system, v.version, v.link
                FROM `app_mobile` AS v
                WHERE v.system = ?
                  AND v.active = 1
                  AND v.deleted_at IS NULL
                ORDER BY v.created_at DESC
                LIMIT 1

[
  "ios"
]

SELECT
  v.id,
  v.system,
  v.version,
  v.link
FROM
  `app_mobile` AS v
WHERE
  v.system = ?
  AND v.active = 1
  AND v.deleted_at IS NULL
ORDER BY
  v.created_at DESC
LIMIT
  1

SELECT v.id, v.system, v.version, v.link
                FROM `app_mobile` AS v
                WHERE v.system = 'ios'
                  AND v.active = 1
                  AND v.deleted_at IS NULL
                ORDER BY v.created_at DESC
                LIMIT 1;

SELECT v.id, v.system, v.version, v.link
                FROM `app_mobile` AS v
                WHERE v.system = ?
                  AND v.active = 1
                  AND v.deleted_at IS NULL
                ORDER BY v.created_at DESC
                LIMIT 1

[
  "android"
]

SELECT
  v.id,
  v.system,
  v.version,
  v.link
FROM
  `app_mobile` AS v
WHERE
  v.system = ?
  AND v.active = 1
  AND v.deleted_at IS NULL
ORDER BY
  v.created_at DESC
LIMIT
  1

SELECT v.id, v.system, v.version, v.link
                FROM `app_mobile` AS v
                WHERE v.system = 'android'
                  AND v.active = 1
                  AND v.deleted_at IS NULL
                ORDER BY v.created_at DESC
                LIMIT 1;