SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565620 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565620 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534349,975417,999842,769771,192837,391481,267847,778978,903018,587230,136623,419280,521830,381126,101029,995074,977997,543020,667042,475506,123938,701765,771641,249179,317919,822408,709659,58071,21495,910433,32758,385013,925885,942151,281148,376181,245062,917679,249495,19114,957923,419383,612178,946277,38409,206305,935459,930925,212791,368796,254237,199423,643557,94489,330513,699142,186757,117908,366784,835216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]