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

Query Metrics

117 Database Queries
11 Different statements
22.96 ms Query time
1 Invalid entities
300 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.50 ms
(50.09%)
76
SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = ?
Parameters:
[
  1
]
3.48 ms
(15.16%)
9
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.profile_image AS profile_image_5, t0.bio AS bio_6, t0.portfolio_link AS portfolio_link_7, t0.instagram_handle AS instagram_handle_8, t0.availability_notes AS availability_notes_9, t0.publish_start_at AS publish_start_at_10, t0.publish_end_at AS publish_end_at_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.is_verified AS is_verified_15, t0.verified_at AS verified_at_16, t0.view_count AS view_count_17, t0.favorite_count AS favorite_count_18, t0.contact_count AS contact_count_19, t0.average_rating AS average_rating_20, t0.review_count AS review_count_21, t0.phone1 AS phone1_22, t0.whatsapp AS whatsapp_23, t0.contact_email AS contact_email_24, t0.instagram AS instagram_25, t0.facebook AS facebook_26, t0.x AS x_27, t0.webpage AS webpage_28, t0.phone2 AS phone2_29, t0.user_id AS user_id_30, t0.venue_id AS venue_id_31 FROM profile t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.91 ms
(8.31%)
4
SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = ? AND a2_.slot_name = ? AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= ?)) AND ((a0_.end_at IS NULL OR a0_.end_at >= ?)) ORDER BY a0_.priority DESC, a0_.created_at ASC
Parameters:
[
  "area_list"
  "area_list-top-landscape"
  "2026-06-03 09:10:19"
  "2026-06-03 09:10:19"
]
1.56 ms
(6.80%)
9
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.thumbnail_path AS thumbnail_path_3, t0.is_main AS is_main_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.profile_id AS profile_id_8 FROM profile_image t0 WHERE t0.profile_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  5
]
1.54 ms
(6.70%)
9
SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.profile_id = ?
Parameters:
[
  5
]
0.89 ms
(3.87%)
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:
[
  1780470619
  1780470619
  "header"
]
0.80 ms
(3.49%)
4
SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = ? AND a0_.slot_name = ? AND a0_.is_active = 1
Parameters:
[
  "area_list"
  "area_list-top-landscape"
]
0.69 ms
(3.00%)
1
SELECT a0_.id AS id_0, a0_.available_from AS available_from_1, a0_.available_until AS available_until_2, a0_.location AS location_3, a0_.notes AS notes_4, a0_.is_active AS is_active_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.profile_id AS profile_id_8 FROM available_now a0_ INNER JOIN profile p1_ ON a0_.profile_id = p1_.id WHERE a0_.is_active = 1 AND a0_.available_from <= ? AND a0_.available_until >= ? AND p1_.status = ? ORDER BY a0_.created_at DESC
Parameters:
[
  "2026-06-03 09:10:19"
  "2026-06-03 09:10:19"
  10
]
0.24 ms
(1.04%)
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:
[]
0.21 ms
(0.90%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM area t0
Parameters:
[]
0.15 ms
(0.64%)
1
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:
[]

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\ProfileArea 81
App\Entity\Area 76
App\Entity\ProfileImage 63
App\Entity\Profile 53
App\Entity\AvailableNow 9
App\Entity\User 9
App\Entity\Service 4
App\Entity\AdSlot 4
App\Entity\Venue 1

Entities Mapping

Class Mapping errors
App\Entity\Area No errors.
App\Entity\ProfileArea No errors.
App\Entity\AvailableNow No errors.
App\Entity\Profile No errors.
App\Entity\Service No errors.
App\Entity\ProfileService No errors.
App\Entity\Banner No errors.
App\Entity\AdSlot No errors.
App\Entity\AdSchedule
  • The association App\Entity\AdSchedule#advert refers to the inverse side field App\Entity\Advert#schedules which does not exist.
  • The association App\Entity\AdSchedule#adSlot refers to the inverse side field App\Entity\AdSlot#schedules which does not exist.
App\Entity\Advert No errors.
App\Entity\User No errors.
App\Entity\Venue No errors.
App\Entity\ProfileImage No errors.
App\Entity\ProfileAttributeValue No errors.
App\Entity\Favorite No errors.
App\Entity\ProfileCategory No errors.
App\Entity\ProfileVenue No errors.
App\Entity\ProfileVideo No errors.
App\Entity\AvailabilitySchedule No errors.