Query Metrics
5
Database Queries
4
Different statements
3.64 ms
Query time
0
Invalid entities
Queries
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.