SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480380 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480380 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572116,476802,512475,828333,1027132,629995,234294,75351,280689,495001,532484,253342,637831,1010062,1036868,710858,357624,733281,746458,837231,365444,47698,186314,872225,832353,758642,197545,981067,404798,384226,947649,639061,684164,19332,869776,306954,949189,306277,175544,1647,48367,201503,277742,48128,662136,303439,115571,291941,262246,714382,291440,741589,752167,439596,976942,561081,999877,139598,476862,513769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]