Query Metrics

5 Database Queries
4 Different statements
3.64 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."
]

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.

forumdb entity manager

No loaded entities.