SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105909 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105909 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925518,1024120,527084,321640,826098,25925,1019408,374825,981632,1026793,700557,414200,600791,761633,617933,86965,309681,537974,1009185,791002,484274,177283,73362,526840,243384,971038,983155,399931,617734,358350,679852,812123,612680,968327,423702,208464,584776,996959,235579,476892,123442,81819,96163,827116,693174,101140,540491,876732,626481,1024375,386706,429271,428277,858615,359640,220622,556408,541396,515526,231261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]