SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321691 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321691 [ RunTime:0.003030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40961,144348,789918,315060,884061,372161,753841,843664,534046,144698,738372,84248,333942,666352,703763,487772,355910,287824,53582,481114,554338,1022825,920000,640428,373053,92675,907617,733941,920922,57795,866307,489424,11740,373335,382640,731990,463499,86798,178865,49717,894141,176764,914784,632797,460491,933676,922815,17348,975395,694012,129068,867672,245844,597028,458363,760008,110772,497293,615064,862671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000862s ]