Symfony Profiler

SELECT
  DISTINCT c.marca AS codigo,
  CONCAT('(', c.cross_reference, ')') AS descripcion,
  e.nombres AS categoriaPadre
FROM
  cross_references c
  LEFT JOIN producto p ON p.id = c.id_producto
  LEFT JOIN estructura_ecommerce e ON e.id = CAST(
    substring(
      p.id_estructura_ecommerce
      FROM
        'i:0;s:\d+:"(\d+)";'
    ) AS int
  )
WHERE
  p.status_infor = 1
  AND p.sesion = false
  AND p.status_ecommerce = 1
ORDER BY
  c.marca ASC

SELECT DISTINCT c.marca AS codigo, CONCAT('(', c.cross_reference, ')') AS descripcion, e.nombres AS categoriaPadre FROM cross_references c LEFT JOIN producto p ON p.id = c.id_producto LEFT JOIN estructura_ecommerce e ON e.id = CAST( substring( p.id_estructura_ecommerce FROM 'i:0;s:\d+:"(\d+)";' ) AS int )  WHERE p.status_infor = 1  AND p.sesion = false  AND p.status_ecommerce = 1 ORDER BY c.marca ASC ;

SELECT
  p.descripcion_corta AS descripcion,
  CONCAT('(', p.idinfor, ')') AS codigo,
  e.nombres AS categoriaPadre
FROM
  producto p
  LEFT JOIN estructura_ecommerce e ON e.id = CAST(
    substring(
      p.id_estructura_ecommerce
      FROM
        'i:0;s:\d+:"(\d+)";'
    ) AS int
  )
WHERE
  p.status_infor = 1
  AND p.sesion = false
  AND p.status_ecommerce = 1
ORDER BY
  p.descripcion_corta ASC

SELECT p.descripcion_corta AS descripcion, CONCAT('(', p.idinfor, ')') AS codigo, e.nombres AS categoriaPadre FROM producto p LEFT JOIN estructura_ecommerce e ON e.id = CAST( substring( p.id_estructura_ecommerce FROM 'i:0;s:\d+:"(\d+)";' ) AS int ) WHERE p.status_infor = 1  AND p.sesion = false  AND p.status_ecommerce = 1 ORDER BY p.descripcion_corta ASC ;