SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64807 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64807 [ RunTime:0.002695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259182,520124,812246,1019965,818453,892560,1031055,106887,839438,848474,601957,614572,376501,58313,1013041,317979,240776,121959,83780,756504,556169,698538,1016009,523165,790313,23298,484530,932637,904069,921121,2062,531700,131430,939418,571550,884056,212412,137353,916977,351959,550483,262564,644539,205642,219786,239734,886809,802222,456128,93321,444719,366457,1048697,452713,216200,667502,637056,870757,328502,123085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]