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
  4800

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

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 (31359, 31358, 31357, 31356, 31355, 31354, 31353, 31352, 31351, 31350, 31349, 31348, 31347, 31346, 31345, 31344, 31343, 31342, 31341, 31340, 31339, 31338, 31337, 31336, 31335, 31334, 31333, 31332, 31331, 31330, 31329, 31328, 31327, 31326, 31325, 31324, 31323, 31322, 31321, 31320, 31319, 31318, 31317, 31316, 31315, 31314, 31313, 31312, 31311, 31310) ORDER BY s0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  stock s0_

SELECT count(*) AS sclr_0 FROM stock s0_;