SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200119 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200119 [ RunTime:0.002879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100857,18052,998055,1007716,63664,417119,355161,744171,122996,165652,1043840,971772,558394,209030,500520,1036826,711409,925097,419953,507161,765384,433841,463448,1004026,917891,918874,54592,280111,204910,1013486,882997,586015,303204,425707,749371,493913,563437,529893,118650,93328,198223,732797,428093,924227,673126,168294,253171,389810,538702,956737,406712,902664,280692,971966,31595,779838,9210,929830,522349,557815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]