GET https://beta.pretoriaescorts.co.za/services

Query Metrics

9 Database Queries
4 Different statements
1.97 ms Query time
0 Invalid entities
230 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.74 ms
(37.40%)
4
SELECT t0.rate AS rate_1, t0.rate_type AS rate_type_2, t0.availability_notes AS availability_notes_3, t0.is_visible AS is_visible_4, t0.created_at AS created_at_5, t0.profile_id AS profile_id_6, t0.service_id AS service_id_7 FROM profile_service t0 WHERE t0.service_id = ?
Parameters:
[
  3
]
0.60 ms
(30.34%)
2
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC
Parameters:
[]
0.42 ms
(21.44%)
2
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= ?)) AND ((b0_.end_date IS NULL OR b0_.end_date >= ?)) AND b0_.position = ? ORDER BY b0_.sort_order ASC
Parameters:
[
  1780470596
  1780470596
  "header"
]
0.21 ms
(10.82%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name 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\ProfileService 98
App\Entity\Area 76
App\Entity\Profile 52
App\Entity\Service 4

Entities Mapping

Class Mapping errors
App\Entity\Service No errors.
App\Entity\ProfileService No errors.
App\Entity\Area No errors.
App\Entity\ProfileArea No errors.
App\Entity\Banner No errors.
App\Entity\Profile No errors.