GET https://www.stephen-nurse.com/market_data_history/new/17/2024-02-28

Query Metrics

7 Database Queries
5 Different statements
42.43 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 7.19 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
  "en"
]
2 22.03 ms
SELECT t0.id AS id_1, t0.share_company AS share_company_2, t0.companies_house AS companies_house_3, t0.weblink AS weblink_4, t0.login AS login_5, t0.password AS password_6, t0.investor_site AS investor_site_7, t0.comment AS comment_8, t0.is_active AS is_active_9, t0.asset_class_id AS asset_class_id_10 FROM market_data t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
3 8.58 ms
SELECT t0.id AS id_1, t0.share_company AS share_company_2, t0.companies_house AS companies_house_3, t0.weblink AS weblink_4, t0.login AS login_5, t0.password AS password_6, t0.investor_site AS investor_site_7, t0.comment AS comment_8, t0.is_active AS is_active_9, t0.asset_class_id AS asset_class_id_10 FROM market_data t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
4 1.37 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
5 0.30 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
6 2.18 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
7 0.78 ms
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Languages 6
App\Entity\MarketData 1
App\Entity\AssetClasses 1

Entities Mapping

Class Mapping errors
App\Entity\Languages No errors.
App\Entity\MarketData No errors.
App\Entity\AssetClasses No errors.
App\Entity\MarketDataHistory No errors.
App\Entity\Product No errors.