SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583421 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583421 [ RunTime:0.004622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177354,58763,831833,344125,130114,758337,584055,890066,256526,1020820,622421,135824,595693,148679,252578,351704,672913,793955,998679,727576,112821,213892,1041697,556563,39676,101236,253205,640001,436810,257042,770973,597084,584126,904308,747182,655081,133271,365493,777425,893480,640167,277399,458976,705460,39792,240531,969992,608240,1039964,828611,166095,911153,352188,531645,802462,500098,670475,250802,760175,696813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]