excel表格
excel表格
收录了0篇文章 1人关注
关注

RANK函数和RANKEQ函数在Excel中有什么不同？

橘子科技 1091 阅读 2019-09-17 17:38:00

Excel表格中的rankeq与rank的区别在哪？

橘子科技 738 阅读 2019-09-17 17:37:11

Rank.EQ函数与Rank函数有什么区别？

橘子科技 664 阅读 2019-09-17 17:36:30

Excel表格的放大缩小快捷键是什么？

橘子科技 760 阅读 2019-09-13 17:30:46

如何让Excel单元格中的123456自动排列？

橘子科技 770 阅读 2019-09-13 17:30:13

Excel的中文意思是什么？

橘子科技 2353 阅读 2019-09-13 17:29:22

Excel中“=A5%”的计算结果是什么？

橘子科技 1232 阅读 2019-09-13 17:28:56

如何授权激活Excel？

橘子科技 2343 阅读 2019-09-13 17:27:48

如何设置excel两列单元格自动同步数据？

橘子科技 649 阅读 2019-09-13 17:27:11

为什么Excel表格中数字显示不全？

橘子科技 519 阅读 2019-09-13 17:26:33

如何让Excel表格多个窗口独立显示？

橘子科技 1703 阅读 2019-09-13 17:25:47

如何在Excel表格中打出小于等于号？

橘子科技 2821 阅读 2019-09-13 17:25:17

什么是删除图例

哈士2奇 1064 阅读 2019-07-09 13:05:47

两张表格怎么比对数据？两种方法解决

橘子科技 8467 阅读 2019-07-08 17:32:05

wps公式输入后为什么显示不出来？

橘子科技 3521 阅读 2019-06-27 17:38:44

excel表格文件的默认保存位置在哪找

哈士2奇 2510 阅读 2019-06-27 13:16:14

在表格中的电话导入手机的方法有哪些

哈士2奇 2638 阅读 2019-06-19 17:20:19

使用Excel，怎么计算员工考勤

伊人 1471 阅读 2019-06-03 17:41:57

电子表格输入很多数字后，会变成字符

伊人 3032 阅读 2019-04-24 17:36:49

Excel表格中输入数字会变成英文，怎么解决

伊人 3029 阅读 2019-04-09 17:11:16

暂无描述

进入话题广场 来这里，发现更多精彩!
关于话题

暂无描述

话题达人

科技小怪兽

威望 0 积分 -265170
+关注

六眼飞鱼

威望 0 积分 -338850
+关注

科技1号

威望 0 积分 2000
+关注

哈士2奇

威望 0 积分 -148735
+关注

科技猫

威望 0 积分 2000
+关注
Debug messages:

Template: chaofen


Session:

Session type: file

[nus__Anwsion] Array ( [permission] => Array ( [visit_site] => 1 [visit_explore] => 1 [search_avail] => 1 [visit_question] => 1 [visit_topic] => 1 [visit_feature] => 1 [visit_people] => 1 [visit_chapter] => 1 [answer_show] => 1 ) [client_info] => [human_valid] => )


Plugins:


Loaded Class:

core_config: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/config.php

core_db: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/db.php

Zend_Db: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db.php

Zend_Db_Adapter_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Adapter/Abstract.php

Zend_Db_Adapter_Mysqli: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Adapter/Mysqli.php

Zend_Db_Profiler: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Profiler.php

Zend_Db_Statement_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Interface.php

Zend_Db_Statement: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement.php

Zend_Db_Statement_Mysqli: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Mysqli.php

Zend_Registry: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Registry.php

Zend_Cache: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache.php

Zend_Cache_Backend: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend.php

Zend_Cache_Backend_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend/Interface.php

Zend_Cache_Backend_ExtendedInterface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend/ExtendedInterface.php

Zend_Db_Table_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Table/Abstract.php

core_plugins: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/plugins.php

Zend_Session_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Abstract.php

Zend_Session: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session.php

Zend_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Exception.php

Zend_Session_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Exception.php

Zend_Session_Namespace: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Namespace.php

core_cache: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/cache.php

core_uri: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/uri.php

TPL: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_template.inc.php

Savant3: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Savant3.php

core_user: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/user.php

account_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/account.php

HTTP: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_http.inc.php

Zend_Validate_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate/Interface.php

Zend_Validate: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate.php

Zend_Loader: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Loader.php

Zend_Validate_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate/Abstract.php

Zend_Filter_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Filter/Interface.php

Zend_Filter_Digits: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Filter/Digits.php

topic_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/topic.php

Zend_Db_Select: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Select.php

Zend_Db_Expr: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Expr.php

FORMAT: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_format.inc.php

ACTION_LOG: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_action_log_class.inc.php

core_lang: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/lang.php

posts_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/posts.php

answer_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/answer.php

question_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/question.php

system_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/system.php

publish_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/publish.php

Zend_Db_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Exception.php

Zend_Db_Statement_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Exception.php

Zend_Db_Statement_Mysqli_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Mysqli/Exception.php


Database

[ Log time: 1789614339.9419 ] [ Expend time: 0.010023832321167 ] Connect Master DB

[ Log time: 1789614339.9715 ] [ Expend time: 0.001270055770874 ] SELECT `aws_topic`.* FROM `aws_topic` WHERE (topic_id = 1219) LIMIT 1

[ Log time: 1789614339.9734 ] [ Expend time: 0.0010359287261963 ] SELECT COUNT(*) AS `n` FROM `aws_topic_relation` WHERE (type='article' and topic_id=1219)

[ Log time: 1789614339.9745 ] [ Expend time: 0.00064897537231445 ] SELECT item_id FROM aws_topic_relation WHERE topic_id IN(1219) AND `type` = '10'

[ Log time: 1789614339.9751 ] [ Expend time: 0.00055885314941406 ] SELECT topic_id FROM aws_topic WHERE parent_id = 1219

[ Log time: 1789614339.9787 ] [ Expend time: 0.0019609928131104 ] SELECT `aws_user_action_history`.* FROM `aws_user_action_history` WHERE (associate_id = 1219 AND associate_type IN (4) AND associate_action IN (401,402,403,404,405,410,411) AND associate_attached = '-1') ORDER BY `add_time` DESC LIMIT 10

[ Log time: 1789614339.9819 ] [ Expend time: 0.0029480457305908 ] SELECT `aws_user_action_history_data`.* FROM `aws_user_action_history_data` WHERE (history_id IN(21073))

[ Log time: 1789614339.9854 ] [ Expend time: 0.0024600028991699 ] SELECT `aws_users`.* FROM `aws_users` WHERE (uid = 7) LIMIT 1

[ Log time: 1789614339.9885 ] [ Expend time: 0.0016121864318848 ] SELECT `aws_topic_merge`.* FROM `aws_topic_merge` WHERE (target_id = 1219)

[ Log time: 1789614339.9935 ] [ Expend time: 0.0018060207366943 ] SELECT `item_id`, `type` FROM aws_topic_relation WHERE `topic_id` IN(1219)

[ Log time: 1789614339.9996 ] [ Expend time: 0.0043308734893799 ] SELECT `aws_posts_index`.* FROM `aws_posts_index` WHERE (((post_id IN (3476,3515,3559,3706,6766,6767,7475,9890,11224,11914,11964,13010,13031,19784,19785,19786,19787,19788,19789,19790,19791,19792,20125,20126,20128) AND post_type = 'question')) AND examine=1 AND add_time<1789484739) ORDER BY `id` DESC LIMIT 20

[ Log time: 1789614340.0026 ] [ Expend time: 0.0019969940185547 ] SELECT COUNT(*) AS `n` FROM `aws_posts_index` WHERE (((post_id IN (3476,3515,3559,3706,6766,6767,7475,9890,11224,11914,11964,13010,13031,19784,19785,19786,19787,19788,19789,19790,19791,19792,20125,20126,20128) AND post_type = 'question')) AND examine=1 AND add_time<1789484739)

[ Log time: 1789614340.0219 ] [ Expend time: 0.0017588138580322 ] SELECT last_answer FROM aws_question WHERE question_id IN (20128,20126,20125,19792,19791,19790,19789,19788,19787,19786,19785,19784,13031,13010,11964,11914,11224,9890,7475,6767)

[ Log time: 1789614340.0247 ] [ Expend time: 0.0018699169158936 ] SELECT `aws_topic_relation`.* FROM `aws_topic_relation` WHERE (item_id IN(20128,20126,20125,19792,19791,19790,19789,19788,19787,19786,19785,19784,13031,13010,11964,11914,11224,9890,7475,6767) AND `type` = 'question')

[ Log time: 1789614340.0261 ] [ Expend time: 0.0011241436004639 ] SELECT `aws_topic`.* FROM `aws_topic` WHERE (topic_id IN(1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219,1219))

[ Log time: 1789614340.0311 ] [ Expend time: 0.0021979808807373 ] SELECT `aws_question`.* FROM `aws_question` WHERE (question_id IN(20128,20126,20125,19792,19791,19790,19789,19788,19787,19786,19785,19784,13031,13010,11964,11914,11224,9890,7475,6767))

[ Log time: 1789614340.0329 ] [ Expend time: 0.0015029907226562 ] SELECT `aws_users`.* FROM `aws_users` WHERE (uid IN(1269,1208,280))

[ Log time: 1789614340.0356 ] [ Expend time: 0.00093197822570801 ] SELECT `aws_category`.* FROM `aws_category`

[ Log time: 1789614340.0397 ] [ Expend time: 0.0010361671447754 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20128) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0414 ] [ Expend time: 0.00086307525634766 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20126) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0429 ] [ Expend time: 0.00087904930114746 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20125) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0445 ] [ Expend time: 0.00095987319946289 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19792) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.046 ] [ Expend time: 0.0008699893951416 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19791) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0472 ] [ Expend time: 0.0006718635559082 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19790) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0484 ] [ Expend time: 0.00070810317993164 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19789) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0496 ] [ Expend time: 0.00065207481384277 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19788) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0508 ] [ Expend time: 0.00067019462585449 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19787) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.052 ] [ Expend time: 0.00064396858215332 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19786) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0531 ] [ Expend time: 0.00064206123352051 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19785) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0542 ] [ Expend time: 0.00063991546630859 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 19784) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0554 ] [ Expend time: 0.00066208839416504 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 13031) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0566 ] [ Expend time: 0.00070381164550781 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 13010) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0578 ] [ Expend time: 0.00068497657775879 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11964) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0591 ] [ Expend time: 0.0007319450378418 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11914) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0603 ] [ Expend time: 0.00066995620727539 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11224) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0616 ] [ Expend time: 0.00065803527832031 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 9890) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0627 ] [ Expend time: 0.0006411075592041 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 7475) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0639 ] [ Expend time: 0.0006868839263916 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 6767) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1789614340.0711 ] [ Expend time: 0.00080204010009766 ] SELECT `item_id`, `type` FROM aws_topic_relation WHERE `topic_id` IN(1219)

[ Log time: 1789614340.0726 ] [ Expend time: 0.00091099739074707 ] SELECT `aws_posts_index`.* FROM `aws_posts_index` WHERE (((post_id IN (3476,3515,3559,3706,6766,6767,7475,9890,11224,11914,11964,13010,13031,19784,19785,19786,19787,19788,19789,19790,19791,19792,20125,20126,20128) AND post_type = 'question')) AND is_recommend = 1 AND examine=1 AND add_time<1789484740) ORDER BY `add_time` DESC, `id` DESC LIMIT 20

[ Log time: 1789614340.0735 ] [ Expend time: 0.00065302848815918 ] SELECT COUNT(*) AS `n` FROM `aws_posts_index` WHERE (((post_id IN (3476,3515,3559,3706,6766,6767,7475,9890,11224,11914,11964,13010,13031,19784,19785,19786,19787,19788,19789,19790,19791,19792,20125,20126,20128) AND post_type = 'question')) AND is_recommend = 1 AND examine=1 AND add_time<1789484740)

[ Log time: 1789614340.0752 ] [ Expend time: 0.00072407722473145 ] select a.* from aws_article as a join aws_topic_relation as r on a.id=r.item_id where a.uid != 894 and r.type='article' and and r.add_time<1789484740 r.topic_id in (1219) order by a.views desc limit 0,20

[ Log time: 1789614340.0805 ] [ Expend time: 0.0048291683197021 ] select * from aws_users where 1 order by article_count desc limit 5


Cache

[ Log time: 1789614339.9587 ] Backend: File

[ Log time: 1789614339.9589 ] [ Expend time: 0.000153 ] Get Cache: crond, result type: boolean

[ Log time: 1789614339.9647 ] [ Expend time: 0.000269 ] Get Cache: user_group_99, result type: array

[ Log time: 1789614339.9947 ] [ Expend time: 0.000245 ] Get Cache: posts_list_by_topic_ids_86240ab38c6c69fa0923b6437a35ad67, result type: boolean

[ Log time: 1789614339.9999 ] [ Expend time: 0.000252 ] Get Cache: db_rows_cache_b0c0d7cba361bb9c73b59261a81bf436, result type: boolean

[ Log time: 1789614340.0162 ] [ Expend time: 0.013531 ] Save Cache: db_rows_cache_b0c0d7cba361bb9c73b59261a81bf436, result type: integer

[ Log time: 1789614340.0172 ] [ Expend time: 0.000901 ] Save Cache: posts_list_by_topic_ids_86240ab38c6c69fa0923b6437a35ad67, result type: array

[ Log time: 1789614340.0173 ] [ Expend time: 0.000112 ] Get Cache: posts_list_by_topic_ids_found_rows_3dcc27f50d78f110205accd3c10b4938, result type: boolean

[ Log time: 1789614340.0181 ] [ Expend time: 0.000687 ] Save Cache: posts_list_by_topic_ids_found_rows_3dcc27f50d78f110205accd3c10b4938, result type: integer

[ Log time: 1789614340.0715 ] [ Expend time: 0.000094 ] Get Cache: posts_list_by_topic_ids_fa742974c5f199ab091cb0d9b7cc7e0a, result type: boolean

[ Log time: 1789614340.0727 ] [ Expend time: 0.000076 ] Get Cache: db_rows_cache_fbe153853e65285660d9b354d35d9ce3, result type: boolean

[ Log time: 1789614340.0736 ] [ Expend time: 0.000068 ] Get Cache: posts_list_by_topic_ids_found_rows_4970397cadc4a671e05f5d1accd112bc, result type: boolean


Escape time: 0.19148802757263, 43 queries, PHP Memory usage: 4821.1171875 KB, Server time: 2026-09-17 11:05:39