SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017307 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017307 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327574,598789,826575,394077,129795,509053,290946,150025,16880,431172,122696,792562,778196,490847,905550,93895,431435,894722,452374,1014065,579251,742694,739053,208500,263458,270575,901894,712896,309392,178494,228216,49526,440271,978808,972081,282382,208164,551020,296300,858702,970709,36300,1017822,1005208,631444,714277,570647,672280,809000,418569,99042,485486,509783,199386,496493,91195,1021436,160985,80914,197524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]