SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426176 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426176 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6753,576673,816085,1009085,548624,105256,356907,49611,1025995,368519,81320,177977,292230,421811,915182,15534,885486,94775,1036742,787185,579942,561003,766359,546606,568697,507507,1026501,591998,864845,314803,1012181,404254,901934,928847,454786,332989,253538,60171,122916,101441,894111,425530,884684,278823,888542,112420,711131,408834,527428,810490,958362,410171,584172,322349,883095,197111,238257,2957,3302,664664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]