Symfony Profiler

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_.location_fossil_id = (?)
  AND f0_.taxanomy_id = (?)
  AND f0_.genus = (?)
  AND f0_.species = (?)

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_.location_fossil_id = (111) AND f0_.taxanomy_id = (82) AND f0_.genus = ('?Crassostrea') AND f0_.species = ('sp.');

SELECT
  DISTINCT f0_.genus AS genus_0,
  f0_.species AS species_1
FROM
  fossildb_fossil f0_
WHERE
  f0_.location_fossil_id = (?)
  AND f0_.taxanomy_id = (?)
ORDER BY
  f0_.genus ASC,
  f0_.species ASC

SELECT DISTINCT f0_.genus AS genus_0, f0_.species AS species_1 FROM fossildb_fossil f0_ WHERE f0_.location_fossil_id = (111) AND f0_.taxanomy_id = (82) ORDER BY f0_.genus ASC, f0_.species ASC;

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 = ?
LIMIT
  1

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 = 111 LIMIT 1;

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 = 7639;

SELECT
  t0_.id AS id_0,
  t0_.name_scientific AS name_scientific_1,
  t0_.name_scientific_clarification AS name_scientific_clarification_2,
  t0_.name_nl AS name_nl_3,
  t0_.name_en AS name_en_4,
  t0_.author AS author_5,
  t0_.author_year AS author_year_6,
  t0_.parent_id AS parent_id_7,
  t0_.is_category AS is_category_8,
  t0_.category_old_id AS category_old_id_9,
  t0_.taxanomy_rank_id AS taxanomy_rank_id_10,
  t0_.glossary_id AS glossary_id_11
FROM
  taxanomy t0_
WHERE
  t0_.id = (?)

SELECT t0_.id AS id_0, t0_.name_scientific AS name_scientific_1, t0_.name_scientific_clarification AS name_scientific_clarification_2, t0_.name_nl AS name_nl_3, t0_.name_en AS name_en_4, t0_.author AS author_5, t0_.author_year AS author_year_6, t0_.parent_id AS parent_id_7, t0_.is_category AS is_category_8, t0_.category_old_id AS category_old_id_9, t0_.taxanomy_rank_id AS taxanomy_rank_id_10, t0_.glossary_id AS glossary_id_11 FROM taxanomy t0_ WHERE t0_.id = (82);

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 19:36:52' AND d0_.time <= '2024-12-31 19:36:52';