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

Queries

Group similar statements

# Time Info
1 0.34 ms
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:
[]
2 0.21 ms
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:
[]
3 0.26 ms
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:
[]
4 0.24 ms
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"
]
5 0.19 ms
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
]
6 0.22 ms
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:
[
  1
]
7 0.17 ms
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:
[
  4
]
8 0.16 ms
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:
[
  2
]
9 0.18 ms
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
  "footer"
]

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.