SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782004 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782004 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917146,1030218,304965,769534,297711,644127,933383,508945,906363,157094,440022,242993,858959,49780,240055,798804,265153,210526,399892,24135,462300,495713,330662,422630,893444,497944,455098,312081,929265,546663,651194,565242,143006,865968,553300,387534,1019862,481964,145455,822294,504891,880231,855000,604888,988319,652402,443393,416650,471557,740241,719789,525902,930424,169642,470928,189378,912435,610005,522405,811158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]