SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477935 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477935 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474515,469227,1023166,336853,409442,10508,452014,1006103,112187,685451,37558,785033,634081,89055,58336,190629,94435,1006339,629494,983548,280565,487066,775318,418204,192971,351727,64375,436960,596599,899476,769593,392027,1002929,204593,165856,512746,420467,301680,1011504,1020986,239747,193625,278743,95664,427508,240297,16969,878365,621196,600276,370793,356315,658413,877334,343472,393992,1041031,736366,1010110,723392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]