SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511437 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511437 [ RunTime:0.004480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169653,112420,187940,1035688,853990,777759,256642,276199,202283,763532,333133,373662,130337,721221,472231,409725,480517,184579,532949,682733,496158,950507,744625,451279,624257,519434,570802,409922,192873,168752,646913,743348,946688,563303,1039188,773851,40198,557644,709830,230172,502714,868740,239091,740571,239696,464853,1038291,434846,682146,566341,378272,772866,1047653,497736,262085,675140,304979,369515,359426,192598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001069s ]