Symfony Profiler

SELECT 
  DISTINCT product.id, 
  product.company_id, 
  product.orig_name, 
  product.creation_date, 
  IF (
    product.orig_name LIKE ?, 
    20, 
    IF (
      product.orig_brand_name LIKE ?, 10, 
      0
    )
  ) + IF (
    product.orig_brand_name LIKE ?, 10, 
    0
  ) + IF (company.name LIKE ?, 5, 0) + IF (tag.name LIKE ?, 5, 0) AS weight, 
  (
    (
      (
        SELECT 
          COUNT(cart_product.id) 
        FROM 
          cart_product 
        WHERE 
          cart_product.product_id = product.id
      ) + 1
    ) / 100
  ) as total_cart 
FROM 
  product 
  LEFT JOIN company ON company.id = product.company_id 
  LEFT JOIN tag_product ON tag_product.product_id = product.id 
  LEFT JOIN tag ON tag.id = tag_product.tag_id 
  LEFT JOIN pricing_product ON pricing_product.product_id = product.id 
  LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id 
WHERE 
  (
    product.orig_name LIKE ? 
    OR product.orig_brand_name LIKE ? 
    OR product.orig_description LIKE ? 
    OR product.list_of_ingredients LIKE ? 
    OR company.name LIKE ? 
    OR tag.name LIKE ?
  ) 
  AND (
    product.draft != 1 
    AND product.available > 0 
    AND product.is_hri = 0 
    AND product.is_displayed_in_association_only = 0 
    AND product.main_image_id IS NOT NULL 
    AND company.show_publicly = 1
  ) 
  AND (
    (
      product.qty_ready_to_ship > 0 
      AND product.delivery_type = 0
    ) 
    OR (product.delivery_type != 0)
  ) 
ORDER BY 
  (`weight` + `total_cart`) DESC

SELECT DISTINCT product.id, product.company_id, product.orig_name, product.creation_date,

      IF (product.orig_name LIKE '%Jack%flat%', 20, IF (product.orig_brand_name LIKE '%Jack%flat%', 10, 0))
  		+ IF (product.orig_brand_name LIKE '%Jack%flat%', 10, 0)
  		+ IF (company.name LIKE '%Jack%flat%', 5, 0)
  		+ IF (tag.name LIKE '%Jack%flat%', 5, 0)
  		AS weight,

      ( ( (SELECT COUNT(cart_product.id) FROM cart_product WHERE cart_product.product_id = product.id) + 1 ) / 100 ) as total_cart

      FROM product

      LEFT JOIN company ON company.id = product.company_id
      LEFT JOIN tag_product ON tag_product.product_id = product.id
      LEFT JOIN tag ON tag.id = tag_product.tag_id
      LEFT JOIN pricing_product ON pricing_product.product_id = product.id
      LEFT JOIN pricing ON pricing.id = pricing_product.pricing_id

      WHERE (
        product.orig_name LIKE '%Jack%flat%'
        OR product.orig_brand_name LIKE '%Jack%flat%'
        OR product.orig_description LIKE '%Jack%flat%'
        OR product.list_of_ingredients LIKE '%Jack%flat%'
        OR company.name LIKE '%Jack%flat%'
        OR tag.name LIKE '%Jack%flat%'
      ) AND (
        product.draft != 1
        AND product.available > 0
        AND product.is_hri = 0
        AND product.is_displayed_in_association_only = 0
        AND product.main_image_id IS NOT NULL
        AND company.show_publicly = 1
      ) AND
      (
        (
          product.qty_ready_to_ship > 0
          AND product.delivery_type = 0
        ) OR (
          product.delivery_type != 0
        )
      )
      
        ORDER BY ( `weight` + `total_cart` ) DESC
        ;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.province AS province_3, 
  t0.country AS country_4 
FROM 
  region t0 
WHERE 
  t0.province = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.province AS province_3, t0.country AS country_4 FROM region t0 WHERE t0.province = 'Qc';

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.display_order AS display_order_3, 
  t0.maturin_fees_pc AS maturin_fees_pc_4, 
  t0.packing_fees_amount AS packing_fees_amount_5, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_6 
FROM 
  conservation t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.maturin_fees_pc AS maturin_fees_pc_4, t0.packing_fees_amount AS packing_fees_amount_5, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_6 FROM conservation t0;