SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346019 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346019 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871642,158395,506177,222243,285974,678120,216244,471114,703230,282871,409147,548016,822805,286192,828727,952905,571235,682928,866257,891042,488795,313518,296288,601994,761384,301888,546661,401968,466154,457241,324793,419767,699869,1017604,204998,226931,740707,938135,572995,844287,93256,646560,895338,37907,929564,568716,618375,30521,416349,847640,159402,530596,385622,111595,990033,366362,562254,657123,419509,880904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]