SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407520 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407520 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277872,935863,425246,58641,741394,275438,896987,975608,612869,342365,513069,140873,778586,902095,16962,538066,746287,211518,297098,185296,750684,296653,70163,988509,562569,115808,261993,1032557,343495,264959,525328,874359,359283,181396,169075,744956,925566,810945,254556,985606,365989,638874,716286,463596,764657,740101,266343,424823,983446,617141,290277,958397,136283,953019,573461,918377,89030,509850,763994,346762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]