SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584820 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584820 [ RunTime:0.002157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271698,966358,531281,422504,730766,403489,591119,272687,815609,873010,698752,274211,464265,411169,608034,452328,348248,19217,645221,304003,324424,141732,392809,112411,119120,328548,500446,824712,337757,228278,987050,749080,384278,919982,196348,413735,309557,590329,301201,538385,671828,10731,471948,489596,822026,682580,913260,370275,5571,328531,287805,414360,612515,251058,127234,626902,907334,459829,684224,478362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]