Query Metrics
7
Database Queries
4
Different statements
12.01 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
5.54 ms (46.09%) |
4 |
SELECT f0_.id AS id_0, f0_.genus AS genus_1, f0_.species AS species_2, f0_.publication AS publication_3, f0_.date_day AS date_day_4, f0_.date_month AS date_month_5, f0_.date_year AS date_year_6, f0_.comment_nl AS comment_nl_7, f0_.comment_en AS comment_en_8, f0_.user_number AS user_number_9, f0_.added AS added_10, f0_.user_id AS user_id_11, f0_.username AS username_12, f0_.edited AS edited_13, f0_.edited_user_id AS edited_user_id_14, f0_.edited_username AS edited_username_15, f0_.approved AS approved_16, f0_.approved_user_id AS approved_user_id_17, f0_.approved_username AS approved_username_18, f0_.taxanomy_tree AS taxanomy_tree_19, f0_.num_reviews AS num_reviews_20, f0_.num_new_photos AS num_new_photos_21, f0_.has_edits AS has_edits_22, f0_.location_fossil_id AS location_fossil_id_23, f0_.taxanomy_id AS taxanomy_id_24, f0_.literature_id AS literature_id_25, f0_.era_id AS era_id_26, f0_.epoch_id AS epoch_id_27, f0_.stage_id AS stage_id_28, f0_.formation_id AS formation_id_29, f0_.member_id AS member_id_30 FROM fossildb_fossil f0_ WHERE f0_.location_fossil_id = (?) AND f0_.taxanomy_id = (?) AND f0_.genus = (?) AND f0_.species = (?)
Parameters:
[ 111 82 "?Crassostrea" "sp." ] |
|
3.62 ms (30.11%) |
1 |
SELECT DISTINCT f0_.genus AS genus_0, f0_.species AS species_1 FROM fossildb_fossil f0_ WHERE f0_.location_fossil_id = (?) AND f0_.taxanomy_id = (?) ORDER BY f0_.genus ASC, f0_.species ASC
Parameters:
[ 111 82 ] |
|
1.93 ms (16.05%) |
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 = ? LIMIT 1
Parameters:
[
111
]
|
|
0.93 ms (7.75%) |
1 |
SELECT t0_.id AS id_0, t0_.name_scientific AS name_scientific_1, t0_.name_scientific_clarification AS name_scientific_clarification_2, t0_.name_nl AS name_nl_3, t0_.name_en AS name_en_4, t0_.author AS author_5, t0_.author_year AS author_year_6, t0_.parent_id AS parent_id_7, t0_.is_category AS is_category_8, t0_.category_old_id AS category_old_id_9, t0_.taxanomy_rank_id AS taxanomy_rank_id_10, t0_.glossary_id AS glossary_id_11 FROM taxanomy t0_ WHERE t0_.id = (?)
Parameters:
[
82
]
|
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\LocationsFossil | No errors. |
| App\Entity\Countries | No errors. |
| App\Entity\LocationsGIS | No errors. |
| App\Entity\LocationReviews | No errors. |
| App\Entity\Literature | No errors. |
| App\Entity\LocationPhotos | No errors. |
| App\Entity\FossildbFossil | No errors. |
| App\Entity\Taxanomy | No errors. |
| App\Entity\TaxanomyRanks | No errors. |
| App\Entity\Glossaries | No errors. |
| App\Entity\StratigraphyUnits | No errors. |
| App\Entity\FossildbPhotos | No errors. |
| App\Entity\FossildbReviews | No errors. |
forumdb entity manager
No loaded entities.