SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485716 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485716 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350811,880347,549601,360676,47597,852144,265280,578018,712327,611556,316909,107083,412093,108138,459524,72408,730352,295887,498793,665051,445533,595019,46249,310788,519979,338461,384233,984958,189478,322776,865291,838381,977585,272971,862073,720401,727315,752072,202192,103695,300925,159760,635009,414994,334475,389019,583970,565989,247084,788467,736981,475416,46463,475404,354057,153325,91508,937715,282900,8859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]