GET https://adultpoint.net/list?category=4&page=59

Query Metrics

21 Database Queries
14 Different statements
1367.69 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.13 ms
SELECT t0.domain AS domain_1, t0.alias AS alias_2, t0.domain_css AS domain_css_3, t0.domain_js AS domain_js_4, t0.homepage_title AS homepage_title_5, t0.logo_font_size AS logo_font_size_6, t0.header_background_color AS header_background_color_7, t0.logo_font_id AS logo_font_id_8 FROM domain t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "adultpoint.net"
]
2 0.23 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
3 0.14 ms
SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.domain = ?
Parameters:
[
  "adultpoint.net"
]
4 99.64 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6 FROM performer p0_ WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.category_id = ? ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  "2025-04-21 20:44:09"
  1
  13
  2
  14
  15
  7
  11
  "4"
]
5 120.86 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_6 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6 FROM performer p0_ WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.category_id = ?) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30 OFFSET 1770
Parameters:
[
  "2025-04-21 20:44:09"
  1
  13
  2
  14
  15
  7
  11
  "4"
]
6 12.27 ms
SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6, p0_.partner_id AS partner_id_7, p0_.category_id AS category_id_8 FROM performer p0_ WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC
Parameters:
[
  "2025-04-21 20:44:09"
  1
  13
  2
  14
  15
  7
  11
  "4"
  543387
  543343
  543319
  543316
  543218
  543216
  543156
  543147
  543043
  542968
  542946
  542906
  542819
  542813
  542802
  542730
  542590
  542489
  542487
  542483
  542464
  542459
  542302
  542277
  542235
  542183
  542172
  542137
  542079
  542064
]
7 0.86 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  543387
  543343
  543319
  543316
  543218
  543216
  543156
  543147
  543043
  542968
  542946
  542906
  542819
  542813
  542802
  542730
  542590
  542489
  542487
  542483
  542464
  542459
  542302
  542277
  542235
  542183
  542172
  542137
  542079
  542064
]
8 0.79 ms
SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  543387
  543343
  543319
  543316
  543218
  543216
  543156
  543147
  543043
  542968
  542946
  542906
  542819
  542813
  542802
  542730
  542590
  542489
  542487
  542483
  542464
  542459
  542302
  542277
  542235
  542183
  542172
  542137
  542079
  542064
]
9 1088.75 ms
SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, p0_.partner_id AS partner_id_6, p0_.category_id AS category_id_7 FROM performer p0_ WHERE LOWER(p0_.performer_code) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "puupyloves2play"
  "ramy311672"
  "atenea_0"
  "badsissyman"
  "madison__hot"
  "zoe-rousse"
  "tsmaiasparks"
  "marziparaiso"
  "_mikaylaroyce_"
  "lorenabebyhot"
  "artemys__"
  "morgz1027"
  "maribigcock25"
  "kamii_latin"
  "thenegraxxx"
  "violetfinch97"
  "12_strongcockxx"
  "johannadollxxts"
  "amelia_winters9553"
  "arid_hot"
  "bestasiantrans"
  "molli3mil3s"
  "clannegra"
  "whitepeach23"
  "paris_hiltom"
  "trailertonya"
  "mia-oficial"
  "svixn"
  "celeste_silva"
  "tsaaliyah13"
  1
  13
  2
  14
  15
  7
  11
]
10 12.14 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (?, ?)
Parameters:
[
  200579
  562050
]
11 0.31 ms
SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (?, ?)
Parameters:
[
  200579
  562050
]
12 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.css AS css_3, t0.family AS family_4 FROM font t0 WHERE t0.id = ?
Parameters:
[
  12
]
13 30.37 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.15 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
15 0.10 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.11 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  1
]
17 0.14 ms
SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = ?
Parameters:
[
  1
]
18 0.13 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  2
]
19 0.13 ms
SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = ?
Parameters:
[
  2
]
20 0.14 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  11
]
21 0.12 ms
SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = ?
Parameters:
[
  11
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Domain
  • The mappings App\Entity\Domain#domainPartners and App\Entity\DomainPartner#domain are inconsistent with each other.
App\Entity\Font No errors.
App\Entity\DomainPartner
  • The association App\Entity\DomainPartner#domain refers to the inverse side field App\Entity\Domain#partners which does not exist.
App\Entity\Category No errors.
App\Entity\Partner No errors.
App\Entity\Performer No errors.
App\Entity\PerformerTag No errors.
App\Entity\PerformerInfo No errors.