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;

SELECT
  t0.id AS id_1,
  t0.name_scientific AS name_scientific_2,
  t0.name_scientific_clarification AS name_scientific_clarification_3,
  t0.name_nl AS name_nl_4,
  t0.name_en AS name_en_5,
  t0.author AS author_6,
  t0.author_year AS author_year_7,
  t0.parent_id AS parent_id_8,
  t0.is_category AS is_category_9,
  t0.category_old_id AS category_old_id_10,
  t0.taxanomy_rank_id AS taxanomy_rank_id_11,
  t0.glossary_id AS glossary_id_12
FROM
  taxanomy t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_scientific AS name_scientific_2, t0.name_scientific_clarification AS name_scientific_clarification_3, t0.name_nl AS name_nl_4, t0.name_en AS name_en_5, t0.author AS author_6, t0.author_year AS author_year_7, t0.parent_id AS parent_id_8, t0.is_category AS is_category_9, t0.category_old_id AS category_old_id_10, t0.taxanomy_rank_id AS taxanomy_rank_id_11, t0.glossary_id AS glossary_id_12 FROM taxanomy t0 WHERE t0.id = 75;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.filename AS filename_3,
  t0.is_primary AS is_primary_4,
  t0.added AS added_5,
  t0.user_id AS user_id_6,
  t0.username AS username_7,
  t0.approved AS approved_8,
  t0.approved_user_id AS approved_user_id_9,
  t0.approved_username AS approved_username_10,
  t0.fossildb_fossil_id AS fossildb_fossil_id_11
FROM
  fossildb_photos t0
WHERE
  t0.fossildb_fossil_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.filename AS filename_3, t0.is_primary AS is_primary_4, t0.added AS added_5, t0.user_id AS user_id_6, t0.username AS username_7, t0.approved AS approved_8, t0.approved_user_id AS approved_user_id_9, t0.approved_username AS approved_username_10, t0.fossildb_fossil_id AS fossildb_fossil_id_11 FROM fossildb_photos t0 WHERE t0.fossildb_fossil_id = 4671;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.location AS location_4,
  t0.date_added AS date_added_5,
  t0.date_reviewed AS date_reviewed_6,
  t0.vulnerability AS vulnerability_7,
  t0.description_nl AS description_nl_8,
  t0.description_en AS description_en_9,
  t0.route_nl AS route_nl_10,
  t0.route_en AS route_en_11,
  t0.finds_nl AS finds_nl_12,
  t0.finds_en AS finds_en_13,
  t0.closed AS closed_14,
  t0.is_quaternary AS is_quaternary_15,
  t0.is_neogene AS is_neogene_16,
  t0.is_paleogene AS is_paleogene_17,
  t0.is_cretaceous AS is_cretaceous_18,
  t0.is_jurassic AS is_jurassic_19,
  t0.is_triassic AS is_triassic_20,
  t0.is_permian AS is_permian_21,
  t0.is_carboniferous AS is_carboniferous_22,
  t0.is_devonian AS is_devonian_23,
  t0.is_silurian AS is_silurian_24,
  t0.is_ordovician AS is_ordovician_25,
  t0.is_cambrian AS is_cambrian_26,
  t0.is_precambrian AS is_precambrian_27,
  t0.has_bacteria AS has_bacteria_28,
  t0.has_archaebacteria AS has_archaebacteria_29,
  t0.has_phaeophyceae AS has_phaeophyceae_30,
  t0.has_diatomophyceae AS has_diatomophyceae_31,
  t0.has_foraminifera AS has_foraminifera_32,
  t0.has_radiolaria AS has_radiolaria_33,
  t0.has_choanoflagellata AS has_choanoflagellata_34,
  t0.has_porifera AS has_porifera_35,
  t0.has_hemichordata AS has_hemichordata_36,
  t0.has_anthozoa AS has_anthozoa_37,
  t0.has_medusozoa AS has_medusozoa_38,
  t0.has_asterozoa AS has_asterozoa_39,
  t0.has_echinoidea AS has_echinoidea_40,
  t0.has_crinoidea AS has_crinoidea_41,
  t0.has_blastoidea AS has_blastoidea_42,
  t0.has_cystoidea AS has_cystoidea_43,
  t0.has_agnatha AS has_agnatha_44,
  t0.has_placodermi AS has_placodermi_45,
  t0.has_chimaeriformes AS has_chimaeriformes_46,
  t0.has_elasmobranchii AS has_elasmobranchii_47,
  t0.has_batoidea AS has_batoidea_48,
  t0.has_actinopterygii AS has_actinopterygii_49,
  t0.has_sarcopterygii AS has_sarcopterygii_50,
  t0.has_dipnoi AS has_dipnoi_51,
  t0.has_amphibia AS has_amphibia_52,
  t0.has_mammaliaterrestrium AS has_mammaliaterrestrium_53,
  t0.has_mammaliamarinis AS has_mammaliamarinis_54,
  t0.has_anapsida AS has_anapsida_55,
  t0.has_squamata AS has_squamata_56,
  t0.has_sauropterygia AS has_sauropterygia_57,
  t0.has_ichthyosauria AS has_ichthyosauria_58,
  t0.has_crocodylomorpha AS has_crocodylomorpha_59,
  t0.has_pterosauria AS has_pterosauria_60,
  t0.has_dinosauria AS has_dinosauria_61,
  t0.has_aves AS has_aves_62,
  t0.has_bryozoa AS has_bryozoa_63,
  t0.has_platyzoa AS has_platyzoa_64,
  t0.has_brachiopoda AS has_brachiopoda_65,
  t0.has_polychaeta AS has_polychaeta_66,
  t0.has_annelida AS has_annelida_67,
  t0.has_polyplacophora AS has_polyplacophora_68,
  t0.has_scaphopoda AS has_scaphopoda_69,
  t0.has_bivalvia AS has_bivalvia_70,
  t0.has_rudista AS has_rudista_71,
  t0.has_gastropoda AS has_gastropoda_72,
  t0.has_nautilida AS has_nautilida_73,
  t0.has_nautiloidea AS has_nautiloidea_74,
  t0.has_goniatitida AS has_goniatitida_75,
  t0.has_ceratitida AS has_ceratitida_76,
  t0.has_ammonitida AS has_ammonitida_77,
  t0.has_belemnoidea AS has_belemnoidea_78,
  t0.has_neocoleoidea AS has_neocoleoidea_79,
  t0.has_trilobita AS has_trilobita_80,
  t0.has_arachnida AS has_arachnida_81,
  t0.has_merostomata AS has_merostomata_82,
  t0.has_myriapoda AS has_myriapoda_83,
  t0.has_ostracoda AS has_ostracoda_84,
  t0.has_crustacea AS has_crustacea_85,
  t0.has_hexapoda AS has_hexapoda_86,
  t0.has_fungi AS has_fungi_87,
  t0.has_mycetozoa AS has_mycetozoa_88,
  t0.has_angiospermae AS has_angiospermae_89,
  t0.has_coniferophyta AS has_coniferophyta_90,
  t0.has_ginkgophyta AS has_ginkgophyta_91,
  t0.has_cycadophyta AS has_cycadophyta_92,
  t0.has_pteridospermophyta AS has_pteridospermophyta_93,
  t0.has_pteridophyta AS has_pteridophyta_94,
  t0.has_sphenophyta AS has_sphenophyta_95,
  t0.has_lycophyta AS has_lycophyta_96,
  t0.has_bryophyta AS has_bryophyta_97,
  t0.has_chlorophyta AS has_chlorophyta_98,
  t0.has_ichnofossilia AS has_ichnofossilia_99,
  t0.has_incertaesedis AS has_incertaesedis_100,
  t0.user_id AS user_id_101,
  t0.username AS username_102,
  t0.approved AS approved_103,
  t0.approved_user_id AS approved_user_id_104,
  t0.approved_username AS approved_username_105,
  t0.num_reviews AS num_reviews_106,
  t0.num_new_photos AS num_new_photos_107,
  t0.country_id AS country_id_108
FROM
  locations_fossil t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.location AS location_4, t0.date_added AS date_added_5, t0.date_reviewed AS date_reviewed_6, t0.vulnerability AS vulnerability_7, t0.description_nl AS description_nl_8, t0.description_en AS description_en_9, t0.route_nl AS route_nl_10, t0.route_en AS route_en_11, t0.finds_nl AS finds_nl_12, t0.finds_en AS finds_en_13, t0.closed AS closed_14, t0.is_quaternary AS is_quaternary_15, t0.is_neogene AS is_neogene_16, t0.is_paleogene AS is_paleogene_17, t0.is_cretaceous AS is_cretaceous_18, t0.is_jurassic AS is_jurassic_19, t0.is_triassic AS is_triassic_20, t0.is_permian AS is_permian_21, t0.is_carboniferous AS is_carboniferous_22, t0.is_devonian AS is_devonian_23, t0.is_silurian AS is_silurian_24, t0.is_ordovician AS is_ordovician_25, t0.is_cambrian AS is_cambrian_26, t0.is_precambrian AS is_precambrian_27, t0.has_bacteria AS has_bacteria_28, t0.has_archaebacteria AS has_archaebacteria_29, t0.has_phaeophyceae AS has_phaeophyceae_30, t0.has_diatomophyceae AS has_diatomophyceae_31, t0.has_foraminifera AS has_foraminifera_32, t0.has_radiolaria AS has_radiolaria_33, t0.has_choanoflagellata AS has_choanoflagellata_34, t0.has_porifera AS has_porifera_35, t0.has_hemichordata AS has_hemichordata_36, t0.has_anthozoa AS has_anthozoa_37, t0.has_medusozoa AS has_medusozoa_38, t0.has_asterozoa AS has_asterozoa_39, t0.has_echinoidea AS has_echinoidea_40, t0.has_crinoidea AS has_crinoidea_41, t0.has_blastoidea AS has_blastoidea_42, t0.has_cystoidea AS has_cystoidea_43, t0.has_agnatha AS has_agnatha_44, t0.has_placodermi AS has_placodermi_45, t0.has_chimaeriformes AS has_chimaeriformes_46, t0.has_elasmobranchii AS has_elasmobranchii_47, t0.has_batoidea AS has_batoidea_48, t0.has_actinopterygii AS has_actinopterygii_49, t0.has_sarcopterygii AS has_sarcopterygii_50, t0.has_dipnoi AS has_dipnoi_51, t0.has_amphibia AS has_amphibia_52, t0.has_mammaliaterrestrium AS has_mammaliaterrestrium_53, t0.has_mammaliamarinis AS has_mammaliamarinis_54, t0.has_anapsida AS has_anapsida_55, t0.has_squamata AS has_squamata_56, t0.has_sauropterygia AS has_sauropterygia_57, t0.has_ichthyosauria AS has_ichthyosauria_58, t0.has_crocodylomorpha AS has_crocodylomorpha_59, t0.has_pterosauria AS has_pterosauria_60, t0.has_dinosauria AS has_dinosauria_61, t0.has_aves AS has_aves_62, t0.has_bryozoa AS has_bryozoa_63, t0.has_platyzoa AS has_platyzoa_64, t0.has_brachiopoda AS has_brachiopoda_65, t0.has_polychaeta AS has_polychaeta_66, t0.has_annelida AS has_annelida_67, t0.has_polyplacophora AS has_polyplacophora_68, t0.has_scaphopoda AS has_scaphopoda_69, t0.has_bivalvia AS has_bivalvia_70, t0.has_rudista AS has_rudista_71, t0.has_gastropoda AS has_gastropoda_72, t0.has_nautilida AS has_nautilida_73, t0.has_nautiloidea AS has_nautiloidea_74, t0.has_goniatitida AS has_goniatitida_75, t0.has_ceratitida AS has_ceratitida_76, t0.has_ammonitida AS has_ammonitida_77, t0.has_belemnoidea AS has_belemnoidea_78, t0.has_neocoleoidea AS has_neocoleoidea_79, t0.has_trilobita AS has_trilobita_80, t0.has_arachnida AS has_arachnida_81, t0.has_merostomata AS has_merostomata_82, t0.has_myriapoda AS has_myriapoda_83, t0.has_ostracoda AS has_ostracoda_84, t0.has_crustacea AS has_crustacea_85, t0.has_hexapoda AS has_hexapoda_86, t0.has_fungi AS has_fungi_87, t0.has_mycetozoa AS has_mycetozoa_88, t0.has_angiospermae AS has_angiospermae_89, t0.has_coniferophyta AS has_coniferophyta_90, t0.has_ginkgophyta AS has_ginkgophyta_91, t0.has_cycadophyta AS has_cycadophyta_92, t0.has_pteridospermophyta AS has_pteridospermophyta_93, t0.has_pteridophyta AS has_pteridophyta_94, t0.has_sphenophyta AS has_sphenophyta_95, t0.has_lycophyta AS has_lycophyta_96, t0.has_bryophyta AS has_bryophyta_97, t0.has_chlorophyta AS has_chlorophyta_98, t0.has_ichnofossilia AS has_ichnofossilia_99, t0.has_incertaesedis AS has_incertaesedis_100, t0.user_id AS user_id_101, t0.username AS username_102, t0.approved AS approved_103, t0.approved_user_id AS approved_user_id_104, t0.approved_username AS approved_username_105, t0.num_reviews AS num_reviews_106, t0.num_new_photos AS num_new_photos_107, t0.country_id AS country_id_108 FROM locations_fossil t0 WHERE t0.id = 655;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.iso AS iso_4,
  t0.geomap AS geomap_5,
  t0.polygons AS polygons_6,
  t0.type AS type_7
FROM
  countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.iso AS iso_4, t0.geomap AS geomap_5, t0.polygons AS polygons_6, t0.type AS type_7 FROM countries t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.author AS author_2,
  t0.title AS title_3,
  t0.year AS year_4,
  t0.description_nl AS description_nl_5,
  t0.description_en AS description_en_6,
  t0.added AS added_7,
  t0.user_id AS user_id_8,
  t0.username AS username_9,
  t0.edited AS edited_10,
  t0.edited_user_id AS edited_user_id_11,
  t0.edited_username AS edited_username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.url AS url_16,
  t0.locations_fossil_id AS locations_fossil_id_17
FROM
  literature t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.year AS year_4, t0.description_nl AS description_nl_5, t0.description_en AS description_en_6, t0.added AS added_7, t0.user_id AS user_id_8, t0.username AS username_9, t0.edited AS edited_10, t0.edited_user_id AS edited_user_id_11, t0.edited_username AS edited_username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.url AS url_16, t0.locations_fossil_id AS locations_fossil_id_17 FROM literature t0 WHERE t0.id = 302;

SELECT
  d0_.id AS id_0,
  d0_.user_id AS user_id_1,
  d0_.username AS username_2,
  d0_.amount AS amount_3,
  d0_.order_id AS order_id_4,
  d0_.time AS time_5,
  d0_.time_updated AS time_updated_6,
  d0_.status AS status_7
FROM
  donations d0_
WHERE
  d0_.status = 'paid'
  AND d0_.time >= ?
  AND d0_.time <= ?

SELECT d0_.id AS id_0, d0_.user_id AS user_id_1, d0_.username AS username_2, d0_.amount AS amount_3, d0_.order_id AS order_id_4, d0_.time AS time_5, d0_.time_updated AS time_updated_6, d0_.status AS status_7 FROM donations d0_ WHERE d0_.status = 'paid' AND d0_.time >= '2024-12-01 13:36:20' AND d0_.time <= '2024-12-31 13:36:20';