SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538803 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538803 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201434,271268,531275,524198,986259,81073,334271,615216,272077,991837,698476,161494,1018934,726479,292837,443454,237174,215295,692087,59865,605138,145677,344185,4928,158131,138418,140160,711386,97582,1011164,61151,459871,148765,72778,963602,741902,952004,149323,557917,266965,533115,420781,188943,719407,764113,608885,531291,226858,570555,595590,631770,735428,454557,143708,500574,449871,397054,80678,640335,980441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]