SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316991 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316991 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117160,257329,1009713,944521,320653,888403,543506,41090,150064,643621,984471,795249,881786,154602,241199,216861,254056,558426,50174,443145,208155,693154,610660,917934,723847,963280,792874,706572,963221,426655,247157,419524,126290,81503,66126,601979,777242,435423,348869,562942,546363,1011725,32076,182082,91652,259522,735428,324140,260942,344078,315383,232387,648691,428629,406468,119363,517479,543322,448324,763197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]