[ SQL ] SHOW COLUMNS FROM `cmf_phone` [ RunTime:0.002306s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_phone` WHERE ( status = 1 AND (
floor(mid(right(phone,8),5,1))=floor(mid(right(phone,8),1,1)) and floor(mid(right(phone,8),6,1))= floor(mid(right(phone,8),2,1)) and floor(mid(right(phone,8),7,1))=floor(mid(right(phone,8),3,1)) and floor(mid(right(phone,8),8,1))= floor(mid(right(phone,8),4,1))
) AND (
( mid(phone,4,2) mod 11 = 0 and mid(phone,3,1) <> mid(phone,4,1) and mid(phone,3,1) = mid(phone,6,1) )
or ( mid(phone,5,2) mod 11 = 0 and mid(phone,4,1) <> mid(phone,5,1) and mid(phone,4,1) = mid(phone,7,1) )
or ( mid(phone,6,2) mod 11 = 0 and mid(phone,5,1) <> mid(phone,6,1) and mid(phone,5,1) = mid(phone,8,1) )
or ( mid(phone,7,2) mod 11 = 0 and mid(phone,6,1) <> mid(phone,7,1) and mid(phone,6,1) = mid(phone,9,1) )
or ( mid(phone,8,2) mod 11 = 0 and mid(phone,7,1) <> mid(phone,8,1) and mid(phone,7,1) = mid(phone,10,1) )
) ) [ RunTime:0.559863s ]
[ SQL ] SELECT * FROM `cmf_phone` WHERE ( status = 1 AND (
floor(mid(right(phone,8),5,1))=floor(mid(right(phone,8),1,1)) and floor(mid(right(phone,8),6,1))= floor(mid(right(phone,8),2,1)) and floor(mid(right(phone,8),7,1))=floor(mid(right(phone,8),3,1)) and floor(mid(right(phone,8),8,1))= floor(mid(right(phone,8),4,1))
) AND (
( mid(phone,4,2) mod 11 = 0 and mid(phone,3,1) <> mid(phone,4,1) and mid(phone,3,1) = mid(phone,6,1) )
or ( mid(phone,5,2) mod 11 = 0 and mid(phone,4,1) <> mid(phone,5,1) and mid(phone,4,1) = mid(phone,7,1) )
or ( mid(phone,6,2) mod 11 = 0 and mid(phone,5,1) <> mid(phone,6,1) and mid(phone,5,1) = mid(phone,8,1) )
or ( mid(phone,7,2) mod 11 = 0 and mid(phone,6,1) <> mid(phone,7,1) and mid(phone,6,1) = mid(phone,9,1) )
or ( mid(phone,8,2) mod 11 = 0 and mid(phone,7,1) <> mid(phone,8,1) and mid(phone,7,1) = mid(phone,10,1) )
) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:3.867163s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001976s ]
[ 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` < '1765873006' ) GROUP BY `post`.`id` LIMIT 3 [ RunTime:0.002633s ]