1
18.15 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 :
[
"xxxcrawl.com "
]
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 = 'xxxcrawl.com' LIMIT 1 ;
Copy
2
5.38 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
3
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 . domain = ?
Parameters :
[
"xxxcrawl.com "
]
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 = 'xxxcrawl.com' ;
Copy
4
235.76 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 20:11:07 "
1
13
2
14
15
7
11
"4 "
]
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 20:11:07' 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 = '4' ORDER BY sclr_6 DESC , p0_ . id DESC ) dctrn_result ) dctrn_table ;
Copy
5
708.20 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 19110
Parameters :
[
"2025-04-21 20:11:07 "
1
13
2
14
15
7
11
"4 "
]
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 20:11:07' 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 = '4' ) dctrn_result_inner ORDER BY sclr_6 DESC , id_0 DESC ) dctrn_result LIMIT 30 OFFSET 19110 ;
Copy
6
1.14 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 20:11:07 "
1
13
2
14
15
7
11
"4 "
7916
7915
7911
7905
7903
7902
7898
7896
7892
7889
7886
7883
7882
7881
7879
7877
7875
7872
7871
7866
7857
7856
7855
7851
7847
7845
7844
7842
7840
7839
]
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 20:11:07' 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 = '4' AND p0_ . id IN (7916 , 7915 , 7911 , 7905 , 7903 , 7902 , 7898 , 7896 , 7892 , 7889 , 7886 , 7883 , 7882 , 7881 , 7879 , 7877 , 7875 , 7872 , 7871 , 7866 , 7857 , 7856 , 7855 , 7851 , 7847 , 7845 , 7844 , 7842 , 7840 , 7839 ) ORDER BY sclr_6 DESC , p0_ . id DESC ;
Copy
7
0.86 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 :
[
7916
7915
7911
7905
7903
7902
7898
7896
7892
7889
7886
7883
7882
7881
7879
7877
7875
7872
7871
7866
7857
7856
7855
7851
7847
7845
7844
7842
7840
7839
]
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 (7916 , 7915 , 7911 , 7905 , 7903 , 7902 , 7898 , 7896 , 7892 , 7889 , 7886 , 7883 , 7882 , 7881 , 7879 , 7877 , 7875 , 7872 , 7871 , 7866 , 7857 , 7856 , 7855 , 7851 , 7847 , 7845 , 7844 , 7842 , 7840 , 7839 );
Copy
8
10.81 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 :
[
7916
7915
7911
7905
7903
7902
7898
7896
7892
7889
7886
7883
7882
7881
7879
7877
7875
7872
7871
7866
7857
7856
7855
7851
7847
7845
7844
7842
7840
7839
]
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 (7916 , 7915 , 7911 , 7905 , 7903 , 7902 , 7898 , 7896 , 7892 , 7889 , 7886 , 7883 , 7882 , 7881 , 7879 , 7877 , 7875 , 7872 , 7871 , 7866 , 7857 , 7856 , 7855 , 7851 , 7847 , 7845 , 7844 , 7842 , 7840 , 7839 );
Copy
9
3880.82 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 :
[
"sissyslutpinky1 "
"luluvaladon "
"empressoflust "
"korina_saenz01 "
"rubyylowell "
"lesi_shy "
"angel_nicole23cm "
"karla_zambrano "
"khloe_angel "
"finestgirlx "
"corinmasterx "
"hangez0e "
"cocknari69 "
"jaddyk_ "
"khalyn_jenner "
"ayara_tasi "
"karla-ebony "
"nesia69 "
"elizabethameen "
"stifany_cooperr "
"bonnie_vega "
"lissi_tv "
"arianagoldd "
"jasmine_elcock "
"vale_bratz_ "
"andy_candy01 "
"sweetcheska19 "
"tania_060101 "
"shemale-maloka "
"sophia_daker "
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 ('sissyslutpinky1' , 'luluvaladon' , 'empressoflust' , 'korina_saenz01' , 'rubyylowell' , 'lesi_shy' , 'angel_nicole23cm' , 'karla_zambrano' , 'khloe_angel' , 'finestgirlx' , 'corinmasterx' , 'hangez0e' , 'cocknari69' , 'jaddyk_' , 'khalyn_jenner' , 'ayara_tasi' , 'karla-ebony' , 'nesia69' , 'elizabethameen' , 'stifany_cooperr' , 'bonnie_vega' , 'lissi_tv' , 'arianagoldd' , 'jasmine_elcock' , 'vale_bratz_' , 'andy_candy01' , 'sweetcheska19' , 'tania_060101' , 'shemale-maloka' , 'sophia_daker' ) AND p0_ . partner_id IN (1 , 13 , 2 , 14 , 15 , 7 , 11 );
Copy
10
0.62 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 :
[
388
11748
11954
12067
12571
12656
12810
14402
19790
25024
]
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 (388 , 11748 , 11954 , 12067 , 12571 , 12656 , 12810 , 14402 , 19790 , 25024 );
Copy
11
0.51 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 :
[
388
11748
11954
12067
12571
12656
12810
14402
19790
25024
]
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 (388 , 11748 , 11954 , 12067 , 12571 , 12656 , 12810 , 14402 , 19790 , 25024 );
Copy
12
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 = ?
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 = 46 ;
Copy
13
48.01 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
14
0.15 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
15
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 = 3 ;
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 = 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.16 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