Symfony Profiler

SELECT
  I.id,
  I.PaymentReference,
  I.Order,
  I.Date,
  I.Source,
  I.Type,
  I.`ChargeAmount`,
  I.`RefundAmount`,
  (
    SELECT
      IF(
        (
          (`Numero Fattura` = "")
          AND (`Corrispettivo` = "")
        ),
        "NO",
        ""
      )
    FROM
      `ordini`
    WHERE
      `Order` = I.`Order`
  ) AS "Gestito"
FROM
  `incassi` I
  LEFT JOIN `ordini` O ON (
    I.`Order` = O.`Order`
    AND O.`Shop` = 1
    AND (
      `Numero Fattura` <> ""
      OR `Corrispettivo` <> ""
    )
  )
WHERE
  1
  AND I.`Shop` = 1
  AND O.Order IS NULL

SELECT I.id, I.PaymentReference, I.Order, I.Date, I.Source, I.Type, I.`ChargeAmount`, I.`RefundAmount`, 
                                      (SELECT IF(((`Numero Fattura` = "") AND (`Corrispettivo` = "")), "NO", "") FROM `ordini` WHERE `Order` = I.`Order`) AS "Gestito"
                                FROM `incassi` I
                                LEFT JOIN `ordini` O ON (I.`Order` = O.`Order` AND O.`Shop` = 1 AND (`Numero Fattura` <> "" OR `Corrispettivo` <> ""))
                                WHERE 1 AND I.`Shop` = 1 AND O.Order IS NULL;

SELECT
  *
FROM
  (
    SELECT
      I.id,
      O.Order,
      O.`Numero Fattura`,
      O.`Corrispettivo`,
      O.`Payment Reference`,
      I.`PaymentReference`,
      I.Source,
      I.`ChargeAmount`,
      I.`RefundAmount`
    FROM
      ordini O
      JOIN incassi I ON (O.Order = I.`Order`)
    WHERE
      I.`Order` <> ""
    UNION
      (
        SELECT
          I.id,
          O.Order,
          O.`Numero Fattura`,
          O.`Corrispettivo`,
          O.`Payment Reference`,
          I.`PaymentReference`,
          I.Source,
          I.`ChargeAmount`,
          I.`RefundAmount`
        FROM
          ordini O
          JOIN incassi I ON (
            I.Order = ""
            AND (
              INSTR(
                O.`Payment Reference`, I.`PaymentReference`
              ) > 0
            )
          )
      )
  ) INCASSI
WHERE
  INCASSI.Order NOT IN (
    SELECT
      `Order`
    FROM
      ordini
  )

SELECT * FROM
                                        (SELECT I.id, O.Order, O.`Numero Fattura`, O.`Corrispettivo`, O.`Payment Reference`, I.`PaymentReference`, I.Source, I.`ChargeAmount`, I.`RefundAmount`
                                        FROM ordini O
                                        JOIN incassi I ON (O.Order = I.`Order`)
                                        WHERE I.`Order` <> ""
                                        
                                        UNION
                                        
                                        (
                                        SELECT I.id, O.Order, O.`Numero Fattura`, O.`Corrispettivo`, O.`Payment Reference`, I.`PaymentReference`, I.Source, I.`ChargeAmount`, I.`RefundAmount`
                                        FROM ordini O
                                        JOIN incassi I ON (I.Order = "" AND (INSTR(O.`Payment Reference`, I.`PaymentReference`) > 0))
                                        )) INCASSI 
                                        WHERE INCASSI.Order NOT IN (SELECT `Order` FROM ordini)
                                        ;