Query Metrics
10
Database Queries
10
Different statements
2601.69 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.59 ms |
SELECT f0_.header_article_type AS header_article_type_0, f0_.header_article AS header_article_1, f0_.header_article_enabled AS header_article_enabled_2, f0_.highlight_location_type AS highlight_location_type_3, f0_.highlight_location AS highlight_location_4, f0_.highlight_article_type AS highlight_article_type_5, f0_.highlight_article AS highlight_article_6, f0_.highlight_fossildb AS highlight_fossildb_7, f0_.event_title AS event_title_8, f0_.event_text AS event_text_9, f0_.event_url AS event_url_10, f0_.event_enabled AS event_enabled_11 FROM frontpage f0_ WHERE f0_.id = 1
Parameters:
[] |
2 | 0.85 ms |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.image AS image_2, a0_.title_nl AS title_nl_3, a0_.title_en AS title_en_4, a0_.intro_nl AS intro_nl_5, a0_.intro_en AS intro_en_6 FROM articles a0_ WHERE a0_.id = 78
Parameters:
[] |
3 | 0.86 ms |
SELECT l0_.id AS id_0, l0_.name_nl AS name_nl_1, l0_.name_en AS name_en_2, l0_.description_nl AS description_nl_3, l0_.description_en AS description_en_4 FROM locations_fossil l0_ WHERE l0_.id = 816
Parameters:
[] |
4 | 0.47 ms |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.image AS image_2, a0_.title_nl AS title_nl_3, a0_.title_en AS title_en_4, a0_.description_nl AS description_nl_5, a0_.description_en AS description_en_6 FROM articles a0_ WHERE a0_.id = 618
Parameters:
[] |
5 | 1.32 ms |
SELECT t0.id AS id_1, t0.genus AS genus_2, t0.species AS species_3, t0.publication AS publication_4, t0.date_day AS date_day_5, t0.date_month AS date_month_6, t0.date_year AS date_year_7, t0.comment_nl AS comment_nl_8, t0.comment_en AS comment_en_9, t0.user_number AS user_number_10, t0.added AS added_11, t0.user_id AS user_id_12, t0.username AS username_13, t0.edited AS edited_14, t0.edited_user_id AS edited_user_id_15, t0.edited_username AS edited_username_16, t0.approved AS approved_17, t0.approved_user_id AS approved_user_id_18, t0.approved_username AS approved_username_19, t0.taxanomy_tree AS taxanomy_tree_20, t0.num_reviews AS num_reviews_21, t0.num_new_photos AS num_new_photos_22, t0.has_edits AS has_edits_23, t0.location_fossil_id AS location_fossil_id_24, t0.taxanomy_id AS taxanomy_id_25, t0.literature_id AS literature_id_26, t0.era_id AS era_id_27, t0.epoch_id AS epoch_id_28, t0.stage_id AS stage_id_29, t0.formation_id AS formation_id_30, t0.member_id AS member_id_31 FROM fossildb_fossil t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
10002
]
|
6 | 2.87 ms |
SELECT t0.id AS id_1, t0.time AS time_2, t0.type AS type_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.is_update AS is_update_6, t0.remote_id AS remote_id_7 FROM newsfeed t0 ORDER BY t0.time DESC LIMIT 35
Parameters:
[] |
7 | 0.90 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:
[
45
]
|
8 | 0.97 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:
[
10002
]
|
9 | 0.90 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:
[ "2024-12-01 03:09:57" "2024-12-31 03:09:57" ] |
forumdb connection
#▲ | Time | Info |
---|---|---|
1 | 2591.95 ms |
SELECT `phpbb_posts`.`post_id`, `phpbb_posts`.`forum_id`, `phpbb_users`.`username`, `phpbb_posts`.`post_subject`, `phpbb_posts`.`post_text`, `phpbb_topics`.`topic_first_post_id` FROM `phpbb_posts`, `phpbb_topics`, `phpbb_users` WHERE `phpbb_topics`.`topic_id` = `phpbb_posts`. `topic_id` AND `phpbb_topics`.`forum_id` NOT IN ('70', '90', '94') AND `post_visibility` = 1 AND `phpbb_users`.`user_id` = `phpbb_posts`.`poster_id` ORDER BY `phpbb_posts`.`post_id` DESC LIMIT 1
Parameters:
[] |
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\Frontpage | No errors. |
App\Entity\Articles | No errors. |
App\Entity\LocationsFossil | No errors. |
App\Entity\FossildbFossil | 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\Newsfeed | No errors. |
App\Entity\ArticleCategories | No errors. |
App\Entity\ArticleReviews | 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.