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.19 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
3
36.30 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 18:00:12 "
"pvt "
1
13
2
14
15
7
11
]
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 18:00:12' 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 = 'pvt' ) WHERE p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 ) ORDER BY sclr_6 DESC , p0_ . id DESC ) dctrn_result ) dctrn_table ;
Copy
4
38.38 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 3210
Parameters :
[
"2025-04-21 18:00:12 "
"pvt "
1
13
2
14
15
7
11
]
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 18:00:12' 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 = 'pvt' ) WHERE p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 )) dctrn_result_inner ORDER BY sclr_6 DESC , id_0 DESC ) dctrn_result LIMIT 30 OFFSET 3210 ;
Copy
5
2.03 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 18:00:12 "
"pvt "
1
13
2
14
15
7
11
95611
95572
95290
95240
95112
95101
94887
94599
94466
94464
94452
94426
94387
93964
93838
93814
93788
93766
93739
93734
93712
93711
93514
93213
93089
93025
92997
92760
92645
92617
]
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
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 18:00:12' 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 = 'pvt' ) WHERE p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 ) AND p0_ . id IN (95611 , 95572 , 95290 , 95240 , 95112 , 95101 , 94887 , 94599 , 94466 , 94464 , 94452 , 94426 , 94387 , 93964 , 93838 , 93814 , 93788 , 93766 , 93739 , 93734 , 93712 , 93711 , 93514 , 93213 , 93089 , 93025 , 92997 , 92760 , 92645 , 92617 ) ORDER BY sclr_6 DESC , p0_ . id DESC ;
Copy
6
1.25 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 :
[
95611
95572
95290
95240
95112
95101
94887
94599
94466
94464
94452
94426
94387
93964
93838
93814
93788
93766
93739
93734
93712
93711
93514
93213
93089
93025
92997
92760
92645
92617
]
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 (95611 , 95572 , 95290 , 95240 , 95112 , 95101 , 94887 , 94599 , 94466 , 94464 , 94452 , 94426 , 94387 , 93964 , 93838 , 93814 , 93788 , 93766 , 93739 , 93734 , 93712 , 93711 , 93514 , 93213 , 93089 , 93025 , 92997 , 92760 , 92645 , 92617 );
Copy
7
1.32 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 :
[
95611
95572
95290
95240
95112
95101
94887
94599
94466
94464
94452
94426
94387
93964
93838
93814
93788
93766
93739
93734
93712
93711
93514
93213
93089
93025
92997
92760
92645
92617
]
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 (95611 , 95572 , 95290 , 95240 , 95112 , 95101 , 94887 , 94599 , 94466 , 94464 , 94452 , 94426 , 94387 , 93964 , 93838 , 93814 , 93788 , 93766 , 93739 , 93734 , 93712 , 93711 , 93514 , 93213 , 93089 , 93025 , 92997 , 92760 , 92645 , 92617 );
Copy
8
586.06 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 :
[
"erin_and_johnny "
"ashleyusme "
"kris69kiss "
"medieval666 "
"airac_memories "
"azucenaxxxgp "
"lilith_cain "
"sweety_cat7 "
"charlotte__g "
"alexluv_23 "
"tsbunnyhun "
"babyvavi "
"gabrielarossa "
"dreamgerls "
"miiasolerr__ "
"cherry_hc "
"mikyloveu "
"liaaa___ "
"asajjj369 "
"captivatinghailey_ "
"sophie_janss "
"exotic_judy "
"elektra_and_konan_01 "
"olgakurylenko "
"medusalady "
"cherry_blossomsx "
"katecrash "
"sophie_bss "
"andromeda_meyer "
"badmodel_ "
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 ('erin_and_johnny' , 'ashleyusme' , 'kris69kiss' , 'medieval666' , 'airac_memories' , 'azucenaxxxgp' , 'lilith_cain' , 'sweety_cat7' , 'charlotte__g' , 'alexluv_23' , 'tsbunnyhun' , 'babyvavi' , 'gabrielarossa' , 'dreamgerls' , 'miiasolerr__' , 'cherry_hc' , 'mikyloveu' , 'liaaa___' , 'asajjj369' , 'captivatinghailey_' , 'sophie_janss' , 'exotic_judy' , 'elektra_and_konan_01' , 'olgakurylenko' , 'medusalady' , 'cherry_blossomsx' , 'katecrash' , 'sophie_bss' , 'andromeda_meyer' , 'badmodel_' ) AND p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 );
Copy
9
0.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 :
[
92169
92794
94270
94966
]
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 (92169 , 92794 , 94270 , 94966 );
Copy
10
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 :
[
92169
92794
94270
94966
]
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 (92169 , 92794 , 94270 , 94966 );
Copy
11
0.12 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
12
0.11 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
13
0.10 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.10 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.12 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
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 = ?
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
18
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
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 = ?
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