Query Metrics
10
Database Queries
6
Different statements
10.69 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.60 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:
[ "stage" 1048 ] |
| 2 | 0.51 ms |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.age_start AS age_start_2, s0_.age_end AS age_end_3, s0_.name_nl AS name_nl_4, s0_.name_en AS name_en_5, s0_.color AS color_6, s0_.glossary_id AS glossary_id_7, s0_.parent_id AS parent_id_8 FROM stratigraphy_units s0_ WHERE s0_.type = 'era' AND s0_.age_start <= (?) AND s0_.age_end >= (?) LIMIT 1
Parameters:
[ 0.012 0.126 ] |
| 3 | 0.48 ms |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.age_start AS age_start_2, s0_.age_end AS age_end_3, s0_.name_nl AS name_nl_4, s0_.name_en AS name_en_5, s0_.color AS color_6, s0_.glossary_id AS glossary_id_7, s0_.parent_id AS parent_id_8 FROM stratigraphy_units s0_ WHERE s0_.type = 'epoch' AND s0_.age_start <= (?) AND s0_.age_end >= (?) LIMIT 1
Parameters:
[ 0.012 0.126 ] |
| 4 | 4.19 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_.stage_id = (?) GROUP BY f0_.taxanomy_id
Parameters:
[
1048
]
|
| 5 | 1.23 ms |
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:
[
56
]
|
| 6 | 0.76 ms |
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:
[
77
]
|
| 7 | 0.43 ms |
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:
[
81
]
|
| 8 | 0.49 ms |
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:
[
82
]
|
| 9 | 0.68 ms |
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:
[
85
]
|
| 10 | 1.33 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-12-01 16:30:14" "2025-12-31 16:30:14" ] |
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\LocationsFossil | No errors. |
| App\Entity\Taxanomy | 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\TaxanomyRanks | 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.