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
  27050

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

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 (9109, 9108, 9107, 9106, 9105, 9104, 9103, 9102, 9101, 9100, 9099, 9098, 9097, 9096, 9095, 9094, 9093, 9092, 9091, 9090, 9089, 9088, 9087, 9086, 9085, 9084, 9083, 9082, 9081, 9080, 9079, 9078, 9077, 9076, 9075, 9074, 9073, 9072, 9071, 9070, 9069, 9068, 9067, 9066, 9065, 9064, 9063, 9062, 9061, 9060) ORDER BY s0_.id DESC;

SELECT
  count(*) AS sclr_0
FROM
  stock s0_

SELECT count(*) AS sclr_0 FROM stock s0_;