GET https://sexsube.com/list?tag=lovense&tag2=dick

Query Metrics

19 Database Queries
14 Different statements
1816.78 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.14 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:
[
  "sexsube.com"
]
2 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.domain = ?
Parameters:
[
  "sexsube.com"
]
3 24.28 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 = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  "2025-04-21 18:08:08"
  "lovense"
  "dick"
  1
  13
  2
  14
  15
  7
  11
]
4 24.70 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, p2_.id AS id_9, p2_.tag AS tag_10 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30
Parameters:
[
  "2025-04-21 18:08:08"
  "lovense"
  "dick"
  1
  13
  2
  14
  15
  7
  11
]
5 27.61 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 = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC
Parameters:
[
  "2025-04-21 18:08:08"
  "lovense"
  "dick"
  1
  13
  2
  14
  15
  7
  11
  202474
  196840
  561121
  481269
  317682
  304928
  289685
  285952
  260351
  234017
  233036
  217037
  214340
  211720
  206134
  204747
  198710
  196893
  191083
  174266
  171681
  171246
  126627
  109619
  98785
  73492
  24229
]
6 1.21 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:
[
  202474
  196840
  561121
  481269
  317682
  304928
  289685
  285952
  260351
  234017
  233036
  217037
  214340
  211720
  206134
  204747
  198710
  196893
  191083
  174266
  171681
  171246
  126627
  109619
  98785
  73492
  24229
]
7 1.01 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:
[
  202474
  196840
  561121
  481269
  317682
  304928
  289685
  285952
  260351
  234017
  233036
  217037
  214340
  211720
  206134
  204747
  198710
  196893
  191083
  174266
  171681
  171246
  126627
  109619
  98785
  73492
  24229
]
8 1725.57 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:
[
  "jeffsexybody"
  "goldcmen"
  "maxx_hunterr"
  "thiagovelasquez"
  "andressdean"
  "kuromi_chococat"
  "azzlikemine"
  "brotrev"
  "sanabreak"
  "saimonhot1"
  "derekwildx"
  "mark_and_fiinn"
  "rus_adventure"
  "alejandrobghero"
  "jacobo__parker21"
  "jakehenry12"
  "giorgio_leone2"
  "otishairy"
  "chris_stev47"
  "jackson_wayne__"
  "luke_cooper3"
  "hardsexlove08"
  "vanessa_brett"
  "noah_monroe_11_"
  "anniee_land"
  "trishaslowxx"
  "veronicadussan"
  1
  13
  2
  14
  15
  7
  11
]
9 10.41 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:
[
  233365
  238933
  260429
  281050
]
10 0.34 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:
[
  233365
  238933
  260429
  281050
]
11 0.38 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:
[
  67
]
12 0.11 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.10 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.09 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
16 0.10 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  1
]
17 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:
[
  1
]
18 0.17 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  2
]
19 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:
[
  2
]

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.