GET http://test.swift-integration.nl/pricing

Query Metrics

7 Database Queries
3 Different statements
10.08 ms Query time
1 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 2.97 ms
SELECT p0_.id AS id_0, p0_.package AS package_1, p0_.price_cents_1m AS price_cents_1m_2, p0_.full_price_cents_1m AS full_price_cents_1m_3, p0_.discount_1m AS discount_1m_4, p0_.discount_text_1m AS discount_text_1m_5, p0_.price_cents_3m AS price_cents_3m_6, p0_.full_price_cents_3m AS full_price_cents_3m_7, p0_.discount_3m AS discount_3m_8, p0_.discount_text_3m AS discount_text_3m_9, p0_.price_cents_6m AS price_cents_6m_10, p0_.full_price_cents_6m AS full_price_cents_6m_11, p0_.discount_6m AS discount_6m_12, p0_.discount_text_6m AS discount_text_6m_13, p0_.title AS title_14, p0_.description AS description_15, p0_.level AS level_16, p0_.image AS image_17, p0_.type AS type_18, p0_.incl_sound AS incl_sound_19, p0_.enabled AS enabled_20 FROM package p0_
Parameters:
[]
2 3.83 ms
SELECT i0_.id AS id_0 FROM instruction_video i0_ WHERE i0_.package_id = ? ORDER BY i0_.`order` ASC
Parameters:
[
  1
]
3 0.60 ms
SELECT i0_.id AS id_0 FROM instruction_video i0_ WHERE i0_.package_id = ? ORDER BY i0_.`order` ASC
Parameters:
[
  2
]
4 0.52 ms
SELECT i0_.id AS id_0 FROM instruction_video i0_ WHERE i0_.package_id = ? ORDER BY i0_.`order` ASC
Parameters:
[
  3
]
5 0.64 ms
SELECT i0_.id AS id_0 FROM instruction_video i0_ WHERE i0_.package_id = ? ORDER BY i0_.`order` ASC
Parameters:
[
  4
]
6 0.58 ms
SELECT i0_.id AS id_0 FROM instruction_video i0_ WHERE i0_.package_id = ? ORDER BY i0_.`order` ASC
Parameters:
[
  5
]
7 0.94 ms
SELECT c0_.id AS id_0, c0_.ip_address AS ip_address_1, c0_.policy_version AS policy_version_2, c0_.decision AS decision_3, c0_.ts AS ts_4, c0_.user_id AS user_id_5 FROM cookie_consent_log c0_ WHERE c0_.ip_address = ? ORDER BY c0_.ts DESC
Parameters:
[
  "10.104.0.19"
]

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\Package 5

Entities Mapping

Class Mapping errors
App\Entity\Package No errors.
App\Entity\InstructionVideo
  • The association App\Entity\InstructionVideo#package refers to the inverse side field App\Entity\Package#instructionVideos which does not exist.
App\Entity\CookieConsentLog No errors.