SEMA API 4.32

Does SEMA API work with WordPress 6.2.2 and PHP 8.1.12? A smoke test was performed on .

Summary

Errors
2PHP fatal errors
286Database errors
No JavaScript exceptions
1Page failed to load
  • 1 0
No resource errors
Performance

Memory usage: 62.04 KiB
The average PHP memory usage increased by this amount after activating by the plugin.

Page speed impact: 0.165 seconds
The average page load time increased by this amount after activating the plugin.

Environment
WordPress version6.2.2
PHP version8.1.12
MySQL version10.6.10
PHP memory limit512M
Plugin Info
Last updated
Active installs 20+
WordPress.org page https://wordpress.org/plugins/sema-api/
Badges

WordPress compatibility badge PHP compatibility badge

Get badge code

Pages 6

Plugins ‹ Test site — WordPress

Page screenshot: Plugins ‹ Test site — WordPress
URL /wp-admin/plugins.php?plugin_status=all&paged=1&s
Requested URL /wp-admin/plugins.php?action=activate&plugin=sema-api%2Fsema-api.php&plugin_status=all&paged=1&s&_wpnonce=9a5e2614a5
Aspect after-activation
HTTP status 200
Load time 0.655 s
Memory usage 3.07 MiB
JS errors None
Resource errors None

Settings → SEMA Setting

Page screenshot: Settings → SEMA Setting
URL /wp-admin/options-general.php?page=sema_setting
Aspect menu-item
HTTP status 200
Load time 0.308 s
Memory usage 3.06 MiB
JS errors None
Resource errors None

Settings → SEMA Setting → Fitment

Page screenshot: Settings → SEMA Setting → Fitment
URL /wp-admin/options-general.php?page=sema_import&section=fitment
Aspect menu-item-tab
HTTP status 200
Load time 0.473 s
Memory usage N/A
JS errors None
Resource errors None

Settings → SEMA Setting → Join SEMA Data Co-op

Screenshot not available
URL
Aspect menu-item-tab
HTTP status 0
Load time -0.001 s
Memory usage N/A
JS errors None
Resource errors None

Settings → SEMA Import

Page screenshot: Settings → SEMA Import
URL /wp-admin/options-general.php?page=sema_import
Aspect menu-item
HTTP status 200
Load time 0.586 s
Memory usage N/A
JS errors None
Resource errors None

Test site – Just another WordPress site

Page screenshot: Test site – Just another WordPress site
URL /
Aspect front-page
HTTP status 200
Load time 0.447 s
Memory usage 3.16 MiB
JS errors None
Resource errors None

Benchmark

URL Load time Memory usage
Inactive Active Change Inactive Active Change
/wp-admin/index.php0.319 s0.574 s+0.255 s3.07 MiB3.12 MiB+ 54.29 KiB
/wp-admin/edit.php0.196 s0.370 s+0.174 s3.1 MiB3.15 MiB+ 57.59 KiB
/wp-admin/post-new.php0.779 s1.315 s+0.536 s5.02 MiB5.07 MiB+ 54.55 KiB
/wp-admin/upload.php0.566 s0.609 s+0.043 s3.02 MiB3.06 MiB+ 39.85 KiB
/wp-admin/options-writing.php0.183 s0.347 s+0.164 s3.01 MiB3.04 MiB+ 29.51 KiB
/wp-admin/media-new.php0.337 s0.347 s+0.010 s2.99 MiB3.05 MiB+ 56.36 KiB
/wp-admin/edit-tags.php?taxonomy=category0.180 s0.339 s+0.159 s3.01 MiB3.06 MiB+ 57.84 KiB
/wp-admin/post-new.php?post_type=page0.640 s0.810 s+0.170 s5.01 MiB5.07 MiB+ 54.55 KiB
/wp-admin/options-discussion.php0.219 s0.463 s+0.244 s3 MiB3.04 MiB+ 43.55 KiB
/wp-admin/edit-comments.php0.247 s0.362 s+0.115 s3.03 MiB3.06 MiB+ 38.11 KiB
/0.348 s0.296 s-0.052 s2.97 MiB3.16 MiB+ 196.27 KiB
Average 0.365 s0.530 s+0.165 s3.38 MiB3.44 MiB+ 62.04 KiB

Code Statistics

Note: Third-party libraries and minified JS/CSS files are excluded from these statistics where possible, so the numbers you see here may be lower than those reported by other tools.

JavaScript
PHP
CSS
Language % Lines of code Comment lines Files
JavaScript66.2%18,0104,8505
PHP19.1%5,1821,21111
CSS14.7%3,9971389
Total 27,189 6,199 25

PHP Code Analysis | More results »

Lines of code 4,059
Total complexity 824
Median class complexity 34.0
Median method complexity 2.0
Most complex class SEMA_Product_Import
Most complex function sema_getdata_callback()
Classes 4
Methods 48
Functions 29

Additions

Things that the plugin adds to the site. This section is not intended to be comprehensive. The test tool only looks for a few specific types of added content.

Database Tables 4

Options wp_options 2

PHP Error Log 888 lines

[21-Jun-2023 18:06:08 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by activate_plugin, do_action('activate_sema-api/sema-api.php'), WP_Hook->do_action, WP_Hook->apply_filters, sema_activation, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:08 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:09 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE
		  ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_parts ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_attr_taxonomy ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(``)' at line 1 for query ALTER TABLE wp_sema_fitment ADD  `` (``) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, sema_plugin_updated, sema_create_tables, dbDelta
[21-Jun-2023 18:06:10 UTC] WordPress database error Key column 'id' doesn't exist in table for query CREATE TABLE wp_sema_products (
			`productid` int(11) NOT NULL,
			`brandid` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`partno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
			`status` int(11) DEFAULT NULL,
			`wpid` int(11) DEFAULT NULL,
			PRIMARY KEY (`id`),
			KEY `idx_wpid` (`wpid`) USING BTREE,
			KEY `idx_brandid` (`brandid`) USING BTREE,
  			KEY `idx_brandidpartno` (`brandid`,`partno`) USING BTREE

(+788 more lines)
See also: All tests for this plugin, How to Hide SEMA API Admin Menus