Symfony Profiler

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  fossildb_fossil f0_
WHERE
  f0_.approved = 1
  AND f0_.genus IN (?)
  AND f0_.species IN (?)

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.genus IN ('Nervostrophia') AND f0_.species IN ('sp.');

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.id AS id_1
FROM
  fossildb_fossil f0_
WHERE
  f0_.approved = 1
  AND f0_.genus IN (?)
  AND f0_.species IN (?)
ORDER BY
  f0_.id DESC
LIMIT
  10

SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.genus IN ('Nervostrophia') AND f0_.species IN ('sp.') ORDER BY f0_.id DESC LIMIT 10;

SELECT
  f0_.id AS id_0,
  f0_.genus AS genus_1,
  f0_.species AS species_2,
  f0_.publication AS publication_3,
  f0_.date_day AS date_day_4,
  f0_.date_month AS date_month_5,
  f0_.date_year AS date_year_6,
  f0_.comment_nl AS comment_nl_7,
  f0_.comment_en AS comment_en_8,
  f0_.user_number AS user_number_9,
  f0_.added AS added_10,
  f0_.user_id AS user_id_11,
  f0_.username AS username_12,
  f0_.edited AS edited_13,
  f0_.edited_user_id AS edited_user_id_14,
  f0_.edited_username AS edited_username_15,
  f0_.approved AS approved_16,
  f0_.approved_user_id AS approved_user_id_17,
  f0_.approved_username AS approved_username_18,
  f0_.taxanomy_tree AS taxanomy_tree_19,
  f0_.num_reviews AS num_reviews_20,
  f0_.num_new_photos AS num_new_photos_21,
  f0_.has_edits AS has_edits_22,
  f0_.location_fossil_id AS location_fossil_id_23,
  f0_.taxanomy_id AS taxanomy_id_24,
  f0_.literature_id AS literature_id_25,
  f0_.era_id AS era_id_26,
  f0_.epoch_id AS epoch_id_27,
  f0_.stage_id AS stage_id_28,
  f0_.formation_id AS formation_id_29,
  f0_.member_id AS member_id_30
FROM
  fossildb_fossil f0_
WHERE
  f0_.approved = 1
  AND f0_.genus IN (?)
  AND f0_.species IN (?)
  AND f0_.id IN (?)
ORDER BY
  f0_.id DESC

SELECT f0_.id AS id_0, f0_.genus AS genus_1, f0_.species AS species_2, f0_.publication AS publication_3, f0_.date_day AS date_day_4, f0_.date_month AS date_month_5, f0_.date_year AS date_year_6, f0_.comment_nl AS comment_nl_7, f0_.comment_en AS comment_en_8, f0_.user_number AS user_number_9, f0_.added AS added_10, f0_.user_id AS user_id_11, f0_.username AS username_12, f0_.edited AS edited_13, f0_.edited_user_id AS edited_user_id_14, f0_.edited_username AS edited_username_15, f0_.approved AS approved_16, f0_.approved_user_id AS approved_user_id_17, f0_.approved_username AS approved_username_18, f0_.taxanomy_tree AS taxanomy_tree_19, f0_.num_reviews AS num_reviews_20, f0_.num_new_photos AS num_new_photos_21, f0_.has_edits AS has_edits_22, f0_.location_fossil_id AS location_fossil_id_23, f0_.taxanomy_id AS taxanomy_id_24, f0_.literature_id AS literature_id_25, f0_.era_id AS era_id_26, f0_.epoch_id AS epoch_id_27, f0_.stage_id AS stage_id_28, f0_.formation_id AS formation_id_29, f0_.member_id AS member_id_30 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.genus IN ('Nervostrophia') AND f0_.species IN ('sp.') AND f0_.id IN (4671) ORDER BY f0_.id DESC;