SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407049 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407049 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570458,93942,32419,910446,507422,220541,819186,324259,358566,269820,23973,673128,999015,76164,336987,979548,47710,472783,347873,284081,599796,317250,575561,289973,839471,650802,546791,430925,310201,774045,371448,104286,422099,683116,935966,772309,1009418,930743,336242,430949,838444,1167,525821,173909,265913,392126,469490,744912,82221,674808,964185,128836,23370,298848,491875,103584,1048880,737291,61148,254028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]