GET https://sexzz.net/list?page=123&tag=dildo

Query Metrics

25 Database Queries
14 Different statements
826.22 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:
[
  "sexzz.net"
]
2 0.17 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:
[
  "sexzz.net"
]
3 43.81 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_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  "2025-04-21 22:44:37"
  "dildo"
  1
  2
  13
  5
  14
  15
  7
  11
]
4 47.30 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, p1_.id AS id_7, p1_.tag AS tag_8 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30 OFFSET 3690
Parameters:
[
  "2025-04-21 22:44:37"
  "dildo"
  1
  2
  13
  5
  14
  15
  7
  11
]
5 1.49 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_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC
Parameters:
[
  "2025-04-21 22:44:37"
  "dildo"
  1
  2
  13
  5
  14
  15
  7
  11
  209030
  208925
  208640
  208569
  208492
  208487
  208147
  207791
  207669
  207605
  207477
  207107
  206890
  206861
  206860
  206751
  206670
  206669
  206628
  206609
  206441
  206351
  206311
  206282
  206003
  205996
  205958
  205776
  205691
  205632
]
6 1.13 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:
[
  209030
  208925
  208640
  208569
  208492
  208487
  208147
  207791
  207669
  207605
  207477
  207107
  206890
  206861
  206860
  206751
  206670
  206669
  206628
  206609
  206441
  206351
  206311
  206282
  206003
  205996
  205958
  205776
  205691
  205632
]
7 0.82 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:
[
  209030
  208925
  208640
  208569
  208492
  208487
  208147
  207791
  207669
  207605
  207477
  207107
  206890
  206861
  206860
  206751
  206670
  206669
  206628
  206609
  206441
  206351
  206311
  206282
  206003
  205996
  205958
  205776
  205691
  205632
]
8 728.41 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:
[
  "facelesstemptation"
  "isabelaguerra"
  "cristian_disick"
  "alisonstafford"
  "bigmanaround9"
  "janb_25"
  "maxxie_goddess"
  "_pretty_fox_"
  "alicek"
  "funtimz16"
  "nicnicnico"
  "mayastarx"
  "isabellebianchi"
  "kendramax"
  "helenerossy"
  "annanolaan"
  "vanezaleviz"
  "emadiamonds"
  "alay"
  "demonskiss"
  "sofiabunton"
  "jhotta_foxx"
  "yaseminsaff"
  "miasocean"
  "laflori"
  "hot_ebony2"
  "deliciousmonster30"
  "kimbless"
  "silverfairy"
  "shadown89"
  1
  2
  13
  5
  14
  15
  7
  11
]
9 0.50 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:
[
  206398
  213228
  401520
  492661
  492735
]
10 0.39 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:
[
  206398
  213228
  401520
  492661
  492735
]
11 0.14 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:
[
  7
]
12 0.13 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.11 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.11 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.10 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
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.16 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.15 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  5
]
19 0.16 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:
[
  5
]
20 0.12 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  2
]
21 0.15 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
]
22 0.12 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  15
]
23 0.20 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:
[
  15
]
24 0.11 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  14
]
25 0.18 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:
[
  14
]

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\Partner No errors.
App\Entity\Performer No errors.
App\Entity\PerformerTag No errors.
App\Entity\Category No errors.
App\Entity\PerformerInfo No errors.