GET https://freewebcamtube.net/list?tag=daddy&tag2=masturbation

Query Metrics

15 Database Queries
12 Different statements
2341.92 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 7.71 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:
[
  "freewebcamtube.net"
]
2 14.44 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:
[
  "freewebcamtube.net"
]
3 171.16 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 17:22:08"
  "daddy"
  "masturbation"
  1
  13
  14
  15
  7
  11
]
4 262.01 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 17:22:08"
  "daddy"
  "masturbation"
  1
  13
  14
  15
  7
  11
]
5 1.84 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 17:22:08"
  "daddy"
  "masturbation"
  1
  13
  14
  15
  7
  11
  247530
  499707
  303218
  294137
  286785
  239018
  217230
  217094
  203744
  200288
  199483
  191079
  178674
]
6 0.77 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:
[
  247530
  499707
  303218
  294137
  286785
  239018
  217230
  217094
  203744
  200288
  199483
  191079
  178674
]
7 0.60 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:
[
  247530
  499707
  303218
  294137
  286785
  239018
  217230
  217094
  203744
  200288
  199483
  191079
  178674
]
8 1863.96 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:
[
  "dizzyy5"
  "masterlucifer45"
  "maduro55boedo"
  "jasonmarkus"
  "scottybeam"
  "mike85bg"
  "shaved_german_man"
  "fury3177"
  "veiledmast3r"
  "jhon_0511"
  "nudejack75"
  "lefti27"
  "sonixxx27"
  1
  13
  14
  15
  7
  11
]
9 0.13 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:
[
  70
]
10 0.11 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.09 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.09 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
13 0.09 ms
SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
14 18.76 ms
SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 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
]

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.