SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437181 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437181 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791353,533660,994045,819488,654780,267978,372444,1040324,205605,943466,128682,756014,803887,455207,200102,766698,819587,364152,481729,398689,948175,820143,230115,433611,1025693,669870,241077,248770,225890,500131,568254,577247,715339,936585,293748,767046,619177,462497,257262,183980,729001,904421,395923,788719,855302,326343,634059,187508,299320,840056,1045522,301102,389936,533580,261161,945758,489388,120284,292731,909583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]