https://acc.paleontica.org/fossildb/fossil/7535

Query Metrics

11 Database Queries
8 Different statements
12.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
3.34 ms
(27.41%)
1
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 = ?
Parameters:
[
  142
]
2.15 ms
(17.65%)
4
SELECT t0.id AS id_1, t0.type AS type_2, t0.age_start AS age_start_3, t0.age_end AS age_end_4, t0.name_nl AS name_nl_5, t0.name_en AS name_en_6, t0.color AS color_7, t0.glossary_id AS glossary_id_8, t0.parent_id AS parent_id_9 FROM stratigraphy_units t0 WHERE t0.id = ?
Parameters:
[
  1004
]
1.79 ms
(14.67%)
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 = ?
Parameters:
[
  313
]
1.46 ms
(11.98%)
1
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 <= ?
Parameters:
[
  "2024-12-01 19:22:18"
  "2024-12-31 19:22:18"
]
1.12 ms
(9.21%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ?
Parameters:
[
  57
]
0.95 ms
(7.84%)
1
SELECT t0.id AS id_1, t0.genus AS genus_2, t0.species AS species_3, t0.publication AS publication_4, t0.date_day AS date_day_5, t0.date_month AS date_month_6, t0.date_year AS date_year_7, t0.comment_nl AS comment_nl_8, t0.comment_en AS comment_en_9, t0.user_number AS user_number_10, t0.added AS added_11, t0.user_id AS user_id_12, t0.username AS username_13, t0.edited AS edited_14, t0.edited_user_id AS edited_user_id_15, t0.edited_username AS edited_username_16, t0.approved AS approved_17, t0.approved_user_id AS approved_user_id_18, t0.approved_username AS approved_username_19, t0.taxanomy_tree AS taxanomy_tree_20, t0.num_reviews AS num_reviews_21, t0.num_new_photos AS num_new_photos_22, t0.has_edits AS has_edits_23, t0.location_fossil_id AS location_fossil_id_24, t0.taxanomy_id AS taxanomy_id_25, t0.literature_id AS literature_id_26, t0.era_id AS era_id_27, t0.epoch_id AS epoch_id_28, t0.stage_id AS stage_id_29, t0.formation_id AS formation_id_30, t0.member_id AS member_id_31 FROM fossildb_fossil t0 WHERE t0.id = ?
Parameters:
[
  "7535"
]
0.69 ms
(5.67%)
1
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 = ?
Parameters:
[
  71
]
0.68 ms
(5.58%)
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 = ?
Parameters:
[
  7535
]

forumdb connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
forumdb doctrine.dbal.forumdb_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
forumdb doctrine.orm.forumdb_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\FossildbFossil No errors.
App\Entity\LocationsFossil No errors.
App\Entity\Taxanomy No errors.
App\Entity\Literature No errors.
App\Entity\StratigraphyUnits No errors.
App\Entity\FossildbPhotos No errors.
App\Entity\FossildbReviews No errors.
App\Entity\Countries No errors.
App\Entity\LocationsGIS No errors.
App\Entity\LocationReviews No errors.
App\Entity\LocationPhotos No errors.
App\Entity\TaxanomyRanks No errors.
App\Entity\Glossaries No errors.
App\Entity\LocationsGeology No errors.
App\Entity\LocationsMuseum No errors.
App\Entity\LocationsSociety No errors.
App\Entity\GlossaryReviews No errors.
App\Entity\Donations No errors.

forumdb entity manager

No loaded entities.