Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  stock s0_
ORDER BY
  s0_.id DESC
LIMIT
  50
OFFSET
  9700

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM stock s0_ ORDER BY s0_.id DESC LIMIT 50 OFFSET 9700;

SELECT
  s0_.id AS id_0,
  s0_.sku AS sku_1,
  s0_.ls_stock AS ls_stock_2,
  s0_.ls_cp AS ls_cp_3,
  s0_.alloy_stock AS alloy_stock_4,
  s0_.alloy_cp AS alloy_cp_5,
  s0_.mmt_stock AS mmt_stock_6,
  s0_.mmt_cp AS mmt_cp_7,
  s0_.ds_stock AS ds_stock_8,
  s0_.ds_cp AS ds_cp_9,
  s0_.dd_stock AS dd_stock_10,
  s0_.dd_cp AS dd_cp_11,
  s0_.dd_status AS dd_status_12,
  s0_.rrp AS rrp_13,
  s0_.synnex_cp AS synnex_cp_14,
  s0_.synnex_stock AS synnex_stock_15
FROM
  stock s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_stock AS ls_stock_2, s0_.ls_cp AS ls_cp_3, s0_.alloy_stock AS alloy_stock_4, s0_.alloy_cp AS alloy_cp_5, s0_.mmt_stock AS mmt_stock_6, s0_.mmt_cp AS mmt_cp_7, s0_.ds_stock AS ds_stock_8, s0_.ds_cp AS ds_cp_9, s0_.dd_stock AS dd_stock_10, s0_.dd_cp AS dd_cp_11, s0_.dd_status AS dd_status_12, s0_.rrp AS rrp_13, s0_.synnex_cp AS synnex_cp_14, s0_.synnex_stock AS synnex_stock_15 FROM stock s0_ WHERE s0_.id IN (26459, 26458, 26457, 26456, 26455, 26454, 26453, 26452, 26451, 26450, 26449, 26448, 26447, 26446, 26445, 26444, 26443, 26442, 26441, 26440, 26439, 26438, 26437, 26436, 26435, 26434, 26433, 26432, 26431, 26430, 26429, 26428, 26427, 26426, 26425, 26424, 26423, 26422, 26421, 26420, 26419, 26418, 26417, 26416, 26415, 26414, 26413, 26412, 26411, 26410) ORDER BY s0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  stock s0_

SELECT count(*) AS sclr_0 FROM stock s0_;