SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101313 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101313 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487563,1044722,26089,271892,400190,242051,687257,928226,315028,557594,635077,714956,661649,607228,392039,983490,962818,778723,475819,887696,839988,159891,614523,236217,257040,344798,232530,915686,826691,108249,85916,431789,938437,140488,801500,523799,230933,824483,1010823,895690,286059,546164,620870,183343,792969,98061,885986,365835,703193,334272,377928,449712,155572,79574,638200,175012,473851,631464,763897,307285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]