SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023809 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023809 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486603,156392,466014,690656,556385,64045,102722,474945,490133,332873,901325,178555,818489,190334,613670,731682,214926,872460,2150,93970,367201,202706,717226,21026,685155,907020,292302,1018557,668786,267624,733377,831912,343130,449984,858752,559680,170025,547749,369459,273548,862218,305081,50429,92559,701215,346573,351235,21344,817491,262789,425696,746898,486266,431034,630617,337002,873902,399898,162146,661776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]