SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495732 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495732 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863759,111659,472389,1019864,447103,491936,936549,716336,640968,1005004,1018611,1040178,903676,970408,711468,517477,839449,835188,251463,280982,580562,930437,352273,571166,1002935,84972,380234,594836,1014129,272934,444887,547077,152440,482010,895430,284534,751534,616694,510103,755551,373944,138108,286960,135949,648289,660997,1036179,518663,21074,734411,1005192,518667,712287,312205,709944,4450,490077,33162,452246,349623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]