Symfony Profiler

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

Query Metrics

SELECT v.id, v.system, v.version, v.minimum_required_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.minimum_required_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.minimum_required_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.minimum_required_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.minimum_required_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.minimum_required_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;

SELECT f.rate, f.subject, f.message, f.created_at,
                    s.nickname, s.given_name, s.family_name
             FROM `feedback` f
             INNER JOIN `feedback__publishing` p ON p.feedback_id = f.id AND p.is_published = 1
             INNER JOIN `feedback__submitter` s ON s.feedback_id = f.id
             WHERE COALESCE(NULLIF(TRIM(f.message), ''), NULLIF(TRIM(f.subject), '')) IS NOT NULL
             ORDER BY p.state_changed_at DESC
             LIMIT 10

[]

SELECT
  f.rate,
  f.subject,
  f.message,
  f.created_at,
  s.nickname,
  s.given_name,
  s.family_name
FROM
  `feedback` f
  INNER JOIN `feedback__publishing` p ON p.feedback_id = f.id
  AND p.is_published = 1
  INNER JOIN `feedback__submitter` s ON s.feedback_id = f.id
WHERE
  COALESCE(
    NULLIF(
      TRIM(f.message),
      ''
    ),
    NULLIF(
      TRIM(f.subject),
      ''
    )
  ) IS NOT NULL
ORDER BY
  p.state_changed_at DESC
LIMIT
  10

SELECT f.rate, f.subject, f.message, f.created_at,
                    s.nickname, s.given_name, s.family_name
             FROM `feedback` f
             INNER JOIN `feedback__publishing` p ON p.feedback_id = f.id AND p.is_published = 1
             INNER JOIN `feedback__submitter` s ON s.feedback_id = f.id
             WHERE COALESCE(NULLIF(TRIM(f.message), ''), NULLIF(TRIM(f.subject), '')) IS NOT NULL
             ORDER BY p.state_changed_at DESC
             LIMIT 10;