Symfony Profiler

SELECT
  DISTINCT u0_.id AS id_0,
  (
    SELECT
      COUNT(m1_.id) AS sclr_2
    FROM
      marker m1_
    WHERE
      m1_.creator_id = u0_.id
  ) AS sclr_1,
  u0_.id AS id_3
FROM
  `user` u0_
  LEFT JOIN marker m2_ ON u0_.id = m2_.creator_id
ORDER BY
  sclr_1 DESC,
  u0_.id DESC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, (SELECT COUNT(m1_.id) AS sclr_2 FROM marker m1_ WHERE m1_.creator_id = u0_.id) AS sclr_1, u0_.id AS id_3 FROM `user` u0_ LEFT JOIN marker m2_ ON u0_.id = m2_.creator_id ORDER BY sclr_1 DESC, u0_.id DESC LIMIT 20;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.grade AS grade_5,
  u0_.company AS company_6,
  u0_.grade_level AS grade_level_7,
  (
    SELECT
      COUNT(m1_.id) AS sclr_9
    FROM
      marker m1_
    WHERE
      m1_.creator_id = u0_.id
  ) AS sclr_8
FROM
  `user` u0_
  LEFT JOIN marker m2_ ON u0_.id = m2_.creator_id
WHERE
  u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
ORDER BY
  sclr_8 DESC,
  u0_.id DESC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.grade AS grade_5, u0_.company AS company_6, u0_.grade_level AS grade_level_7, (SELECT COUNT(m1_.id) AS sclr_9 FROM marker m1_ WHERE m1_.creator_id = u0_.id) AS sclr_8 FROM `user` u0_ LEFT JOIN marker m2_ ON u0_.id = m2_.creator_id WHERE u0_.id IN (1, 38, 37, 35, 34, 31, 29, 28, 25, 24, 23, 22, 13, 10, 6, 4, 3) ORDER BY sclr_8 DESC, u0_.id DESC;

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  `user` u0_
  LEFT JOIN marker m1_ ON u0_.id = m1_.creator_id

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM `user` u0_ LEFT JOIN marker m1_ ON u0_.id = m1_.creator_id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 38;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 37;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 35;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 34;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 25;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.region AS region_4,
  t0.comment AS comment_5,
  t0.image AS image_6,
  t0.pos_x AS pos_x_7,
  t0.pos_y AS pos_y_8,
  t0.display AS display_9,
  t0.creator_id AS creator_id_10
FROM
  marker t0
WHERE
  t0.creator_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = 3;