Query Metrics

7 Database Queries
7 Different statements
2598.92 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:
[]

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.

forumdb entity manager

No loaded entities.