SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280313 LIMIT 1 [ RunTime:0.000847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280313 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267740,84576,53760,191077,527449,439632,33479,602185,204654,150052,594553,731409,927253,74276,678526,249299,731821,711928,520534,540405,411814,540628,652137,262018,494180,645121,726241,677591,309388,1009071,781394,699247,223448,471382,245114,178948,425798,327095,245065,908788,489359,608620,644539,61117,719063,801211,560915,258718,708207,203616,94898,714283,428317,417464,12387,750030,854231,417481,294496,388559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]