SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108938 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108938 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506698,744468,980816,261427,531366,1025781,509817,401418,816387,1013179,1044538,512333,440236,284802,15071,535958,414277,104507,167128,114410,158636,781771,413348,773632,437709,831635,411521,34355,518694,716226,257839,936381,717241,610294,811253,958139,825056,966330,297990,89887,148275,464960,860893,774939,450461,792572,355794,368323,1007936,775366,156405,567273,406198,278851,775781,609974,969914,965703,938352,791901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]