SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314420 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314420 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498527,596926,1037165,466848,714237,556146,882738,671429,323487,444583,529385,983946,620914,703335,725346,951534,708361,361782,154023,17012,1009026,651671,932486,958913,840989,166187,793521,128024,115137,469679,144819,390801,4012,671126,41952,1038671,879331,267101,425649,687499,145485,801493,291292,557043,173323,1029027,537380,449195,884324,554489,263228,531655,90548,987910,398416,862156,1018863,911150,405566,45974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]