SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367081 LIMIT 1 [ RunTime:0.001097s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367081 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726921,59308,913733,285449,578380,38913,898360,460569,856251,770307,1027228,413224,508378,245569,78514,1018405,165047,219825,19649,196667,298052,795650,98126,821796,959221,410095,37091,952398,172169,623578,745817,920072,749005,980843,763892,179196,822621,70716,907922,916886,119385,648331,421365,898633,1028144,340524,489275,660955,704716,378875,363176,1013037,577314,982329,267882,524759,889991,5795,974340,362590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002725s ]