SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581084 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581084 [ RunTime:0.003013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287292,105779,589367,855513,664726,551062,694163,390272,274525,461365,987540,221433,105655,35549,743209,832086,815970,592894,784401,1015771,972874,194199,1000988,109425,70115,446604,858284,538344,209724,351773,490158,292019,435488,299033,571552,314169,1035901,316576,819786,644591,880983,503394,28720,106234,984663,704675,311430,568530,510270,638273,761709,212410,412074,195638,469198,675375,498448,172115,634256,713424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001120s ]