SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485994 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485994 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261771,367663,809475,866660,510206,169362,249331,804322,702297,916287,24657,1035831,45076,1026383,907362,366259,979874,10512,389805,110413,752699,340127,923860,785040,765636,724165,277884,714616,278909,142686,597103,611575,764119,746704,443326,370340,850163,516169,708956,246973,988275,709251,692274,282879,649990,98847,678879,286297,293978,176788,931747,406790,743074,507728,147460,351726,494236,762663,132842,204776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]