SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013992 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013992 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871311,218185,165027,373871,145101,753856,560719,299893,11382,258872,213642,835310,689553,216409,500810,221892,496309,610787,61392,291713,633108,506569,979992,336271,628573,977062,836434,721120,991864,333844,588729,699016,907816,1017181,734591,675045,136979,791425,140606,61642,911879,12571,98635,859264,378922,559016,973052,274188,955664,372127,387401,780740,782002,95718,966200,820541,302809,72311,559492,859993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]