https://acc.paleontica.org/

Query Metrics

10 Database Queries
10 Different statements
2601.69 ms Query time
0 Invalid entities

Queries

Group similar statements

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.