SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116091 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116091 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116715,1000370,554829,687493,603405,281902,901966,335785,49047,101987,890207,98784,691959,178463,954453,426258,739087,551436,737260,649955,33700,336904,696401,70431,8164,721326,346149,32373,464556,117442,996382,121200,180768,113728,116568,19884,1039466,222990,603739,404508,275804,420910,995696,770210,715786,124335,518353,35067,201745,4280,254499,686517,23690,288642,662137,873055,474550,580106,124993,287935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]