Query Metrics
4
Database Queries
4
Different statements
20.88 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 18.83 ms |
SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1
Parameters:
[] |
| 2 | 0.48 ms |
SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 ORDER BY f0_.id DESC LIMIT 10
Parameters:
[] |
| 3 | 0.84 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_.approved = 1 AND f0_.id IN (?) ORDER BY f0_.id DESC
Parameters:
[
[
10009
10008
10007
10006
10005
10004
10003
10002
10001
10000
]
]
|
| 4 | 0.73 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:
[ "2026-04-01 17:19:00" "2026-04-30 17:19:00" ] |
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\Donations | No errors. |
| App\Entity\LocationsGeology | No errors. |
| App\Entity\LocationsMuseum | No errors. |
| App\Entity\LocationsSociety | No errors. |
| App\Entity\GlossaryReviews | No errors. |
forumdb entity manager
No loaded entities.