AE
Size: a a a
AE
AE
VS
VS
IZ
VS
left join product_specials vps ON (vps.product_id = v.id AND vps.user_group_id = 270 and
vps.date_start < '2020-11-23 13:43:28'
and (ps.date_end > '2020-11-23 13:43:28' or ps.date_end is null))
VS
IZ
left join product_specials vps ON (vps.product_id = v.id AND vps.user_group_id = 270 and
vps.date_start < '2020-11-23 13:43:28'
and (ps.date_end > '2020-11-23 13:43:28' or ps.date_end is null))
VS
V
G
AD
A
[mysqld]
wait_timeout=600
max_allowed_packet=1000M
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
default_authentication_plugin=mysql_native_password
max_binlog_size=500M
expire_logs_days=1
skip-log-bin
innodb_buffer_pool_size=15G
slow_query_log=/var/log/mysql/mysql-slow.log
long_query_time=1
DE
[mysqld]
wait_timeout=600
max_allowed_packet=1000M
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
default_authentication_plugin=mysql_native_password
max_binlog_size=500M
expire_logs_days=1
skip-log-bin
innodb_buffer_pool_size=15G
slow_query_log=/var/log/mysql/mysql-slow.log
long_query_time=1
A
product
(id
int NOT NULL AUTO_INCREMENT,category_id
int DEFAULT NULL,title
longtext COLLATE utf8mb4_unicode_ci,url
longtext COLLATE utf8mb4_unicode_ci NOT NULL,sku
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,description
json DEFAULT NULL,created_at
datetime NOT NULL,updated_at
datetime DEFAULT NULL,images
json DEFAULT NULL,update_error
longtext COLLATE utf8mb4_unicode_ci,variants
json DEFAULT NULL,html
longtext COLLATE utf8mb4_unicode_ci,id
),IDX_D34A04AD12469DE2
(category_id
),FK_D34A04AD12469DE2
FOREIGN KEY (category_id
) REFERENCES category
(id
)DE
product
(id
int NOT NULL AUTO_INCREMENT,category_id
int DEFAULT NULL,title
longtext COLLATE utf8mb4_unicode_ci,url
longtext COLLATE utf8mb4_unicode_ci NOT NULL,sku
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,description
json DEFAULT NULL,created_at
datetime NOT NULL,updated_at
datetime DEFAULT NULL,images
json DEFAULT NULL,update_error
longtext COLLATE utf8mb4_unicode_ci,variants
json DEFAULT NULL,html
longtext COLLATE utf8mb4_unicode_ci,id
),IDX_D34A04AD12469DE2
(category_id
),FK_D34A04AD12469DE2
FOREIGN KEY (category_id
) REFERENCES category
(id
)A
DE
DE
DE