SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335508 LIMIT 1 [ RunTime:0.002207s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335508 [ RunTime:0.005281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566114,897664,1022377,70611,112477,713480,704493,750866,673495,416681,830344,250898,686434,43362,675520,903111,70743,259518,498803,324608,699802,562229,516077,722796,931755,127368,1008474,874779,1008949,1008325,548436,515200,137565,837156,947955,650651,970958,718001,336065,1035387,647702,753260,800565,685430,401433,798487,1011470,153062,419683,449780,657406,604521,265698,982515,394959,430854,452863,1025306,721362,925904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.011237s ]