SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982012 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982012 [ RunTime:0.003855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210799,620395,511948,861095,362960,650191,512912,421478,437560,296101,43372,231631,770805,643482,452859,930641,1024128,711714,409629,365787,878938,387638,281692,410410,522594,972857,36641,573963,790015,992757,172794,950518,900234,1025832,18037,382144,46972,768326,167407,686862,735473,95727,655475,554551,537402,482226,391503,357332,168455,620535,425413,336033,27722,767639,465229,646313,893297,636015,696692,789736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]