Symfony Profiler

SELECT
  p.id,
  p.name,
  p.model_no AS modelNo,
  p.product_fdm AS productFdm,
  p.global_id AS globalId,
  p.sync_flag AS syncFlag,
  '' AS description,
  p.alias,
  ig.name AS igName,
  cat.name AS categoryName,
  sub.name AS subCategoryName,
  br.name AS brandName,
  ut.name AS uomName,
  '' AS image
FROM
  inv_products p
  LEFT JOIN inv_item_group ig ON ig.id = p.ig_id
  LEFT JOIN inv_product_categories cat ON cat.id = p.category_id
  LEFT JOIN inv_product_sub_categories sub ON sub.id = p.sub_category_id
  LEFT JOIN brand_company br ON br.id = p.brand_company
  LEFT JOIN unit_type ut ON ut.id = p.unit_type_id
WHERE
  (
    p.name LIKE ?
    OR p.model_no LIKE ?
  )
ORDER BY
  CASE WHEN p.name = ? THEN 0 WHEN p.model_no = ? THEN 1 ELSE 2 END,
  p.name ASC
LIMIT
  ?

SELECT p.id, p.name, p.model_no AS modelNo, p.product_fdm AS productFdm, p.global_id AS globalId, p.sync_flag AS syncFlag, '' AS description, p.alias, ig.name AS igName, cat.name AS categoryName, sub.name AS subCategoryName, br.name AS brandName, ut.name AS uomName, '' AS image
                FROM inv_products p
                LEFT JOIN inv_item_group ig ON ig.id = p.ig_id
                LEFT JOIN inv_product_categories cat ON cat.id = p.category_id
                LEFT JOIN inv_product_sub_categories sub ON sub.id = p.sub_category_id
                LEFT JOIN brand_company br ON br.id = p.brand_company
                LEFT JOIN unit_type ut ON ut.id = p.unit_type_id
                WHERE (p.name LIKE '%JA Sola%' OR p.model_no LIKE '%JA Sola%')
                ORDER BY CASE WHEN p.name = 'JA Sola' THEN 0 WHEN p.model_no = 'JA Sola' THEN 1 ELSE 2 END, p.name ASC
                LIMIT 10;

SELECT
  table_name AS t
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()

SELECT table_name AS t FROM information_schema.tables WHERE table_schema = DATABASE();

SELECT
  column_name AS c
FROM
  information_schema.columns
WHERE
  table_schema = DATABASE()
  AND table_name = 'inv_products'

SELECT column_name AS c FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'inv_products';