Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.05 ms (100.00%)	1	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 = ? Parameters: [`"4680"`] View formatted query View runnable query Explain query 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 = ? 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 = '4680';

Time▼

Count

Info

1.05 ms
(100.00%)

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 = ?

Parameters:

[
  "4680"
]

View formatted query View runnable query Explain query

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 = ?

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 = '4680';

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.

forumdb entity manager

No loaded entities.