Symfony Profiler

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  location l0_

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM location l0_;

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.name AS name_1
FROM
  location l0_
ORDER BY
  l0_.name ASC
LIMIT
  100 OFFSET 600

SELECT DISTINCT l0_.id AS id_0, l0_.name AS name_1 FROM location l0_ ORDER BY l0_.name ASC LIMIT 100 OFFSET 600;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.lat AS lat_2,
  l0_.lon AS lon_3,
  l0_.approved AS approved_4,
  l0_.type AS type_5,
  l0_.description AS description_6,
  l0_.image AS image_7,
  l0_.today_known_as AS today_known_as_8,
  l0_.created_at AS created_at_9,
  l0_.updated_at AS updated_at_10,
  l0_.owner_id AS owner_id_11,
  l0_.update_of_id AS update_of_id_12,
  l0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_13
FROM
  location l0_
WHERE
  l0_.id IN (?)
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.approved AS approved_4, l0_.type AS type_5, l0_.description AS description_6, l0_.image AS image_7, l0_.today_known_as AS today_known_as_8, l0_.created_at AS created_at_9, l0_.updated_at AS updated_at_10, l0_.owner_id AS owner_id_11, l0_.update_of_id AS update_of_id_12, l0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_13 FROM location l0_ WHERE l0_.id IN (611, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 612, 613, 614, 615, 1065, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698) ORDER BY l0_.name ASC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.type AS type_2,
  l0_.lat AS lat_3,
  l0_.lon AS lon_4
FROM
  location l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.type AS type_2, l0_.lat AS lat_3, l0_.lon AS lon_4 FROM location l0_;