https://acc.paleontica.org/specieslist/epoch/1032/129

Query Metrics

9 Database Queries
6 Different statements
5.90 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.57 ms
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.type = ? AND t0.id = ? LIMIT 1
Parameters:
[
  "epoch"
  1032
]
2 1.11 ms
SELECT DISTINCT f0_.genus AS genus_0, f0_.species AS species_1 FROM fossildb_fossil f0_ WHERE f0_.epoch_id = (?) AND f0_.taxanomy_id = (?) ORDER BY f0_.genus ASC, f0_.species ASC
Parameters:
[
  1032
  129
]
3 0.50 ms
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 = (?)
Parameters:
[
  129
]
4 0.78 ms
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_.epoch_id = (?) AND f0_.taxanomy_id = (?) AND f0_.genus = (?) AND f0_.species = (?)
Parameters:
[
  1032
  129
  "Paleoincisurus"
  "hellmundi"
]
5 0.67 ms
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_.epoch_id = (?) AND f0_.taxanomy_id = (?) AND f0_.genus = (?) AND f0_.species = (?)
Parameters:
[
  1032
  129
  "Planolites"
  "sp."
]
6 0.70 ms
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:
[
  3012
]
7 0.48 ms
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:
[
  6039
]
8 0.31 ms
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:
[
  6040
]
9 0.78 ms
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:
[
  "2025-11-01 17:03:29"
  "2025-11-30 17:03:29"
]

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\StratigraphyUnits No errors.
App\Entity\Glossaries No errors.
App\Entity\FossildbFossil No errors.
App\Entity\Taxanomy No errors.
App\Entity\TaxanomyRanks No errors.
App\Entity\LocationsFossil No errors.
App\Entity\Literature No errors.
App\Entity\FossildbPhotos No errors.
App\Entity\FossildbReviews No errors.
App\Entity\GlossaryReviews No errors.
App\Entity\Countries No errors.
App\Entity\LocationsGIS No errors.
App\Entity\LocationReviews No errors.
App\Entity\LocationPhotos No errors.
App\Entity\Donations No errors.
App\Entity\LocationsGeology No errors.
App\Entity\LocationsMuseum No errors.
App\Entity\LocationsSociety No errors.

forumdb entity manager

No loaded entities.