Symfony Profiler

SELECT
  *
FROM
  (
    (
      SELECT
        `O`.`Order`,
        "Corrispettivo" as "Tipo",
        `O`.`Corrispettivo` as "Numero",
        SUM(
          IF(I.`Type` = "charge", 1, 0)
        ) as "Incassi",
        SUM(
          IF(I.`Type` = "refund", 1, 0)
        ) as "Rimborsi",
        `O`.`Payment Reference`,
        `O`.`Total`,
        `O`.`Payment Method`,
        `O`.`Created at`
      FROM
        `ordini` `O`
        LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
      where
        (`O`.`Total` > 0.00)
        AND `O`.`Corrispettivo` <> ""
      GROUP BY
        `O`.`Order`
    )
    UNION
      (
        SELECT
          `O`.`Order`,
          "Fattura" as "Tipo",
          `O`.`Numero Fattura`,
          SUM(
            IF(I.`Type` = "charge", 1, 0)
          ) as "Incassi",
          SUM(
            IF(I.`Type` = "refund", 1, 0)
          ) as "Rimborsi",
          `O`.`Payment Reference`,
          `O`.`Total`,
          `O`.`Payment Method`,
          `O`.`Created at`
        FROM
          `ordini` `O`
          LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
        where
          (`O`.`Total` > 0.00)
          AND `O`.`Numero Fattura` <> ""
        GROUP BY
          `O`.`Order`
      )
    UNION
      (
        SELECT
          `O`.`Order`,
          "--" as "Tipo",
          `O`.`Numero Fattura`,
          SUM(
            IF(I.`Type` = "charge", 1, 0)
          ) as "Incassi",
          SUM(
            IF(I.`Type` = "refund", 1, 0)
          ) as "Rimborsi",
          `O`.`Payment Reference`,
          `O`.`Total`,
          `O`.`Payment Method`,
          `O`.`Created at`
        FROM
          `ordini` `O`
          LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
        where
          (`O`.`Total` > 0.00)
          AND (
            `O`.`Numero Fattura` = ""
            AND `O`.`Corrispettivo` = ""
          )
        GROUP BY
          `O`.`Order`
      )
  ) X
WHERE
  X.`Incassi` = 0
  AND X.`Rimborsi` = 0
ORDER BY
  X.`Created at` DESC

SELECT * 
                FROM ((SELECT `O`.`Order`, "Corrispettivo" as "Tipo", `O`.`Corrispettivo` as "Numero", SUM(IF(I.`Type` = "charge",1, 0)) as "Incassi", SUM(IF(I.`Type` = "refund",1, 0)) as "Rimborsi",
                    `O`.`Payment Reference`, `O`.`Total`, `O`.`Payment Method`, `O`.`Created at`
                    FROM `ordini` `O`
                    LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
                    where (`O`.`Total` > 0.00) AND `O`.`Corrispettivo` <> ""
                    GROUP BY `O`.`Order`)
                
                    
                UNION

                (SELECT `O`.`Order`, "Fattura" as "Tipo", `O`.`Numero Fattura`, SUM(IF(I.`Type` = "charge",1, 0)) as "Incassi", SUM(IF(I.`Type` = "refund",1, 0)) as "Rimborsi",
                    `O`.`Payment Reference`, `O`.`Total`, `O`.`Payment Method`, `O`.`Created at`
                    FROM `ordini` `O`
                    LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
                    where (`O`.`Total` > 0.00) AND `O`.`Numero Fattura` <> ""
                    GROUP BY `O`.`Order`
                )
                
                UNION

                (SELECT `O`.`Order`, "--" as "Tipo", `O`.`Numero Fattura`, SUM(IF(I.`Type` = "charge",1, 0)) as "Incassi", SUM(IF(I.`Type` = "refund",1, 0)) as "Rimborsi",
                    `O`.`Payment Reference`, `O`.`Total`, `O`.`Payment Method`, `O`.`Created at`
                    FROM `ordini` `O`
                    LEFT JOIN `incassi` I ON (`O`.Order = I.`Order`)
                    where (`O`.`Total` > 0.00) AND (`O`.`Numero Fattura` = "" AND `O`.`Corrispettivo` = "")
                    GROUP BY `O`.`Order`
                )                
                
                ) X
                WHERE X.`Incassi` = 0 AND X.`Rimborsi` = 0
                ORDER BY X.`Created at` DESC;