Symfony Profiler

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  structure s0_
WHERE
  s0_.longitude IS NULL
  OR s0_.latitude IS NULL

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM structure s0_ WHERE s0_.longitude IS NULL OR s0_.latitude IS NULL;

SELECT
  s0_.subtitle AS subtitle_0,
  s0_.address AS address_1,
  s0_.postal_code AS postal_code_2,
  s0_.town AS town_3,
  s0_.phone AS phone_4,
  s0_.email AS email_5,
  s0_.website AS website_6,
  s0_.longitude AS longitude_7,
  s0_.latitude AS latitude_8,
  s0_.id AS id_9,
  s0_.tmp_old_ids AS tmp_old_ids_10,
  s0_.name AS name_11,
  s0_.title AS title_12,
  s0_.slug AS slug_13,
  s0_.chapo AS chapo_14,
  s0_.content AS content_15,
  s0_.tmp_keywords AS tmp_keywords_16,
  s0_.priority AS priority_17,
  s0_.published AS published_18,
  s0_.created_at AS created_at_19,
  s0_.updated_at AS updated_at_20,
  s0_.host_id AS host_id_21,
  s0_.includer_id AS includer_id_22
FROM
  structure s0_
WHERE
  (
    s0_.longitude IS NULL
    OR s0_.latitude IS NULL
  )
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.created_at DESC

SELECT s0_.subtitle AS subtitle_0, s0_.address AS address_1, s0_.postal_code AS postal_code_2, s0_.town AS town_3, s0_.phone AS phone_4, s0_.email AS email_5, s0_.website AS website_6, s0_.longitude AS longitude_7, s0_.latitude AS latitude_8, s0_.id AS id_9, s0_.tmp_old_ids AS tmp_old_ids_10, s0_.name AS name_11, s0_.title AS title_12, s0_.slug AS slug_13, s0_.chapo AS chapo_14, s0_.content AS content_15, s0_.tmp_keywords AS tmp_keywords_16, s0_.priority AS priority_17, s0_.published AS published_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.host_id AS host_id_21, s0_.includer_id AS includer_id_22 FROM structure s0_ WHERE (s0_.longitude IS NULL OR s0_.latitude IS NULL) AND s0_.id IN (648, 645, 385, 151, 612, 546, 544, 523, 488, 481, 480, 479, 478, 338, 475, 468, 467, 466, 463, 461, 460, 450, 447, 641, 442, 441, 439, 438, 642, 437) ORDER BY s0_.created_at DESC;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.created_at AS created_at_1
FROM
  structure s0_
WHERE
  s0_.longitude IS NULL
  OR s0_.latitude IS NULL
ORDER BY
  s0_.created_at DESC
LIMIT
  30

SELECT DISTINCT s0_.id AS id_0, s0_.created_at AS created_at_1 FROM structure s0_ WHERE s0_.longitude IS NULL OR s0_.latitude IS NULL ORDER BY s0_.created_at DESC LIMIT 30;