SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018631 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018631 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033171,763940,787433,846518,285985,865683,276061,704315,16074,1017529,385397,894601,472111,930286,628592,178353,290526,704176,999389,994804,1045122,935383,363509,404239,477252,127447,439795,745556,456190,1035217,842165,359175,885561,64000,971344,288665,442296,1033179,560382,837165,649236,237023,728969,698356,572571,265213,960367,530256,271483,836294,206709,891024,478604,628190,1031506,111998,723282,492418,1008594,552132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]