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

Query Metrics

63 Database Queries
8 Different statements
12.41 ms Query time
1 Invalid entities
332 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.78 ms
(30.48%)
24
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:
[
  55
]
3.78 ms
(30.44%)
24
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:
[
  55
]
2.17 ms
(17.46%)
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:
[
  "model_list"
  "model_list-top-landscape"
  "2026-06-03 09:09:55"
  "2026-06-03 09:09:55"
]
0.78 ms
(6.27%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.profile_image AS profile_image_4, p0_.bio AS bio_5, p0_.portfolio_link AS portfolio_link_6, p0_.instagram_handle AS instagram_handle_7, p0_.availability_notes AS availability_notes_8, p0_.publish_start_at AS publish_start_at_9, p0_.publish_end_at AS publish_end_at_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.is_verified AS is_verified_14, p0_.verified_at AS verified_at_15, p0_.view_count AS view_count_16, p0_.favorite_count AS favorite_count_17, p0_.contact_count AS contact_count_18, p0_.average_rating AS average_rating_19, p0_.review_count AS review_count_20, p0_.phone1 AS phone1_21, p0_.whatsapp AS whatsapp_22, p0_.contact_email AS contact_email_23, p0_.instagram AS instagram_24, p0_.facebook AS facebook_25, p0_.x AS x_26, p0_.webpage AS webpage_27, p0_.phone2 AS phone2_28, p0_.user_id AS user_id_29, p0_.venue_id AS venue_id_30 FROM profile p0_ WHERE p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 24
Parameters:
[
  10
]
0.71 ms
(5.70%)
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:
[
  "model_list"
  "model_list-top-landscape"
]
0.44 ms
(3.52%)
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:
[
  1780470595
  1780470595
  "header"
]
0.44 ms
(3.51%)
2
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.32 ms
(2.61%)
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:
[]

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\ProfileImage 168
App\Entity\Area 76
App\Entity\ProfileArea 30
App\Entity\Profile 24
App\Entity\User 24
App\Entity\Service 4
App\Entity\AdSlot 4
App\Entity\Venue 2

Entities Mapping

Class Mapping errors
App\Entity\Profile No errors.
App\Entity\User No errors.
App\Entity\Venue No errors.
App\Entity\ProfileImage No errors.
App\Entity\ProfileAttributeValue No errors.
App\Entity\AvailableNow No errors.
App\Entity\Favorite No errors.
App\Entity\ProfileCategory No errors.
App\Entity\ProfileService No errors.
App\Entity\ProfileArea No errors.
App\Entity\ProfileVenue No errors.
App\Entity\ProfileVideo No errors.
App\Entity\AvailabilitySchedule No errors.
App\Entity\Area No errors.
App\Entity\Service 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.