SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201092 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201092 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114779,835328,1015091,214738,124124,828927,449970,165400,915962,254412,604940,96878,805948,106886,338224,789072,388151,306055,303560,946926,590821,802116,762241,412548,369242,393928,248255,36406,220444,998086,861707,198492,190332,451151,537794,211531,861561,832794,832010,525296,816264,525015,1028408,419668,843360,480159,637022,512490,964837,953811,564186,547208,442740,248581,62737,231258,340138,666557,495115,642716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]