SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610201 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610201 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788656,285048,241479,923681,232264,127963,90199,1031981,464174,680777,551016,752538,174822,322590,109866,117463,957861,356937,395694,416307,771252,256739,393470,469895,256312,158719,374959,342505,208619,94942,193989,869029,760053,15319,300569,840306,1034701,618975,753383,254807,690789,141685,364337,151999,815416,916926,612733,963792,62910,137061,272487,511142,686678,246318,38749,689836,710007,1001838,355175,229428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]