SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416981 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416981 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773895,851186,454949,19275,647938,42798,333980,243860,758004,73530,977510,331981,684821,529150,72500,949614,880339,757870,616088,452335,560948,1034894,205534,307851,593854,992288,441678,501593,649836,237321,699355,741449,679655,1047224,810777,752754,1009606,814641,556187,679284,107502,697609,389005,677517,584494,209710,186727,966384,672283,574480,622561,297796,1017539,661161,471991,322315,396723,613966,415795,240549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001135s ]