Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation 24
• Security
• Twig
• Doctrine
• HTTP Client
• Debug
• Emails
• Serializer
• Configuration

Query Metrics

SELECT
                COUNT(DISTINCT g.country_id) AS cnt
            FROM
                member m,
			    address a
            JOIN geo__names g ON a.location = g.geonameId 
			WHERE m.id = a.member_id and m.Status IN ('Active', 'OutOfRemind')

[]

SELECT
  COUNT(DISTINCT g.country_id) AS cnt
FROM
  member m,
  address a
  JOIN geo__names g ON a.location = g.geonameId
WHERE
  m.id = a.member_id
  and m.Status IN ('Active', 'OutOfRemind')

SELECT
                COUNT(DISTINCT g.country_id) AS cnt
            FROM
                member m,
			    address a
            JOIN geo__names g ON a.location = g.geonameId 
			WHERE m.id = a.member_id and m.Status IN ('Active', 'OutOfRemind')
        ;

SELECT
                COUNT(*) AS cnt
            FROM
                member m
            WHERE
                m.status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')

[]

SELECT
  COUNT(*) AS cnt
FROM
  member m
WHERE
  m.status IN (
    'Active', 'ActiveHidden', 'ChoiceInactive',
    'OutOfRemind', 'Pending'
  )

SELECT
                COUNT(*) AS cnt
            FROM
                member m
            WHERE
                m.status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')
        ;

SELECT
                COUNT(DISTINCT l.shortCode) AS cnt
            FROM
                language l,
                member_language_level mll,
                member m
            WHERE
                l.ShortCode = mll.language
                AND mll.member_id = m.Id
                AND m.Status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')

[]

SELECT
  COUNT(DISTINCT l.shortCode) AS cnt
FROM
  language l,
  member_language_level mll,
  member m
WHERE
  l.ShortCode = mll.language
  AND mll.member_id = m.Id
  AND m.Status IN (
    'Active', 'ActiveHidden', 'ChoiceInactive',
    'OutOfRemind', 'Pending'
  )

SELECT
                COUNT(DISTINCT l.shortCode) AS cnt
            FROM
                language l,
                member_language_level mll,
                member m
            WHERE
                l.ShortCode = mll.language
                AND mll.member_id = m.Id
                AND m.Status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')
        ;

SELECT
                COUNT(a.id)
            FROM
                activities a
            WHERE
                a.status = 0

[]

SELECT
  COUNT(a.id)
FROM
  activities a
WHERE
  a.status = 0

SELECT
                COUNT(a.id)
            FROM
                activities a
            WHERE
                a.status = 0
        ;

SELECT
                COUNT(c.id) AS cnt
            FROM
                comments c,
                member m
            WHERE
                c.Quality = 'Good'
                AND IdFromMember = m.Id
                AND m.Status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')

[]

SELECT
  COUNT(c.id) AS cnt
FROM
  comments c,
  member m
WHERE
  c.Quality = 'Good'
  AND IdFromMember = m.Id
  AND m.Status IN (
    'Active', 'ActiveHidden', 'ChoiceInactive',
    'OutOfRemind', 'Pending'
  )

SELECT
                COUNT(c.id) AS cnt
            FROM
                comments c,
                member m
            WHERE
                c.Quality = 'Good'
                AND IdFromMember = m.Id
                AND m.Status IN ('Active', 'ActiveHidden', 'ChoiceInactive', 'OutOfRemind', 'Pending')
        ;