SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011019 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011019 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21338,618633,45141,300619,508495,354718,397417,889649,879665,555723,1959,916540,516710,462711,83886,451801,630949,35254,374618,472298,886534,816794,116575,465138,213178,184120,375682,453200,446856,868304,291090,727875,468318,165924,763455,183928,309131,668998,1040901,652887,580642,548651,287029,172556,588688,215706,1040492,608304,157678,255771,889450,176261,203379,707296,929004,800660,162617,77067,791926,434391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]