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` = 980935 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980935 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287033,154689,248797,601765,625426,916971,123717,250906,358366,200416,96381,292233,806058,208829,650154,151775,751362,264725,530566,4912,291913,547146,971099,789855,113496,865385,844214,539670,824742,997695,937092,573776,707803,814374,775645,1008048,43179,585790,234125,459597,439436,825646,188853,905027,133281,298249,646595,669308,792539,719700,92161,167131,380462,460381,915389,869888,713699,288791,698054,344263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]