SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584583 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584583 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830680,912847,508943,1011638,74717,57292,475702,716714,300921,421001,697062,272188,255949,567243,88828,416552,239340,551726,302424,93615,137311,36679,44729,801066,294482,88751,194725,734958,962172,513829,939280,1024185,776838,886821,820870,1009299,883656,692493,757646,463297,998567,842039,297928,273099,739116,935546,325187,591887,546796,264195,935700,451601,378761,283361,233198,584291,665842,950594,129173,664424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]