SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285416 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285416 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021067,259899,236314,348787,957005,360233,1017251,124716,476619,146437,542954,370249,613979,37965,973076,853157,59316,381974,321523,793352,248778,77771,650443,947702,730339,970014,71010,861250,79170,611421,387982,739614,614760,203170,247462,1000007,1000294,716325,512557,179725,474386,378548,933803,508873,59158,544219,920303,926892,892598,967108,225340,491406,183108,386255,93594,221793,673754,438683,515883,517550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]