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` = 671648 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671648 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037372,837978,145806,110245,485940,315439,997513,483046,134574,366813,874542,165308,522393,972960,31225,844027,1035420,110963,506165,153753,564615,271129,1011869,54014,178766,396181,793824,279667,285377,468762,930343,773397,295035,1006767,539692,36180,656644,539211,102816,39549,108261,3478,495516,792225,426965,57952,606516,996536,154397,501607,598786,390324,50614,57711,181,1011765,243343,880320,1004950,807852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000954s ]