GET https://www.stephen-nurse.com/market_data_history/new/19/2022-01-23

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.57 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 13.05 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:
[
  "19"
]
3 2.34 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:
[
  "19"
]
4 0.57 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
5 0.28 ms
SELECT COUNT(*) FROM product t0 WHERE t0.category = ?
Parameters:
[
  "Useful Guide"
]
6 0.30 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 5.46 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.