[ SQL ] SHOW COLUMNS FROM `cmf_phone` [ RunTime:0.001634s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_phone` WHERE ( status = 1 AND floor(LEFT(phone,3)) = '136' AND (
(mid(phone,length(phone)-1,1)-1 = floor(right(phone,1)) and mid(phone,length(phone)-2,1)-2 = floor(right(phone,1)) and mid(phone,length(phone)-3,1)-3 = floor(right(phone,1))) or (mid(phone,length(phone)-1,1)+1 = floor(right(phone,1)) and mid(phone,length(phone)-2,1)+2 = floor(right(phone,1)) and mid(phone,length(phone)-3,1)+3 = floor(right(phone,1)))
) AND (
( floor(mid(phone,2,2)) mod 11 = 0 and floor(mid(phone,4,2)) mod 11 =0 and floor(mid(phone,2,2))<>floor(mid(phone,4,2)) and floor(mid(phone,5,1))<>floor(mid(phone,6,1)) and floor(mid(phone,2,1))<>floor(mid(phone,1,1)) )
or ( floor(mid(phone,3,2)) mod 11 = 0 and floor(mid(phone,5,2)) mod 11 =0 and floor(mid(phone,3,2))<>floor(mid(phone,5,2)) and floor(mid(phone,6,1))<>floor(mid(phone,7,1)) and floor(mid(phone,3,1))<>floor(mid(phone,2,1)) )
or ( floor(mid(phone,4,2)) mod 11 = 0 and floor(mid(phone,6,2)) mod 11 =0 and floor(mid(phone,4,2))<>floor(mid(phone,6,2)) and floor(mid(phone,7,1))<>floor(mid(phone,8,1)) and floor(mid(phone,4,1))<>floor(mid(phone,3,1)) )
or ( floor(mid(phone,5,2)) mod 11 = 0 and floor(mid(phone,7,2)) mod 11 =0 and floor(mid(phone,5,2))<>floor(mid(phone,7,2)) and floor(mid(phone,8,1))<>floor(mid(phone,9,1)) and floor(mid(phone,5,1))<>floor(mid(phone,4,1)) )
or ( floor(mid(phone,6,2)) mod 11 = 0 and floor(mid(phone,8,2)) mod 11 =0 and floor(mid(phone,6,2))<>floor(mid(phone,8,2)) and floor(mid(phone,9,1))<>floor(mid(phone,10,1)) and floor(mid(phone,6,1))<>floor(mid(phone,5,1)) )
or ( floor(mid(phone,7,2)) mod 11 = 0 and floor(mid(phone,9,2)) mod 11 =0 and floor(mid(phone,7,2))<>floor(mid(phone,9,2)) and floor(mid(phone,10,1))<>floor(mid(phone,11,1)) and floor(mid(phone,7,1))<>floor(mid(phone,6,1)) )
) ) [ RunTime:0.409777s ]
[ SQL ] SELECT * FROM `cmf_phone` WHERE ( status = 1 AND floor(LEFT(phone,3)) = '136' AND (
(mid(phone,length(phone)-1,1)-1 = floor(right(phone,1)) and mid(phone,length(phone)-2,1)-2 = floor(right(phone,1)) and mid(phone,length(phone)-3,1)-3 = floor(right(phone,1))) or (mid(phone,length(phone)-1,1)+1 = floor(right(phone,1)) and mid(phone,length(phone)-2,1)+2 = floor(right(phone,1)) and mid(phone,length(phone)-3,1)+3 = floor(right(phone,1)))
) AND (
( floor(mid(phone,2,2)) mod 11 = 0 and floor(mid(phone,4,2)) mod 11 =0 and floor(mid(phone,2,2))<>floor(mid(phone,4,2)) and floor(mid(phone,5,1))<>floor(mid(phone,6,1)) and floor(mid(phone,2,1))<>floor(mid(phone,1,1)) )
or ( floor(mid(phone,3,2)) mod 11 = 0 and floor(mid(phone,5,2)) mod 11 =0 and floor(mid(phone,3,2))<>floor(mid(phone,5,2)) and floor(mid(phone,6,1))<>floor(mid(phone,7,1)) and floor(mid(phone,3,1))<>floor(mid(phone,2,1)) )
or ( floor(mid(phone,4,2)) mod 11 = 0 and floor(mid(phone,6,2)) mod 11 =0 and floor(mid(phone,4,2))<>floor(mid(phone,6,2)) and floor(mid(phone,7,1))<>floor(mid(phone,8,1)) and floor(mid(phone,4,1))<>floor(mid(phone,3,1)) )
or ( floor(mid(phone,5,2)) mod 11 = 0 and floor(mid(phone,7,2)) mod 11 =0 and floor(mid(phone,5,2))<>floor(mid(phone,7,2)) and floor(mid(phone,8,1))<>floor(mid(phone,9,1)) and floor(mid(phone,5,1))<>floor(mid(phone,4,1)) )
or ( floor(mid(phone,6,2)) mod 11 = 0 and floor(mid(phone,8,2)) mod 11 =0 and floor(mid(phone,6,2))<>floor(mid(phone,8,2)) and floor(mid(phone,9,1))<>floor(mid(phone,10,1)) and floor(mid(phone,6,1))<>floor(mid(phone,5,1)) )
or ( floor(mid(phone,7,2)) mod 11 = 0 and floor(mid(phone,9,2)) mod 11 =0 and floor(mid(phone,7,2))<>floor(mid(phone,9,2)) and floor(mid(phone,10,1))<>floor(mid(phone,11,1)) and floor(mid(phone,7,1))<>floor(mid(phone,6,1)) )
) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:5.237564s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002748s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `post`.`recommended` = '1' AND ( `post`.`published_time` > '0' and `post`.`published_time` < '1765894931' ) GROUP BY `post`.`id` LIMIT 3 [ RunTime:0.002264s ]