SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101989 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101989 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306321,135734,204514,212133,158546,742088,473175,277994,128958,357327,67415,270168,490956,64357,177467,501476,657292,106834,9370,270866,599783,223575,881396,933967,161031,545644,12294,748441,609202,977133,964639,538022,124477,520564,1031859,202988,113039,197780,365803,9665,949261,67705,837905,749212,551731,35852,52361,795748,167293,335295,713542,495294,734472,464179,824917,758599,538,961817,579723,6773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]