基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-03-23 12:09:15 HTTP/1.1 GET : http://www.sundaedu.net/portal/teacher
- 运行时间 : 0.048900s [ 吞吐率：20.45req/s ] 内存消耗：4,699.47kb 文件加载：101
- 查询信息 : 78 queries 0 writes
- 缓存信息 : 4 reads,0 writes
- 会话信息 : SESSION_ID=j1q5vc181ttvhukk9ruai2rb8t
- [ LANG ] /www/wwwroot/www.sundaedu.net/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ ROUTE ] array (
)
- [ HEADER ] array (
'connection' => 'Keep-Alive',
'host' => 'www.sundaedu.net',
'accept-encoding' => 'br,gzip',
'accept-language' => 'en-US,en;q=0.5',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
)
- [ LANG ] /www/wwwroot/www.sundaedu.net/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/www.sundaedu.net/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /www/wwwroot/www.sundaedu.net/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/www.sundaedu.net/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ VIEW ] /www/wwwroot/www.sundaedu.net/public/themes/default/portal/teacher/index.html [ array (
0 => 'site_info',
1 => 'siteInfo',
2 => 'province_default',
3 => 'city_default',
4 => 'area_default',
5 => 'street_default',
6 => 'street_name',
7 => 'city_name',
8 => 'area_name',
9 => 'periods',
10 => 'grade_list',
11 => 'subject_list',
12 => 'subjects',
13 => 'group_list',
14 => 'class_type',
15 => 'key_title',
16 => 'shop_type',
17 => 'menu_top',
18 => 'menu_foot',
19 => 'menu_city',
20 => 'user_period_id',
21 => 'user_subject_id',
22 => 'group_id',
23 => 'roles_id',
24 => 'wid',
25 => 'wxid',
26 => 'workshops_user',
27 => 'is_creater',
28 => 'create_user',
29 => 'is_admin',
30 => 'is_pay_live',
31 => 'is_pay_video',
32 => 'workshops',
33 => 'user',
34 => 'uid',
35 => 'is_status',
36 => 'msg_count',
37 => 'teacher',
38 => 'pages',
39 => 'theme_vars',
40 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000435s ] mysql:host=127.0.0.1;port=3306;dbname=www_sundaedu_net;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_hook` [ RunTime:0.000475s ]
- [ SQL ] SELECT `hook` FROM `cmf_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000245s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 56,
'filtered' => 11.710000038146973,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000274s ]
- [ SQL ] SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000221s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_period` [ RunTime:0.000357s ]
- [ SQL ] SELECT * FROM `cmf_period` [ RunTime:0.000136s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_period` [ RunTime:0.000096s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_subject` [ RunTime:0.000234s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_subject` [ RunTime:0.000113s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_period` [ RunTime:0.000087s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_subject` [ RunTime:0.000089s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_period_subject` [ RunTime:0.000219s ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 1 [ RunTime:0.000124s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 2 [ RunTime:0.000095s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 3 [ RunTime:0.000119s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 4 [ RunTime:0.000085s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 5 [ RunTime:0.000081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 6 [ RunTime:0.000083s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 7 [ RunTime:0.000081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 8 [ RunTime:0.000083s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 9 [ RunTime:0.000100s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 10 [ RunTime:0.000088s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 11 [ RunTime:0.000081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 12 [ RunTime:0.000080s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 13 [ RunTime:0.000079s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 14 [ RunTime:0.000085s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 15 [ RunTime:0.000081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 16 [ RunTime:0.000083s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `period_id` FROM `cmf_period_subject` WHERE `subject_id` = 17 [ RunTime:0.000084s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_period_subject',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 39,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user_group` [ RunTime:0.000243s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_user_group` [ RunTime:0.000114s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user_group',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000234s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000184s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 1 [ RunTime:0.000135s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 2 [ RunTime:0.000125s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 4 [ RunTime:0.000120s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 28 [ RunTime:0.000145s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 6 [ RunTime:0.000126s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 8 [ RunTime:0.000121s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 26 [ RunTime:0.000125s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000140s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 21 [ RunTime:0.000127s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 22 [ RunTime:0.000123s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 23 [ RunTime:0.000119s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 24 [ RunTime:0.000119s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 25 [ RunTime:0.000117s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 8 ORDER BY `list_order` ASC [ RunTime:0.000144s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 9 [ RunTime:0.000119s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 10 [ RunTime:0.000117s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 11 [ RunTime:0.000113s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 12 [ RunTime:0.000175s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 13 [ RunTime:0.000126s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 14 [ RunTime:0.000122s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 15 [ RunTime:0.000145s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 16 [ RunTime:0.000112s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 17 [ RunTime:0.000114s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 18 [ RunTime:0.000114s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 19 [ RunTime:0.000114s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 20 [ RunTime:0.000114s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'filtered' => 3.4482758045196533,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_workshops_user` [ RunTime:0.000295s ]
- [ SQL ] SELECT * FROM `cmf_workshops_user` WHERE `uid` = 0 LIMIT 1 [ RunTime:0.000153s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_workshops_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 81,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_workshops` [ RunTime:0.000260s ]
- [ SQL ] SELECT `admin_id` FROM `cmf_workshops` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000206s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_member` [ RunTime:0.000282s ]
- [ SQL ] SELECT * FROM `cmf_member` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000140s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'Impossible WHERE',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_message` [ RunTime:0.000265s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_message` WHERE `uid` = 0 AND `is_read` = 0 [ RunTime:0.000170s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_message',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'uid',
'key' => 'uid',
'key_len' => '5',
'ref' => 'const',
'rows' => 1,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_teacher` [ RunTime:0.000330s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_teacher` WHERE `status` = 1 [ RunTime:0.000163s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_teacher',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 70,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_teacher` WHERE `status` = 1 LIMIT 0,20 [ RunTime:0.000164s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_teacher',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 70,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000350s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/teacher/index' ) [ RunTime:0.000177s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_slide` [ RunTime:0.000282s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_slide` WHERE `id` = 1 AND `status` = 1 AND `delete_time` = 0 [ RunTime:0.000148s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000245s ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `status` = 1 AND `slide_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000196s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'slide_id',
'key' => 'slide_id',
'key_len' => '4',
'ref' => 'const',
'rows' => 1,
'filtered' => 20.0,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.000256s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000165s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
