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 :
[
"camsearch.net "
]
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 = 'camsearch.net' LIMIT 1 ;
Copy
2
0.13 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = 1 ;
Copy
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 :
[
"camsearch.net "
]
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 = 'camsearch.net' ;
Copy
4
375.25 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 17:22:54 "
1
13
2
14
15
7
11
"1 "
]
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 > '2025-04-21 17:22:54' THEN 1 ELSE 0 END ) AS sclr_6 FROM performer p0_ WHERE p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 ) AND p0_ . category_id = '1' ORDER BY sclr_6 DESC , p0_ . id DESC ) dctrn_result ) dctrn_table ;
Copy
5
727.33 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 197520
Parameters :
[
"2025-04-21 17:22:54 "
1
13
2
14
15
7
11
"1 "
]
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 > '2025-04-21 17:22:54' THEN 1 ELSE 0 END ) AS sclr_6 FROM performer p0_ WHERE p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 ) AND p0_ . category_id = '1' ) dctrn_result_inner ORDER BY sclr_6 DESC , id_0 DESC ) dctrn_result LIMIT 30 OFFSET 197520 ;
Copy
6
1.24 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 17:22:54 "
1
13
2
14
15
7
11
"1 "
1652
1651
1650
1648
1646
1643
1642
1641
1640
1639
1637
1636
1633
1632
1628
1627
1625
1624
1622
1620
1619
1618
1617
1615
1614
1613
1612
1611
1606
1604
]
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
Copy
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 > '2025-04-21 17:22:54' 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 (1 , 13 , 2 , 14 , 15 , 7 , 11 ) AND p0_ . category_id = '1' AND p0_ . id IN (1652 , 1651 , 1650 , 1648 , 1646 , 1643 , 1642 , 1641 , 1640 , 1639 , 1637 , 1636 , 1633 , 1632 , 1628 , 1627 , 1625 , 1624 , 1622 , 1620 , 1619 , 1618 , 1617 , 1615 , 1614 , 1613 , 1612 , 1611 , 1606 , 1604 ) ORDER BY sclr_6 DESC , p0_ . id DESC ;
Copy
7
0.85 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 :
[
1652
1651
1650
1648
1646
1643
1642
1641
1640
1639
1637
1636
1633
1632
1628
1627
1625
1624
1622
1620
1619
1618
1617
1615
1614
1613
1612
1611
1606
1604
]
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 (1652 , 1651 , 1650 , 1648 , 1646 , 1643 , 1642 , 1641 , 1640 , 1639 , 1637 , 1636 , 1633 , 1632 , 1628 , 1627 , 1625 , 1624 , 1622 , 1620 , 1619 , 1618 , 1617 , 1615 , 1614 , 1613 , 1612 , 1611 , 1606 , 1604 );
Copy
8
0.69 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 :
[
1652
1651
1650
1648
1646
1643
1642
1641
1640
1639
1637
1636
1633
1632
1628
1627
1625
1624
1622
1620
1619
1618
1617
1615
1614
1613
1612
1611
1606
1604
]
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 (1652 , 1651 , 1650 , 1648 , 1646 , 1643 , 1642 , 1641 , 1640 , 1639 , 1637 , 1636 , 1633 , 1632 , 1628 , 1627 , 1625 , 1624 , 1622 , 1620 , 1619 , 1618 , 1617 , 1615 , 1614 , 1613 , 1612 , 1611 , 1606 , 1604 );
Copy
9
963.91 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 :
[
"nanachi_cook "
"dragonwind "
"mildredbowring "
"fairy_di "
"gina_gracia_ "
"blair_uwu_ "
"valen_ruiz_ "
"violeta_euphoria "
"divine_sin "
"catalina-whore "
"blackjaguar30 "
"pamela-shadya "
"athenea_mills "
"umarany "
"catyf1 "
"juicygoddess2 "
"lizysoul "
"adib_ali "
"maissa_alabi "
"kathy_lopez "
"sassy_stella "
"daniiphoeniixx "
"milkyqueen69 "
"elvaaxley "
"dahlia_rousse "
"bianca_zaens2 "
"kylielipa "
"cat_mary1 "
"carmela_cute "
"matchedeyebrow "
1
13
2
14
15
7
11
]
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 (? , ? , ? , ? , ? , ? , ? )
Copy
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 ('nanachi_cook' , 'dragonwind' , 'mildredbowring' , 'fairy_di' , 'gina_gracia_' , 'blair_uwu_' , 'valen_ruiz_' , 'violeta_euphoria' , 'divine_sin' , 'catalina-whore' , 'blackjaguar30' , 'pamela-shadya' , 'athenea_mills' , 'umarany' , 'catyf1' , 'juicygoddess2' , 'lizysoul' , 'adib_ali' , 'maissa_alabi' , 'kathy_lopez' , 'sassy_stella' , 'daniiphoeniixx' , 'milkyqueen69' , 'elvaaxley' , 'dahlia_rousse' , 'bianca_zaens2' , 'kylielipa' , 'cat_mary1' , 'carmela_cute' , 'matchedeyebrow' ) AND p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 );
Copy
10
0.64 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 :
[
12703
13363
14078
15925
17184
17691
59579
]
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 (12703 , 13363 , 14078 , 15925 , 17184 , 17691 , 59579 );
Copy
11
0.43 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 :
[
12703
13363
14078
15925
17184
17691
59579
]
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 (12703 , 13363 , 14078 , 15925 , 17184 , 17691 , 59579 );
Copy
12
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 = ?
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 = 56 ;
Copy
13
10.87 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = 2 ;
Copy
14
0.16 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = 3 ;
Copy
15
0.09 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 FROM category t0 WHERE t0 . id = 4 ;
Copy
16
0.14 ms
SELECT t0 . id AS id_1 , t0 . partner_name AS partner_name_2 FROM partner t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . partner_name AS partner_name_2 FROM partner t0 WHERE t0 . id = 2 ;
Copy
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 = ?
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 = 2 ;
Copy
18
0.13 ms
SELECT t0 . id AS id_1 , t0 . partner_name AS partner_name_2 FROM partner t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . partner_name AS partner_name_2 FROM partner t0 WHERE t0 . id = 1 ;
Copy
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 = ?
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 = 1 ;
Copy