Query Metrics
8
Database Queries
8
Different statements
6.67 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.41 ms (21.20%) |
1 |
SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.iso AS iso_4, t0.geomap AS geomap_5, t0.polygons AS polygons_6, t0.type AS type_7 FROM countries t0 WHERE t0.id = ?
Parameters:
[
72
]
|
|
1.05 ms (15.78%) |
1 |
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:
[
23
]
|
|
0.96 ms (14.32%) |
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:
[
"995"
]
|
|
0.93 ms (13.96%) |
1 |
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 22:46:46" "2024-12-31 22:46:46" ] |
|
0.77 ms (11.50%) |
1 |
SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.location AS location_4, t0.date_added AS date_added_5, t0.date_reviewed AS date_reviewed_6, t0.vulnerability AS vulnerability_7, t0.description_nl AS description_nl_8, t0.description_en AS description_en_9, t0.route_nl AS route_nl_10, t0.route_en AS route_en_11, t0.finds_nl AS finds_nl_12, t0.finds_en AS finds_en_13, t0.closed AS closed_14, t0.is_quaternary AS is_quaternary_15, t0.is_neogene AS is_neogene_16, t0.is_paleogene AS is_paleogene_17, t0.is_cretaceous AS is_cretaceous_18, t0.is_jurassic AS is_jurassic_19, t0.is_triassic AS is_triassic_20, t0.is_permian AS is_permian_21, t0.is_carboniferous AS is_carboniferous_22, t0.is_devonian AS is_devonian_23, t0.is_silurian AS is_silurian_24, t0.is_ordovician AS is_ordovician_25, t0.is_cambrian AS is_cambrian_26, t0.is_precambrian AS is_precambrian_27, t0.has_bacteria AS has_bacteria_28, t0.has_archaebacteria AS has_archaebacteria_29, t0.has_phaeophyceae AS has_phaeophyceae_30, t0.has_diatomophyceae AS has_diatomophyceae_31, t0.has_foraminifera AS has_foraminifera_32, t0.has_radiolaria AS has_radiolaria_33, t0.has_choanoflagellata AS has_choanoflagellata_34, t0.has_porifera AS has_porifera_35, t0.has_hemichordata AS has_hemichordata_36, t0.has_anthozoa AS has_anthozoa_37, t0.has_medusozoa AS has_medusozoa_38, t0.has_asterozoa AS has_asterozoa_39, t0.has_echinoidea AS has_echinoidea_40, t0.has_crinoidea AS has_crinoidea_41, t0.has_blastoidea AS has_blastoidea_42, t0.has_cystoidea AS has_cystoidea_43, t0.has_agnatha AS has_agnatha_44, t0.has_placodermi AS has_placodermi_45, t0.has_chimaeriformes AS has_chimaeriformes_46, t0.has_elasmobranchii AS has_elasmobranchii_47, t0.has_batoidea AS has_batoidea_48, t0.has_actinopterygii AS has_actinopterygii_49, t0.has_sarcopterygii AS has_sarcopterygii_50, t0.has_dipnoi AS has_dipnoi_51, t0.has_amphibia AS has_amphibia_52, t0.has_mammaliaterrestrium AS has_mammaliaterrestrium_53, t0.has_mammaliamarinis AS has_mammaliamarinis_54, t0.has_anapsida AS has_anapsida_55, t0.has_squamata AS has_squamata_56, t0.has_sauropterygia AS has_sauropterygia_57, t0.has_ichthyosauria AS has_ichthyosauria_58, t0.has_crocodylomorpha AS has_crocodylomorpha_59, t0.has_pterosauria AS has_pterosauria_60, t0.has_dinosauria AS has_dinosauria_61, t0.has_aves AS has_aves_62, t0.has_bryozoa AS has_bryozoa_63, t0.has_platyzoa AS has_platyzoa_64, t0.has_brachiopoda AS has_brachiopoda_65, t0.has_polychaeta AS has_polychaeta_66, t0.has_annelida AS has_annelida_67, t0.has_polyplacophora AS has_polyplacophora_68, t0.has_scaphopoda AS has_scaphopoda_69, t0.has_bivalvia AS has_bivalvia_70, t0.has_rudista AS has_rudista_71, t0.has_gastropoda AS has_gastropoda_72, t0.has_nautilida AS has_nautilida_73, t0.has_nautiloidea AS has_nautiloidea_74, t0.has_goniatitida AS has_goniatitida_75, t0.has_ceratitida AS has_ceratitida_76, t0.has_ammonitida AS has_ammonitida_77, t0.has_belemnoidea AS has_belemnoidea_78, t0.has_neocoleoidea AS has_neocoleoidea_79, t0.has_trilobita AS has_trilobita_80, t0.has_arachnida AS has_arachnida_81, t0.has_merostomata AS has_merostomata_82, t0.has_myriapoda AS has_myriapoda_83, t0.has_ostracoda AS has_ostracoda_84, t0.has_crustacea AS has_crustacea_85, t0.has_hexapoda AS has_hexapoda_86, t0.has_fungi AS has_fungi_87, t0.has_mycetozoa AS has_mycetozoa_88, t0.has_angiospermae AS has_angiospermae_89, t0.has_coniferophyta AS has_coniferophyta_90, t0.has_ginkgophyta AS has_ginkgophyta_91, t0.has_cycadophyta AS has_cycadophyta_92, t0.has_pteridospermophyta AS has_pteridospermophyta_93, t0.has_pteridophyta AS has_pteridophyta_94, t0.has_sphenophyta AS has_sphenophyta_95, t0.has_lycophyta AS has_lycophyta_96, t0.has_bryophyta AS has_bryophyta_97, t0.has_chlorophyta AS has_chlorophyta_98, t0.has_ichnofossilia AS has_ichnofossilia_99, t0.has_incertaesedis AS has_incertaesedis_100, t0.user_id AS user_id_101, t0.username AS username_102, t0.approved AS approved_103, t0.approved_user_id AS approved_user_id_104, t0.approved_username AS approved_username_105, t0.num_reviews AS num_reviews_106, t0.num_new_photos AS num_new_photos_107, t0.country_id AS country_id_108 FROM locations_fossil t0 WHERE t0.id = ?
Parameters:
[
116
]
|
|
0.61 ms (9.22%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ?
Parameters:
[
63
]
|
|
0.47 ms (7.07%) |
1 |
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:
[
995
]
|
|
0.46 ms (6.96%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.age_start AS age_start_3, t0.age_end AS age_end_4, t0.name_nl AS name_nl_5, t0.name_en AS name_en_6, t0.color AS color_7, t0.glossary_id AS glossary_id_8, t0.parent_id AS parent_id_9 FROM stratigraphy_units t0 WHERE t0.id = ?
Parameters:
[
1010
]
|
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\LocationsGeology | No errors. |
| App\Entity\LocationsMuseum | No errors. |
| App\Entity\LocationsSociety | No errors. |
| App\Entity\GlossaryReviews | No errors. |
| App\Entity\Donations | No errors. |
forumdb entity manager
No loaded entities.