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
  9950

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

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 (26209, 26208, 26207, 26206, 26205, 26204, 26203, 26202, 26201, 26200, 26199, 26198, 26197, 26196, 26195, 26194, 26193, 26192, 26191, 26190, 26189, 26188, 26187, 26186, 26185, 26184, 26183, 26182, 26181, 26180, 26179, 26178, 26177, 26176, 26175, 26174, 26173, 26172, 26171, 26170, 26169, 26168, 26167, 26166, 26165, 26164, 26163, 26162, 26161, 26160) ORDER BY s0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  stock s0_

SELECT count(*) AS sclr_0 FROM stock s0_;