Symfony Profiler

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

Query Metrics

SELECT
                    p.id, 
                    p.type,
                    p.name, 
                    p.address, 
                    p.number,
                    p.zip_code,
                    p.neighborhood,
                    p.city,
                    p.state,
                    p.retail,
                    p.distributor,
                    ROUND((( 3959 * ACOS(COS(RADIANS(-23.681431312067787)) * COS(RADIANS(p.lat)) * COS(RADIANS(p.lng) - RADIANS(-46.67916507977847)) + SIN(RADIANS(-23.681431312067787)) * SIN(RADIANS(p.lat))))*1.61),2) as distance
                FROM
                    pdv p
                WHERE 
                    p.active = 1
                    AND p.active = true
                ORDER BY (distance IS NULL), distance ASC, TRIM(p.name) ASC;

[]

SELECT
  p.id,
  p.type,
  p.name,
  p.address,
  p.number,
  p.zip_code,
  p.neighborhood,
  p.city,
  p.state,
  p.retail,
  p.distributor,
  ROUND(
    (
      (
        3959 * ACOS(
          COS(
            RADIANS(-23.681431312067787)
          ) * COS(
            RADIANS(p.lat)
          ) * COS(
            RADIANS(p.lng) - RADIANS(-46.67916507977847)
          ) + SIN(
            RADIANS(-23.681431312067787)
          ) * SIN(
            RADIANS(p.lat)
          )
        )
      )* 1.61
    ),
    2
  ) as distance
FROM
  pdv p
WHERE
  p.active = 1
  AND p.active = true
ORDER BY
  (distance IS NULL),
  distance ASC,
  TRIM(p.name) ASC;

SELECT
                    p.id, 
                    p.type,
                    p.name, 
                    p.address, 
                    p.number,
                    p.zip_code,
                    p.neighborhood,
                    p.city,
                    p.state,
                    p.retail,
                    p.distributor,
                    ROUND((( 3959 * ACOS(COS(RADIANS(-23.681431312067787)) * COS(RADIANS(p.lat)) * COS(RADIANS(p.lng) - RADIANS(-46.67916507977847)) + SIN(RADIANS(-23.681431312067787)) * SIN(RADIANS(p.lat))))*1.61),2) as distance
                FROM
                    pdv p
                WHERE 
                    p.active = 1
                    AND p.active = true
                ORDER BY (distance IS NULL), distance ASC, TRIM(p.name) ASC;;

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.token = ? LIMIT 1

[
  "086325a2c39dc31b8630bdfccc56e623"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.cpf AS cpf_4,
  t0.avatar AS avatar_5,
  t0.token AS token_6,
  t0.firebase_token AS firebase_token_7,
  t0.os AS os_8,
  t0.initial AS initial_9,
  t0.active AS active_10,
  t0.can_register AS can_register_11,
  t0.did_register AS did_register_12,
  t0.salt_pass AS salt_pass_13,
  t0.salt_pass_expires_at AS salt_pass_expires_at_14,
  t0.token_expire_at AS token_expire_at_15,
  t0.firebase_expire_at AS firebase_expire_at_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.last_login AS last_login_19,
  t0.roles AS roles_20,
  t0.password AS password_21
FROM
  user t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.token = '086325a2c39dc31b8630bdfccc56e623' LIMIT 1;