SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585097 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585097 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182535,858904,254198,665404,285254,1028191,431670,129717,773293,61324,365752,131060,965356,246347,872637,33126,985476,1036989,615012,850903,560710,829092,70988,808410,204478,671924,989181,236532,476087,929500,131256,965735,522954,1006363,582937,878758,944130,134769,573775,534118,861442,186970,650703,413256,539299,400996,405248,64663,112000,446071,533164,643514,661293,941288,122014,225667,942419,404384,818070,886982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003502s ]