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
  9100

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

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 (27059, 27058, 27057, 27056, 27055, 27054, 27053, 27052, 27051, 27050, 27049, 27048, 27047, 27046, 27045, 27044, 27043, 27042, 27041, 27040, 27039, 27038, 27037, 27036, 27035, 27034, 27033, 27032, 27031, 27030, 27029, 27028, 27027, 27026, 27025, 27024, 27023, 27022, 27021, 27020, 27019, 27018, 27017, 27016, 27015, 27014, 27013, 27012, 27011, 27010) ORDER BY s0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  stock s0_

SELECT count(*) AS sclr_0 FROM stock s0_;