SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108731 LIMIT 1 [ RunTime:0.002177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108731 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875167,714217,611181,88619,150434,557727,334797,106512,322854,627958,469247,234886,535256,962163,129831,1635,751258,371975,197159,26534,904153,99427,350411,13343,241873,284960,498280,408319,363926,793820,446949,344322,17345,833257,784413,86271,1040676,777701,434222,596697,658549,505303,1046935,49168,1028082,560193,942822,550416,428415,764436,87557,737035,286911,346211,135835,377718,615565,522361,493098,224557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003419s ]