SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583108 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583108 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138264,1034668,20343,39444,859747,1030393,553789,989148,707018,657239,445392,76760,594680,1023676,830982,237448,949095,451519,679431,365700,305974,936332,28904,537568,891348,324030,328028,906672,219835,550205,904134,542048,71108,448687,501862,872760,563096,237251,542779,311546,122049,623324,35373,753710,1010276,341579,363465,959379,333037,963180,347235,558923,844604,260093,850316,510566,721999,52175,370862,156925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]