Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat = ?
ORDER BY
  c0_.id ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = 1 ORDER BY c0_.id ASC LIMIT 7;

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat = ?
ORDER BY
  c0_.id ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = 2 ORDER BY c0_.id ASC LIMIT 7;

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat = ?
ORDER BY
  c0_.id ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = 3 ORDER BY c0_.id ASC LIMIT 7;

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat <> ?
ORDER BY
  c0_.created_at DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat <> 10 ORDER BY c0_.created_at DESC LIMIT 10;

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat = ?
ORDER BY
  c0_.id ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = 5 ORDER BY c0_.id ASC LIMIT 7;

SELECT
  c0_.id AS id_0,
  c0_.cart_cat AS cart_cat_1,
  c0_.type AS type_2,
  c0_.type1 AS type1_3,
  c0_.status AS status_4,
  c0_.user_id AS user_id_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.name AS name_8,
  c0_.name_en AS name_en_9,
  c0_.content AS content_10,
  c0_.content_en AS content_en_11,
  c0_.image AS image_12,
  c0_.price AS price_13,
  c0_.price_old AS price_old_14
FROM
  cart_product c0_
WHERE
  c0_.cart_cat = ?
ORDER BY
  c0_.id ASC
LIMIT
  7

SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = 6 ORDER BY c0_.id ASC LIMIT 7;

SELECT
  cat_sp,
  sum(price) as sum1
FROM
  cart_product_sp
WHERE
  cat_sp = 1
UNION
SELECT
  cat_sp,
  sum(price) as sum2
FROM
  cart_product_sp
WHERE
  cat_sp = 2
UNION
SELECT
  cat_sp,
  sum(price) as sum3
FROM
  cart_product_sp
WHERE
  cat_sp = 3
UNION
SELECT
  cat_sp,
  sum(price) as sum4
FROM
  cart_product_sp
WHERE
  cat_sp = 4
UNION
SELECT
  cat_sp,
  sum(price) as sum5
FROM
  cart_product_sp
WHERE
  cat_sp = 5

SELECT cat_sp, sum(price) as sum1
                FROM cart_product_sp
				WHERE cat_sp =1
				UNION
				SELECT cat_sp, sum(price) as sum2
                FROM cart_product_sp
			    WHERE cat_sp =2
				UNION
				SELECT cat_sp, sum(price) as sum3
				FROM cart_product_sp
				WHERE cat_sp =3
				UNION
				SELECT cat_sp, sum(price) as sum4
				FROM cart_product_sp
				WHERE 	cat_sp =4
				UNION
				SELECT cat_sp, sum(price) as sum5
				FROM cart_product_sp
				WHERE 	cat_sp =5
			    ;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.name AS name_3,
  c0_.content AS content_4,
  c0_.image AS image_5,
  c0_.price AS price_6
FROM
  cart_payment c0_

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.content AS content_4, c0_.image AS image_5, c0_.price AS price_6 FROM cart_payment c0_;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.name AS name_3,
  c0_.price AS price_4,
  c0_.content AS content_5,
  c0_.image AS image_6
FROM
  cart_shipment c0_

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.price AS price_4, c0_.content AS content_5, c0_.image AS image_6 FROM cart_shipment c0_;