Symfony Profiler

SELECT
  p.id,
  p.title,
  p.description,
  c.title AS category,
  p.size_id AS grp
FROM
  almeda.product p
  JOIN almeda.category c ON c.id = p.category_id
WHERE
  p.enabled = 1
ORDER BY
  p.size_id,
  p.title

SELECT p.id
    ,p.title
    ,p.description
    ,c.title AS category
    ,p.size_id AS grp 
FROM almeda.product p 
JOIN almeda.category c 
 ON c.id = p.category_id 
WHERE p.enabled = 1 
ORDER BY p.size_id, p.title;

SELECT
  DISTINCT product_id
FROM
  almeda.size
ORDER BY
  product_id;

SELECT DISTINCT product_id FROM almeda.size ORDER BY product_id;;

SELECT
  *
FROM
  almeda.size
ORDER BY
  product_id,
  id;

SELECT * FROM almeda.size ORDER BY product_id, id;;

SELECT
  *
FROM
  almeda.vPageSectionInfo
WHERE
  CategoryID = :catID
  OR ProductID = 9
ORDER BY
  PageTitle,
  PageSequence,
  SizeSequence,
  ProductCost;

SELECT * FROM almeda.vPageSectionInfo WHERE CategoryID = 1 OR ProductID = 9 ORDER BY PageTitle, PageSequence, SizeSequence, ProductCost;;

SELECT
  *
FROM
  almeda.vPageSectionInfo
WHERE
  CategoryID = :catID
ORDER BY
  PageTitle,
  PageSequence,
  SizeSequence,
  ProductCost;

SELECT * FROM almeda.vPageSectionInfo WHERE CategoryID = 2 ORDER BY PageTitle, PageSequence, SizeSequence, ProductCost;;