Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 ORDER BY t0.external_id DESC LIMIT 1

[]

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.user_name AS user_name_3,
  t0.user_email AS user_email_4,
  t0.company AS company_5,
  t0.tax_number AS tax_number_6,
  t0.gross AS gross_7,
  t0.net5 AS net5_8,
  t0.net23 AS net23_9,
  t0.tax5 AS tax5_10,
  t0.tax23 AS tax23_11,
  t0.items_count AS items_count_12,
  t0.status AS status_13,
  t0.created_at AS created_at_14,
  t0.main_product_id AS main_product_id_15,
  t0.ad_id AS ad_id_16
FROM
  `order` t0
ORDER BY
  t0.external_id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.user_name AS user_name_3, t0.user_email AS user_email_4, t0.company AS company_5, t0.tax_number AS tax_number_6, t0.gross AS gross_7, t0.net5 AS net5_8, t0.net23 AS net23_9, t0.tax5 AS tax5_10, t0.tax23 AS tax23_11, t0.items_count AS items_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.main_product_id AS main_product_id_15, t0.ad_id AS ad_id_16 FROM `order` t0 ORDER BY t0.external_id DESC LIMIT 1;

SELECT o.id AS order_id, u.display_name AS user_name, u.user_email, wwoa.company, NULLIF(wwom_tax.meta_value, '') AS tax_no, ROUND(o.total_amount, 2) AS gross, COALESCE(MAX(CASE WHEN rpm.meta_value = '5' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)), 2) END), 0) AS tax_5, COALESCE(MAX(CASE WHEN rpm.meta_value = '23' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)), 2) END), 0) AS tax_23, COALESCE(MAX(CASE WHEN rpm.meta_value = '5' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)) * 100 / 5, 2) END), 0) AS net_5, COALESCE(MAX(CASE WHEN rpm.meta_value = '23' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)) * 100 / 23, 2) END), 0) AS net_23, COUNT(DISTINCT oil.order_item_id) AS items_count, GROUP_CONCAT(DISTINCT pi.meta_value ORDER BY pi.meta_value SEPARATOR ',') AS product_ids, GROUP_CONCAT(DISTINCT oil.order_item_name ORDER BY oil.order_item_name SEPARATOR ',') AS product_names, wwom_pys.meta_value AS pys_enrich_data, wwom_wcfc.meta_value AS wcf_checkout_id, o.date_created_gmt AS created_at FROM wp_wc_orders o INNER JOIN wp_users u ON u.id = o.customer_id INNER JOIN wp_wc_order_addresses wwoa ON wwoa.order_id = o.id LEFT JOIN wp_wc_orders_meta wwom_tax ON wwom_tax.order_id = o.id AND wwom_tax.meta_key = '_billing_tax_no' LEFT JOIN wp_wc_orders_meta wwom_pys ON wwom_pys.order_id = o.id AND wwom_pys.meta_key = 'pys_enrich_data' LEFT JOIN wp_wc_orders_meta wwom_wcfc ON wwom_wcfc.order_id = o.id AND wwom_wcfc.meta_key = '_wcf_checkout_id' LEFT JOIN wp_woocommerce_order_items oi ON oi.order_id = o.id AND oi.order_item_type = 'tax' LEFT JOIN wp_woocommerce_order_items oil ON oil.order_id = o.id AND oil.order_item_type = 'line_item' LEFT JOIN wp_woocommerce_order_itemmeta tam ON tam.order_item_id = oi.order_item_id AND tam.meta_key = 'tax_amount' LEFT JOIN wp_woocommerce_order_itemmeta rpm ON rpm.order_item_id = oi.order_item_id AND rpm.meta_key = 'rate_percent' LEFT JOIN wp_woocommerce_order_itemmeta pi ON pi.order_item_id = oil.order_item_id AND pi.meta_key = '_product_id' WHERE ((o.status = ?) OR (o.status = ?)) AND (o.id > ?) GROUP BY o.id ORDER BY o.id ASC

[
  "wc-completed"
  "wc-processing"
  17850
]

SELECT
  o.id AS order_id,
  u.display_name AS user_name,
  u.user_email,
  wwoa.company,
  NULLIF(wwom_tax.meta_value, '') AS tax_no,
  ROUND(o.total_amount, 2) AS gross,
  COALESCE(
    MAX(
      CASE WHEN rpm.meta_value = '5' THEN
        ROUND(
          CAST(
            tam.meta_value AS DECIMAL(10, 2)
          ),
          2
        )
      END
    ),
    0
  ) AS tax_5,
  COALESCE(
    MAX(
      CASE WHEN rpm.meta_value = '23' THEN
        ROUND(
          CAST(
            tam.meta_value AS DECIMAL(10, 2)
          ),
          2
        )
      END
    ),
    0
  ) AS tax_23,
  COALESCE(
    MAX(
      CASE WHEN rpm.meta_value = '5' THEN
        ROUND(
          CAST(
            tam.meta_value AS DECIMAL(10, 2)
          ) * 100 / 5,
          2
        )
      END
    ),
    0
  ) AS net_5,
  COALESCE(
    MAX(
      CASE WHEN rpm.meta_value = '23' THEN
        ROUND(
          CAST(
            tam.meta_value AS DECIMAL(10, 2)
          ) * 100 / 23,
          2
        )
      END
    ),
    0
  ) AS net_23,
  COUNT(DISTINCT oil.order_item_id) AS items_count,
  GROUP_CONCAT(
    DISTINCT pi.meta_value
    ORDER BY
      pi.meta_value SEPARATOR ','
  ) AS product_ids,
  GROUP_CONCAT(
    DISTINCT oil.order_item_name
    ORDER BY
      oil.order_item_name SEPARATOR ','
  ) AS product_names,
  wwom_pys.meta_value AS pys_enrich_data,
  wwom_wcfc.meta_value AS wcf_checkout_id,
  o.date_created_gmt AS created_at
FROM
  wp_wc_orders o
  INNER JOIN wp_users u ON u.id = o.customer_id
  INNER JOIN wp_wc_order_addresses wwoa ON wwoa.order_id = o.id
  LEFT JOIN wp_wc_orders_meta wwom_tax ON wwom_tax.order_id = o.id
  AND wwom_tax.meta_key = '_billing_tax_no'
  LEFT JOIN wp_wc_orders_meta wwom_pys ON wwom_pys.order_id = o.id
  AND wwom_pys.meta_key = 'pys_enrich_data'
  LEFT JOIN wp_wc_orders_meta wwom_wcfc ON wwom_wcfc.order_id = o.id
  AND wwom_wcfc.meta_key = '_wcf_checkout_id'
  LEFT JOIN wp_woocommerce_order_items oi ON oi.order_id = o.id
  AND oi.order_item_type = 'tax'
  LEFT JOIN wp_woocommerce_order_items oil ON oil.order_id = o.id
  AND oil.order_item_type = 'line_item'
  LEFT JOIN wp_woocommerce_order_itemmeta tam ON tam.order_item_id = oi.order_item_id
  AND tam.meta_key = 'tax_amount'
  LEFT JOIN wp_woocommerce_order_itemmeta rpm ON rpm.order_item_id = oi.order_item_id
  AND rpm.meta_key = 'rate_percent'
  LEFT JOIN wp_woocommerce_order_itemmeta pi ON pi.order_item_id = oil.order_item_id
  AND pi.meta_key = '_product_id'
WHERE
  (
    (o.status = ?)
    OR (o.status = ?)
  )
  AND (o.id > ?)
GROUP BY
  o.id
ORDER BY
  o.id ASC

SELECT o.id AS order_id, u.display_name AS user_name, u.user_email, wwoa.company, NULLIF(wwom_tax.meta_value, '') AS tax_no, ROUND(o.total_amount, 2) AS gross, COALESCE(MAX(CASE WHEN rpm.meta_value = '5' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)), 2) END), 0) AS tax_5, COALESCE(MAX(CASE WHEN rpm.meta_value = '23' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)), 2) END), 0) AS tax_23, COALESCE(MAX(CASE WHEN rpm.meta_value = '5' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)) * 100 / 5, 2) END), 0) AS net_5, COALESCE(MAX(CASE WHEN rpm.meta_value = '23' THEN ROUND(CAST(tam.meta_value AS DECIMAL(10,2)) * 100 / 23, 2) END), 0) AS net_23, COUNT(DISTINCT oil.order_item_id) AS items_count, GROUP_CONCAT(DISTINCT pi.meta_value ORDER BY pi.meta_value SEPARATOR ',') AS product_ids, GROUP_CONCAT(DISTINCT oil.order_item_name ORDER BY oil.order_item_name SEPARATOR ',') AS product_names, wwom_pys.meta_value AS pys_enrich_data, wwom_wcfc.meta_value AS wcf_checkout_id, o.date_created_gmt AS created_at FROM wp_wc_orders o INNER JOIN wp_users u ON u.id = o.customer_id INNER JOIN wp_wc_order_addresses wwoa ON wwoa.order_id = o.id LEFT JOIN wp_wc_orders_meta wwom_tax ON wwom_tax.order_id = o.id AND wwom_tax.meta_key = '_billing_tax_no' LEFT JOIN wp_wc_orders_meta wwom_pys ON wwom_pys.order_id = o.id AND wwom_pys.meta_key = 'pys_enrich_data' LEFT JOIN wp_wc_orders_meta wwom_wcfc ON wwom_wcfc.order_id = o.id AND wwom_wcfc.meta_key = '_wcf_checkout_id' LEFT JOIN wp_woocommerce_order_items oi ON oi.order_id = o.id AND oi.order_item_type = 'tax' LEFT JOIN wp_woocommerce_order_items oil ON oil.order_id = o.id AND oil.order_item_type = 'line_item' LEFT JOIN wp_woocommerce_order_itemmeta tam ON tam.order_item_id = oi.order_item_id AND tam.meta_key = 'tax_amount' LEFT JOIN wp_woocommerce_order_itemmeta rpm ON rpm.order_item_id = oi.order_item_id AND rpm.meta_key = 'rate_percent' LEFT JOIN wp_woocommerce_order_itemmeta pi ON pi.order_item_id = oil.order_item_id AND pi.meta_key = '_product_id' WHERE ((o.status = 'wc-completed') OR (o.status = 'wc-processing')) AND (o.id > 17850) GROUP BY o.id ORDER BY o.id ASC;