SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564763 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564763 [ RunTime:0.003188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506864,914834,527427,1000294,665331,757194,1030940,830152,365605,570029,807878,222976,985536,995492,427985,876960,921104,792783,300839,666027,825320,253079,950522,651465,628915,1033710,9080,755784,598153,414810,905444,741244,609195,725460,1018481,525757,112229,173541,1027130,1009608,1018699,729571,629181,884743,915647,508673,85604,526340,704989,799745,10651,788584,144525,350722,77574,514461,202307,826693,950101,807740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]