Symfony Profiler

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

Query Metrics

SELECT t0.name AS name_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.feature_class AS feature_class_4, t0.feature_code AS feature_code_5, t0.country_id AS country_id_6, t0.admin_1_id AS admin_1_id_7, t0.admin_2_id AS admin_2_id_8, t0.admin_3_id AS admin_3_id_9, t0.admin_4_id AS admin_4_id_10, t0.population AS population_11, t0.moddate AS moddate_12, t0.geoname_id AS geoname_id_13, t0.country AS country_14, t0.admin1 AS admin1_15, t0.admin2 AS admin2_16, t0.admin3 AS admin3_17, t0.admin4 AS admin4_18 FROM geo__names t0 WHERE t0.geoname_id = ?

[
  2797114
]

SELECT
  t0.name AS name_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.feature_class AS feature_class_4,
  t0.feature_code AS feature_code_5,
  t0.country_id AS country_id_6,
  t0.admin_1_id AS admin_1_id_7,
  t0.admin_2_id AS admin_2_id_8,
  t0.admin_3_id AS admin_3_id_9,
  t0.admin_4_id AS admin_4_id_10,
  t0.population AS population_11,
  t0.moddate AS moddate_12,
  t0.geoname_id AS geoname_id_13,
  t0.country AS country_14,
  t0.admin1 AS admin1_15,
  t0.admin2 AS admin2_16,
  t0.admin3 AS admin3_17,
  t0.admin4 AS admin4_18
FROM
  geo__names t0
WHERE
  t0.geoname_id = ?

SELECT t0.name AS name_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.feature_class AS feature_class_4, t0.feature_code AS feature_code_5, t0.country_id AS country_id_6, t0.admin_1_id AS admin_1_id_7, t0.admin_2_id AS admin_2_id_8, t0.admin_3_id AS admin_3_id_9, t0.admin_4_id AS admin_4_id_10, t0.population AS population_11, t0.moddate AS moddate_12, t0.geoname_id AS geoname_id_13, t0.country AS country_14, t0.admin1 AS admin1_15, t0.admin2 AS admin2_16, t0.admin3 AS admin3_17, t0.admin4 AS admin4_18 FROM geo__names t0 WHERE t0.geoname_id = 2797114;

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM geo__names_translations t0 WHERE t0.object_id = ? ORDER BY t0.locale ASC

[
  2797114
]

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  geo__names_translations t0
WHERE
  t0.object_id = ?
ORDER BY
  t0.locale ASC

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM geo__names_translations t0 WHERE t0.object_id = 2797114 ORDER BY t0.locale ASC;

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 g.country_id) AS cnt
            FROM
                member m,
			    address a
            JOIN geo__names g ON a.location = g.geoname_id 
			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.geoname_id
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.geoname_id 
			WHERE m.id = a.member_id and m.Status IN ('Active', 'OutOfRemind')
        ;

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(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')
        ;

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
        ;