SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465927 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465927 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179376,989188,903566,745964,805698,1020369,372976,822000,532383,210658,824875,104131,202237,461219,335901,15970,299721,891684,782048,890557,21084,245861,107614,490685,147835,505878,314884,446679,768518,900839,414609,416725,207274,965088,396807,35164,935195,415031,423068,1024088,515117,930504,415450,637864,693018,804021,259098,1022696,910081,401482,661429,561440,1154,342074,423411,933149,160757,864789,476214,966164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]