Symfony Profiler

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

Query Metrics

select * from  shop where shopid = '8597665'

[]

select
  *
from
  shop
where
  shopid = '8597665'

select * from  shop where shopid = '8597665';

select * from orders 
        JOIN orderstatus ON orderstatus.orderid = orders.orderid
        JOIN user ON user.userid = orders.userid
        JOIN useraddress ON useraddress.userid = user.userid
        JOIN orderaddress ON orderaddress.orderid = orders.orderid
        where establishmentid = '8597665' and orderstatus.status <> 'preview' group by orders.orderid order by orders.id desc limit 0,10

[]

select
  *
from
  orders
  JOIN orderstatus ON orderstatus.orderid = orders.orderid
  JOIN user ON user.userid = orders.userid
  JOIN useraddress ON useraddress.userid = user.userid
  JOIN orderaddress ON orderaddress.orderid = orders.orderid
where
  establishmentid = '8597665'
  and orderstatus.status <> 'preview'
group by
  orders.orderid
order by
  orders.id desc
limit
  0, 10

select * from orders 
        JOIN orderstatus ON orderstatus.orderid = orders.orderid
        JOIN user ON user.userid = orders.userid
        JOIN useraddress ON useraddress.userid = user.userid
        JOIN orderaddress ON orderaddress.orderid = orders.orderid
        where establishmentid = '8597665' and orderstatus.status <> 'preview' group by orders.orderid order by orders.id desc limit 0,10;

SELECT productname, SUM(productorderprice) AS total_amount, orderproducts.quantity as productorderquantity FROM orderproducts 
        JOIN orders ON orders.orderid = orderproducts.orderid
        WHERE addedtime >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) and orders.establishmentid = '8597665' GROUP BY productname ORDER BY total_amount DESC LIMIT 10

[]

SELECT
  productname,
  SUM(productorderprice) AS total_amount,
  orderproducts.quantity as productorderquantity
FROM
  orderproducts
  JOIN orders ON orders.orderid = orderproducts.orderid
WHERE
  addedtime >= DATE_SUB(
    CURDATE(),
    INTERVAL 1 MONTH
  )
  and orders.establishmentid = '8597665'
GROUP BY
  productname
ORDER BY
  total_amount DESC
LIMIT
  10

SELECT productname, SUM(productorderprice) AS total_amount, orderproducts.quantity as productorderquantity FROM orderproducts 
        JOIN orders ON orders.orderid = orderproducts.orderid
        WHERE addedtime >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) and orders.establishmentid = '8597665' GROUP BY productname ORDER BY total_amount DESC LIMIT 10;

SELECT DATE(ordertime) AS order_date, SUM(ordertotal) AS total_order_value FROM orders WHERE ordertime >= CURDATE() - INTERVAL 1 MONTH and orders.establishmentid = '8597665' GROUP BY DATE(ordertime) ORDER BY order_date ASC

[]

SELECT
  DATE(ordertime) AS order_date,
  SUM(ordertotal) AS total_order_value
FROM
  orders
WHERE
  ordertime >= CURDATE() - INTERVAL 1 MONTH
  and orders.establishmentid = '8597665'
GROUP BY
  DATE(ordertime)
ORDER BY
  order_date ASC

SELECT DATE(ordertime) AS order_date, SUM(ordertotal) AS total_order_value FROM orders WHERE ordertime >= CURDATE() - INTERVAL 1 MONTH and orders.establishmentid = '8597665' GROUP BY DATE(ordertime) ORDER BY order_date ASC;

SELECT MONTH(ordertime) AS order_month, YEAR(ordertime) AS order_year, SUM(ordertotal) AS month_order_value FROM orders WHERE ordertime >= CURDATE() - INTERVAL 12 MONTH and orders.establishmentid = '8597665' GROUP BY MONTH(ordertime) ORDER BY order_month ASC

[]

SELECT
  MONTH(ordertime) AS order_month,
  YEAR(ordertime) AS order_year,
  SUM(ordertotal) AS month_order_value
FROM
  orders
WHERE
  ordertime >= CURDATE() - INTERVAL 12 MONTH
  and orders.establishmentid = '8597665'
GROUP BY
  MONTH(ordertime)
ORDER BY
  order_month ASC

SELECT MONTH(ordertime) AS order_month, YEAR(ordertime) AS order_year, SUM(ordertotal) AS month_order_value FROM orders WHERE ordertime >= CURDATE() - INTERVAL 12 MONTH and orders.establishmentid = '8597665' GROUP BY MONTH(ordertime) ORDER BY order_month ASC;