SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101748 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101748 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248509,698061,376046,555202,617087,513975,761918,702261,492083,690643,1013284,457939,173056,507874,432716,653190,174086,51311,359095,809508,453322,1018591,513793,158905,877573,917355,36298,628137,764588,606986,890017,219032,938275,248627,554966,1043126,544214,766862,128201,162088,588624,294207,600676,951586,821435,694859,880726,679976,10066,443255,102075,809227,256995,853019,980107,221273,576738,468806,220810,725888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]