Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 19
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations
• Debug
• Messages
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.user_id AS user_id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.display_name AS display_name_6, t0.info AS info_7, t0.last_login AS last_login_8, t0.last_login_from AS last_login_from_9, t0.state AS state_10 FROM tbl_users t0 WHERE t0.email = ? LIMIT 1

[
  "mads@gartneriet.dk"
]

SELECT
  t0.user_id AS user_id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.display_name AS display_name_6,
  t0.info AS info_7,
  t0.last_login AS last_login_8,
  t0.last_login_from AS last_login_from_9,
  t0.state AS state_10
FROM
  tbl_users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.user_id AS user_id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.display_name AS display_name_6, t0.info AS info_7, t0.last_login AS last_login_8, t0.last_login_from AS last_login_from_9, t0.state AS state_10 FROM tbl_users t0 WHERE t0.email = 'mads@gartneriet.dk' LIMIT 1;

SELECT
               extract(epoch from alldates::timestamp)::varchar as id,
               extract(epoch from alldates::timestamp)::varchar as "@id",
               alldates::date as "dato",
               date_part('week', alldates)::int as week,
               date_part('month', alldates)::int as month,
               date_part('year', alldates)::int as year,
               sales.customer_count::int,
               -sales.total_sale::float AS total_sale,
               sales.created_at
        FROM (
            SELECT *
              FROM
                  generate_series(
                              date_trunc('year', now()) - '1 year'::interval,
                              date_trunc('year', now()) + '1 year'::interval - '1 day'::interval,
                              '1 day'
                      ) as alldates
        ) AS alldates
            LEFT JOIN (
                SELECT s.*,
                       sum(p.amount)::float as total_sale
                FROM acc_sales s
                         JOIN acc_postings p ON s.id = p.sales_id
                WHERE p.account < 50000
                GROUP BY s.id
                ORDER BY s.id DESC

            ) AS sales ON alldates::date = to_timestamp(sales.sale_date)::date
        ;

[]

SELECT
  extract(
    epoch
    from
      alldates :: timestamp
  ):: varchar as id,
  extract(
    epoch
    from
      alldates :: timestamp
  ):: varchar as "@id",
  alldates :: date as "dato",
  date_part('week', alldates):: int as week,
  date_part('month', alldates):: int as month,
  date_part('year', alldates):: int as year,
  sales.customer_count :: int,
  - sales.total_sale :: float AS total_sale,
  sales.created_at
FROM
  (
    SELECT
      *
    FROM
      generate_series(
        date_trunc(
          'year',
          now()
        ) - '1 year' :: interval,
        date_trunc(
          'year',
          now()
        ) + '1 year' :: interval - '1 day' :: interval,
        '1 day'
      ) as alldates
  ) AS alldates
  LEFT JOIN (
    SELECT
      s.*,
      sum(p.amount):: float as total_sale
    FROM
      acc_sales s
      JOIN acc_postings p ON s.id = p.sales_id
    WHERE
      p.account < 50000
    GROUP BY
      s.id
    ORDER BY
      s.id DESC
  ) AS sales ON alldates :: date = to_timestamp(sales.sale_date):: date;

SELECT
               extract(epoch from alldates::timestamp)::varchar as id,
               extract(epoch from alldates::timestamp)::varchar as "@id",
               alldates::date as "dato",
               date_part('week', alldates)::int as week,
               date_part('month', alldates)::int as month,
               date_part('year', alldates)::int as year,
               sales.customer_count::int,
               -sales.total_sale::float AS total_sale,
               sales.created_at
        FROM (
            SELECT *
              FROM
                  generate_series(
                              date_trunc('year', now()) - '1 year'::interval,
                              date_trunc('year', now()) + '1 year'::interval - '1 day'::interval,
                              '1 day'
                      ) as alldates
        ) AS alldates
            LEFT JOIN (
                SELECT s.*,
                       sum(p.amount)::float as total_sale
                FROM acc_sales s
                         JOIN acc_postings p ON s.id = p.sales_id
                WHERE p.account < 50000
                GROUP BY s.id
                ORDER BY s.id DESC

            ) AS sales ON alldates::date = to_timestamp(sales.sale_date)::date
        ;
        ;