SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50440 LIMIT 1 [ RunTime:0.000930s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50440 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458047,810712,784110,1032541,305603,217561,955752,50039,1030525,872188,464321,17553,875957,41370,864495,360954,888702,600852,1004780,501089,808662,436343,822281,28940,751507,389825,54576,22821,565932,319983,7635,122112,578203,443698,139519,471291,509677,764434,468360,186375,959419,195704,24230,562194,954148,457623,321216,758345,781599,796373,1008228,409557,339023,134272,574481,174400,377104,552885,179081,222652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]