SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541863 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541863 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903100,290639,442741,825552,151625,955960,37534,256265,350436,64568,269492,513258,676344,181210,8923,743227,355946,383187,394385,590690,607827,537054,135651,263999,113390,65313,560767,48419,530739,182498,425434,842,362985,1028096,583289,726866,168845,248722,361109,345671,1041138,259351,65943,940621,744837,376155,732930,102321,373521,128053,604460,385532,425106,201012,1041960,697580,494744,461853,941231,977205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]